On this page
Lesson details
- Estimated study time
- 1 hr 30 min
Learning objectives (6)
The first calculation is a control decision
Suppose Cedar Works needs $60,000 in 3 years and is given a 4.8% stated annual rate compounded monthly. A calculator invites four keystrokes. A professional workpaper first asks what each input means.
valuation date: 2026-01-01, labeled t = 0
target date: month 36
cash flows: one deposit at t = 0; one $60,000 target at t = 36
periodic rate: 0.048 / 12 = 0.004 per month
period count: 3 × 12 = 36 months
The controlled pair is 0.004/month and 36 months. Units are part of the
number. If they do not match, stop.
The failure in a mismatched pair is mechanical, not stylistic. Entering
i = 0.048 with n = 36 tells the formula to apply 4.8% in every month;
entering i = 0.004 with n = 3 applies a monthly rate only three times. In
each case the formula follows the inputs exactly and answers the wrong unit
question.
Build the timeline from boundaries
The points t = 0, 1, 2, 3 contain three intervals. This matters because a
common error counts labels instead of gaps. For monthly work, expand the same
line to month 36 rather than leaving the rate monthly and the period count in
years.
Use signs only after declaring a viewpoint. Cedar Works can show its deposit as an outflow and the target as an available inflow. A bank or fund would see the opposite directions. The foundation sometimes computes only a positive amount's size and leaves inflow or outflow signs outside the formula. Even in that magnitude-only use, the workpaper must name the viewpoint before later cash-flow analysis.
Ask what the comparison date is
Equal nominal dollars at two dates are not directly equivalent under a positive supplied rate. Translate both to one date before comparison. That date can be the present, a future decision date, or another supported measurement date; it is not automatically the day the analyst opens a spreadsheet.
Accounting and finance share the date-and-unit discipline. They do not share every decision rule. An accounting measurement requires applicable authority and a measurement objective. A finance comparison requires a rate and cash- flow set justified for the decision. This lesson supplies neither judgment; it shows how to preserve inputs once supplied.
Use a pre-calculation control block
Before opening a TVM function, write:
| Control | Required evidence |
|---|---|
| Viewpoint | Whose inflows and outflows are represented? |
| Valuation date | At what exact date will values be compared? |
| Cash-flow dates | On which boundary does every amount occur? |
| Interval | What duration is one period? |
| Rate type | Stated, periodic, effective, or another convention? |
| Rate unit | Decimal rate per what interval? |
| Count | How many matching intervals, not date labels? |
| Boundaries | Which fees, risks, taxes, options, and rules are excluded? |
Stop conditions
Do not calculate when the first payment date is ambiguous, annual and monthly units conflict, a quoted rate is undefined, unequal intervals are forced into an equal-period factor, or the valuation date is missing. A precise output from uncontrolled inputs is not partial credit in professional work; it is a more persuasive error.
Exit check
A 9% stated annual rate compounds quarterly for 2 years. The controlled pair
is 0.09/4 = 0.0225 per quarter and 2×4 = 8 quarters. Explain why
i = 0.09, n = 8 and i = 0.0225, n = 2 each fail before computing anything.