Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please show formula work for excel usage 4. Consider the following data - A machine costs $950 today (year 0). Assume this investment is fully
please show formula work for excel usage
4. Consider the following data | |||||||||||||
- A machine costs $950 today (year 0). Assume this investment is fully tax-deductible, as stipulated by the new US corporate tax code of 2018. | |||||||||||||
- This company has current pre-tax profits from other projects that are greater than $950, so it can take full advantage of the investment tax break above in year 0. | |||||||||||||
- The machine will generate operating profits before depreciation (EBITDA) of $520 per year for 5 years. The first cash flow happens one year after the machine is put in place (year 1). | |||||||||||||
- Depreciation is not tax-deductible. Notice that you do not need to calculate depreciation at all to solve this problem since it has no effect on taxes. | |||||||||||||
- The tax rate is 21% | |||||||||||||
- There is no salvage value at the end of the five years (the machine is worthless), and no required working capital investment. | |||||||||||||
Compute the NPV of the project if the discount rate is 8%. Please show your work below, not just the final answer (15 points) | |||||||||||||
NPV = |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started