Answered step by step
Verified Expert Solution
Question
1 Approved Answer
AgriGrow is to purchase a tractor for over-the-road hauling for $90,000. It is expected to be of use to the company for 6 years, after
AgriGrow is to purchase a tractor for over-the-road hauling for $90,000. It is expected to be of use to the company for 6 years, after which it will be salvaged for $4,000. Transportation cost savings are expected to be $170,000 per year; however, the cost of drivers is expected to be $70,000 per year, and operating expenses are expected to be $63,000 per year, including fuel, maintenance, insurance, and the like. The company's marginal tax rate is 40 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 $6,000. 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 double declining balance depreciation (no half-year convention, no switching). End of Year ATCF 90000 34200 30200 27533.33 36466.67 After-tax PW: $ 11643.01 After-tax AW: $U 2673.32 For dollar amounts, carry all interim calculations to 5 decimal places and then round your final answer to the nearest dollar. The tolerance is +3%. After-tax IRR: 15.836% -12.98 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. AgriGrow is to purchase a tractor for over-the-road hauling for $90,000. It is expected to be of use to the company for 6 years, after which it will be salvaged for $4,000. Transportation cost savings are expected to be $170,000 per year; however, the cost of drivers is expected to be $70,000 per year, and operating expenses are expected to be $63,000 per year, including fuel, maintenance, insurance, and the like. The company's marginal tax rate is 40 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 $6,000. 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 double declining balance depreciation (no half-year convention, no switching). End of Year ATCF 90000 34200 30200 27533.33 36466.67 After-tax PW: $ 11643.01 After-tax AW: $U 2673.32 For dollar amounts, carry all interim calculations to 5 decimal places and then round your final answer to the nearest dollar. The tolerance is +3%. After-tax IRR: 15.836% -12.98 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
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