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


basic accounting knowledge testwhat is objectivity principle in accountingwhat is an accounts payable ledgermatching concept accounting principlefiguring markupoperating leverage calculationroyalty expense on income statementvertical analysis of financial statementsdeclared cash dividendfixed asset register templatehow to calculate allowance for doubtful accountscash receipts journal exampleprovision for doubtful debtcalculate actual manufacturing overhead costsadjusting entry for merchandise inventorycommon size income statement and balance sheetwhat is the pmt formulacalculate payback period uneven cash flowsjournalizing accountingcalculate net realizable valuejournal entry interest expensegross margin equalswhat is depletion expenseexplain pmt function in excelcompute the depreciation cost per unitwhat are adjusting entriesprepaid expense account typepurchase ledger control account exampleexcel present value annuityperiodic inventory system income statementthe accounting for cash discounts and trade discounts aretotal asset turnover ratio examplebasic bookkeeping formshow to do fifo methodpartnership appropriation accountequation for quick ratiohow do i calculate retained earnings on a balance sheetspreadsheet for bookkeepinglong term borrowings definitionsample of a bank reconciliation statementweighted average cost inventory methoddebt calculator excelbond amortization tabledeferrals and accrualsexcel npv calculationcontra equity account exampleshow to calculate npv excelbills receivable accounting entrieseft electronic funds transfer definitionaccounting fob shipping pointjournal entry for cheque receivedhow do you calculate debtor dayswhat is the formula for straight line depreciationanuity formuladouble depreciation formulaaverage account receivablescalculating npv on excelstockholders equity equationdeferred revenue accounts receivableadjusted trial balance worksheet templatedebits and credits journal entrieswage expense journal entrydiscounted cash flows excelaccruals journal entrypresent value of an ordinary annuity calculatorpurpose of cvpmanufacturing overheadbalance sheet with accumulated depreciation examplebalance sheet unearned revenueextended warranty revenue recognitionmeaning of imprest moneyjournalize the petty cash transactionswhat does nett 30 days mean
s, on 23-06-18 17:44:25 -->