TVM Demystified

Master answer sheet + study notes combining the original exercise, the accompanying KC Lau PDF notes, and the concepts tested across our 30-question review.

Compounding & Discounting PV / FV / PMT / RATE / NPER Flat vs Nominal vs Effective Rate Car Loans & Mortgages Cash-flow Timing Interactive Calculator

1 Direct Answers to the Original Exercise

Definition

Compounding

Moving money forward in time: a present value grows into a future value because returns can themselves earn returns.

FV = PV × (1 + r)^n

PDF framing: Compounding moves from PV → FV. PDF pp.7-8

Definition

Discounting

Moving money backward in time: a future amount is converted into its equivalent value today.

PV = FV ÷ (1 + r)^n

PDF framing: Discounting moves from FV → PV. PDF pp.7-8

The 5 TVM variables you should know

AbbreviationStands forMeaningQuick memory
PVPresent ValueValue / amount of money today.Present = now
PMTPaymentFixed payment made or received each period.Regular instalment
FVFuture ValueValue / amount of money at a future date.Future = later
RATERateInterest / return rate per period.Must match NPER's unit
NPERNumber of PeriodsTotal number of payment or compounding periods.9 years monthly = 108

The PDF explicitly organizes TVM problems around PV, FV, RATE, NPER and PMT. PDF p.9

2 Original Car-Loan Exercise - Complete Worked Answer

Question: Car price / loan amount RM80,000, quoted hire-purchase rate 2.9% p.a., tenure 9 years. Find the monthly instalment and the effective annual rate.
RM80,000Original principal
2.90%Flat annual rate
108Monthly periods
RM934.07Monthly instalment

Calculate flat-rate interest

Total interest = RM80,000 × 2.9% × 9 = RM20,880

This follows the flat-rate method illustrated for car loans in the PDF: interest is calculated using the original principal for the quoted tenure. PDF pp.20-21

Total amount to repay

RM80,000 + RM20,880 = RM100,880

Number of monthly instalments

NPER = 9 × 12 = 108 months

Monthly instalment

PMT = RM100,880 ÷ 108 = RM934.0741 ≈ RM934.07

Find the implied monthly reducing-balance rate

Now ask: what monthly rate makes an RM80,000 loan equivalent to 108 payments of RM934.0741?

80,000 = 934.0741 × [1 − (1 + i)^(-108)] ÷ i
i ≈ 0.443960% per month

Spreadsheet approach:

=RATE(108, -934.074074, 80000, 0)

Annualize the monthly rate

Nominal annual rate = 0.443960% × 12 ≈ 5.3275%
Effective annual rate = (1 + 0.00443960)^12 − 1 ≈ 5.4596%
Final answer: Monthly instalment ≈ RM934.07. The implied monthly rate is ≈ 0.44396%; the nominal annualized rate is ≈ 5.33%; and the effective annual rate (EAR) is ≈ 5.46%.

3 Flat Rate vs Nominal Rate vs Effective Rate

Quoted

2.90% Flat Rate

Applied to the original principal when computing the flat interest.

Solve cash flows

0.44396% / month

Periodic reducing-balance rate implied by the actual payments.

Annualize

5.33% nominal / 5.46% EAR

Two annual expressions of the monthly rate.

Flat Rate

Original principal is the base

Interest = P × f × t

P = principal, f = flat annual rate, t = years.

A low-looking flat rate is not directly comparable with a reducing-balance mortgage rate. PDF p.5, pp.20-21

Nominal Annual Rate

Periodic rate multiplied by frequency

j = i × m

For monthly payments, m = 12. It does not add the within-year compounding effect.

Effective Annual Rate

Compounded annual equivalent

EAR = (1 + i)^m − 1

With monthly compounding: EAR = (1 + i_month)^12 − 1.

Most important relationship: there is no universal shortcut that converts a flat rate directly into an effective rate. First construct the actual cash flows, then solve for the periodic RATE, and only then annualize it.
Rate labelOriginal exerciseWhat it representsCan you compare directly?
Flat annual rate2.90%Hire-purchase quote based on original principal.No - not directly with a reducing-balance rate.
Monthly implied rate0.44396%Periodic rate matching the 108 actual payments.Yes, once units are matched.
Nominal annual rate5.33%Monthly rate × 12.Useful quote, but not fully compounded.
Effective annual rate5.46%Annual equivalent after monthly compounding.Best of these for annual cost comparison.

4 TVM Core Knowledge from the 30 Questions

Time Machine

Money has a time dimension

RM100 today is normally preferable to RM100 later because of inflation and opportunity cost.

This is the PDF's first intuitive explanation of TVM. PDF p.6

Direction

Compounding vs Discounting

PV ──compounding──▶ FV
PV ◀──discounting── FV
Time Units

RATE and NPER must speak the same language

If payments are monthly:

  • RATE must be monthly.
  • NPER must be in months.
  • 35 years → 420 monthly periods.

The mortgage example shows that using 4.5% directly as a monthly RATE gives a wildly wrong answer. PDF pp.14-16

Cash-flow Signs

Positive = money in; negative = money out

Borrower's perspective: PV received is positive; monthly PMT paid is negative.

Bank's perspective: the signs reverse.

The PDF stresses that sign convention matters in spreadsheets. PDF pp.9,16,18-19

Which TVM function solves which unknown?

You want to know...UseTypical example
Value todayPVWhat is RM20,000 in 5 years worth today?
Value laterFVWhat will RM10,000 grow to?
Regular paymentPMTWhat is my monthly mortgage instalment?
Interest / return per periodRATEWhat rate is implied by these cash flows?
How many periodsNPERHow many months until the loan is fully paid?
Beginning vs End payments: Type 0 means the payment occurs at the end of each period; Type 1 means it occurs at the beginning. Earlier receipts are more valuable to the receiver. PDF pp.11-12

5 Knowledge Worth Highlighting from the PDF

Mortgage

Long tenure lowers PMT but can greatly increase total interest

The notes use a RM500,000, 35-year mortgage example to show how a manageable monthly instalment can still produce very large lifetime interest.

Lesson: don't evaluate debt using monthly payment alone; include total cost and opportunity cost. PDF p.4

Car Loan

Flat rate can look cheaper than a mortgage rate

The PDF compares a flat-rate car loan with a reducing-balance mortgage and emphasizes using the effective rate for meaningful comparison.

Its RM100,000 / 3.1% / 5-year example produces RM1,925 monthly payments and an effective cost of about 6% p.a. PDF pp.20-21

Insurance

Do not divide a total return percentage by years

In the PDF example, paying RM10,000 yearly for 30 years and receiving RM900,000 at maturity is presented as “200% ÷ 30 = 6.7%”. TVM instead solves the actual annual cash-flow rate, around 6.4% in the notes.

Lesson: timing of contributions matters. PDF pp.22-23

Investment Return

Compare CAGR / implied rate, not just final money

The PDF's lending quizzes show that different cash-flow timings can produce different rates even when total amounts look attractive.

“Math beats intuition” is one of its explicit takeaways. PDF pp.8-13

Opportunity Cost

Cash vs loan is a rate comparison

The notes frame the decision as: compare what your cash can reasonably earn with the effective borrowing cost, not merely the advertised flat rate.

The source uses EPF, FD and investments as examples. PDF p.24

Early Repayment

Paying down a reducing-balance mortgage saves interest at the loan rate

The PDF example shows that reducing a 4.5% mortgage balance by RM50,000 saves about RM2,250 of annual interest initially - equivalent to 4.5% on that amount.

Lesson: compare this guaranteed saving with the return and risk of alternatives. PDF p.25

Early Car Settlement

The source discusses Rule of 78 / rebates

The notes state that early settlement of a flat-rate car loan can result in an interest rebate and describe Rule of 78 front-loading. Treat this as the course-note framework and check the current agreement / rules when applying it to a real loan. PDF p.26

BNPL

“0% instalment” thinking can hide a very high implied rate

The PDF uses a RM5,000 cash price versus RM6,000 over six months example to show why the implied interest rate should be calculated from the cash flows.

Lesson: compare cash price against total instalments using TVM. PDF p.27

Useful cleanup of one PDF quiz: page 8 labels Option D as the “Correct Answer (Guessed)”; page 10 then calculates the rates and confirms D at 12.25%. So the later calculation is the confirmation.
Broader PDF message: TVM is the “grammar of money” - useful for debt, investing, savings, insurance, retirement and business/project evaluation. PDF pp.3-5

6 Interactive Flat-Rate Car Loan Calculator

Change the inputs to see how a flat quote translates into monthly instalment, implied monthly rate, nominal annual rate and EAR.

Assumption: equal monthly instalments and a simple flat-interest quotation over the full tenure.

RM20,880.00Total flat interest
RM934.07Monthly instalment
0.44396%Implied monthly rate
5.4596%Effective annual rate
5.3275%Nominal annualized rate
108Monthly periods
Flat quote 2.90% → solve the reducing-balance monthly rate from the payment cash flows → annualize it.

7 One-Page Memory Sheet

Core formulas

FV = PV × (1 + r)^n
PV = FV ÷ (1 + r)^n
Flat Interest = Principal × Flat Rate × Years
Nominal Annual Rate = Periodic Rate × periods/year
EAR = (1 + Periodic Rate)^(periods/year) − 1

Before solving any TVM problem

  1. Draw the cash-flow direction.
  2. Identify PV, FV, PMT, RATE, NPER.
  3. Match the time units.
  4. Set signs from one perspective.
  5. Check payment timing: beginning or end.
  6. Solve the unknown.
  7. Compare equivalent rates, not labels.

Common traps to avoid

“2.9% flat = 2.9% effective.”

False. They are different rate conventions. The RM80,000 example translates to about 5.46% EAR.

“5.33% nominal and 5.46% EAR contradict each other.”

No. 5.33% is monthly rate × 12. 5.46% compounds the monthly rate over 12 months.

“A bigger final amount must mean a better investment.”

Not necessarily. You must account for how long the money was invested and when cash flows occurred.

“RATE is always annual.”

No. RATE is per period. If NPER is in months, RATE must be monthly.

“The total amount paid matters more than timing.”

TVM says timing matters greatly. Earlier money is usually more valuable.

Best single sentence to remember:
TVM converts cash flows occurring at different times into a common basis so you can compare loans, investments and payment plans fairly.