Use the balance sheet information above, fill in the values and formulas to complete the excel sheet.

\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 39 & Shareholders' Equity & & & & & & \\ \hline 40 & Common Stock - Par Value & 5,061 & 5,061 & 5,061 & 5,061 & 5,061 & 5,061 \\ \hline 41 & Additional Paid in Capital & 9,947 & 9,052 & 7,787 & 6,745 & 6,768 & 6,804 . \\ \hline 42 & Treasury Stock - Common & (50,814). & (51,861). & (52,641). & (54,914). & (52,348). & (43,454). \\ \hline 43 & Retained Earnings & 29,473 & 34,408 & 38,610 & 50,644 & 55,941 & 49,618 . \\ \hline 44 & Accumulated Other Comprehensive Income (Loss) & (9,550). & (11,659). & (17,133). & (16,153). & (15,083). & (16,373). \\ \hline 45 & Total Shareholders Equity & (15,883). & (14,999). & (18,316). & (8,617). & 339. & 1,656 . \\ \hline 46 & Total Liabilities \& Shareholders Equity & 137,100 & 138,552 & 152,136 & 133,625 & 117,359 & 112,362 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 27 & & Year (t=0) & Year (t=1) & Year (t=2) & Year (t=3) & Year (t=4) & Year (t=5) \\ \hline 28 & Accounts Receivable: & 2022 & 2021 & 2020 & 2019 & 2018 & 2017 \\ \hline 29 & \multicolumn{7}{|c|}{ Review Footnotes related to AR. Were there any changes? } \\ \hline \multicolumn{8}{|l|}{30} \\ \hline 31 & \begin{tabular}{l} AR Amounts Reported on Bal Sheet (Net of \\ Allowances) \end{tabular} & & & & & & \\ \hline 32 & Allowance Amounts & & & & & & \\ \hline 33 & Gross AR (AR + Allowances) & & & & & & \\ \hline 34 & \begin{tabular}{l} Allowance to Gross AR Ratio (i.e. what \\ percentage the firm thinks is uncollectible) = \\ Allowance Amt/Gross AR \end{tabular} & & & & & & \\ \hline \multicolumn{8}{|l|}{35} \\ \hline 36 & Bad Debt Expense & & & & & & \\ \hline 37 & Bad Debt to Sales Ratio & & & & & & \\ \hline 38 & \begin{tabular}{l} AR to Sales Ratio (note that it's the inverse of AR \\ turnover) \end{tabular} & & & & & & \\ \hline \multicolumn{8}{|l|}{39} \\ \hline 40 & Accounts Receivable Turnover & Y & & & & & \\ \hline 41 & DSO & & & & & & \\ \hline \multicolumn{8}{|l|}{42} \\ \hline 43 & Potential for Income Shifting? & & & & & & \\ \hline \end{tabular}