|
There are two Economic Value Added worksheets. The first calculates EVA from the 15-year cash flow forecasting worksheet budget data (see first screen). The second supplies departmental or divisional EVA templates. The individual EVA results are consolidated to calculate the overall company EVA score. If the consolidated EVA<0 the company can locate departments/divisions responsible for dragging the overall EVA score down and take remedial action.
The Capital Investment Appraisal worksheet supplies a quicker route to calculation of Net Present Values of forecast cash flows over 1-30 years by automating calculations using constant ratios. Depreciation, loan repayments and tax calculations are calculated in prepared tables.
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 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