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

how to calculate equivalent unitsexcel npvmargin calculation in excelsundry in accountingaccounts payable reconciliation examplecontribution margin statement examplegrn accountingfinancial accounting ratios formulasaccounts receivable questions and answerssample nonprofit financial statementssalvage value formulastatement of comprehensive income formatjob costing formatprovisioning accountinginvoice ledgerdebtors accounting definitionaccelerated depreciation calculationsample of ledger bookbasic double entry bookkeepinghow to calculate actual manufacturing overheadaccounting balance sheet equationjob costing excelaccounting transposition erroraged creditorst accounts debits and creditscontrolaccountcash flow margin ratio analysisweekly bookkeeping recordaccrued income asset or liabilitywip inventorieshow to calculate interest earned ratiocompound interest and simple interest formulasreorder point calculation examplepresent value of annuity formulamaterial requisition slippetty cash expense report templateraw materials requisitioned journal entrymarkup to margin calculatormanual bookkeeping templatedouble entry prepaymentaccounting for debt factoringconsignee and consignortransactional analysis simple explanationentry for prepaid insurancecompounding periods per yeargp calculator excelnpv calculator excelusing pmt function in excelexample of sundry expensesamortisation calculationjournal entry for cash withdrawal from bankdso ratio formulathe accounting equation examplescash receipt journal exampleaccumulated depreciation journal entriesweighted average inventory methodhow to calculate markup formuladisbursement voucher templatewhat is the accounting cycle stepsaccrual accounting and adjusting entriesfiguring gross marginaccounting for owners equitygrowing perpetuitygross profit formulasrecievable turnoverjournal entry of bad debtsformula dupontcogs journal entrycash payback formuladouble declining balance depreciation examplecontra accounts receivableamortization spreadsheet templateexample of subsidiary ledgernpv formula constant cash flowaccounts receivable quizpurchase ledger control account formatexample of accrual basis of accountingimprest bank accountnet profit turnover ratio formulaaccounts receivables turnover ratioreversal of accrued expensesbank reconciliation example problems