Use Excel to solve problem. Please peovide the built in functions used for each column/cell.
Elena's Cafe is investing in a new commercial refrigeration unit that will cost $40,000. They estimate that the unit will produce annual revenues of $11,000 for each of the next 6 years. The refrigeration unit will have negligible salvage value at the end of the next 6 years. Assuming a tax rate of 25%, a MACRS 5 -year property clas5, 50% bonus depreciation, and an after-tax MARR of 8%, compute the present worth of the refrigeration unit and determine whether or not Elena's Cafe should invest in the refrigeration unit. 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 8 . Should Elena's Cafe invest in the refrigeration unit? eTextbook and Media Hint Assistance Used 50% bonus depreciation will impact the depreciation schedule and impact the cost basis used to depreciate the asset after the first year. 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}{c} 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} ion: Create and calculate the values of the following table format for each plan (for 10 ye