For Year Ending December 31, 2022 Note: The estimated market value of the business is four times Net Income Before Interest Expense and Income Taxes Required: Complete the ratios and the open ended questions and then upload your file to CyberText.com for grading. Debt-to-Equity Ratio Total Liabilities Round to two decimal places =Round(number,2) $54,190.00 Return on Assets Gross Margin Ratio Basic Eamings per Share Inventory Tumover Ratio Book Value per Common Share Days' Sales Uncollected Times Interest Eamed = Total Asset Tumover Days' Sales in Inventory Dividend Yield Price-Eamings Ratio Account Receivable Turnover Ratio = Debt Ratio Cash Flow on Total Assets Profit Margin Ratio Current Ratio = Acid-Test Ratio = Total Equity Net Income Average Total Assets Gross Profit Net Sales Net Income - Preferred Dividends Average Shares of Common Stock Outstanding Cost of Goods Sold Average Inventory Stockholders' Equity Applicable to Common Shares Number of Common Shares Outstanding Accounts Receivable, Net x 365 days Net Sales Income Before Interest Expense and Income Tax Expense Interest Expense Net Sales Average Total Assets Ending Inventory x 365 days Cost of Goods Sold Annual Cash Dividend Per Share Market Price Per Common Share Market Price Per Common Share Eamings Per Share Net Sales Average Account Receivables Total Liabilities Total Assets Cash Flow From Operations Average Total Assets Net Income Net Sales Current Assets Current Liabilities Cash+Short-Term Investments+Current Receivables Current Liabilities #DIV/0! #DIV/0! A Byte of Accounting Balance Sheet As of December 31, 2021 Assets Current Assets Cash Accounts Receivable Allowance for Doubtful Accounts Net Receivable Prepaid Rent Office Supplies Total Current Assets Long-Term Assets $ 183,590.00 $ 30,000.00 600.00 Office Equipment $ 67,100.00 Accum. Depr.-Office Equipment 6,400.00 Net Office Equipment $ 60,700.00 Computer Equipment $ 21,500.00 Accum. Depr.-Computer Equipment 4,300.00 Net Computer Equipment 17,200.00 Total Long Term Assets Total Assets Liabilities Current Liabilities Accounts Payable Salaries Payable Income Taxes Payable Total Liabilities Stockholder's Equity $ 47,330.00 29,400.00 2,400.00 900.00 $ 216,290.00 77,900.00 $ 294,190.00 860.00 6,000.00 $ 54,190.00 Capital Stock, $0.01 Par Value $ 15.00 Paid in Capital in Excess of Par Retained Earnings 215,985.00 24,000.00 Total Stockholder's Equity Total Liabilities and Stockholder's Equity 240,000.00 $ 294,190.00 Balance Sheet As of December 31, 2022 Assets Current Assets Cash Accounts Receivable Allowance for Doubtful Accounts Net Receivable Prepaid Insurance Prepaid Rent Office Supplies Inventory Total Current Assets Long-Term Assets Office Equipment Accum. Depr.-Office Equipment Net Office Equipment Computer Equipment Accum. Depr.-Computer Equipment Net Computer Equipment Total Long-Term Assets Total Assets $ 71,900.00 12,880.63 $ 21,500.00 8,600.00 $ 26,231.00 1,311.55 $ 59,019.37 12,900.00 $ 475,584.10 24,919.45 6,325.00 2,400.00 782.00 540.00 510,550.55 71,919.37 $ 582,469.92 Liabilities Current Liabilities Accounts Payable Advanced Payment Interest Payable Salaries Payable Income Taxes Payable Total Current-Liabilities Long-Term Liabilities Notes Payable Bond Payable Premium on Bond Payable Net Bond Payable Total Long-Term Liabilities Total Liabilities Stockholder's Equity Capital Stock, $0.01 par value Paid in Capital in Excess of Par Retained Earnings Total Stockholder's Equity Total Liabilities and Stockholder's Equity $ 22,620.00 8,715.00 21.60 1,290.00 11,045.66 $ 43,692.26 $ 4,320.00 $ 190,000.00 12,720.68 202,720.68 35.00 275,965.00 55,736.98 207,040.68 $ 250,732.94 331,736.98 $ 582,469.92 Revenues Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses Rent Expense Salary Expense Advertising Expense Repairs & Maint. Expense Supplies Expense Insurance Expense Depreciation Expense Bad Debt Expense Telephone Expense Total Operating Expenses Income Statement For Year Ending December 31, 2022 Income From Operations Before Interest and Income Taxes Interest Expense Net Income Before Tax Income Tax Expense (Round to two decimal places) Net Income After Tax $ 28,800.00 102,340.00 4,760.00 15,055.00 2,568.00 275.00 455,718.00 227.805.00 $ 227,913.00 10,780.63 1,273.55 5,970.00 171,822.18 56,090.82 11,908.18 44,182.64 11,045.66 33,136.98 A Byte of Accounting Statement of Cash Flows - Indirect Method For Year Ending December 31, 2022 Cash Flow from Operating Activities Net Income Adjustments to reconcile net income to net cash flows from operating activities: Depreciation expenses Decrease in accounts receivable Increase in prepaid Insurance Change in prepaid rent Decrease in office supplies Increase in inventory Decrease in payables Increase in income tax payable Net cash flows from operations Cash Flows from Investing Activities Purchase of equipment Net cash flows from investing activities Cash Flows from Financing Activities Issuance of common stock Proceeds from issuance of bonds payable Payment of cash dividends Net cash flows from financing activities Net increase (decrease) in cash Cash at the beginning of the period Cash at the end of the period $ 33,136.98 10,780.63 4,480.55 (6,325.00) 118.00 (540.00) (15,543.40) 5,045.66 $ 31,153.42 $ (480.00) $ 60,000.00 202,720.68 (1,400.00) (480.00) 261,320.68 $ 291,994.10 183,590.00 $ 475,584.10 Noncash Activities Purchased equipment by issuing note payable $ 4,320.00 Balance, Beginning of Period Issue of Common Stock Cash Dividends Net Income Balance, End of Period A Byte of Accounting, Inc Statement of Stockholders' Equity For Year Ending December 31.2022 Common Stock, $0.01 Additional Paid-in- Retained Total Stockholders' Capital Earnings par value Equity $ 15.00 $ 215,985.00 $ 24,000.00 $ 240,000.00 20.00 59,980.00 60,000.00 1,400.00 1,400.00 33,136.98 33,136.98 $ 35.00 $ 275,965.00 $55,736.98 $ 331,736.98