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

bank reconciliation statement proformahow to calculate gearing ratio from balance sheetreduced balance depreciationhow to record allowance for doubtful accountsdepletion of coalannuity due payments are madepayback ratiocalculation of straight line depreciationaging the accounts receivablerequisition of materialshow to calculate a stock splitbusiness plan financials template excelcalculating present value of annuitysales discounts on income statementjurnal inventorydirect material price variance formulaunderapplied overheadfob destination prepaid and addcost accounting overheadsfob shipping point means the seller pays cost of freightacid test liquidity ratiopercentage of completion journal entriesimportance of petty cash bookstock turnover days calculationaccounts receivable days calculationtrial balances accountingpmt calculationstraight line depreciation journal entryjournal entry for collection of accounts receivablesales ledger control account exampleperpetuity due formulabooking depreciationsuspenses accountprojected revenue templatebad debts in profit and loss accounttotal manufacturing overhead cost formulaaged accounts payabletypes of bank reconciliation statementaccount receivable balance sheetaccounts payable debits and creditsobsolescence inventorybank account reconciliation templatecash disbursement voucherdouble entry bookkeeping basicsgoods shipped on consignmentcompound continuously interest formulamanufacturing overhead rate calculatorstore requisition slip formatdebit credit accounting chartaccounting cheat sheet debit creditimprest accountsdu pont ratiosbank reconciliation notes pdfreversing accrued expensesfactory overheadsexamples of horizontal analysisprepayment accounting entryprepaid insurance current assethow to compute total manufacturing costreceivable discountingaccounts receivable checklistcommon size balance sheetsuncleared cheques in bank reconciliationpurchased merchandise on account journal entryaccounts receivable templateswhy trial balance is preparedcash receipt book templateaccounting equitionabsorption rate calculatorgoods receipt notereceivable control account formatcalculating cost of goods manufacturedannuity immediate and annuity due