Annuity Payment Formula PV


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


This annuity payment formula PV calculates the annuity payment required to provide a given value today PV (present value). The annuity formula assumes payments are made at the end of each period for n periods, and a discount rate i is applied.

The annuity formula can be used for example to determine the regular periodic payments required to clear a loan balance (PV).

Excel Function

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

PMT(Rate, Nper, PV, FV, Type)

*In this instance, the FV and type arguments are not used when using the Excel annuity payment function.

Example Using Annuity Payment Formula PV

A loan balance (PV) of 6,000 is cleared with regular annuity payments for 10 periods at an interest rate of 5%. The amount of the annuity payment is given by the annuity payment formula PV as follows:

Annuity payment = Pmt = PV x i / (1 - 1 / (1 + i)n)
Annuity payment = Pmt = 6000 x 5% / (1 - 1 / (1 + 5%)10)
Annuity payment = Pmt = 777.03 

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

Annuity payment = PMT(Rate, Nper, PV, FV, Type)
Annuity payment = PMT(5%, 10, -6000)
Annuity payment = 777.03

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

Annuity Payment Formula PV November 6th, 2016Team

You May Also Like

Related pages

how to compute for retained earningsjournal entry interest expensehow to calculate depreciation straight line methodfactored accounts receivablemarkup on cost vs markup on selling pricerevenue recognition percentage of completion methodgeneral ledger accounts receivablefinished goods inventory formuladeferred expense journal entrycash credit memo formataccounting for obsolete inventorybasics of payrollwhen is the trial balance preparedaccoutning equationcalculate markup percentage formulalower of cost and net realizable valuebookkeeping notesdeferred taxation meaningaccrued expenses journalmargin versus markup calculatorwhat does sales ledger meandirect labor rate formulajournal entry deferred tax assetjournal entries basicsprepaid insurance liabilitygrn in accountingbasic accounting conceptjournalizing entriesbond coupon formulaformula for present value of annuity duegrn accountingwhat is profit markupwarranty expense on income statementfob shipping point definitiongraduated annuityending inventorydebit note definition in accountingbalancing petty cashtrial balance worksheet templatequick ratio formula financeinventory turnover calculatorallocation of overheads in cost accountingjob costing spreadsheetexplain double entry bookkeepingaverage inventory days formulaexamples of prepaid expenses in accountingamortisation of debtexamples of stockholders equitytie ratio calculatoraccounting for leases lessorjournal entry for collection of accounts receivablecash disbursementscurrent liabilities definition in accountinghow to figure out percentage markupconverting cash basis to accrual basiscommon size analysis on an income statemententry for bad debtscash vs accrualsequity method journal entriesaccount receivable turnover analysisunfavorable variance definitionmanufacturing overhead costs includebookkeeping for small business templatesa common size income statementaccounting for leases journal entriesstock turnover calculationa company that receives an interest bearing note receivable willvoucher templates wordfactored receivablesdefine sundry debtorswhat is lifo reservewhat is the formula for retained earningswhat is debtors control account