PLEASE INCLUDE THE FORMULAS FOR THE EXCEL SHEET, THANK YOU!
\begin{tabular}{lcc} Sales & \multicolumn{2}{c}{2021} \\ Depreciation & $ & 24,047 \\ Cost of goods sold & $ & 3,229 \\ Other expenses & $ & 8,750 \\ Interest & $ & 1,531 \\ Cash & $ & 1,723 \\ Accounts receivable & $ & 12,021 \\ Short term notes payable & $ & 17,529 \\ Longterm debt & $ & 2,133 \\ Net fixed assets & $ & 45,7980 \\ Accounts payable & $ & 100,893 \\ laventory & $ & 8,632 \\ Divdends & $ & 28,421 \\ Taxtate & $ & 3,008 \\ \hline \end{tabular} \begin{tabular}{lr|} \hline \multicolumn{2}{c|}{2021 income Slatement ' } \\ \hline Sales & $24,04700 \\ Costs & 875000 \\ Other expenses & 1,531,00 \\ naneenatinn & 323000 \end{tabular} This is not a evrrency format. Press F9 and see at the top it says Comma with 2 decim Input area: Output area: Output area: Input area: Output area: Output area. Inventory turnover On average. a unit of inventory sat on the shelf days. Output area: Output area: Net income Earnings per share Dividends per share Book value per share Market-to-book ratio P/Eratio Sales per share P/S ratio Input area: Output area Input area. Current assets Current liabilities Accounts payable Notes payable Total \begin{tabular}{|l|l|} \hline 2020 & 2021 \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} Long-term debt Owners' equity Common stock and paid-in surplus Net plant and equipment Retained earnings Total Total liabisties and Total assets owners' equity Summary Chapter 3 CH2 "1 42 "2 43 44 467#13.21426 Input area: Output area: Taxrate 25% SMOLIRA GOLF CORP Assels 2020 and 2021 Balance Sheets Liabihties and owners equity Cument assets Citsh Accounts receivable inventory Total 2020532,55316,91134,495584.059 \begin{tabular}{l} 2021 \\ 39,350 \\ 28,877 \\ 44,336 \\ \hline \end{tabular} Foxed assets Net plare and equpment 441099525154 Accumulated refained earrings Total Total bobilites and owners'equaty SMOLIRA GOLF CORP. 2021 income statement Output area: Surmmary Chapter 3 CH2#12#3#4#6#7#13#21#26 Output area: 31 Long-term solvency ratios: 2020 Total debt ratio 2021 Total debt ratio 2020 Debt-equity ratio 2021 Debt-equity ratio 2020 Equity mulitplier 2021 Equity mutiplier 2021 Times interest earned ratio Profitability ratios: Profit margin Return on assets Return on equity \begin{tabular}{lcc} Sales & \multicolumn{2}{c}{2021} \\ Depreciation & $ & 24,047 \\ Cost of goods sold & $ & 3,229 \\ Other expenses & $ & 8,750 \\ Interest & $ & 1,531 \\ Cash & $ & 1,723 \\ Accounts receivable & $ & 12,021 \\ Short term notes payable & $ & 17,529 \\ Longterm debt & $ & 2,133 \\ Net fixed assets & $ & 45,7980 \\ Accounts payable & $ & 100,893 \\ laventory & $ & 8,632 \\ Divdends & $ & 28,421 \\ Taxtate & $ & 3,008 \\ \hline \end{tabular} \begin{tabular}{lr|} \hline \multicolumn{2}{c|}{2021 income Slatement ' } \\ \hline Sales & $24,04700 \\ Costs & 875000 \\ Other expenses & 1,531,00 \\ naneenatinn & 323000 \end{tabular} This is not a evrrency format. Press F9 and see at the top it says Comma with 2 decim Input area: Output area: Output area: Input area: Output area: Output area. Inventory turnover On average. a unit of inventory sat on the shelf days. Output area: Output area: Net income Earnings per share Dividends per share Book value per share Market-to-book ratio P/Eratio Sales per share P/S ratio Input area: Output area Input area. Current assets Current liabilities Accounts payable Notes payable Total \begin{tabular}{|l|l|} \hline 2020 & 2021 \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} Long-term debt Owners' equity Common stock and paid-in surplus Net plant and equipment Retained earnings Total Total liabisties and Total assets owners' equity Summary Chapter 3 CH2 "1 42 "2 43 44 467#13.21426 Input area: Output area: Taxrate 25% SMOLIRA GOLF CORP Assels 2020 and 2021 Balance Sheets Liabihties and owners equity Cument assets Citsh Accounts receivable inventory Total 2020532,55316,91134,495584.059 \begin{tabular}{l} 2021 \\ 39,350 \\ 28,877 \\ 44,336 \\ \hline \end{tabular} Foxed assets Net plare and equpment 441099525154 Accumulated refained earrings Total Total bobilites and owners'equaty SMOLIRA GOLF CORP. 2021 income statement Output area: Surmmary Chapter 3 CH2#12#3#4#6#7#13#21#26 Output area: 31 Long-term solvency ratios: 2020 Total debt ratio 2021 Total debt ratio 2020 Debt-equity ratio 2021 Debt-equity ratio 2020 Equity mulitplier 2021 Equity mutiplier 2021 Times interest earned ratio Profitability ratios: Profit margin Return on assets Return on equity
