Growing Annuity Payment Formula FV

Formula

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

Use

This growing annuity payment formula FV calculates the initial annuity payment required to provide a given future value (FV) using a growing annuity. The growing annuity payment formula assumes payments are made at the end of each period for n periods and are growing or declining at a constant rate g, and a discount rate i is applied.

Example Using Growing Annuity Payment Formula FV

Initial Payment

The initial payment is made at the end of period one. Suppose an investment requires 24 (n) regular periodic payments growing at a rate of 4% (g) each period. Assuming a discount rate of 6% (i), and a required future value of 8,000 (FV), what is the amount of the first (initial) payment required.

The initial payment amount is given by the growing annuity payment formula FV as follows:

Pmt = FV x (i - g) / ( (1 + i)n - (1 + g)n )
Pmt = 8000 x (6% - 4%) / ( (1 + 6%)24 - (1 + 4%)24 )
Pmt = 107.70

Later Period Payments

The initial payment calculated above is made at the end of period one. The value of the payment at the end of any other period is calculated by compounding the initial payment forward at the growth rate (g) using the . For example, if the amount of the payment at the end of period nine is required, then this would be calculated as follows:

FV = PV x (1 + i)n
FV = Pmt (9)
PV = Pmt (1)
n = 15 (periods between 1 and 16)
Pmt(n) = Pmt(1) x (1 + g)n
Pmt(16) = 107.70 x (1 + 4%)15
Pmt(16) = 193.96

At a growth rate of 2% (g), the initial payment at the end of period one of 107.70, would have grown into a payment 193.96 by the end of period sixteen.

The growing annuity payment formula FV is one of many growing annuity formulas used in time value of money calculations, discover another at the link below.

Growing Annuity Payment Formula FV November 6th, 2016Team

You May Also Like


Related pages


fifo costingaccounts receivable turnover rationpresent value perpetuity formuladouble declining calculatorfundamental accounting conceptabsorbed overheadadjusting entries for interestaged receivablejournal entry for rent paid to landlordequation for markupaccounting general ledger exampleunearned revenue meaningpv and fv formulasjournal entry for billing customersaccrual to cash worksheetbookkeeping formatdu pont equationsum of years digits method of depreciationimprest amount meaningaccounting equation spreadsheetprinciple of double entry accountingexcel annuity formulacompany bookkeeping templatesdouble declining depreciation calculation formulaaccounting equation isoutstanding rent journal entryaccounting ledger examplesaccounts receivable interview questions and answersfinding the interest rate of an annuityinterest on investment journal entrymarkup vs gross profitwhat is lifo methodcontra liabilitiesmanagement accounts excel templatecheque received journal entryexcel formula to calculate interest ratebookkeeping t accountsexamples of reversing entriesstandard costing journal entriescalculating percentage markupequity gearing ratiocash vs accrualsexcel charts samplesfinancial ratios formulas excelcash receipt journal templatedouble declining balance method depreciationaccrued revenue exampleperpetuity formulabad debts debit or creditformula to calculate marginal costjournal entries debits and creditsaccounts receivable is a debit or creditpayment record template excelcommon bookkeeping entriesfinancial ledger examplecurrent portion of long term debt journal entryannuity due formulajob costing exceldefine capacity cushionpresent value of increasing annuitybad debts journal entryannuity table excelaccrued expenses in accountingfavorable variance definitioncheque nsfexcel ratio formulacalculating a ratio in excelnpv for perpetuityfree payment voucher templateannuity due equationgeneral ledger exampleaccounts receivable excel templatesyd depreciation