Use Excel to solve problem. Please provide the built in functions used for each Column cell. Calculate, BT&LCF, PPMT, IPMT, DWO, TI, Tax, ATCF.

Robinson Co. is interested in purchasing a new delivery vehicle so it can become a subcontractor with Amazon Logistics. The vehicle would cost $75,000 and generate delivery revenue of $30,000 for each of the next 6 years. If Robinson C0. purchases the vehicle, it will take a loan for $60,000. The terms of the loan stipulate that 4% 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 $10,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 10\%, 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 \pm 10 . Should Robinson Co, purchase the new delivery vehicle? eTextbook and Media Assistance Used Remember that loan interest is deductible and will therefore impact the taxable income. MACRS-GDS nercentages for 3-5, 7, and 10-vear nronertv am onne Create and calculate the values of the following table format for each plan (for 10 yeai