Present Value of Annuity Due Calculator

What does it do?

This present value of annuity due calculator works out the present value (PV) of a regular sum of money (Pmt) received at the start of each of n periods, using a discount rate i.

Formula

The calculator uses the present value of an of annuity due formula as shown below:

PV = Pmt x (1 + i) x (1 - 1 / (1 + i)n) / i

Instructions

The Excel present value of annuity due calculator, available for download below, is used to compute the present value by entering details relating to the regular payment, discount rate and the number of periods. The calculator is used as follows:

present-value-of-annuity-due-calculator-v-1.0
Present Value of Annuity Due Calculator Preview

Step 1

Enter the regular payment amount (Pmt). The regular payment is the amount received at the start of each period for n periods. The amount must be the same for each period.

Step 2

Enter the discount rate (i). The discount rate is the rate used to discount each payment amount back from the start of the period in which is was made, to the start of period 1 (today). The rate should be for a period, so for example, if the period is a year, then the rate should be the yearly rate.

Step 3

Enter the number of periods (n). The number of periods is entered. A period can be any term (month, year etc), but must be consistent with the discount rate provided (see step 2).

Step 4

The present value of an of annuity due calculator works out the present value (PV). The answer is the value today (start of period 1) of an a regular sum of money received at the start of each of n periods, at a discount rate of i. It is the present value of an annuity due.

Present Value of Annuity Due Calculator Download

The present value of annuity due calculator spreadsheet is available for download in Excel format by following the link below.

The present value of annuity due calculator is one type of tvm calculator used in time value of money calculations, discover another at the links below.

Notes and major health warnings
Users use this free annuity calculator at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of a PV of annuity due calculator that you might use when considering how to calculate the present value of an annuity due. It is purely illustrative of a present value of an of annuity due calculator. This is not intended to reflect general standards or targets for any particular business, company or sector. If you do spot a mistake in this of annuity due present value calculator, please let us know and we will try to fix it.
Present Value of Annuity Due Calculator November 6th, 2016Team

You May Also Like


Related pages


accrual and prepayment examplesfuture value of a lump sum formuladeferred tax expense calculationcost of ending inventorystraight line amortizationhow to calculate ending raw materials inventoryperpituity formulaformula to calculate simple interest and compound interestaccounting concepts quiznpv excel formula examplewhat is an example of an accelerated depreciation methodfixed asset turnover calculatorpartnership accounting for dummiespresent value calculator excel templategross redemption yield calculationcreditor turnover periodinterest rate formula in excelcontra liability account examplesweighted average inventory costing methodnonprofit bookkeeping & accounting for dummies pdfpv of an annuity duenotes receivable assetcredit debit balance sheet excelexample of cash receipts journalaccounting ratios formulasaccounts ledger templatehow do i calculate npv in excellabor variance formulahow to extract a trial balanceblank trial balance sheetsales tax payable journal entryshipment terms fobpto accrual formulaadjusting entry for inventoryhow to calculate total fixed cost per unitcogs in accountingis accounts payable a credit or debithow to calculate total variable costunderstanding accruals and prepaymentsdefine adjusting entriesexcel worksheet templateconsignor vs consigneedays sales in payablesadvantages of zero based budgetingzero based budgeting advantages and disadvantageswhat is a nsf checkaccounting adjusting entries for dummieswhat is difference between markup and marginexcel gross margin formularoa equationunearn revenuedepreciation straight line method exampleexcel pmt formulatable present value annuityimputed interest rate formulasales accrual journal entryoutstanding checks bank reconciliationpetty cash assetaccounting ledger templatesales returns and allowances accountdefine sundries expensewarranty journal entrywhat is npererrors detected by trial balanceaccounting formats in excelperpetuity formula present valuecash disbursement formulasundry expenses accountingprintable accounting ledgernpv annuity calculatoraccounts receivable flowchartfixed asset subsidiary ledger