Growing Annuity Payment Formula PV

Formula

Pmt = PV x (i - g) / (1 - (1 + g)n x (1 + i)-n )
Variables used in the growing annuity payment formula PV
PV = Present 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 PV calculates the initial annuity payment required to provide a given value today PV (present value) 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 PV

Initial Payment

The initial payment is made at the end of period one. Suppose an investment provides 12 (n) regular periodic payments growing at a rate of 2% (g) each period. Assuming a discount rate of 5% (i), and a required present value of 5,000 (PV), what is the amount of the first (initial) payment required.

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

Pmt = PV x (i - g) / (1 - (1 + g)n x (1 + i)-n )
Pmt = 5,000 x (5% - 2%) / (1 - (1 + 2%)12 x (1 + 5%)-12 )
Pmt = 510.56

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 future value of a single payment formula. 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 = 8 (periods between 1 and 9)
Pmt(n) = Pmt(1) x (1 + g)n
Pmt(9) = 510.56 x (1 + 2%)8
Pmt(9) = 598.20

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

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

Growing Annuity Payment Formula PV November 6th, 2016Team

You May Also Like


Related pages


petty cash systemsfob invoiceinventory turnover period formuladefinition of absorption costingdepreciation expense journal entrymultiple step income statement templatefob freight collecthow to compute ending retained earningsadjusting entries problems and solutionscash receipt book formatformula for calculating payback periodobsolete inventory definitionbookkeeping excel templatespetty cash voucher template ukfuture value of periodic paymentsaccounting worksheetssundry meaning in accountingmeaning of accounting cycleperpetuity due formulapresent value of lump sumdirect material usage variancepresent value of a perpetuity that starts in the futurebond interest expense calculatoraccounts payable accrualsdebt to equity calculatoraccelerated depreciation formulaadjusting entry for notes payablecalculate present value of annuity dueprepayment journal entriesreorder point equationvertical analysis of balance sheetcash conversion calculatoraccounting rate of return advantages and disadvantagesjournal entry to record accounts receivablehow to calculate bad debt provisionprofit margin in excelhow to prepare a bank reconciliation statement for the monthcalculating npv using excelba ii plus growing annuityuncredited chequesunearned revenue normal balancepost closing trail balancewhat does gross payroll meanannuity present value excelfuture value ordinary annuity calculatordisposal of fixed assets definitionhow to record accrued expensestvm calculator exceldefine direct labor costcontribution margin in dollarsbookkeeping for a small business templatecontra revenue account listmargin vs markup calculatorcommon sized income statementpresent annuity tablethe amount of a promissory note is called thevariable overhead varianceimprest account examplebookkeeping on excel spreadsheetsstandard chart of accounts numberingpetty cash sheetdefinition of bounced checkbalance sheet reconciliations examplesafda accountingaccounting adjusting entries practice problemswhat is consumables in accountingpremium bonds interesthow to calculate material price variancepetty cash transactions definitionarr in accountingexcel ratio formulahow to calculate payback period in yearshow to calculate raw materials inventorypresent value factor of annuitypetty cash definition in accounting