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


definition of shrinkagebank reconciliation journal entriescurrent ratios and quick ratiospresent value of an annuity due of 1 tablecalculating quick ratio from balance sheetvoucher template wordsum-of-the-years-digits method of depreciationdaily timesheet template excelaged creditorshalf year rule depreciationunits of production method depreciation calculatorgross profit percentage formula excelformula for diminishing value depreciationexpenses voucher samplecoupon bond calculator present valuedirect material variance formulaaccrual versus casheffective interest rate amortization calculatorhow to calculate cost of goods sold from balance sheetaverage account receivableschart of accounts for a restaurantreceivable control account formatfactored debtsadjusted trial balance templateunderstanding debits and creditsoutstanding loan calculatorhow to calculate stock value in excelwhat is stockholders equity in accountingreversing entries definitioncash disbursementsunit variable cost formuladouble entry records for depreciationdepreciation expense journal entry examplethe double declining balance method of depreciation is used forfinding ending inventoryadvantages of petty cashtreatment for provision for doubtful debtdeferred tax calculationaccounts mcq questions with answersinsurance accounting basicsstandard cost and standard costingcalculating gross profit rateimpairment journal entryhow to calculate project payback periodlcm in accountingprintable blank spreadsheet templatescvp income statement exampleexcess and obsolete inventorysmall business bookkeeping template excelfinancial leverage ratio formulaexcel pv calculationledger sheet template excelis unearned revenue a credit or debitsales invoice double entrydeferred revenue expenditureperpetual and periodic inventory systemabsorption of overheadsaccounts payable report samplear accounting entriestrade discount series formulaannuity tables future valuelength of operating cycle formulatrial balance and balance sheet exampleoverapplied overheadperpetuities calculatornbv in accountingcost of goods manufactured statementpv of growing annuitycalculate percentage markupjournal entry for dividendsdebtors days calculation formulabusiness plan financial projections template freejournal entries for construction contractscalculating allowance for doubtful accountsequation for ending inventoryretained earnings meaningperiodic quizcapital in accounting equationcoverage ratios formulainventories turnover days formulacalculate paybackaccrual accounting entriesexamples of journal entries with narrationmanual ledger formatear apr formulahow to calculate salvage value of equipmentfifo method in cost accountinglease journal entriesvariable cost calculationdebits vs credits