Future Value of a Growing Annuity Formula

Formula

FV = Pmt x ( (1 + i)n - (1 + g)n ) / (i - g)
Variables used in the annuity formula
FV = Future Value
Pmt = Periodic payment
i = Discount rate
g = Growth rate
n = Number of periods

Use

The future value of growing annuity formula shows the value at the end of period n of series of periodic payments which are growing or declining at a constant rate (g) each period. The payments are made at the end of each period for n periods, and a discount rate i is applied.

A growing annuity is sometimes referred to as an increasing annuity or graduated annuity.

The formula compounds the value of each payment forward to its value at the end of period n (future value).

Example Using the Future Value of a Growing Annuity Formula

If a payment of 8,000 is received at the end of period 1 and grows at a rate of 6% for each subsequent period for a total of 10 periods, and the discount rate is 3%, then the value of the payments at the end of period 10 is given by the future value of a growing annuity formula as follows:

FV = Pmt x ( (1 + i)n - (1 + g)n ) / (i - g)
FV = 8,000 x ( (1 + 3%)10 - (1 + 6%)10 ) / (3% - 6%)
FV = 119,181.68

Discount Rate Equals Growth Rate

In the special case where the discount rate (i), is equal to the growth rate (g), the formula above cannot be used as the term (i – g) goes to zero.
In this situation the following formula is used.

FV = Pmt x n x (1 + i)(n-1)

The future value of a growing annuity formula is one of many annuity formulas used in time value of money calculations, discover another at the links below.

Future Value of a Growing Annuity Formula November 6th, 2016Team

You May Also Like


Related pages


is commission a variable costdefinition cashiers checkexcel amortization spreadsheetstraight line method of depreciation calculationcalculation of operating leveragenet receivables turnoverprovision for bad debts income statementcalculate npv on excelaccounting template excelpetty cash voucher meaninga dividend preference for preferred stock means thatjournal entry for bad debtdebit and credit quizmanufacturing over headhow do you compute gross profitis cash book a journal or a ledgerpresent value of an annuity in excellump sum purchase accountingformula for calculating gross profitaccounts receivable turnover ratio interpretationdouble declining balance depreciation examplejournal entry for prepaymentcalculate manufacturing overhead ratepetty cash reconciliationhow to calculate contribution to sales ratiofuture value of an annuity formulaamortizing bond premiumexamples of revenue receipts and capital receiptsdepreciation deferred tax liabilitydistinguish between revenue expenditure and capital expenditurechain discount calculatoraccruals and prepayments double entrycalculating markup vs marginretained earning formulacogs formulawhat is the meaning of prepaid expensescost volume profit graph excel templatewhat does gross payroll meanincome statement projection templatepayroll accrual entryexcel bank reconciliation templatepv of perpetuity formulasteps for accounting cycledouble declining depreciation calculationwhat is contra entry give an examplelabour costing in cost accountingfinancial statement projections templatedividend declaration templatewhat is a compound journal entry in accountingbep formulavoucher templatesfinancial accounting worksheetpv table annuityrate variance formulaexamples of unearned revenueinterest calculator reducing balance methodformula to work out marginprofit margin formulasfair value ociallowance for bad debt accounthow to calculate variable overhead rateamortize bond discountequity multiplier analysisformula dividend payout ratiodefine capital injectionfixed manufacturing overhead costswhat is revenue expendituresvertical analysis for balance sheetdouble entry accounting tutorialformula present value annuityincurred advertising expense on accounthow to calculate debtors days