Number 5
Feedback for Project 5 Milestone
Top of Form
|
Submission Feedback |
|
|
|
|
|
Overall Feedback |
|
|
3/2: Early submission. Cost of Capital Tab: In Cell L46, Tax Rate (TC) = 34% = 26% (Federal tax rate) + 8% (State tax rate). Payback Tab: In Cell E37, you should use WACC calculated from Cost of Capital tab. All related calculations should be changed. NPV and Projected After-tax Cash Flows should be the same amount of $191.1 for Year 0. You used the incorrect formulas when calculating NPV2. All related calculations should be changed. You did not calculate NPV value. Budget Projections Tab: Expense increases 2.5% = 0.025. You used the incorrect number in the related calculations. |
Bottom of Form