Annuity Payment Formula FV


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


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

The annuity payment formula FV can be used for example, to calculate the periodic deposits needed 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 payment formula FV, and has the syntax shown below.

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

*In this instance, the PV and type arguments are not used when using the Excel annuity payment function.

Example Using Annuity Payment Formula FV

An investor wants to save an amount of 7,000 by depositing regular annuity payments for 14 periods at an interest rate of 3% per period. The amount of the annuity payment is given by the annuity payment formula FV as follows:

Annuity payment = Pmt = FV x i / ( (1 + i)n - 1 )
Annuity payment = Pmt = 7000 x 3% / ( (1 + 3%)14 - 1 )
Annuity payment = Pmt = 409.68

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

Annuity payment = PMT(Rate, Nper, PV, FV, Type)
Annuity payment = PMT(3%,14,,-7000)
Annuity payment = 409.68

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

Annuity Payment Formula FV November 6th, 2016Team

You May Also Like

Related pages

how to calculate overhead variancesundry accountscash float sheet templatedefine double entry accounting systemprepaid expenses examplereorder point calculationhow to calculate depreciation expensedebits and credits accountingconstruction accounting percentage of completion methodfully depreciated assetslegal timesheet templatehow to solve for variable costadjustments for unearned revenuefob destination meansannuity with growth formulaprepaid insurance journal entry exampleaccounting journalizing examplesfv annuity dueoverhead apportionmentdebtors control account reconciliationhow to calculate vertical analysis percentageswhat is the worksheet in accountingformula of present value of annuityif the labor efficiency variance is unfavorable thensample cash voucherrent payable journal entry10 steps in the accounting cyclecalculate discount excelonline apportionment calculatoradjusting accounting entriesformula for dso calculationloss on disposal of fixed assetsbookkeeping spreadsheetstrade creditors accounts payabledebtors control definitionwhat is sundry assetsunearned rent revenuepurpose of subsidiary ledgerdebt to equity ratio equationjournal entry interest expensecalculate future value of annuitycollected accounts receivable journal entrygrant amortisationjournal accounting entries examplesgeneral ledger papermanufacturing over headpresent value of annuity due tablearr equationfinished goods inventory calculationhow do you calculate beginning inventorywhat is the purpose of double entry bookkeepinghow to calculate depreciation straight linelifo accounting exampleaccrued expenses in balance sheethow to find contribution margin ratioprofitability index in exceljournal entry to record accounts receivablelifo reservesaccouting quizwhy accumulated depreciation is creditunits of output depreciationperpetuity growth formulahow to calculate accrued expenseswhat accounts have a normal debit balancetill reconciliation templateannuity due sample problems with solutionssales tax converter calculatorwhat is the formula for predetermined overhead ratefixed asset turnover equationsalvage value in accountingaccounts payable journal entriessale of receivables without recourseallowance doubtful accounts