Please fill in yellow boxes and answer ratios with the formulas for each

Clipboard UPDATES AVAILABLE Font Alignment Updates for Office are 'ready to be installed. but first we need to close SQme apps. Number Update now - -Insert woage Layout - Formulas Data MAXIMIZE YOUR SUBSCRIPTION VALUE Onlyn of the 6 accounts included inyour Migosoft 365 subscription is active. '+ Activate Accounts 9 A 8 9 10 11 12 13 14 15 16 17 18 19, 20 21 22 23 24 25 26 27 28 29 30 31 32, 33 34 ready Sales B c D L M N o -iAriaV. Painter AILABLE Bombadil Boots - Excel Review View Developer Wrap Text Alignment Font U datesfor Bombadil Boots Comparative Balanc Sheets 2010 Assets to i led first e n e are re OUR SUBSCRIPTIONVALUE Onlynnfthe 6 accountsincludecfin your Microsoft 365 subscription isactiv >009 1,300 2,500 5 ooo 8,800 20,000 (1 ,000) 19 ooo 27 800 2,200 900 800 3,900 8,900 12,800 10,000 5,000 15,000 27 800 Y"' Return on Equity on Assets Debt:Equityr Break Even Sales Break Even Units;, Units to sell for Desired Profit EBT Sales Required for Desired Profit EB WACC c CUrtnt Ratio Quick Ratio Inventoryiurns Gross Profit Margin -Eamings Per Share - Payout Ratio Average Collection Period DSO Interest Coverage Debt Coverage Fixed Payments Coverage Net Profit Margin Return on Equity Assets Debt: Equity D Current assets Cash Accounts receivable Inventory Total- Fixed assets Plant and equipment Accumulated Amortization Net plant and equipment Total assets Liabilities and owners' equity Current liabilities Accounts payable Notes payable Current Portion of LTD Total Long-term debt Total Liabilities Owners' equity Common stock Retained earnings Total Total liabilities and owners' equity 2,502 3,000 6 ooo 11 ,502 20,000 11 502 3,500 1 ,ooo 600 5,100 8,400 13,500 10,000 10 ooo $ 23 500 Current Assets) Current Liabilities Current Assets-invento Current Liabilities cos A Invento Net Sales-CoS Net Sales EAT _# of Shares Dividends Declared EAT counts Receivable Avera e dail credit sales EBIT Interest EBIT + Current rtion of LTD Interest + Current rtion of LTD IT + Current onion Of LTD + Leases rest Current; rtion of LTD + Leases Balance Sheets Accessibility: Bombadil Boote 2010 Income statement Income Statement $ 55,000 30 ooo '5,000 2,400 1 ooo (22,900) S2,ooo 1,000 522 10,000 shares' $ 15,000 30.00 82% 120% Ratios & Breakeven EAT Net Sales EAT Shareholdeds E uit EAT Total Assets Total Debt Ratios & Breakeven Cost of Sales Gross Profit Selling and Admin RenVLease Amortization EBIT Interest paid EBT Taxes EAT Dividends Change in Retained earnings pther Information Ciedit Sales Selling & Admin includes eases ot Units Sold Estimated Share price Outstanding Shares Desired prom (EBT)' Income -tax Rate: Gross Piont pei:unit: Unit Coit Interest Rate ont_TO Desired rate of return by shareholder 6 7 8 9 82 63 54 , 56 66 57 Incorpe Statefnent Balance Sheets EAT Shareholder'S E uit EAT -Total Assets tal Debt Total E ui Fixed Costs Gross Profit Mar in Fixed Costs r unit Gross Profit Fixed Costs + Profit Unit Cost Gross Mar in