Answered step by step
Verified Expert Solution
Link Copied!

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

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

Essentials of Managerial Finance

Authors: Scott Besley, Eugene F. Brigham

14th edition

324422709, 324422702, 978-0324422702

More Books

Students also viewed these Finance questions