Discussion Post. Plagarism checker will be used
Finisher07
student_scenario_capital_budget_analysis.xlsxSheet1
| TFC Capital Budgeting Analysis - Week 6 Scenario | ||||||
| ENTER CORRECT DATA IN YELLOW-CODED CELLS | ||||||
| ($600,000,000) | Projected Expansion Cost | |||||
| 8.50% | WACC | |||||
| 0 | 1 | 2 | 3 | 4 | 5 | Year |
| ($600,000,000) | ($2,500,000) | $175,000,000 | $200,000,000 | $150,000,000 | $300,000,000 | Cash flows |
| ($602,500,000) | ($427,500,000) | ($227,500,000) | ($77,500,000) | 0.258 | Cumulative cash flows | |
| $10,681,917 | NPV | |||||
| 9.03% | IRR | |||||
| 8.88% | MIRR | |||||
| 4.258 | Payback years |
