Annuity Payment Formula FV

Formula

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

Use

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


future value of annuity dueraw materials requisitioned journal entryprepaids accountingwhat is subsidiary ledgercalculation for payback periodaccounts payable period formulaaverage accounts receivable turnover ratiodouble booking accountingdifference between single entry and double entry bookkeepingapportionment of costsprepare a multiple step income statementeffective yield method amortizationexcel formula for gross marginprepayment balance sheetretail markup calculator ukexamples of contra assetsdouble entry bookkeeping practice questionsdirect material cost variancemargin markup tableaccrued interest accounting entrybank recoannual depreciation straight line methodbookkeeping exambad debts written off meaninggross fixed assets formulaaccounts receivable turnover ratio exampledefer revenuehow to find net profit margin ratiojournal entries for accounts payable12 column ledger bookbank recon sampleirrevocable letter of credit costassets employed formuladelayed perpetuity formulaaccounts payable ledgerrule of 78 calculatorraw materials purchased formuladupont equation calculatorsample payroll journal entrybookkeeping ledger templateperpetual inventory journal entries exampleperpetual inventory system and periodic inventory systemactivity ratios measureaccounting debit and creditscalculating amortization expensespecial journals accountingwhat is margin and markupcost of goods manufactured equationsuspense accountingfixed asset turnover equationgraduated annuitygearing ratio interpretationcash discount journal entrydebt to equity ratio calculation examplehow to calculate ear on financial calculatoraccumulated depreciation in trial balancejournal entries debits and creditsfinance lease journal entriestill float check sheetaccounts receivable factorwhat is the present value of a perpetuityfuture value formula in excelextended dupont equationaccounts receivable aging templateusance letter of credit meaningredeemable convertible preferred stockformula for mark upprepaid insurance accountingjournal entry for warrantycalculation of payback period examplecash flow calculator exceljournal entry for interest expensewhat is amortisation in accountinghorizontal and vertical analysiscarriage outwardsaccounting for accrued vacationfixed asset register template downloadformula for inventory turnover ratio