The NPV-IRR worksheet calculates annual cash flows and Net Present Values using accelerated depreciation tax calculations if required.
The capital investment projections are recalculated by changing assumptions in the NPV-IRR Sensitivity Forecast. In this example the investment, earnings and working capital forecasts have been lowered to create higher rates of return than the original. Experiment with the Sensitivity Forecasting to locate the maximum rate of return combinations.
More Details: Investment-Calc For NPV, IRR, ROI + Portfolio ROR | Cash flow Excel worksheets | Sensitivity Analysis calculations | NPV-IRR worksheet | EVA & Capital Investment Appraisal | Daily Interest Tables Spreadsheet | PV & Monthly Cash Flows
NPV - IRR Analysis for Periodic Cash Flows
$169.95 $69.95 Secure Payment Options
Buy as part of All Excel Templates Gold Edition - HUGE Value - 80% Discount!
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $69.00. ALL purchases totaling over $138.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft