AutoSave Data Review View Tell me Home Insert Formulas Draw Page Layout EEE General X Wrap Text Arial v 11 * ' ' A $% Merge & Center Paste IV B G H 2013 E78 X A C D U Porno Porno TOUW Ven you 94 ROE- PM XTA Tumover X Equity Mutter 95 2010 1.53 20.05% 11.90% 1.09 96 2018 15.80% 8.63% 1.22 1.50 97 50 90 100 101 102 e. Perform a common se analysis. What has happened to the composition 103 (that is percentage in each category of assets and abilities? 104 108 Common Size Balance Sheets 106 Assets 107 Cash and cashes 100 Short-term investments 100 Accounts Receivable 110 inventores 111 Total current assets 112 Noted assets 113 Total 154 115 Liabilities and equity 2019 2018 116 Accounts payable 117 Accruals 116 Nepal 110 Total current times 120 Long-term det 121 Totalbes 122 common stock 123 Pared Earnings 124 Totalcomone 125 Totes and out 2010 2018 127 Common Size Income Statements 120 Sales 129 C005 except excluding dependant 199 Depreciation and more on 131 ter operating expenses 132 T Build a Model Ready 9 tv MacBook Pro esc BI U E A # 1 2 3 4 5 6 7 Paste 10 V ' BI V 114 av Av fx F B D 25 Retained Earnings E 26 Total common equity 72.125 40.000 27 Total liabilities and equity $250,565 $218.440 $384.356 28 $327 240 29 Joshua & White Technologies December 31 Income Statements 30 (Thousands of Dollars) 31 2019 2018 32 Sales $420,000 33 COGS except excluding depr. and amort. $400,000 300,000 298,000 34 Depreciation and Amortization 19,660 18,000 35 Other operating expenses 27.600 22.000 36 EBIT $72,740 $62,000 37 Interest Expense 5 740 4460 38 EBT $67,000 $57,540 39 Taxes (25%) 16.750 14.385 40 Net Income $50.250 $34.524 41 42 Common dividends $18,125 $17.262 43 Addition to retained earnings $32,125 $17.262 44 45 Other Data 2019 2018 46 Year-end Stock Price $90.00 $96.00 47 # of shares (Thousands) 4,052 4,000 48 Lease payment (Thousands of Dollars) $20,000 $20,000 49 Sinking fund payment (Thousands of Dollar $5,000 $5,000 50 51 Ratio Analysis 2018 Industry Avg 52 Liquidity Ratios Current Ratio 54 Quick Ratio 56 Asset Management Ratios 56 Inventory Turnover (Total COGS/inventories) 57 Days Sales Outstanding Fixed Assets Turnover Total RON 2019 53 2.58 1.53 58 50 7.69 47.45 2.04 Build a Model PWeek 2 Chapte Data Home View Review Tell me AutoSave OF BESU Insert Draw Page Layout Formulas Arial 12A A B A P 2 Wrap Text General Paste Merge & Center $ % A1 fx 'Bulld a Model D Cash and cash equivalents $21,000 $20,000 3.750 3.240 10 Short form investments 11 Accounts Receivable 52.500 48.000 12 Inventories 84.000 13 Total current assets $161.250 $127 240 14 Net fixed assets 223.097 200.000 15 Total assets $384.350 $327240 16 17 Liabilities and equity 18 Accounts payable $33.600 $32.000 10 Acer 12.600 12,000 20 Notes payable 5.489 21 Total current is 566,129 $50,480 22 Long-term debit 67.002 58.320 23 Total Babies $133,791 $108,800 24 Common stock 178,440 178,440 25 Retained Earrings 72.125 40.000 26 Totalcommon equity $250,565 $218.440 27 Total abies and equity $384356 $327240 28 20 Joshua & White Technologies December 31 Income Statements 30 Thousands of Dollars) 31 2019 2018 $420,000 $400.000 33 COGS except excluding depr. and amort 300,000 298,000 34 Depreciation and Amortization 19.660 18,000 35 Other operating expenses 27.000 22.000 30 EBIT $72.740 $62.000 37 Interest Expense 5.740 4.460 38 EBT $57.000 $57,540 30 Taxes (25% 16.750 14,385 40 Net Income $50259 41 42 Common dividends $18,125 $17,202 43 Addition to retained earnings $32,125 $17,262 44 45 Other Data 2019 2018 46 Year-end Stock Price 590.00 596.00 47 of shares (Thousands) 4052 4,000 4 and san Build a Model 10 MacBook