Tutorials › VEE Accounting and Finance › Solving for Annuity Payments From Present or Future Value

VEE Accounting and Finance · Annuities and Perpetuities · Tutorial 329 of 996

Solving for Annuity Payments From Present or Future Value

Learn how to isolate a level end-of-period payment from a present-value or future-value target and verify that the timing and rate periods match.

Beginner 9 min read

What You'll Learn

  • Identify the payment timing and period before selecting an annuity formula.
  • Solve for a level payment using a present-value target.
  • Solve for a level payment using a future-value target.
  • Derive the ordinary-annuity payment factors from the cash flows.
  • Check a solved payment by valuing the resulting stream.
  • Recognize errors caused by mismatched timing, rates, or rounding.

From an Annuity Value to the Payment

An annuity problem often gives the value of a stream of equal payments and asks for the payment itself. The key is to identify the valuation date and payment dates before rearranging a formula. A present value discounts payments to the start of the stream; a future value accumulates them to the end. In either case, the payment formula applies only when the payment timing and interest-rate period match the annuity factor being used.

This tutorial focuses on an ordinary annuity: a fixed number of equal payments made at the end of each period. Let \(R\) be the payment per period, \(n\) the number of payments, and \(i\) the effective interest rate per payment period. Assume the same rate applies in every period. The payment amount is solved from a given value; it is not necessary to guess payments and adjust them iteratively.

Definition: For an ordinary annuity with \(n\) end-of-period payments of \(R\), the present value at time 0 is \(R a_{\overline{n}|}\), where \(a_{\overline{n}|}=(1-v^n)/i\) and \(v=1/(1+i)\). Its accumulated value immediately after the \(n\)th payment is \(R s_{\overline{n}|}\), where \(s_{\overline{n}|}=((1+i)^n-1)/i\). These factors use an effective rate per payment period.

If the given present value is \(P\), solve \(P=R a_{\overline{n}|}\) for \(R\). If the given future value is \(F\), solve \(F=R s_{\overline{n}|}\). When \(i=0\), each payment has the same value at every date, so both annuity factors are \(n\), and the payment is the stated value divided by \(n\). The formulas with division by \(i\) are used when \(i\ne0\).

$$ R=\frac{P}{a_{\overline{n}|}} \qquad\text{or}\qquad R=\frac{F}{s_{\overline{n}|}} $$

The rate and \(n\) must describe the same period. For example, if payments are monthly, use a monthly effective rate and a count of monthly payments. A quoted nominal annual rate convertible monthly is not itself the monthly rate; divide it by 12 to obtain the monthly rate when that is the stated compounding convention. If the payments occur at the beginning rather than the end of each period, these ordinary-annuity factors do not directly apply.

Why the Payment Formulas Work

Each payment is valued separately, then the values are added. For present value, the payment at time \(k\) is discounted \(k\) periods. For future value at time \(n\), the payment at time \(k\) earns interest for \(n-k\) periods. These cash-flow descriptions explain both the factors and why the timing convention matters.

$$ P=Rv+Rv^2+\cdots+Rv^n =R\left(v+v^2+\cdots+v^n\right) =R\frac{1-v^n}{i} =R a_{\overline{n}|} $$

For the present-value identity, the terms in parentheses form a finite geometric series with first term \(v\), common ratio \(v\), and \(n\) terms. Its sum is \(v(1-v^n)/(1-v)\). Since \(v=1/(1+i)\), \(1-v=i/(1+i)=iv\), so \(v/(1-v)=1/i\). Therefore the sum is \((1-v^n)/i\). Dividing the resulting equation \(P=R a_{\overline{n}|}\) by the annuity factor gives \(R=P/a_{\overline{n}|}\).

$$ F=R+R(1+i)+\cdots+R(1+i)^{n-1} =R\frac{(1+i)^n-1}{i} =R s_{\overline{n}|} $$

The future-value terms also form a finite geometric series, now with first term 1 and common ratio \(1+i\). Their sum is \(((1+i)^n-1)/i\), which gives the stated accumulated-value factor. Thus \(R=F/s_{\overline{n}|}\). In both derivations, the first payment is at the end of period 1; shifting payments earlier changes their valuation dates and changes the applicable factor.

Solving from a Present-Value Target

Worked Example: Funding a Present-Value Requirement

A hypothetical reserve plan is to be funded by six equal annual deposits, each made at the end of the year. The effective annual interest rate is 8%, and the deposits must have a present value of $12,000 at time 0. Find the annual deposit, rounded to the nearest cent.

Method and timing. There are \(n=6\) payments at times 1 through 6, so this is an ordinary annuity valued at time 0. The rate per annual payment period is \(i=0.08\). The present-value equation is \(12{,}000=R a_{\overline{6}|}\).

Calculate the factor. First, \(1.08^6=1.586874322944\), so \(v^6=1/1.08^6\approx0.630169627\). Therefore,

$$ a_{\overline{6}|} =\frac{1-0.630169627}{0.08} \approx4.622879664 $$

Solve for the payment.

$$ R=\frac{12{,}000}{4.622879664} \approx2{,}595.7846 $$

Rounding only the final payment to two decimal places gives an annual deposit of $2,595.78. As a check, six end-of-year deposits of this amount have present value approximately \(2{,}595.78(4.622879664)=\$11{,}999.98\). The small difference from $12,000 is due to rounding the payment to cents. The method avoids treating the target present value as if it were the payment itself.

Solving from a Future-Value Target

Worked Example: Reaching a Target Accumulated Balance

A hypothetical equipment fund receives five equal deposits at the end of each year. The effective annual interest rate is 6%, and the balance immediately after the fifth deposit must be $20,000. Find the annual deposit, rounded to the nearest cent.

Method and timing. The deposits occur at times 1, 2, 3, 4, and 5. At time 5, the last deposit has earned no interest, while the first has earned interest for four years. Thus the target is a future value, and \(n=5\), \(i=0.06\).

Calculate the accumulation factor. Since \(1.06^5=1.3382255776\),

$$ s_{\overline{5}|} =\frac{1.3382255776-1}{0.06} =5.63709296 $$

Solve for the payment.

$$ R=\frac{20{,}000}{5.63709296} \approx3{,}547.9280 $$

Rounding the annual deposit to two decimal places gives $3,547.93. Checking the rounded amount, \(3{,}547.93(5.63709296)\approx\$20{,}000.01\), which is one cent above the target because of payment rounding. The method avoids accumulating the first deposit for five years: it is made at the end of year 1 and therefore earns interest for only four years.

Check the Payment Dates Before Calculating

Annuity factors are compact summaries of a specific set of dated cash flows. For an ordinary annuity, the present-value terms are \(Rv, Rv^2,\ldots,Rv^n\), and the future-value terms are \(R(1+i)^{n-1},\ldots,R, R\). A payment at time 0 would not be discounted in a present-value calculation; a payment made at the beginning of a period has a different accumulation duration from an end-of-period payment. Before using a factor, sketching the payment dates is a useful safeguard.

Worked Example: Separating Timing from the Algebra

A short-term project is expected to produce two equal cash inflows at the ends of years 1 and 2. Their present value at time 0 is $7,200. The effective annual interest rate is 25%. Find each inflow.

Method. The two inflows are end-of-year payments, so use the ordinary-annuity present-value factor with \(n=2\) and \(i=0.25\). Write the dated cash flows explicitly before applying the factor:

$$ 7{,}200=R(1.25)^{-1}+R(1.25)^{-2} =R(0.8+0.64) =1.44R $$

Solve and check. Dividing by 1.44 gives \(R=\$5{,}000\). Discounting the two payments separately confirms the result: the first has present value \(5{,}000/1.25=\$4{,}000\), and the second has present value \(5{,}000/1.25^2=\$3{,}200\). Their sum is $7,200.

The common mistake is to treat the first inflow as if it occurred at time 0. That would give the incorrect equation \(7{,}200=R+0.8R\), and an incorrect payment of $4,000. The stated end-of-year timing requires discounting the first payment once and the second twice.

A Reliable Solution Process

1
Mark the valuation date and payment dates.
Confirm whether the value is present or future and whether payments occur at period ends. Count the actual payments, not the intervals between the first and last payment.
2
Match the rate period to the payment period.
Use the effective rate for one payment interval. Convert a quoted rate as required by its compounding convention before using an annuity factor.
3
Choose and rearrange the value equation.
For a present-value target use \(P=R a_{\overline{n}|}\); for a future-value target use \(F=R s_{\overline{n}|}\). Isolate \(R\) only after choosing the factor.
4
Check the result against the original cash flows.
Substitute the payment into the appropriate annuity equation. Keep full precision in intermediate calculations and round the payment only at the end.

Common Errors and Why the Method Matters

Solving for a payment is useful whenever a financial decision is framed as a required periodic contribution, receipt, or debt-service amount. The arithmetic is usually short; most errors come from modeling the cash flows incorrectly or rounding too early.

ErrorWhy it is wrongCorrection
Using \(s_{\overline{n}|}\) for a present-value targetThe future-value factor accumulates payments to the end date rather than discounting them to time 0.Match the factor to the stated valuation date.
Using an annual rate with monthly paymentsThe rate and number of periods then refer to different time units.Convert to the effective rate per payment period and use the number of payments.
Assuming an ordinary annuity when payments are due at the startThe cash flows occur on different dates from the ordinary-annuity model.Identify timing first; do not apply the end-of-period factor unchanged.
Rounding the annuity factor or payment too earlySmall rounding differences can affect the final payment, especially when the target or factor is large.Retain calculator precision through the division and round only the final amount.
Counting elapsed intervals instead of paymentsTwo payments can be separated by one interval, but the annuity has two payments.List the payment dates and count each cash flow.

A useful dimensional check is that the annuity factor is dimensionless: it is a sum of discount or accumulation factors. Dividing a dollar value by that factor therefore produces a dollar payment. A useful direction check is that, for a positive interest rate, an ordinary annuity's future-value factor exceeds \(n\), while its present-value factor is less than \(n\). Those comparisons can reveal a wrong factor or a rate entered with the wrong sign.

Key takeaway: For equal end-of-period payments, divide the target present value by \(a_{\overline{n}|}\), or divide the target future value by \(s_{\overline{n}|}\). The result is valid only when the interest rate, payment period, payment count, and payment timing all match the model.

Check Your Understanding

For each problem, use the stated end-of-period timing and round the requested payment to the nearest cent.

  1. A fund must have present value $9,000 for three equal annual payments made at year-end. The effective annual rate is 5%. Find each payment. (Answer: $3,304.88)
  2. Four equal deposits are made at the ends of years 1 through 4 into an account earning an effective annual rate of 8%. What deposit produces a balance of $12,000 immediately after the fourth deposit? (Answer: $2,663.05)
  3. Two equal cash receipts at the ends of years 1 and 2 have present value $5,000 at an effective annual rate of 10%. Find each receipt. (Answer: $2,880.95)
  4. An account earns an effective monthly rate of 1%. Six equal deposits are made at the ends of months 1 through 6. What monthly deposit produces a balance of $6,152.02 immediately after the sixth deposit? (Answer: $1,000.00)
Clinical Biostats