Can you solve it?

Rebound Financial Statements Assignment.xlsx Download Rebound \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & B & c & D & E & G & H & 1 & J & K & L & M & N & 0 & P & Q \\ \hline 1 & Balances as of 9/30/2023 & & & & & & & & & & & & & & \\ \hline 2 & (in thousands) & & & & & & & & & & & & & & \\ \hline 3 & & & & & & & & & & & & & & & \\ \hline 4 & Assets & & & & Liabilities & & & & & & & & & & \\ \hline 5 & Cash & $51,950 & & & Current Portion of Debt & $65,000 & & & & & & & & & \\ \hline 6 & Accounts Receivable, gross & $40,000 & & & Interest Payable & $10,000 & & & & & & & & & \\ \hline 7 & less: allowance for bad debt & ($5,000) & & & Accounts Payable & $11,000 & & & & & & & & & \\ \hline 8 & Inventory & $90,000 & & & Dividends Payable & $0 & & & & & & & & & \\ \hline 9 & Property, Plant, and Equipmen & $81,000 & & & Legal Contingency & $0 & & & & & & & & & \\ \hline 10 & less: accum depreciation & ($20,000) & & & Long-term Portion of Debt & $92,000 & & & & & & & & & \\ \hline 11 & & & & & Total Liabilities & $178,000 & & & & & & & & & \\ \hline 12 & & & & & & & & & & & & & & & \\ \hline 13 & Total Assets & $237,950 & & & Owner's Equity & & & & & & & & & & \\ \hline 14 & & & & & Common Stock (400,000 shares) & $16,000 & & & & & & & & & \\ \hline 15 & & & & & Retained Earnings & $43,950 & & & & & & & & & \\ \hline 16 & & & & & & & & & & & & & & & \\ \hline 17 & & & & & & & & & & & & & & & \\ \hline 18 & & & & & Total Liab \& Equity & $237,950 & & & & & & & & & \\ \hline 19 & & & & & & & & & & & & & & & \\ \hline 20 & & & & & & & & & & & & & & & \\ \hline 21 & & & & & & & & & & & & & & & \\ \hline \end{tabular} Rebound Financial Statements Assignment.xlsx Download Rebound Financial Statements Assignment.xlsx (22.9 KB) elected Prior Year Balances as of 12/31/2022 Worning: only use these for colculating rotios on the Ratio Analysis tob. Do not change these numbers Rebound Financial Statements Assignment.xlsx Download Rebound Financial Statements Assignment.xlsx (22.9 KB) Rebound Financial Statements Assignment.xlsx Download Rebound Financial Statements Assignment.xlsx (22.9 KB) Balances as of 9/30/2023 (in thousonds) Rebound Financial Statements Assignment.xlsx Download Rebound Financial Statements Assignment.xlsx (22.9 KB) \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline 4 & A & B & c & D & E & F & G & H & 1 & J & k & L & M & N & 0 & P & Q & R & s \\ \hline 1 & Balances & as of 9/30/2023 & & & & & & & & & & & & & & & & & \\ \hline 2 & (in thous & ands) & & & & & & & & & & & & & & & & & \\ \hline 3 & & & & & & & & & & & & & & & & & & & \\ \hline 4 & & Beginning Retained Earnin! & $43,600 & & & & & & & & & & & & & & & & \\ \hline 5 & & CY Net Income & $350 & & & & & & & & & & & & & & & & \\ \hline 6 & & Less: Dividends Declared & \$0 & & & & & & & & & & & & & & & & \\ \hline 7 & & Ending Retained Earnings & $43,950 & & & & & & & & & & & & & & & & \\ \hline 8 & & & & & & & & & & & & & & & & & & & \\ \hline 9 & & & & & & & & & & & & & & & & & & & \\ \hline 10 & & & & & & & & & & & & & & & & & & & \\ \hline 11 & & & & & & & & & & & & & & & & & & & \\ \hline 12 & & & & & & & & & & & & & & & & & & & \\ \hline 13 & & & & & & & & & & & & & & & & & & & \\ \hline 14 & & & & & & & & & & & & & & & & & & & \\ \hline 15 & & & & & & & & & & & & & & & & & & & \\ \hline 16 & & & & & & & & & & & & & & & & & & & \\ \hline 17 & & & & & & & & & & & & & & & & & & & \\ \hline 18 & & & & & & & & & & & & & & & & & & & \\ \hline 19 & & & & & & & & & & & & & & & & & & & \\ \hline 20 & & & & & & & & & & & & & & & & & & & \\ \hline 21 & & & & & & & & & & & & & & & & & & & \\ \hline & > & Instructions & Statement & & nt of & hld & & tmt of & Flows & B & & & & + & & & & & \\ \hline \end{tabular} Rebound Financial Statements Assignment.xlsx Download Rebound Financial Statements Assignment.xlsx (22.9 KB) Pieose colculote all of the financiol stotement ratios below, ofter you have made your financial accounting entries: For rotios using overoge bolonces, please use the figures on the "Prior Year Balonces" tab A B C E F G H \begin{tabular}{l|l|l} \hline & J \end{tabular} M N 0 P Q For ratios using average balances, please use the figures on the "Prior Year Balances" tab Receivables Turnover Net Credit Sales Average net Accounts Receivable \begin{tabular}{|r|r|} \hline 7 & \\ \hline 8 & \\ 9 & Inventory Turnover \\ \hline 10 & Cost of Goods Sol \end{tabular} 0 Cost of Goods Sold Average Inventory 12 4 Gross Profit Ratio Gross Profit Net Sales Return on Assets Net Income Average Total Assets Average Collection Period Days in the Year Receivables Turnove \#DIV /0 ! Average Days in Inventory Days in the Year Inventory Turnover Profit Margin Net Income Net Sales Return on Equity Net Income Average Equity Instructions Income Statement Statement of Stockhldr's Equity Stmt of Cash Flows Balance Sheet Ratio Analysis P... + Rebound Financial Statements Assignment.xlsx Download Rebound Financial Statements Assignment.xIsx (22.9 KB) Balances as of 9/30/2023 (in thousonds) Rebound Financial Statements Assignment.xlsx Download Rebound Financial Statements Assignment.xlsx (22.9 KB) Rebound Financial Statements Assignment.xlsx Download Rebound \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & B & c & D & E & G & H & 1 & J & K & L & M & N & 0 & P & Q \\ \hline 1 & Balances as of 9/30/2023 & & & & & & & & & & & & & & \\ \hline 2 & (in thousands) & & & & & & & & & & & & & & \\ \hline 3 & & & & & & & & & & & & & & & \\ \hline 4 & Assets & & & & Liabilities & & & & & & & & & & \\ \hline 5 & Cash & $51,950 & & & Current Portion of Debt & $65,000 & & & & & & & & & \\ \hline 6 & Accounts Receivable, gross & $40,000 & & & Interest Payable & $10,000 & & & & & & & & & \\ \hline 7 & less: allowance for bad debt & ($5,000) & & & Accounts Payable & $11,000 & & & & & & & & & \\ \hline 8 & Inventory & $90,000 & & & Dividends Payable & $0 & & & & & & & & & \\ \hline 9 & Property, Plant, and Equipmen & $81,000 & & & Legal Contingency & $0 & & & & & & & & & \\ \hline 10 & less: accum depreciation & ($20,000) & & & Long-term Portion of Debt & $92,000 & & & & & & & & & \\ \hline 11 & & & & & Total Liabilities & $178,000 & & & & & & & & & \\ \hline 12 & & & & & & & & & & & & & & & \\ \hline 13 & Total Assets & $237,950 & & & Owner's Equity & & & & & & & & & & \\ \hline 14 & & & & & Common Stock (400,000 shares) & $16,000 & & & & & & & & & \\ \hline 15 & & & & & Retained Earnings & $43,950 & & & & & & & & & \\ \hline 16 & & & & & & & & & & & & & & & \\ \hline 17 & & & & & & & & & & & & & & & \\ \hline 18 & & & & & Total Liab \& Equity & $237,950 & & & & & & & & & \\ \hline 19 & & & & & & & & & & & & & & & \\ \hline 20 & & & & & & & & & & & & & & & \\ \hline 21 & & & & & & & & & & & & & & & \\ \hline \end{tabular} Rebound Financial Statements Assignment.xlsx Download Rebound Financial Statements Assignment.xlsx (22.9 KB) elected Prior Year Balances as of 12/31/2022 Worning: only use these for colculating rotios on the Ratio Analysis tob. Do not change these numbers Rebound Financial Statements Assignment.xlsx Download Rebound Financial Statements Assignment.xlsx (22.9 KB) Rebound Financial Statements Assignment.xlsx Download Rebound Financial Statements Assignment.xlsx (22.9 KB) Balances as of 9/30/2023 (in thousonds) Rebound Financial Statements Assignment.xlsx Download Rebound Financial Statements Assignment.xlsx (22.9 KB) \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline 4 & A & B & c & D & E & F & G & H & 1 & J & k & L & M & N & 0 & P & Q & R & s \\ \hline 1 & Balances & as of 9/30/2023 & & & & & & & & & & & & & & & & & \\ \hline 2 & (in thous & ands) & & & & & & & & & & & & & & & & & \\ \hline 3 & & & & & & & & & & & & & & & & & & & \\ \hline 4 & & Beginning Retained Earnin! & $43,600 & & & & & & & & & & & & & & & & \\ \hline 5 & & CY Net Income & $350 & & & & & & & & & & & & & & & & \\ \hline 6 & & Less: Dividends Declared & \$0 & & & & & & & & & & & & & & & & \\ \hline 7 & & Ending Retained Earnings & $43,950 & & & & & & & & & & & & & & & & \\ \hline 8 & & & & & & & & & & & & & & & & & & & \\ \hline 9 & & & & & & & & & & & & & & & & & & & \\ \hline 10 & & & & & & & & & & & & & & & & & & & \\ \hline 11 & & & & & & & & & & & & & & & & & & & \\ \hline 12 & & & & & & & & & & & & & & & & & & & \\ \hline 13 & & & & & & & & & & & & & & & & & & & \\ \hline 14 & & & & & & & & & & & & & & & & & & & \\ \hline 15 & & & & & & & & & & & & & & & & & & & \\ \hline 16 & & & & & & & & & & & & & & & & & & & \\ \hline 17 & & & & & & & & & & & & & & & & & & & \\ \hline 18 & & & & & & & & & & & & & & & & & & & \\ \hline 19 & & & & & & & & & & & & & & & & & & & \\ \hline 20 & & & & & & & & & & & & & & & & & & & \\ \hline 21 & & & & & & & & & & & & & & & & & & & \\ \hline & > & Instructions & Statement & & nt of & hld & & tmt of & Flows & B & & & & + & & & & & \\ \hline \end{tabular} Rebound Financial Statements Assignment.xlsx Download Rebound Financial Statements Assignment.xlsx (22.9 KB) Pieose colculote all of the financiol stotement ratios below, ofter you have made your financial accounting entries: For rotios using overoge bolonces, please use the figures on the "Prior Year Balonces" tab A B C E F G H \begin{tabular}{l|l|l} \hline & J \end{tabular} M N 0 P Q For ratios using average balances, please use the figures on the "Prior Year Balances" tab Receivables Turnover Net Credit Sales Average net Accounts Receivable \begin{tabular}{|r|r|} \hline 7 & \\ \hline 8 & \\ 9 & Inventory Turnover \\ \hline 10 & Cost of Goods Sol \end{tabular} 0 Cost of Goods Sold Average Inventory 12 4 Gross Profit Ratio Gross Profit Net Sales Return on Assets Net Income Average Total Assets Average Collection Period Days in the Year Receivables Turnove \#DIV /0 ! Average Days in Inventory Days in the Year Inventory Turnover Profit Margin Net Income Net Sales Return on Equity Net Income Average Equity Instructions Income Statement Statement of Stockhldr's Equity Stmt of Cash Flows Balance Sheet Ratio Analysis P... + Rebound Financial Statements Assignment.xlsx Download Rebound Financial Statements Assignment.xIsx (22.9 KB) Balances as of 9/30/2023 (in thousonds) Rebound Financial Statements Assignment.xlsx Download Rebound Financial Statements Assignment.xlsx (22.9 KB)