answer this by using the financial statements. let me knkw if i can provide any more information

5. Items due on the fourth due date a. Six of the following fourteen ratios from Chapter 12 must be calculated based on the financial statements and show comparative information for the two years. The ratios must be calculated using the financial information for this project. Ratios are found in Chapter 12 of the text book. 1. Current Ratio it. Quick Ratio ili Cash Ratio iv. Operating Cash Flow Ratio V. Times Interest Earned Ratio vi. Long-term Debt to Equity Ratio vil. Debt to Equity Ratio viii. Long-term Debt to Total Assets ix. Accounts Receivable Turnover Ratio X. Inventory Ratio xi. Asset Turnover Ratio xil. Gross Profit Percentage xlii. Operating Margin Percentage xiv. Net Profit Margin Percentage otomont Laurnal Data Formulas Review File Home Draw Insert Page Layout * abe Gene Calibri 11 AA ==EO. B 1 0 - 1 + 2 + A + = v $ Paste ul 2 Font Alignment Clipboard E16 D B E H G 100,000 A 1 Revenues 2 Sales Revenue 3 4 Total Revenue 5 100,000 22,000 16,000 2,000 1,000 6 7 Expenses 8 Rent Expense 9 Salary expense 10 Utility Expense 11 Insurance Expense 12 13 Total Expenses 14 15 Net Income 16 17 18 19 20 21 41,000 59,000 Balance sheet First Year Income Statement Ending Balance Sheet Jou Type here to search o 8 Project Amanda Thompson and Austin Cunnien hi[1301] - Read-Only - Excel amanda AutoSave Review View Draw File Help Home Insert Page Layout Formulas Data - AA EE 9 A Calibri WD 11 General Insert 2 Delete Format . . Is- - $ . % 98- Conditional Formatas Cell Formatting Table Styles Sort Filte Celle Edit For Alignment G34 f G H E A. Sports January 1, 2021 Ending Balance 10.500 21,500 1,500 1,000 Total Current Assets: 34,500 B D 1 2 3 Assets 4 Current Assets: Cash 6 Accounts Receivable 7 Supplies e Prepaid Insurance 9 10 11 Property, plant, and equipment 12. Building 13 Equipment - Less: Accumulated Depreciation 14 15 Total Assets 16 17 Labilities 18 Current Liabilities: 19 Accounts Payable 20 Salary Payable 21 Unearned Revenue Balance sheet First Year Income Statement 60,000 20,500 Total Property. Plant, and Equpiment: 39,500 74000 3 6,000 21,000 10,000 Ending Balance Sheet Journal Entries - Income Stm ... 3 Type here to search o ED 3 File Home Insert Formulas Duta Review View Help Calibri Draw Page Layout 11 - AA = a.A. General $ - % *18-22 Incert D Delete WE Pasta Conditional Formatas Formatting Table - Styles I Format Gipboard Alignment Number Cells G34 6,000 21,000 10,000 2,000 Tatal Current Liabilities: 39,000 12.000 Total Long-term Liabilities 12,000 51,000 18 Current Liabilities 19 Accounts Payable 20 Salary Payable 21 Unearned Revenue 22 Notes Payable 23 24 Long-term Liabilities 25 Building Lease 26 27 Total Liabilities 28 29 Stockholder's Equity 30 Common Stock 31 Retained Earnings 32 Total Stockholder's Equity 33 34 35 36 37 38 17,000 6,000 23,000 Balance sheet First Year Income Statement Ending Balance Sheet Journal Entries - Income Stm... Type here to search a O AutoSave On Project Amanda Thompson and Aus- File Home Insert Draw Page Layout Formulas Review Hel Data View X Calibri 29 General A A SE AE Paste v BIU $ % 908-98 5 Clipboard Font Alignment Number E 130 A E F G H 1 2 3 B C D A. Sports Shop Multi-Step Income Statement Jan.1 2022 250,000 15,000 12,000 223,000 27,000 196,000 5 Sales Revenue 6 Less: Sales returnes and allowances 7 Less: Sales discounts 8 Net sales 9 Less: Cost of goods sold 10 Gross profit 11 Operating expense 12 Rent expense 13 Utility expense 14 Salary expense 15 Insurance expense 16 Depretation expense 17 Total operating expense 18 Income from operations 19 Non-Operating expense 20 Interest Expense 21 Total Non-Operating Expense Ending Balance Sheet 22,000 6,000 17,000 2,000 4,000 51,000 145,000 15,000 130,000 Journal Entries - Income Stmt. Income Statement fe year 2 Type here to search O AutoSave Om T GD Project Amanda Thompson and AL Data Review View H File Home Insert Draw Page Layout Formulas X Calibri 29 General 11 AA == OA Paste BIU $ % 38 Clipboard Font Alignment Number 130 > f D E F G H E 223,000 27,000 196,000 B 8 Net sales 9 Less: Cost of goods sold 10 Gross profit 11 Operating expense 12 Rent expense 13 Utility expense 14 Salary expense 15 Insurance expense 16 Depretation expense 17 Total operating expense 18 Income from operations 19 Non-Operating expense 20 Interest Expense 21 Total Non-Oporating Expense 22 Income Before Tax 23 Less: Income Tax Expense 24 Net Income 25 26 27 28 Ending Balance Sheet 22,000 6,000 17,000 2,000 4,000 51,000 145,000 15,000 130,000 30,000 100,000 Journal Entries - Income Stmt. Income Statement for year 2 Type here to search o C Project Amanda Thompson and Austin Cunnien hi[ 1 AutoSave Data View File Draw Home linsert Formulas Review Page Layout Help Calibri 11 ' ' General 2 IS Paste BIU A- $ % 9 8-98 Condition Formatting Clipboard 15 Font Alignment Number H24 fy A B F G H 1 K 1 2 3 4 C D A. Sports Shop Balance Sheet As on December 31st 5 Assets 6 Cash 30,000 7 Accounts Recievable 40,000 8 Supplies 4,000 9 Prepaid rent 2,000 10 Total current Assets 76,000 11 Total Property Plant and Equipment 12 Equipment 29,000 13 Less: Accumulated Depretation -12,000 17,000 14 Building 70,000 15 Less: Accumulated Depretiation -22,000 48,000 16 Total Property Plant and Equipment 65,000 17 Total Assets 141,000 18 Liabilities and Stockholder's Equity 19 Current Liabilities 20 Accounts Payable 22,000 21 Salary payable 5,000 Journal Entries Income Stit. Income Statement for year 2 2nd year, ending balance sheet Type here to search o a Project Amanda Thompson and Austin Cunnies AutoSave Ol Formulas Data Draw Review Page Layout File View Home Insert Help F Calibri 11 A A General Paste BIU a. A- ===== = $ -% 8-9 Cond Forma Font 15 Clipboard Alignment FS Number H24 fr H A B D E F G 13 Less: Accumulated Depretiation - 12,000 17,000 14 Building 70,000 15 Less: Accumulated Depretiation -22,000 48,000 16 Total Property Plant and Equipment 65,000 17 Total Assets 141,000 18 Liabilities and Stockholder's Equity 19 Current Liabilities 20 Accounts Payable 22,000 21 Salary payable 5,000 22 Unearned Revenue 3,000 23 Total Current Liabilities 30,000 24 Long Term Liabilities 25 Notes Payble 30,000 26 Mortgage 55,000 27 Total Long term Liabilities 85,000 28 Total Liabilities 29 Common Sock 7,000 30 Retianed Earnings 19,000 31 Total Sockholder's Equity 26,000 32 Total Liabilities and Stockholders Equity 141,000 33 Journal Entries - Income Stmt. Income Statement for year 2 2nd year, ending balance sheet Type here to search