Question: Show work and dont use excel please. If you must use excel, show formulas Robinson Co. is interested in purchasing a new delivery vehicle so

 Show work and dont use excel please. If you must use

Show work and dont use excel please.

If you must use excel, show formulas

Robinson Co. is interested in purchasing a new delivery vehicle so it can become a subcontractor with Amazon Logistics. The vehicle would cost $100,000 and generate delivery revenue of $40,000 for each of the next 6 years. If Robinson Co. purchases the vehicle, it will take a loan for $80,000. The terms of the loan stipulate that 3% annual interest would be charged and that the loan would be repaid in 6 equal end of year payments. At the end of the 6 years, the vehicle will have a salvage value of $5,000. The tax rate is 40%. Assuming that the vehicle is depreciated using MACRS (5-year property class) and that Robinson Co. uses an after-tax MARR of 12%, compute the PW and determine whether Robinson Co. should purchase the new business vehicle. Click here to access the TVM Factor Table calculator. Click here to access the MACRS-GDS Property Classes. Click here to access the MACRS-GDS percentages page. Click here to access the MACRS-GDS percentages for 27.5-year residential rental property. $ Carry all interim calculations to 5 decimal places and then round your final answer to a whole number. The tolerance is +10. Should Robinson Co. purchase the new delivery vehicle

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!