Use excel to solve problem. Please provide the built in functions used for each column cell.

A small business purchases a used airplane for $1,200,000; this is considered MACRS 5 -year property. The business plans to keep the plane for the next 7 years. The business estimates that the equipment would generate annual time and travel saving 5 of $300,000 per year. At the end of 7 years, the airplane would have a salvage value of $100,000. The tax rate is 25%, the aircraft is eligible for a Section 179 deduction, and that the small business uses an after-tax MARR of 8%. Compute the PW and determine whether the business should invest in the airplane. 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 5 . Should the small business invest in the airplane? eTextbook and Media Section 179 deductions allow small businesses to depreciate up to $1 million at the end of year 1; any remaining depreciation is taken according to the regular depreciation schedule on the adjusted cost basis. TABLE 8.3 MACRS-GDS percentages for 3,5,7, and 10-year property are 200% DBSLH and 15 - and 20 -year property are 150% DBSLH \begin{tabular}{|c|c|c|c|c|c|c|} \hline EOY & \begin{tabular}{l} 3-Year \\ Property \end{tabular} & \begin{tabular}{l} 5-Year \\ Property \end{tabular} & \begin{tabular}{l} 7-Year \\ Property \end{tabular} & \begin{tabular}{c} 10-Year \\ Property \end{tabular} & \begin{tabular}{l} 15-Year \\ Property \end{tabular} & \begin{tabular}{l} 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 & i & & . & & 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} After-Tax Analysis of the SMP Investment with MACRS Depreciation \begin{tabular}{|l|l|l|l|l|l|} \hline EOY & BTCF & DWO & TI & T & ATCF \\ \hline \end{tabular}