## NPV and Taxes

The NPV (net present value) of an investment is calculated by adding together the present value of each of the individual cash flows associated with the investment. The purpose of this tutorial is to discuss the effect of taxation and depreciation on each of the investment cash flows and, as a result, on the NPV of the investment itself.

NPV and Taxes November 28th, 2017

## 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, 2016

## 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, 2017

## Net Present Value

The net present value (NPV) of a series of cash flows is found by calculating the present value of each cash flow at the appropriate discount rate and then adding them together.

The net present value is used to compare projects and to evaluate whether or not a project is worthwhile. It assumes that a project comprises a series of cash flows in or out of the business over a number of years.

Net Present Value September 28th, 2017

## Related pages

calculating times interest earnedgrowth perpetuity formulaleasing calculator formulajv in accounting termsunderapplied overheadroe return on equity formulaunearned rent revenue balance sheetallowance for loan losses journal entriesexamples of fifosimple bank reconciliation templatepresent value calculator excelunearned rent adjusting entrybook keeping templateslabor variancesapr ear formulaendowment fund definitionaccount receivable turnover measuresprojected balance sheet templatenet asset turnover ratiounearned income accountingdepreciation expense calculatoris accounts receivable an intangible assetwhat is factory overheadpresent value of future lump sumcurrent liabilities formulaactivity ratios formulascost of finished goods manufactured formulahow to calculate dsowhat are the differences between revenue expenditures and capital expendituresequipment lease calculator excelspreadsheet templates for small businessstraight line method depreciation formulacalculating pmtin process cost accounting manufacturing costs are summarized on aaccounting entry for accrued interestaccounting for consignment inventoryrecording bad debt expensecalculating doubling timedefine capacity cushionvertical analysis financial statementscalculating markup percentage formulacash payment voucher templatehow to calculate effective annual interest ratehow to calculate net realizable valuepaid rent for the month journal entryaverage days sales outstandinghow to use irr function in excelbookkeeping exercises with answersterm promissory noteapplying manufacturing overheadcash coverage ratio interpretationmarkup and margin differencerevenue turnover formulafinance lease accounting journal entriesbank reconciliation statement easy methodtally journal entrydiscounted cash flow perpetuitybank reconciliation statements examplesmeaning of amortisationstraight line depreciation schedulepresent value discount rate calculatorunearned revenue journal entry examplescost volume profit graph excel templategeneral ledger account balancescredits and debits cheat sheethow to do fifo perpetual inventorygearing leverageaccount receivable interview questionsgoods sent on consignmentgeneral ledger for dummiesprintable accounting worksheetshow do you calculate beginning inventoryaccruals and deferrals