Answered step by step
Verified Expert Solution
Question
1 Approved Answer
First 2 is information provided and the last one is what needs answered. ABC Company Balance Sheet begin{tabular}{|c|c|c|c|c|c|c|} hline multicolumn{7}{|c|}{ As of 12/31/2022,12/31/2021, and 12/31/20}
First 2 is information provided and the last one is what needs answered.
ABC Company Balance Sheet \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ As of 12/31/2022,12/31/2021, and 12/31/20} \\ \hline \multirow[b]{2}{*}{ Cash } & \multicolumn{2}{|r|}{12/31/22} & \multicolumn{2}{|c|}{12/31/21} & \multicolumn{2}{|r|}{12/31/20} \\ \hline & $ & 420,000 & $ & 320,000 & $ & 120,000 \\ \hline Accounts Receivable, Net & & 170,000 & & 130,000 & & 200,000 \\ \hline Inventory & & 200,000 & & 300,000 & & 200,000 \\ \hline Prepaid Rent & & 50,000 & & 40,000 & & 45,000 \\ \hline Prepaid Insurance & & 30,000 & & 30,000 & & 30,000 \\ \hline Total Current Assets & F & 870,000 & & 820,000 & & 595,000 \\ \hline Plant, Property \& Equipment, Net & & 600,000 & & 550,000 & & 520,000 \\ \hline Note Receivable & & - & & - & & - \\ \hline Total Long-Term Assets & & 600,000 & & 550,000 & & 520,000 \\ \hline Total Assets & $ & 1,470,000 & $ & 1,370,000 & $ & 1,115,000 \\ \hline Accounts Payable & $ & 40,000 & $ & 30,000 & $ & 50,000 \\ \hline Interest Payable & & 15,000 & & 15,000 & & 15,000 \\ \hline Total Current Liabilites & & 55,000 & & 45,000 & & 65,000 \\ \hline Note Payable & & 200,000 & & 160,000 & & 180,000 \\ \hline Total Liabilities & & 255,000 & & 205,000 & & 245,000 \\ \hline Common Stock & & 400,000 & & 380,000 & & 360,000 \\ \hline Preferred Stock & & 50,000 & & 50,000 & & 50,000 \\ \hline Retained Earnings & & 765,000 & & 735,000 & & 460,000 \\ \hline Total Stockholder's Equity & & 1,215,000 & & 1,165,000 & & 870,000 \\ \hline Total Liabilities and Stockholder's Equity & $ & 1,470,000 & $ & 1,370,000 & $ & 1,115,000 \\ \hline \end{tabular} \begin{tabular}{|l|rr|rr|rr|} \hline Additional Information Needed & & & & \\ \hline Common Stock Shares Outstanding & 50,000 & & 45,000 & 42,000 \\ \hline Market Price Per Share & $ & 50 & $ & 30 & $ & 26 \\ \hline Preferred Dividend & $ & 5,000 & $ & 5,000 & $ & 5,000 \\ \hline Dividends Per Share & $ & 3.20 & $ & 2.40 & $ & 2.00 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \cline { 2 - 3 } \multicolumn{1}{l|}{} & 12/31/22 & 12/31/21 \\ \hline Qurrent Ratio & & \\ \hline Quick Ratio & & \\ \hline Average Days to Collect Receivables & & \\ \hline Inventory Turnover & & \\ \hline Average Days to Sell Inventory & & \\ \hline Debt to Assets & & \\ \hline Debt to Equity & & \\ \hline Number of Times Interest Earned & & \\ \hline Plant Assets to Long-Term Liabilities & & \\ \hline Net Margin (Return on Sales) & & \\ \hline Asset Turnover & & \\ \hline Return on Investment (ROI) & & \\ \hline Return on Equity (ROE) & & \\ \hline Earnings Per Share & & \\ \hline Book Value Per Share & & \\ \hline Price-Earnings Ratio & & \\ \hline Dividend Yield & & \\ \hline \end{tabular} ABC Company Balance Sheet \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ As of 12/31/2022,12/31/2021, and 12/31/20} \\ \hline \multirow[b]{2}{*}{ Cash } & \multicolumn{2}{|r|}{12/31/22} & \multicolumn{2}{|c|}{12/31/21} & \multicolumn{2}{|r|}{12/31/20} \\ \hline & $ & 420,000 & $ & 320,000 & $ & 120,000 \\ \hline Accounts Receivable, Net & & 170,000 & & 130,000 & & 200,000 \\ \hline Inventory & & 200,000 & & 300,000 & & 200,000 \\ \hline Prepaid Rent & & 50,000 & & 40,000 & & 45,000 \\ \hline Prepaid Insurance & & 30,000 & & 30,000 & & 30,000 \\ \hline Total Current Assets & F & 870,000 & & 820,000 & & 595,000 \\ \hline Plant, Property \& Equipment, Net & & 600,000 & & 550,000 & & 520,000 \\ \hline Note Receivable & & - & & - & & - \\ \hline Total Long-Term Assets & & 600,000 & & 550,000 & & 520,000 \\ \hline Total Assets & $ & 1,470,000 & $ & 1,370,000 & $ & 1,115,000 \\ \hline Accounts Payable & $ & 40,000 & $ & 30,000 & $ & 50,000 \\ \hline Interest Payable & & 15,000 & & 15,000 & & 15,000 \\ \hline Total Current Liabilites & & 55,000 & & 45,000 & & 65,000 \\ \hline Note Payable & & 200,000 & & 160,000 & & 180,000 \\ \hline Total Liabilities & & 255,000 & & 205,000 & & 245,000 \\ \hline Common Stock & & 400,000 & & 380,000 & & 360,000 \\ \hline Preferred Stock & & 50,000 & & 50,000 & & 50,000 \\ \hline Retained Earnings & & 765,000 & & 735,000 & & 460,000 \\ \hline Total Stockholder's Equity & & 1,215,000 & & 1,165,000 & & 870,000 \\ \hline Total Liabilities and Stockholder's Equity & $ & 1,470,000 & $ & 1,370,000 & $ & 1,115,000 \\ \hline \end{tabular} \begin{tabular}{|l|rr|rr|rr|} \hline Additional Information Needed & & & & \\ \hline Common Stock Shares Outstanding & 50,000 & & 45,000 & 42,000 \\ \hline Market Price Per Share & $ & 50 & $ & 30 & $ & 26 \\ \hline Preferred Dividend & $ & 5,000 & $ & 5,000 & $ & 5,000 \\ \hline Dividends Per Share & $ & 3.20 & $ & 2.40 & $ & 2.00 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \cline { 2 - 3 } \multicolumn{1}{l|}{} & 12/31/22 & 12/31/21 \\ \hline Qurrent Ratio & & \\ \hline Quick Ratio & & \\ \hline Average Days to Collect Receivables & & \\ \hline Inventory Turnover & & \\ \hline Average Days to Sell Inventory & & \\ \hline Debt to Assets & & \\ \hline Debt to Equity & & \\ \hline Number of Times Interest Earned & & \\ \hline Plant Assets to Long-Term Liabilities & & \\ \hline Net Margin (Return on Sales) & & \\ \hline Asset Turnover & & \\ \hline Return on Investment (ROI) & & \\ \hline Return on Equity (ROE) & & \\ \hline Earnings Per Share & & \\ \hline Book Value Per Share & & \\ \hline Price-Earnings Ratio & & \\ \hline Dividend Yield & & \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started