Use of the basic reference/linking function and math functionality in Excel/Sheets must be included

T Bardmen Corp has purchased a new Assembly Machine on Jan 1, 2023 paying 10% of the purchase price in cash and signing a 5 year note for the balance. The following information is known: \begin{tabular}{|c|c|c|} \hline \multicolumn{2}{|c|}{ Master Fixed Asset Record } & \\ \hline Cost: & 3,250,000 & \multirow{4}{*}{\begin{tabular}{l} Use Learning \\ resources (Slides) \\ and Ebook Ch 9. \end{tabular}} \\ \hline Estimated Residual: & 165,000 & \\ \hline Estimated Life in years & 5 & \\ \hline Estimated Life in hours & 32,000 & \\ \hline \multicolumn{3}{|l|}{ Actual hours per year } \\ \hline 1 & 7,000 & \\ \hline 2 & 9,500 & \\ \hline 3 & 8,000 & \\ \hline 4 & 5,500 & \\ \hline 5 & 2,000 & \\ \hline \multicolumn{2}{|c|}{ Additional Problem information: } & \\ \hline Cash received from sale & 850,000 & \\ \hline Fair value (impairment) & 300,000 & \\ \hline \end{tabular}