Present Value of Annuity Due Formula

Formula

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

Use

The present value of annuity due formula shows the value today of series of regular payments. The payments are made at the start of each period for n periods, and a discount rate i is applied.

The formula discounts the value of each payment back to its value at the start of period 1 (present value).

Excel Function

The Excel PV function can be used instead of the present value of annuity formula, and has the syntax shown below.

PV(i, n, pmt, FV, type)

*The FV argument is not used when using the Excel present value of an annuity due function.

Example Using the Present Value of Annuity Due Formula

If a payment of 6,000 is received at the start of each period for 9 periods, and the discount rate is 6%, then the value of the payments today is given by the present value of annuity due formula as follows:

PV = Pmt x (1 + i) x (1 - 1 / (1 + i)n) / i
PV = 6,000 x (1 + 6%) x (1 - 1 / (1 + 6%)9) / 6%
PV = 43,258.76

The same answer can be obtained using the Excel PV function as follows:

PV = PV(i, n, pmt,,1)
PV = PV(6%,9,-6000,,1)
PV = 43,258.76

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

Present Value of Annuity Due Formula November 6th, 2016Team

You May Also Like


Related pages


joint venture accounts examplesfederal income tax expense adjusting entrysimple accounting spreadsheet for small businessrule 78 calculatoradjusting entries for accrualsledger bookkeepingcapital expenditure accounting treatmenttrial balance entries examplesgaap chart of accounts numberingpayback accountinginvestment accounting journal entriespayroll journal templateconsignor consigneedays sales in receivables ratio formuladebit cash credit accounts receivablecalculating markup and marginexcel npv function exampleassets turnover ratio interpretationnotes receivable adalahpetty cash voucher templatebudgeted overhead absorption ratelegal timesheet templatecalculating operating leveragedeferred tax asset accountingabsorption costing calculatortrial balance meaning in accountingimprest petty cash system examplepurchase order format xlspresent value of cash flows in excelresidual value exceldifference between periodic and perpetual inventorycapital turnovercredit card accounting entriesdebtor days ratioapr ear formularetained earnings debitdouble decline depreciation formulafreight prepaid meanswip calculation formuladebtors and creditors on balance sheetformula cogsperiodic costingbalance sheet template in excelcashflow statement samplehow do you calculate contribution marginjournal entries for construction contractsmaterials quantity variancehow do you calculate retained earningsadjusting entry for supplies usedincome statement unearned revenuepoc calculationannuity formula excelallowance for doubtful receivablesdeclining depreciation calculatorrecording bad debt expense journal entrygross profit formula excelcalculate pmt in excelamortization spreadsheet templatedebtors ledger examplehow do you calculate markup percentagehow to improve total asset turnovermargin vs markup calculationbook keeping equationdebit to accounts payablecalculate present value of perpetuityweighted average periodic inventory methodpva tablejournal entry for debtorsasset disposal double entryddb depreciation calculatorpv annuity formulacalculate current ratio accountingrecording depreciation expensehow to do bank reconciliation examplesubsidiary journalsannuity table present valueprepaid journal entry