Liquidity

Q 1) Calculate the Current Ratio

Q 2) Calculate the Quick Ratio

Q 3) Calculate the Working Capital

Q 4) - Calculate the Average Collection Period in Days

Q 5) - Calculate the Average Payables Period in Days

Q 6) - Calculate the Inventory days

Operating Performance

Q 7) - Calculate the Inventory Turnover

Q 8) - Calculate the Accounts Receivable Turnover

Q 9) - Calculate the Times Interest Earned

\begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ Balance Sheet XYZ } \\ \hline \multicolumn{2}{|l|}{ Assets } & \multirow[b]{2}{*}{2021} & \multirow{2}{*}{LiabilityCurrentLiabilities} & \multirow[t]{2}{*}{2020} & \multirow[t]{2}{*}{221} \\ \hline Current Assets: & 2020 & & & & \\ \hline Cash & 12,450 & 11,000 & Account Payable & 10,500 & 12,000 \\ \hline Marketable securities & 1,000 & 1,000 & Notes Payable & 24,200 & 22,500 \\ \hline Account Receivable & 18,750 & 13,000 & Wages accrued & 1,000 & 500 \\ \hline Inventories & 22,000 & 21,000 & Total Current Liabilities & 35,700 & 35,000 \\ \hline \multirow[t]{2}{*}{ Total Current Assets } & 54,200 & 46,000 & & & \\ \hline & & & Long term Liabilities & & \\ \hline Fixed Assets & & & Long term Debt & 175,000 & 165,000 \\ \hline \multirow[t]{2}{*}{ Property,land \&equip } & 195,000 & 181,000 & & & \\ \hline & & & Total Liabilities & 210,700 & 200,000 \\ \hline \multirow[t]{2}{*}{ Total Fixed Assets } & 195,000 & 181,000 & & & \\ \hline & & & Shareholder's Equity & & \\ \hline \multirow[t]{4}{*}{ Total Assets } & 249,200 & 227,000 & Common Shares & 28,000 & 18,000 \\ \hline & & & Retained Earning & 10,500 & 9,000 \\ \hline & & & Total shareholder's Equity & 38,500 & 27,000 \\ \hline & & & Total Liabilities \& S/E & 249,200 & 227,000 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Income statement XYZ Company \$ Thousand } \\ \hline & 2020 & 2021 \\ \hline \multicolumn{3}{|l|}{ Revenues } \\ \hline Product A & 12700 & 26500 \\ \hline Product B & 10000 & 10000 \\ \hline Total Revenue & 22700 & 36500 \\ \hline Cost of Goods Sold & 8,900.00 & 19,500.00 \\ \hline Gross Profit (Loss) & 13,800.00 & 17,000.00 \\ \hline \multicolumn{3}{|l|}{ Operation Expenses } \\ \hline Depreciation & 500.00 & 500.00 \\ \hline Marketing \& Sale & 1,600.00 & 2,400.00 \\ \hline Insurance & 300.00 & 300.00 \\ \hline Administration & 450.00 & 430.00 \\ \hline Total Operation Expense & 2,850.00 & 3,630.00 \\ \hline Operation Income & 10,950.00 & 13,370.00 \\ \hline Interest & 7,200.00 & 7,200.00 \\ \hline Net Income before taxes & 3,750.00 & 6,170.00 \\ \hline Taxes @ 4\% & 150.00 & 246.80 \\ \hline Net Income & 3,600.00 & 5,923.20 \\ \hline \end{tabular}