Using excel balance sheet calculate the current ratio and the debt to equity ratio

SDUNN MOD2 EXCEL.XSX Week 3 - Excel Sally Dunn-X File Home Insert Draw Page Layout Formulas Data Review iew Help Tell me what you want to do Share Comments AutoSum . A Calibri Custom Paste Copy Conditional Format as Cell Formatting Table Styles Styles Insert Delete Fonmat & Center Format Painter ClrFilterSelect Clipboard Font Alignment Number Editing 0 March 31,2016 Debit Credit 318,230 240,000 1,200 23 Accumulated Depreciation 1,020 25 Salaries and Wages Expense 26 Bank Notes Payable 27 Mortgage Note Payable 192,000 31 Salaries and Wages Expense 32 Insurance 33 Depreciation Expense 13,500 667,620 667,620 A.Journal Entries B.T-Acts C.Trial Balance D. Balance SheetE. Retained Earnings +90% O Type here to search 2/10/2019 SDUNN MOD2 EXCEL.XSX Week 3 - Excel Sally Dunn File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Share Comments X Cut AutoSum . A Calibri General Fill Past Copy Format as. Cel Formatting Table Styles Insert Delete Fonmat 6848 Sort & Find & Filter, Select i Format Painter I A [ Merge & Center . $ % , 5 Clear Clipboard Font Number Editing ABC 18 Use the Check Figures from Part B here. Shoes for You, Inc. Balance Sheet March 31, 2016 19 20 Solution: Current Assets $318,230 Account receivable $70,170 Prpaid Insurance Total Assests $389,180 Building, Plant and equipment Building Display Equipment Less: Acc. Dep. Equipment Total Building, Plant and equipment Total Assets $240,000 1,200 $1,020 $240,180 $629,360 Liabilities and stockholders' Equity Current li C. Trial Balance D. Balance Sheet E. Retained Earnings F. Statement of Cash Flows G. Ratio + 100% O Type here to search 3:18 2/11/2019 SDUNN MOD2 EXCEL.XSX Week 3 - Excel Sally Dunn-X File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Share Comments AutoSum A Fill Clear X Cut General Past Copy Conditional Format as Cell Formatting Table Styles Insert Delete Fonmat A Sort & Find & Filter Select i I [ Merge & Center . $ % , 58 48 Format Painter Clipboard Number Cells Editing F21 A B C Total Building, Plant and equipment Total Assets $240,180 $629,360 35 36 37 38 39 Liabilities and stockholders' Equity Current Liabilities Account Payable salaries and Wages Payable $32,500 $1,500 $34,000 Bank Notes Payable Mortgage Note Payable Total Liabilities Shareholder's Equity Common Stock Retained Earnings Total shareholder's Equity Total Liabilities and Shareholders' Equity $192,000 $526,000 $100,000 $3,360 46 $103,360 629,360 Working Retained Earnings $40,600-$22,330-$13,500-$390-$1,020 52 C. Trial BalanceD. Balance Sheet E. Retained EarningsF. Statement of Cash FlowsG. Ratio... C + 100% O Type here to search 3:18 2/11/2019