Cash Flow Timeline: How to Draw and Read One
In this chapter
Beginner
You pay $600 for a used camera today. You plan to rent it out for three years and sell it at the end. The purchase happens now. The rent comes in later. The sale and its fee happen on the same day. Where would you put each amount?
A cash-flow timeline shows when money comes in or goes out, and how much moves on each date. It gives you somewhere to put every payment before you start working out what those payments are worth.
Pick a starting date and a point of view
On a timeline, \(t\) tells you how many periods have passed since the starting date. If you’re working in years and starting today, \(t=0\) is today, \(t=1\) is one year from today, and \(t=2\) is two years from today. Time 0 is your reference point. Your first payment might happen there or several periods later.
Pick whose cash you’re tracking. Money coming in is a cash inflow, shown with a positive sign. Money going out is a cash outflow, shown with a negative sign. A cash-flow timeline for a bond shows the same payment leaving the borrower and arriving with the holder.
Suppose you lend someone $300 today and they repay $315 in one year. The same two payments look like this from each side.
| Point of view | Today, \(t=0\) | End of year 1, \(t=1\) |
|---|---|---|
| Borrower | +$300 | −$315 |
| Lender | −$300 | +$315 |
The borrower receives the $300 and pays it back with interest. The lender gives up the $300 today and receives the full $315 later. Once you choose a row, keep that point of view for the whole calculation.
The examples use hypothetical amounts in U.S. dollars. Assume no taxes or fees beyond the amounts stated. Round final calculated amounts to the nearest cent where needed.
How to draw a cash-flow timeline
- Draw a line and mark the starting date. Put \(t=0\) on the left. Mark the later dates to the right. Use equal gaps for equal lengths of time.
- Label the time unit. Decide whether each gap is a year, month or other period. If payments come on irregular dates, write down the actual dates so you can see how far apart they are.
- Put each amount on its payment date. Use a plus sign for a receipt and a minus sign for a payment. On a sketch you can draw receipts with arrows up and payments with arrows down. A table works too.
Use $0 when you know no cash moves on a date. If a payment will happen but the amount is unknown, mark the amount as unknown.
Worked example 1. Put the camera’s payments on the line
You pay $600 today. You receive $180 in rent at the end of each of the next three years. At the end of year 3, you also sell the camera for $150 and pay a $25 selling fee on that same date.
| Time | Date | What happens | Your cash flow |
|---|---|---|---|
| \(t=0\) | Today | Buy the camera | −$600 |
| \(t=1\) | End of year 1 | Receive rent | +$180 |
| \(t=2\) | End of year 2 | Receive rent | +$180 |
| \(t=3\) | End of year 3 | Receive rent and sale proceeds, pay the selling fee | +$305 |
At \(t=3\), all three amounts move on the same date. You can combine them into a net cash flow, the cash in minus the cash out on that date.
\[ \text{Net cash flow at end of year 3} =\$180+\$150-\$25 =\$305 \]
The three-year net cash total is $65. If you want to know what the deal is worth today, bring each future cash flow back to today and combine those values with the initial outflow of −$600.
Beginning and end of a period
With months on your timeline, \(t=1\) is the point one month after you started. For back-to-back monthly periods, that’s both the end of month 1 and the start of month 2.
Read the wording carefully. A payment due at the start of the first month goes at \(t=0\). A payment due at the end of the first month goes at \(t=1\).
Worked example 2. Three payments for music lessons
You take music lessons for three months. Each month costs $40. Here’s how the same three payments would look under two billing schedules, from your point of view.
| Billing schedule | Today \(t=0\) | After 1 month \(t=1\) | After 2 months \(t=2\) | After 3 months \(t=3\) |
|---|---|---|---|---|
| Start of each month | −$40 | −$40 | −$40 | $0 |
| End of each month | $0 | −$40 | −$40 | −$40 |
If you pay at the start, you pay for month 1 today and for month 3 two months from now. If you pay at the end, each payment moves one month later. The number of payments stays at three.
Count the gaps between dates
If you’re moving an amount from one date to another, count the periods between those two marks. The number beside the last mark tells you how far that date is from the start of the timeline.
\[ n=t_{\mathrm{later}}-t_{\mathrm{earlier}} \]
Here, \(n\) is the number of periods between the dates. The labels \(t_{\mathrm{later}}\) and \(t_{\mathrm{earlier}}\) measure elapsed time in the same unit.
Worked example 3. A deposit you make two years from now
You plan to deposit $500 at the end of year 2 and withdraw the balance at the end of year 5. Assume the money earns 5% per year, compounded annually.
| Date | Time | What happens |
|---|---|---|
| Today | \(t=0\) | Set the starting date for the timeline |
| End of year 2 | \(t=2\) | Deposit $500 |
| End of year 5 | \(t=5\) | Withdraw the balance |
The deposit earns interest for \(5-2=3\) years. It grows from the end of year 2 to the end of year 3, then through years 4 and 5. Multiply by \(1.05\) once for each of those three years.
\[ \$500(1.05)^3\approx \$578.81 \]
From your point of view, the deposit is −$500 at \(t=2\) and the withdrawal is about +$578.81 at \(t=5\). The two years before the deposit are on the timeline, but the deposit earns interest only after you make it.
Moving an amount forward uses compounding. Moving it backward uses discounting. Either way, count the gap between the payment date and the date you want to value it at. Use a rate for the same unit you’re counting. The calculations are explained in Time Value of Money.
A cash flow and an account balance tell you different things
In the deposit example, the account has $525 at the end of year 3. You leave that money in the account. On a timeline that tracks what you put into the account and take out of it, the cash flow between you and the account at \(t=3\) is $0.
The balance answers how much is in the account at that date. The cash flow answers how much you put in or took out on that date. Keeping the two separate helps you avoid counting reinvested interest once as a payment you received and again as part of the final withdrawal.
Practice questions
Choose one answer per question. Use the point of view and dates given in each question. All amounts are in U.S. dollars.
1. Whose cash is moving?
You borrow $900 today and repay $945 exactly one year later. Which amounts go on your timeline at \(t=0\) and \(t=1\), in that order?
2. The first bill is due today
You make three $60 payments at the start of three consecutive months. The first payment is today. With time measured in months, which marks have a payment?
3. Two amounts on the same date
You receive $240 and pay a $35 fee at the end of year 2. You receive another $30 at the end of year 3. What is your net cash flow at \(t=2\)?
4. Count how long the money is invested
You put money in at the end of year 3 and withdraw it at the end of year 7. How many years does the money have to grow?
5. Interest stays in the account
You deposit $800 today at 5% per year, compounded annually. You leave the interest in the account and make no other deposits or withdrawals until the end of year 2. On a timeline that tracks the money you put into the account and take out of it, what cash flow goes at the end of year 1?
6. Value a payment at an earlier date
You will receive $630 at the end of year 4. The discount rate is 5% per year with annual compounding. What is the equivalent value at the end of year 2, rounded to the nearest cent?
More chapters in Finance foundations.