| FALCONVILLE PUMP COMPANY - CASH FLOW ESTIMATION WORK WORKSHEET |
| Input Data | New pump |
| Cost of NEW equipment | 209000 | Annual dep. of old equipment |
| Salvage value new equipment | 10450 | OLD equipment's depreciable life left |
| Cost of old equipment | Old equipment's depreciated years |
| Depreciation of old equipment till date | Annal cost savings |
| Salvage value of old equipment | Removal cost of old equipment |
| Tax rate | Removal cost of new equipment |
| WACC | Net working capital requirement |
| t=0 | t=1 | t=2 | t=3 | t=4 | t=5 | t=6 | t=7 | t=8 |
| I | INVESTMENT OUTLAY |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| II | OPERATING CASH FLOWS OVER THE PROJECT'S LIFE |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| III | TERMINAL YEAR CASH FLOWS |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| IV | NET CASH FLOWS |
| 18 |
| V | RESULTS |
| NPV | = | |
| IRR | = | |
| MIRR | = | |
| Payback period = | |
| DECISION BASED ON YOUR ANALYSIS: |
| ANSWERS TO QUESTIONS: |
| Q#1: |
| Q#2: |
| Q#3: |
| Q#4: |
adamrereo
FPCReplacementProjectAnalysisWorksheet.xlsx
