Can use excel and provide each column cells built in functions used.
A small business is trying to decide whether it should purchase or lease a delivery truck. The cost to purchase a delivery truck is $100,000; it would be depreciated as 5 -year MACRS property and would cost $6,000 per year to operate and maintain. The company plans to keep it for 7 years, at which point it would have a salvage value of $8,000. Alternatively, the small business could lease a delivery truck for $20,000 per year with payments due at the beginning of each year. Maintenance is included in the cost of the lease but operating costs would be $4.000 per year. The delivery truck would be leased for 7 years. Assuming an after-tax MARR of 8% and a tax rate of 30%, compute the PW of each alternative and determine whether the small business should purchase or lease the delivery truck. 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. PW(purchase)=$PW(lease)=$ Carry all interim calculations to 5 decimal places and then round your final answers to a whole number. The tolerance is \pm 2 . Should the small business should purchase or lease the delivery truck? eTextbook and Media Assistance Used Remember both the tax and depreciation implications of leasing an asset vs, purchasing it. TABLE 8.3 MACRS-GDS percentages for 3-, 5-, 7-, and 10-year property are 200% \begin{tabular}{|c|c|c|c|c|c|c|} \hline EOY & \begin{tabular}{c} 3-Year \\ Property \end{tabular} & \begin{tabular}{c} 5-Year \\ Property \end{tabular} & \begin{tabular}{c} 7-Year \\ Property \end{tabular} & \begin{tabular}{l} 10-Year \\ Property \end{tabular} & \begin{tabular}{c} 15-Year \\ Property \end{tabular} & \begin{tabular}{c} 20-Year \\ Property \end{tabular} \\ \hline 1 & 33.33 & 20.00 & 14.29 & 10.00 & 5.00 & 3.750 \\ \hline 2 & 44.45 & 32.00 & 24.49 & 18.00 & 9.50 & 7.219 \\ \hline 3 & 14.81 & 19.20 & 17.49 & 14.40 & 8.55 & 6.677 \\ \hline 4 & 7.41 & 11.52 & 12.49 & 11.52 & 7.70 & 6.177 \\ \hline 5 & & 11.52 & 8.93 & 9.22 & 6.93 & 5.713 \\ \hline 6 & & 5.76 & 8.92 & 7.37 & 6.23 & 5.285 \\ \hline 7 & & & 8.93 & 6.55 & 5.90 & 4.888 \\ \hline 8 & & & 4.46 & 6.55 & 5.90 & 4.522 \\ \hline 9 & & & & 6.56 & 5.91 & 4.462 \\ \hline 10 & & & & 6.55 & 5.90 & 4.461 \\ \hline 11 & & & & 3.28 & 5.91 & 4.462 \\ \hline 12 & 4 & & . & & 5.90 & 4.461 \\ \hline 13 & & & & & 5.91 & 4.462 \\ \hline 14 & & & & & 5.90 & 4.461 \\ \hline 15 & & & & & 5.91 & 4.462 \\ \hline 16 & & & & & 2.95 & 4.461 \\ \hline 17 & & & & & & 4.462 \\ \hline 18 & & & & & & 4.461 \\ \hline 19 & & & & & & 4.462 \\ \hline 20 & & & & & & 4.461 \\ \hline 21 & & & & & & 2.231 \\ \hline \end{tabular} Create and calculate the values of the following table format for each plan (for 10 year
