1. Initial investment 2. Revenues 3. Cash operating costs 4. Tax depreciation 5. Income pretax 6. Tax at 40% 7. Net income 8. After-tax salvage 9. Cash flow (7 +8+4-1) NPV at 20% = 0 - 100 -100 100 50 33.33 16.67 6.67 10 +43.33 2 100 50 33.33 16.67 6.67 10 +43.33 3 100 50 33.33 16.67 6.67 10 15 +58.33
Taxes are costs, and, therefore, changes in tax rates can affect consumer prices, project lives, and the value of existing firms. Evaluate the change in
Assumptions: Tax
4. Would it now make sense to terminate the project after two rather than three years?
5. How would your answers change if the corporate income tax were abolished entirely?
NOTE: The three initial question was sent before these last two. please clarify the answer as much as possible in the Excel spreadsheet. The table to the question is attchedThank you
Trending now
This is a popular solution!
Step by step
Solved in 3 steps