Excel NPV Function

The Excel NPV function is used to calculate the present value of unequal cash flows in time value of money calculations.

To calculate the net present value of a project, the original investment at the start of the project needs to be deducted from the answer provided by the Excel NPV function.

Excel NPV Function November 6th, 2016Team
Read more

Excel NPER Function

The Excel NPER function is one of many Excel financial functions, and can be used to calculate the number of periods for a lump sum, annuity or annuity due to grow to a future value. In addition the function can also be used to calculate the number of periods it takes for a loan to be repaid.

Excel NPER Function November 6th, 2016Team
Read more

Profitability Index Calculation

The profitability index (PI) of a series of cash flows is found by calculating the present value of all the cash flows from a project (PV) and dividing the value by the initial investment (I). The profitability index is sometimes referred to as the value investment ratio.

Profitability Index Calculation July 6th, 2017Team
Read more

Effective Annual Rate Formula

The effective interest rate formula calculates the rate of interest for a year based on a nominal rate (i) compounded a number of times a year (m). The formula for annual interest rate is sometimes referred to as the annual equivalent rate formula or AER formula.

Effective Annual Rate Formula November 6th, 2016Team
Read more

Present Value of a Lump Sum

The concept of the present value of lump sum is the starting point for many time value of money calculations including the present value of an annuity, and net present value calculations.

Present Value of a Lump Sum November 6th, 2016Team
Read more

Future Value of a Lump Sum

The concept of the future value of lump sum is the starting point for all time value of money calculations.

If a lump sum (PV) is invested and earns interest at a rate (i), then over time (n), the lump sum will grow into a larger sum (FV).

Future Value of a Lump Sum November 6th, 2016Team
Read more

The Rule of 72

If money is invested in an account paying compound interest, the finance rule of 72 is a quick way to estimate the time it will take for the investment to double in value.

The Rule of 72 November 6th, 2016Team
Read more

Lump Sum Discount Rate Formula

The lump sum discount rate formula 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 Formula December 7th, 2017Team
Read more

You May Also Like


Related pages


convertible bond accountingcommon stock valuation formulasales ledger meaningallocating overheadunadjusted trial balance worksheetformula to calculate current ratiosteps involved in adjusting entriesretained profits definitioncalculate vertical analysiswhat is an accounts receivable ledgernper formula excelbank reconciliation excel spreadsheetbasic accounting quizdebtors balance sheetperpetual inventory vs periodic inventoryprepaid expense meaningreturn on capital employed examplehow do you calculate inventory turnover ratiocapital gearing formulafixed assets turnover ratio calculatorpaid advertising expense journal entryrealised and unrealised gains and losses in accountingdouble entry accounting for personal financecalculating markupvariable cost calculationpre incorporation expensesdeferred revenues accountingtrial balance definition in accountingannuity value formulapercent markup formulaaccelerated depreciation calculationbookkeeping double entry examplestotal asset turnover ratio calculatorallowance for uncollectible accounts journal entryhow to compute gross profit marginexamples of suspenseunearned revenue is a liabilitydefine reversing entriesjournal entry of prepaid expensessingle column cash book exampleannuity due calculatorthe journal entries for a bank reconciliationpv annuitybond calculator excelcash receipt voucher sampleoperating leverage formula accountingdupont analysis spreadsheetreturn on equity duponthow to calculate operating leveragecalculate equivalent units of production weighted average methodprinciples of accounting conceptsrevenue accrual entryexcess and obsolete inventory definitionallowance for doubtful accounts calculationaccruals and prepayments journal entriesannuity discount factor tablenet income retained earningamortized discountroce return on capital employedcalculating dividends from balance sheetdepreciation calculation in excelamortisation of debtdividend accrualexamples of common stockretained income on balance sheetaccounting for royalty paymentscash flow to creditors calculatoraccounts receivable debitdebtors balance sheetsample chart of accounts for non profit organizationssmall business bookkeeping formsexample of general ledger entries for accountingcapital gearing definitionsundry accounts definitionconvertible participating preferredfactory overhead appliedis prepaid rent a current assetdelivery term fobthe accounts receivable turnoveraccounting year end closing entries