Finance Train
Menu

Ebooks / Time Value of Money / Chapter 13 of 13

Using a Timeline to Solve Time Value of Money Problems

When solving a time value of money problem, it is sometimes easy to draw a timeline to present the cash flows on it. Once we have the timeline, we can easily understand the variables and visualize the present value or future value calculations.

In the previous pages, we demonstrated the time line for an ordinary annuity and for uneven cash flows.

Let’s take one more example to demonstrate the use of a time line.

Example: Loan Payments

You have taken a loan of $10,000 at an annual interest rate of 12% for a period of 2 years. Calculate the monthly payments you will make on this loan.

The payments (PMT) or Equated Monthly Instalments will be paid monthly for the next 24 months.

The above problem can be demonstrated on a timeline as follows:

timeline

Calculator Usage
To calculate the monthly payment:
Set compounding frequency to 12 (P/Y)
PV = 10,000
I/Y = 12
N = 24
PMT = 470.735

Check your understanding

5 questions

    1. When drawing a timeline for a loan repayment problem, which direction do cash flows typically move to represent money received versus money paid out?
    1. In the loan example ($10,000 at 12% annual interest, 2-year term with monthly payments), what is the correct value of N to enter into the financial calculator?
    1. Using the loan example ($10,000 at 12% annual rate, monthly payments for 2 years), what monthly payment (PMT) does the calculator return, and which calculator setting is critical to getting this result?
    1. On a loan repayment timeline, where is the present value (PV) of the loan located?
    1. A borrower takes a $15,000 loan at a 9% annual interest rate to be repaid with monthly payments over 3 years. Which set of calculator inputs is completely correct?
5 left

Files

  • The Time Value of Money

    PDF · Free