Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Distressed Debt Analysis Strategies For Speculative Investors

Authors: Stephen Moyer

1st Edition

1932159185, 978-1932159189

More Books

Students also viewed these Finance questions

Question

1. Plan in advance how and when you will test.

Answered: 1 week ago

Question

Identify three types of physicians and their roles in health care.

Answered: 1 week ago

Question

Compare the types of managed care organizations (MCOs).

Answered: 1 week ago