Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A tractor for over-the-road hauling is to be purchased by AgriGrow for $75,000. It is expected to be of use to the company for 6

image text in transcribedimage text in transcribedimage text in transcribed

A tractor for over-the-road hauling is to be purchased by AgriGrow for $75,000. It is expected to be of use to the company for 6 years, after which it will be salvaged for $3,500. Transportation cost savings are expected to be $120,000 per year; however, the cost of drivers is expected to be $45,000 per year, and operating expenses are expected to be $41,000 per year, including fuel, maintenance, insurance, and the like. The company's marginal tax rate is 25 percent, and MARR is 10 percent on after-tax cash flows. Suppose that, to AgriGrow's surprise, they actually dispose of the tractor at the end of the fourth tax year for $5,500. Develop tables using a spreadsheet to determine the ATCF for each year and the after-tax PW, AW, IRR, and ERR after only 4 years. Use MACRS-GDS and state the appropriate property class. End of Year ATCF 0 $ -75000 1 $ 2 $ 3 $ 4 $ After-tax PW:$ After-tax AW:$ For dollar amounts, carry all interim calculations to 5 decimal places and then round your final answer to the nearest dollar. The tolerance i +10. After-tax IRR: % After-tax ERR: % For rates, carry all interim calculations to 5 decimal places and then round your final answer to 1 decimal place. The tolerance is +0.2. Property Class: TABLE 8.3 EOY MACRS-GDS percentages for 3-, 5-, 7-, and 10-year property are 200% DBSLH and 15- and 20-year property are 150% DBSLH 3-Year 5-Year 7-Year 10-Year 15-Year 20-Year Property Property Property Property Property Property 33.33 20.00 14.29 10.00 5.00 3.750 44.45 32.00 24.49 18.00 9.50 7.219 14.81 19.20 17.49 14.40 8.55 6.677 1 2 3 4 7.41 11.52 12.49 11.52 7.70 6.177 5 11.52 8.93 9.22 6.93 5.713 5.285 6 5.76 8.92 7.37 6.23 7 8.93 6.55 5.90 4.888 8 4.46 6.55 5.90 4.522 9 6.56 5.91 4.462 10 6.55 5.90 4.461 11 3.28 5.91 4.462 12 5.90 4.461 13 5.91 4.462 14 5.90 4.461 15 5.91 4.462 16 2.95 4.461 17 4.462 18 4.461 19 4.462 20 4.461 21 2.231

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

Personal Finance

Authors: E. Thomas Garman, Raymond E. Forgue, Jonathan Fox

14th Edition

0357901495, 9780357901496

More Books

Students also viewed these Finance questions

Question

Discuss the history of human resource management (HRM).

Answered: 1 week ago