Annuity Due Formulas

An annuity due is a series of annual payments made at the beginning of each year for a fixed number of years.

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

Annuity Due Formula Examples

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

In all annuity due 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 due formulas is based on the following information.

  • Future value = FV = 7,922.80
  • Present value = PV = 4,992.71
  • Annual annuity rate = i = 8%
  • Annual annuity payment = Pmt = £1,000
  • Number of years = n = 6

Future Value of an Annuity Due

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

Present Value of Annuity Due

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

Calculate Annuity Due Payments based on Present Value

Pmt = PV/((1-1/(1+i)n)/i x (1+i))
Excel Formula
Pmt = PMT(i%,n,-PV,,1)
Pmt = 4,992.71/((1-1/(1+8%)^6)/0.08 * (1+8%)) = 1,000

Calculate Annuity Due Payment based on Future Value

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

Number of years based on Future Value of Annuity Due

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

Number of years based on Present Value of Annuity Due

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

The other type of annuity is the regular annuity where payments are made at the end of each year.

Annuity Due Formulas November 6th, 2016Team

You May Also Like

Related pages

assignment of receivablesreceived cash from customers on account journal entryoutstanding mortgage calculatorpetty cash register formatdouble entry for petty cashfifo method examplespmt mortgageincome statement common sizebond amortisationgeneral ledger basicsdiscount amortization schedulebank rec formatdirect material cost formulabalance sheet reconciliation examplescalculating periodic interest ratebank reconciliation statement samplereturn on equity dupontstandard cost variance analysiswhat are retained earningaccounting fifo methodunearned revenue what type of accountblank ledger sheetsannuity formula exceljournal entry for insurance premiumfuture value of an annuity due formulanbv depreciationtotal variable cost formulareturn on retained earnings formulaimprestsdeferred tax reversaltvm calculator free downloadunpresented checksthe income summary account is a permanent accountannuity due chart4 stages of accounting cycleledger paper printabledouble entry bookeepingfixed overhead capacity variancematerial requisition slipbills of discountingledger book formatpv annuity factor tablecalculate contribution margin percentageannuity duehow to do bank reconciliation exampleannuity in perpetuityannuity formula excelthree column ledgerwhat is journal and ledger with examplemarkup and margin formulajournal entries for bad debtsaccount receivable journal entriessimple compound formulathe balance sheet equationsum of years depreciation calculatoreffective annual interest rate equationjournal entry for prepaymentinventory turnover calculation exampleoperating cycle in accountingexcel small business accounting templatethe double declining balance method of depreciation is used forwhat are closing entriesselling inventory journal entryuneven cash flow calculatorhow to calculate interest on notes receivablejournal entry for invoiceobsolescence accountingcontra liabilitiesinvoice ledgercalculate fv of annuitynet operating asset turnover formulaannuity formulwip revenue recognitionpresent value of growing perpetuityfuture value of an annuity excel