Annuity Formulas

An annuity is a series of annual payments made at the end of each year for a fixed number of years. Annuities with payments at the end of each year are sometimes referred to as regular annuities.

Annuity Formula Examples

Annuity formulas are used to calculate annuity values. The formula to use will depend on which components of the annuity are already known.

The listing below summarizes the various formulas to use for annuity calculations.

In all annuity formulas the following symbols are used.

  • FV = Future value
  • PV = Present value
  • i = Periodic rate
  • Pmt = Periodic payment
  • n = Number of years
  • LN is a natural logarithm

The example used below for each of the annuity formulas is based on the following information.

  • Future value = FV = 7,335.93
  • Present value = PV = 4,622.88
  • Periodic rate = i = 8%
  • Periodic payment = Pmt = 1,000
  • number of years = n = 6

Future Value of an Annuity

FV = Pmt x ((1+i)n-1)/i
Excel Formula
FV = -FV(i%,n,Pmt)
FV = 1000 x ((1+8%)6-1)/8% = 7,335.93

Present Value of Annuity

Calculate Annuity Payments based on Present Value

Pmt = PV/((1-1/(1+i)n)/i)
Excel Formula
Pmt = PMT(i%,n,-PV)
Pmt = 4,622.88/((1-1/(1+8%)6)/8%) = 1,000

Calculate Annuity Payment based on Future Value

Pmt = FV/(((1+i)n-1)/i)
Excel Formula
Pmt = PMT(i%,n,,-FV)
Pmt = 7,335.93 /(((1+8%)6-1)/8%) = 1,000

Number of years based on Future Value

n = LN(1+FV/Pmt x i)/LN(1+i)
Excel Formula
n = nPER(i%,Pmt,,-FV)
n = LN(1+7,335.93/1000 x 8%)/LN(1+8%) = 6

Number of years based on Present Value

n = -LN(1-PV/Pmt x i)/LN(1+i)
Excel Formula
n = nPER(i%,Pmt,-PV)
n = -LN(1-4,622.88/1000 x 8%)/LN(1+8%) = 6

The other type of annuity is the annuity due where payments are made at the beginning of each year.

Annuity Formulas November 6th, 2016Team

You May Also Like

Related pages

double decline depreciation examplefreight fobdiscount on bonds payable balance sheetfifo periodicpayback cashhow to calculate common size percentage income statementinventory requisition formadjusting entries in accounting tutorialprinciples of bookkeeping and accountingbalancing quizdilapidation provision ifrsprovision for doubtful receivablesdebtors collection period ratio analysisdirect materials efficiency varianceoperating lease payment calculatorexpenses are debits or creditstypes of transactions in transactional analysistypes of accounting ledgershow to calculate annual depreciation expenseroce ratio formulawhat is the formula for total fixed costeffective monthly rate calculatorretained earnings journal entryamortization expense exampletotal variable cost formulajob sheet templatesp&l chartcallable preferred stockincurred advertising expense on accountnormal balance of dividendsallowance for doubtful receivablesaptitude test accountingpayment receipt format docgross margin per unit formulafv excelinventory average cost methodexamples of straight line depreciationcash withdrawal from bank journal entry in tallypresent value of perpetual annuitycreditors journal entryaccumulated depreciation contra assett accounts debits and creditsmargin and markup calculator ukexample of overstatementjournal entry for bank reconciliationfuture value interest factor of annuitydiscounted cash flow formula in excelaccounting contra accountswhy is an adjusting entry importantwhat is the maturity date of a note receivableformula for profitability indexpetty cash imprest system templatereplenishment of petty cashcost of goods sold formulaschart of accounts templatescalculating npv using excelliquidity current ratio formulapv function in exceldebtor collection ratiorequisition form template download freemerchandise inventory adjusting entrydrawings in trial balancewhat is accrued expensesingle step or multi step income statementcogs equationinventory shrinkageexcel accounting spreadsheetdouble entry for fixed assetsmeaning of amortisationdrawings meaning in accountingexamples of deferred revenueaccounts receivable divided by salesnetbook value formulaebit interest cover