Finance education, free and open.An independent learning project
THEFINANCE ARCHIVES
Finance foundationsEquitiesFixed incomeDerivativesEconomicsFinancial statementsPortfolio management
Home / Finance foundations / Cash Flow Timeline: How to Draw and Read One
Finance foundations

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 viewToday, \(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

  1. 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.
  2. 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.
  3. 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.

TimeDateWhat happensYour cash flow
\(t=0\)TodayBuy the camera−$600
\(t=1\)End of year 1Receive rent+$180
\(t=2\)End of year 2Receive rent+$180
\(t=3\)End of year 3Receive 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 scheduleToday \(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.

DateTimeWhat 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?

Question 1 choices

B is correct

  • A. These are the lender’s cash flows. The lender pays out the loan amount today and receives the repayment later.
  • B. You receive $900 today and pay out the full $945 a year later. The receipt is positive and the repayment is negative.
  • C. $45 is the interest part of your repayment. Your cash outflow includes the $900 you borrowed as well, so the full payment is $945.

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?

Question 2 choices

C is correct

  • A. These are payments at the ends of months 1, 2 and 3. That schedule puts the first bill one month after today.
  • B. This puts the first two bills on the right dates but delays the third one. The start of month 3 is \(t=2\).
  • C. The first payment is today. One month later you pay for month 2. Two months from today you pay for month 3.

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\)?

Question 3 choices

A is correct

  • A. Both amounts at \(t=2\) belong together. The receipt of $240 minus the fee of $35 gives a net inflow of $205.
  • B. $235 includes the $30 paid to you at \(t=3\). That receipt has its own date on the timeline.
  • C. $275 adds the $35 to the $240. You pay the fee, so it reduces the cash you receive on that date.

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?

Question 4 choices

B is correct

  • A. Three years takes you from the end of year 3 to the end of year 6. The money stays invested for one more year.
  • B. There are four years between the two marks. Subtract 3 from 7.
  • C. The marks for years 3, 4, 5, 6 and 7 give you five dates. There are four gaps between those dates.

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?

Question 5 choices

C is correct

  • A. The account earns $40 in year 1. The interest stays there, so you take out $0 on that date.
  • B. $840 is the balance after interest is added. You leave the balance in the account at the end of year 1.
  • C. You make no deposit or withdrawal on that date. The $0 cash flow records the movement between you and the account.

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?

Question 6 choices

A is correct

  • A. The payment is two years beyond the date you want to value it at. Divide $630 by \(1.05^2\) to get about $571.43 at the end of year 2.
  • B. Dividing by \(1.05\) once gives $600. That moves the payment back one year, to the end of year 3.
  • C. Dividing by \(1.05^4\) gives about $518.30. That moves the payment all the way to \(t=0\).

More chapters in Finance foundations.

Find a finance concept

Press Enter to see all matching chapters.