Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you show me how to solve this in excel? An asset used in a 3-year project falls in the five-year MACRS class for tax
Can you show me how to solve this in excel?
An asset used in a 3-year project falls in the five-year MACRS class for tax purposes. The asset has an acquisition cost of $5.4 million and will be sold for $1.7 million at the end of the project. If the tax rate is 35 percent, what is the after-tax salvage value of the asset?
Year 3-year Property 5-year Property 7-year Property
1 33.33% 20% 14.29%
2 44.45% 32% 24.49%
3 14.81% 19.2% 17.49%
4 7.41% 11.52% 12.49%
5 11.52% 8.93%
6 5.76% 8.92%
7 8.93%
8 4.46%
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