Series 1
A short, practical path through timelines, present and future value, rates, annuities, perpetuities, bonds, NPV, and terminal value timing.
Start here
This short introduction will explain the topic, the sequence, and how to use the videos, quizzes, Excel files, and calculator tools.
S1-00
Start here before the TVM lessons. This video sets expectations: short explanations, pause-and-practice moments, quizzes for feedback, and downloads for extra work.
S1-01 through S1-03
Before the formulas get busy, make sure the timeline, cash-flow signs, compounding periods, and rates all line up.
S1-01
Set the cash-flow perspective before calculating anything. Money you receive and money you pay should not have the same sign.
S1-02
Use one formula to move a single cash flow forward or backward in time. This is the financial time travel skill.
S1-03
Match the rate to the period. Monthly compounding, semiannual compounding, and annual compounding are not the same thing.
Checkpoint
Practice timeline setup, PV/FV movement, and APR/EAR plumbing.
Practice S1-AS1-04 through S1-05
Turn the basic TVM formula around, then use annuity and perpetuity shortcuts when cash flows follow a pattern.
S1-04
Find the missing return or the missing number of periods when you know the present value and future value.
S1-05
Recognize repeated cash flows, use the shortcut, and remember that perpetuity formulas start with next period's cash flow.
Workbook
Use this workbook after the video to practice annuities, perpetuities, and Excel function setup.
Download workbookCheckpoint
Practice solving for r/N, annuity PV, perpetuity timing, and mixed setups.
Practice S1-BS1-06 through S1-09
Use semiannual cash flows to understand the bond, price it on a calculator, price it in Excel, and solve for YTM.
S1-06
See the bond as a stream of semiannual coupons plus the face value at maturity.
S1-07
Enter semiannual bond inputs, compute price, and interpret the negative PV as sign convention.
S1-08
Draw the bond timeline horizontally, discount each cash flow, and sum the present values.
Spreadsheet detail: use fullscreen and set YouTube quality to 2160p if numbers look blurry.
S1-09
Use Goal Seek to make calculated bond price match the observed market price.
Spreadsheet detail: use fullscreen and set YouTube quality to 2160p if numbers look blurry.
Workbooks
Calculator
Use this with S1-07 and any bond calculator practice.
Open HP-12C emulatorCheckpoint
Practice bond cash flows, pricing, YTM, and premium/discount intuition.
Practice S1-CS1-10 through S1-11
Build the cash-flow timeline in Excel, discount each cash flow back to today, then handle the perpetuity tail at the correct date.
S1-10
Use Excel as a timeline: discount each irregular cash flow back to today and sum the present values.
Spreadsheet detail: use fullscreen and set YouTube quality to 2160p if numbers look blurry.
S1-11
Use the growing perpetuity shortcut for continuing cash flows and place the terminal value where it belongs.
Spreadsheet detail: use fullscreen and set YouTube quality to 2160p if numbers look blurry.
Workbooks
Checkpoint
Practice NPV, terminal value timing, double counting, and longer project tails.
Practice S1-DAll quizzes
Use standard mode for a quick check, or challenge mode for a shorter set of hard questions.
Downloads
Use the notes for a concise written companion, then use the workbooks to practice the spreadsheet setup.