In: Finance
Refer to the Web Tax Appendix to correctly answer this question. Barngrover Inc. is considering a new investment whose data are shown below. The required equipment will be used for 3 years during the project’s life. The equipment qualifies for bonus depreciation, so it will be fully depreciated at the time of purchase. It will have a positive salvage value at the end of Year 3, when the project would be terminated. Also, some new net operating working capital would be required, but it would be recovered at the end of the project's life. Revenues and operating costs are expected to be constant over the project's 3-year life. What is the project's NPV?
Please give a DETAILED Explanation and show how you reached your answer using Excel or formulas or both.
WACC 8%
Purchase price of equipment $125,000
Required new NOWC $22,000
Sales revenues $140,000
Operating costs $56,000
Before-tax salvage value $9,000
Tax rate 25%
a. $51,965.48
b. $68,607.11
c. $69,429.79
d. $71,215.91
e. $73,965.48