Lump Sum Discount Rate Calculator

The lump sum discount rate calculator is used to calculate the discount rate (i) needed to compound a lump sum from its present value (PV) to a future value (FV) over a given number of periods (n).

Lump Sum Discount Rate Calculator November 6th, 2016

Effective Interest Rate for any Time Period

The effective interest rate adjusts the stated nominal rate to allow for the effects of compounding over a specific time period, referred to as the effective period. Different compounding periods earn different amounts of interest and the effective interest rate allows comparisons to be made by converting these to an equivalent rate as if compounding took place once every effective period,

Effective Interest Rate for any Time Period November 6th, 2016

Effective Annual Rate (EAR)

The effective annual rate adjusts the stated nominal rate to allow for the effects of compounding. Different compounding periods earn different amounts of interest and the effective annual rate allows comparisons to be made by converting these to an equivalent rate as if compounding took place once at the end of the year, hence the alternative name of annual equivalent rate (AER).

Effective Annual Rate (EAR) November 6th, 2016

Real Interest Rate Formula

The real interest rate formula is used to adjust a nominal interest rate (i), for the effects of inflation (g) to give a real interest rate (r).

Real Interest Rate Formula November 6th, 2016

Periodic to Continuous Interest Rate Formula

The periodic to continuous interest rate formula can be used to convert a periodic interest rate (i) compounded (m) times in a period, to a continuous interest rate (r).

Periodic to Continuous Interest Rate Formula November 6th, 2016

Continuous Compound Interest Formula

The continuous compound interest formula is used to calculate the compound interest on a lump sum PV invested today at an interest rate of i and compounded continuously for a time n.

Continuous Compound Interest Formula July 7th, 2017

Excel NOMINAL Function

The Excel NOMINAL function is used to calculate the nominal annual rate (i) required to give an effective annual rate (r), allowing for a given number of compounding periods each year (m). The effective rate allows for compounding, whereas the nominal rate does not allow for compounding.

Excel NOMINAL Function November 6th, 2016

Nominal Interest Rate Formula

The nominal rate formula calculates the nominal rate of interest for a year based on an effective rate (r), with compounding taking place a number of times a year (m).

Nominal Interest Rate Formula November 6th, 2016

Effective Interest Rate Formula

The effective interest rate formula calculates the rate of interest for a number of compounding periods (n) based on a nominal rate (i) compounded a number of times a year (n).

Effective Interest Rate Formula November 6th, 2016

MIRR Formula

The MIRR formula is used to calculate the rate of return for a project taking into account the finance cost (f) of the cash used to fund the project (negative cash flows), and the rate of return (r) on cash from the project (positive cash flows) reinvested elsewhere.

MIRR Formula November 6th, 2016

Excel RATE Function

The Excel RATE function is used to calculate the discount rate (i) in time value of money calculations. For example, it can calculate the interest rate on a loan given the value of the loan, the term and the periodic payments, it can be used to calculate the interest rate earned on a savings account, or the interest rate needed to generate annuity payments from a lump sum investment.

Excel RATE Function November 6th, 2016

Excel IRR Function

The Excel IRR function is used to calculate internal rate of return for a range of cash flows in time value of money calculations, and has the syntax IRR (Values, Guess).

Care must be taken when using the Excel IRR function with cash flows that change sign multiple times though out the term of the project, as it can produce meaningless solutions.

Excel IRR Function November 6th, 2016

Related pages

definition of acid test ratiojournalize accountingperiodic inventory methodproveit practice testbank reconciliation statement exercisesthe purpose of closing entriesaccounting debits and creditsvertical analysis accountingadjusting entries for prepaid insurancedeferred revenue accounts receivablebasic bookkeeping tutorialrate variance definitionannuity payments calculatoraverage settlement period for trade payablesinterest on investment journal entryratios accounting formulashow to calculate markup from cost and selling pricehow to calculate prepaid insurance accountingformula to find variable costaccounting tutorialsformula for acid test ratiois prepaid rent an expensepresent value of increasing annuitybalance sheet accrued expensesreceipts and payments accounts templatedu pont identity formulaexample of general ledger entries for accountingfob sellerexcel spreadsheet for bookkeepingprudence in accountingnpv of annuity formulaaccruals and prepayments practice questionsaccounting notes payable journal entriesadvantages of subsidiary booksnpv excel calculationsample ledger for small businessprepaid expense journal entryformula to calculate pmtdeclining balance method of depreciationdeclining method of depreciationpetty cash claim formreapportionment of overheadscalculate payback periodaccounting equation chartexamples of vouchers templatewhat does accrued salaries meanstraight line method of depreciation formulaequity method journal entries examplespartnership profit sharing ratioaccounting quiz questions and answersexamples of comprehensive incomedegree of operating leverage calculationpromissory note journal entryallowance for doubtful accounts ratiowip calculationfinancial projection xlsconvert cash calculatorworking capital turnover ratio interpretationexcel cash receipt templatebookkeeping explainedstraight line depreciation examplessample payroll sheetwhat is objectivity principle in accountingwhat is triple column cash booknet relizable valuedupont analysis spreadsheetfixed assets ppeentries are made to the petty cash account whenhow to find net realizable valuedeffered tax calculationhow to calculate interest bearing debtaccounts payable days formulamarkup vs margin formulabank reconcilliationscauses of labour rate variancesample ledger for small businessifrs deferred revenuewhat does nrv meancontra income accountconstant growth model excel