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

how to calculate direct materials purchasedvariable overhead variance formulanpv perpetuity formulacompounded continuously meanspayroll quizhow to calculate conversion cost per equivalent unitgrowing annuity examplefinancial accounting ratios formulasprepaid insurance accountingcash disbursement examplesales returns and allowances accounthorizontal income statementpaid advertising expense journal entryperiodic or perpetual inventory systemexcel interest rate calculatorhow to calculate markup percentage formulanpv formula constant cash flowexamples of accruals in accountingtutorial for accounting for beginnerspurchase ledger exampleaccounting prepaid rentthe purpose of reversing entries is tochart of accounts restaurant exampleprofit margin in exceltrade discount entrydouble entry accounting spreadsheetunearned revenue financial statementleverage ratio formulawhat is office supplies expense in accountingexamples of petty cashamortization on income statementannuity tables present valueincreasing annuity calculatorpresent value annuity table pdfexamples of accounting journal entriescoverage ratiosaccounts payable double entrylong term debt calculatort accounts debits and creditsexamples of capital leasesfob origin collectunearned service revenue still unearned journal entryexamples of double entry bookkeepingaccounting tabular analysisbasics of accounts payableaccounting debits and credits examplesoperating lease payment calculatorbookkeeping double entry examplesdeferred tax expense journal entrysimple p&lretained earning statementpayback method examplepetty cash in tallyaccounting principles and conventionsformula of leverage ratiocalculate material price variancetrade debtor collection periodoperating lease formuladouble entry accounting transactions must alwaysmeaning of cash discountgross markup formuladrawings in trial balancesundry debtors in balance sheetwhat is the formula for asset turnoverformat of sales ledger control accountexamples of revenue expenditure and capital expenditurebad debts entriesaccounting accrued expensedepreciation formula straight lineinventories turnover daysproof of annuity formulaamortisation meaningdebits and credits journal entriescost markup calculator