Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The first 2 is the information provided and the last one is what needs answered. Fill in the chart for Company ABC ABC Company Balance

image text in transcribed

image text in transcribedimage text in transcribed

The first 2 is the information provided and the last one is what needs answered. Fill in the chart for Company ABC

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modeling And Designing Accounting Systems Using Access To Build A Database

Authors: Laura R. Ingraham, C. Janie Chang

1st Edition

0471450871, 978-0471450870

More Books

Students also viewed these Accounting questions

Question

What benefit or advantage does your organization offer each public?

Answered: 1 week ago