Annuity Due Payment Formula FV

Formula

Pmt = FV x i / ((1 + i)( (1 + i)n - 1 ))
Variables used in the annuity formula
FV = Present Value
Pmt = Periodic payment
i = Discount rate
n = Number of periods

Use

This annuity due payment formula FV calculates the annuity payment required to provide a given future value (FV). The annuity due formula assumes payments are made at the start of each period for n periods, and a discount rate i is applied.

The annuity due payment formula FV can be used for example, to calculate the periodic deposits needed at the start for each period to provide a required savings account balance (FV), given the number of deposits (n), and the account interest rate (i).

Excel Function

The Excel PMT function can be used instead of the annuity due payment formula FV, and has the syntax shown below.

PMT(Rate, Nper, PV, FV, Type)

*In this instance, the PV argument is not used when using the Excel Annuity due payment function.

Example Using Annuity Due Payment Formula FV

An investor wants to save an amount of 8,000 by depositing regular annuity payments at the start of each period for 15 periods at an interest rate of 4% per period. The amount of the annuity payment is given by the annuity due payment formula FV as follows:

Annuity payment = Pmt = FV x i / ((1 + i)( (1 + i)n - 1 ))
Annuity payment = Pmt = 8000 x 4% / ((1 + 4%)( (1 + 4%)15 - 1 ))
Annuity payment = Pmt = 384.16

The same answer can be obtained using the Excel PMT function as follows:

Annuity payment = PMT(Rate, Nper, PV, FV, Type)
Annuity payment = PMT(4%,15,,-8000,1)
Annuity payment = 384.16

The annuity due payment formula FV is one of many annuity formulas used in time value of money calculations, discover another at the links below.

Annuity Due Payment Formula FV November 6th, 2016Team

You May Also Like


Related pages


sundry payments definitionblank inventory sheetexcel formula fvretiring bonds journal entryhow to prepare an income statement in exceljournal entry for closing stockpresent value tables annuity dueunearned service revenue still unearned journal entryexamples of accounting conceptswrite off receivableaccruals examplesjournal entry in tallyjournal entry for provision of income taxadvantage of payback periodformula for annuity paymentreceipt spreadsheet templateexcel bank reconciliation templatefob accounting definitionaccounts receivable days on hand formulabank account reconciliation examplerule of 78 calculatorperpetuity formula present valuesmall business balance sheet template excelroyalty payments accountingbank reconciliation statement problems and solutionstotal cost of goods manufacturedwhat is accounting equationcalculate roceadjusting journal entries for depreciationdepreciation cost per unitwhich journal would adjusting entries be foundcash receipts formatthe accounting cycle stepsdebtor day calculationhow to calculate retained incomeequation for quick ratiopv annuity factorwhat is the normal balance of accumulated depreciationgross profit margin vs markupchart of accounts excel templatecreditors turnover ratiomarkup vs margin formulaadjusting entry examplesadjusting entries worksheetcost of ending inventory formulasum-of-the-years-digits method of depreciationprepaid expense examplesexamples of general ledgersales tax converter calculatorhow to calculate fixed cost per unitfob buyercalculate ending finished goods inventoryformula for accumulated depreciationaccounting for gift cardsar turnover in days formulafair value ociequation of cost of goods soldtimesheet layoutweighted average unit cost formulagoods sold on consignmentcreditor definition accountingdupont turnoverperpetual inventory fifotreatment of suspense account in balance sheetfinancial statement worksheet templateprepaid expense schedulepetty cash report formatreceivables turnover ratio industry averagefob destination examplecalculate net present value excelaccounting equestionhow to calculate interest expense on a loanaverage cost inventory method