Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Could you please answer and show equations in excel? A proposed cost-saving device has an installed cost of $705,000. The device will be used in
Could you please answer and show equations in excel?
A proposed cost-saving device has an installed cost of $705,000. The device will be used in a five-year project but is classified as three-year MACRS property for tax purposes. The required initial net working capital investment is $115,000, the marginal tax rate is 22 percent, and the project discount rate is 13 percent. The device has an estimated Year 5 salvage value of $86,000. What level of pretax cost savings do we require for this project to be profitable? MACRS schedule. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Pretax cost savings Property Class Five-Year Seven-Year Year Three-Year 33.33% 1 20.00% 14.29% 32.00 2 44.45 24.49 14.8 3 19.20 17.49 4 7.41 11.52 12.49 11.52 8.93 5.76 8.92 8.93 8 4.46Step 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