Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone do this in Excel and show me the formulas as well. The management of Tri-County Air Taxi, Inc., is considering the replacement of

Can someone do this in Excel and show me the formulas as well.

The management of Tri-County Air Taxi, Inc., is considering the replacement of an old machine used in its helicopter repair facility. It is fully depreciated but it can be used by the corporation through 20x5. If management decides to replace the old machine, James Transportation Company has offered to purchase it for $69,000 on the replacement date. The old machine would have no salvage value in 20x5. If the replacement occurs, a new machine would be acquired from Hillcrest Industries on December 31, 20x1. The purchase price of $1,200,000 for the new machine would be paid in cash at the time of replacement. Due to the increased efficiency of the new machine, estimated annual cash savings of $360,000 would be generated through 20x5, the end of its expected useful life. The new machine is not expected to have any salvage value at the end of 20x5. Tri-Countys management requires all investments to earn a 12 percent after-tax return. The companys tax rate is 30 percent. The new machine would be classified as three-year property for MACRS purposes. Use Appendix A and Exhibit 16-9. for your reference. (Use appropriate factor(s) from the tables provided.) Required: 1. Compute the net present value of the machine replacement investment. 3. Compute the payback period for the replacement of the machine. 4. How much would the salvage value of the new machine have to be on December 31, 20x5, in order to turn the machine replacement into an acceptable investment?

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

Strategic Audits For Continuous Business Improvement

Authors: Parbatee Chang

2nd Edition

1507679483, 978-1507679487

More Books

Students also viewed these Accounting questions

Question

Be sensitive to and adapt to the diversity of your audience.

Answered: 1 week ago

Question

a sin(2x) x Let f(x)=2x+1 In(be)

Answered: 1 week ago