Can yall show me how yall calculate the ratios not just the answer please!!!
Use the information from the financial statements to calculate the following ratios: 1. Debt ratio 2. Profit margin 3. Current ratio
Last period the company had the following for the corresponding ratios Debt ratio = 32% Profit margin = 52.60% Current ratio = 23.06
How does the companys current performance compare to last periods? Provide a brief discussion of the companys performance. Your discussion should be at least 4 well-articulated sentences.
ACC PROJECT - Excel Emily Guerrero EG File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share AutoSum Calibri 11 ab Wrap Text Ie> II General & Cut e Copy *Format Painter AY O Fill - - Paste BIU- Merge & Center $ - % 4.0 .00 .00 0 Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Clear Sort & Find & Filter - Select Editing Clipboard Font Alignment Number Cells F48 f unearned revenue H 1 J K L M N O P 0 R S 1 2 3 B D E F G Balance Sheet Assets Cash Accounts Receivable Prepaid Insurance Debit Credit Debit Credit Debit Credit 29000 1 14000 Supplies Debit Credit Office Supplies Debit Credit Liabilities Accumulated Depred Accounts Payable Wages Payable Debit Credit Debit Credit Debit Credit Salaries Payable Debit Credit 4 5 Beginning Balance 6 14000 6000 7 8 2-Jan 3 6000 2000 2000 4 41000 5 9200 9 10 11 12 Unadj. Bal 13 6 14000 52800 6000 2000 7 2000 14 8 5000 1650 1000 3501 14000 -2000 15 9 16 10 17 Adjusted Balance 58200 18 19 20 Smith Consult. Company 21 Unadjusted trial balance 22 Dec 31 2020 23 Account title Debit Credit Sheet1 + Smith Consulting Company Income Statement year ended Dec 31 2020 Revenues: Ready B + 100% Type here to search j O L W (99+ 10:10 AM 11/18/2020 ACC PROJECT - Excel Emily Guerrero EG File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Share f! AutoSum Calibri 11 ab Wrap Text General & Cut e Copy Format Painter AY O Fill - - Paste BIU U -A === Merge & Center $ - % 4.0 .00 .00 0 Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Clear - Sort & Find & Filter - Select- Editing Clipboard Font Alignment Number Cells F48 for unearned revenue N O P Q R S T V w Y Z AA AB AC AD AE AF AG AF A 1 2 Liabilities 3 Accounts Payable 4 Debit Credit Wages Payable Debit Credit Salaries Payable Debit Credit Taxes Payable Debit Credit Stockholders equity Income Statement Unearned Revenue Common Stock Retained Earnings Revenue Expenses Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit 15000 14000 5 6 7 8 9 41000 10 9200 11 12 13 14 15 16 17 18 - 15000 - 14000 -41000 9200 19 20 21 22 23 Sheet1 + Ready B + 100% Type here to search j L W 99+ 10:10 AM 11/18/2020 ACC PROJECT - Excel Emily Guerrero EG File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Share * Cut f! AutoSum Calibri 11 ab Wrap Text General AY O Fill - - Paste LE Copy *Format Painter BIU -A 3 Merge & Center - $ - % 4.0 .00 .00 0 Insert Delete Format Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter - Select- Editing Clipboard Font Alignment Number Cells F48 f unearned revenue B D E F G H 1 K L M N O P O R S 19 20 Smith Consult. Company 21 Unadjusted trial balance 22 Dec 31 2020 23 Account title Debit Credit 24 Cash 52800 25 Accounts receivable 0 26 Prepaid Insurance 6000 27 Supplies 2000 28 Equipment 14000 29 Accumulated Depreciati 0 30 Accounts payable 0 31 Wages Payable 0 32 Salaries Payable 0 33 Taxes Payable 0 34 Unearned revenue 14000 35 Common stock 15000 36 Retained earnings 14000 37 Service Revenue 41000 38 Salaries and wages expel 9200 39 Totals 84000 84000 40 41 Sheet1 + Smith Consulting Company Income Statement year ended Dec 31 2020 Revenues: Service Revenue 515001 Expenses Salaries Ex 9200 Depreciati 2000 prepaid in: 5000 supplies e: 1650 total expenses 17850 Net income 33650 Smith Consulting Company Balance Sheet 31-Dec-20 Assets Current Assets Cash 52800 Supplies 1000 Prepaid in 350 Total current assets 54150 Ready B + 100% Type here to search j L W 99+ 10:11 AM 11/18/2020 ACC PROJECT - Excel Emily Guerrero EG File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Share f! AutoSum Calibri 11 ab Wrap Text General & Cut e Copy *Format Painter AY O Fill - - Paste BIU. -A Merge & Center - $ % 4.0 .00 .00 0 Insert Delete Format Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter - Select- Editing Clipboard Font Alignment Number Cells F48 X f unearned revenue B D E | 1 J K L M N O P O R S 0 14000 A 33 Taxes Payable 34 Unearned revenue 35 Common stock 36 Retained earnings 37 Service Revenue 38 Salaries and wages expe 39 Totals 40 15000 14000 41000 9200 84000 84000 41 42 43 G H Smith Consulting Company Balance Sheet 31-Dec-20 Assets Current Assets Cash 52800 Supplies 1000 Prepaid in 350 Total current assets 54150 Property, plant and equipment Equipment 14000 Accumulat -2000 12000 Total assets 661501 Liabilities and owner's equity current liabilities unearned levenue 3500 total current liabilitie 3500 stockholder' equity commons 150001 retained el 47650) total stockholder' egl 62650 Total Liabilities and 66150 44 45 46 47 48 49 50 51 52 53 54 55 Sheet1 + Ready B + 100% Type here to search j L W 99+ 10:11 AM 11/18/2020
