AutoSave ON Home Insert Draw View Formulas Page Layout Data Review Tell me Arial 11 ~ A = Wrap Paste BIU V A v JUL TH IM Merge D57 . fx 45.63 C D 102 e. Perform a common size analysis. What has happened to the composition 103 (that is, percentage in each category) of assets and liabilities? 104 105 Common Size Balance Sheets 106 Assets 2019 2018 107 Cash and cash equivalents 108 Short-term investments 109 Accounts Receivable 110 Inventories 111 Total current assets 112 Net fixed assets 113 Total assets 114 115 Liabilities and equity 2019 2018 116 Accounts payable 117 Accruals 118 Notes payable 119 Total current liabilities 120 Long-term debt 121 Total liabilities 122 Common stock 123 Retained Earnings 124 Total common equity 126 Total liabilities and equity 126 127 Common Size Income Statements 2019 2018 128 Sales 129 COGS except excluding depr. and amort. 130 Depreciation and Amortization 131 Other operating expenses 132 EBIT 133 Interest Expense 134 EBT 135 Taxes (25%) 136 Net Income 137 138 139 140 Build a Model + Ready Arial v Av E Paste BIU X Vfx 45.63 D57 F D E B 2019 $90.00 4,052 $20,000 $5,000 2018 $96.00 4,000 $20,000 $5,000 2019 2018 Industry Avg 2.44 1.17 2.52 1.41 2.58 1.53 0.71 45.63 1.88 1.09 0.75 43.80 2.00 1.22 7.69 47.45 2.04 1.23 45 Other Data 46 Year-end Stock Price 47 # of shares (Thousands) 48 Lease payment (Thousands of Dollars) 49 Sinking fund payment (Thousands of Dollar 50 51 Ratio Analysis 52 Liquidity Ratios 53 Current Ratio 54 Quick Ratio 55 Asset Management Ratios 56 Inventory Turnover (Total COGS/Invent 57 Days Sales Outstanding 5B Fixed Assets Turnover 59 Total Assets Turnover 60 Debt Management Ratios 61 Debt Ratio (Total debt-to-assets) 62 Liabilities-to-assets ratio Times-interest-earned ratio 64 EBITDA coverage ratio 65 Profitability Ratios 66 Profit Margin 67 Basic Earning Power 6B Return on Assets 69 Return on Equity 70 Market Value Ratios 71 Earnings per share 72 Price-to-earrings ratio 73 74 75 76 77 100.0% 34.8% 12.67 16.10 100.0% 33.3% 13.90 16.00 20.0% 32.1% 15.33 4.18 11.96% 18.93% 13.07% 20.05% 8.63% 18.95% 10.55% 15.80% 8.86% 19.48% 10.93% 16.10% Cash flow per share Price-to-cash flow ratio Book Value per share Market-to-book ratio $12.40 7.26 $17.25 5.22 $61.84 1.46 $8.63 11.12 $13.13 7.31 $54.61 1.76 NA 10.65 NA 7.11 NA 1.72 78. Has Joshua & White's liquidity position improved or worsened? Explain. 79 80 quidity has it worsened compared to industry however nothing to worryas it is still more than the deal. In ca 81 of current should be o 12 to 2 and in case of quick should ideally be 1. 82 6. Has Joshua & White's abity to manage its assets improved or worsened? Explain. Build a Model Ready B D E F G H 8 Assets 2019 2018 9 Cash and cash equivalents $21,000 $20,000 10 Short-term investments 3,759 3,240 11 Accounts Receivable 52,500 48,000 12 Inventories 84,000 56.000 13 Total current assets $161.259 $127,240 14 Net foxed assets 223,097 200.000 15 Total assets $384.356 $327 240 16 17 Liabilities and equity 18 Accounts payable $33,600 $32,000 19 Accruals 12,600 12,000 20 Notes payable 19.929 6,480 21 Total current liabilities $66,129 $50,480 22 Long-term debt 67,662 58,320 23 Total liabilities $133,791 $108,800 24 Common stock 178,440 178,440 25 Retained Earnings 72.125 40.000 26 Total common equity $250,565 $218.440 27 Total liabilities and equity $384256 $327.240 28 29 Joshua & White Technologies December 31 Income Statements 30 (Thousands of Dollars) 31 2019 2018 32 Sales $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,600 22.000 36 $72,740 $62,000 37 Interest Expense 5.740 4.460 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 EBIT 45 Other Data 46 Year-end Stock Price 47 of shares. (Thousands 2019 $90.00 2018 $96.00 A AED Arial a. Av Paste BI - B Xvfx 45.63 F 57 B D C A E $161,259 $127,240 Total current assets Net fixed assets 223,097 200.000 $384 356 $327 240 5 Total assets 6 7 Liabilities and equity 8 Accounts payable $33,600 $32,000 19 Accruals 12,600 12,000 20 Notes payable 19.929 6.480 21 Total current liabilities $66,129 $50,480 22 Long-term debt 67,662 58.320 23 Total liabilities $133,791 $108,800 24 Common stock 178,440 178,440 25 Retained Earnings 72 125 40.000 26 Total common equity $250,565 $218.440 27 Total liabilities and equity $384356 $327 240 28 29 Joshua & White Technologies December 31 Income Statements 30 (Thousands of Dollars) 31 2019 2018 32 Sales $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,600 22.000 36 EBIT $72,740 $62,000 37 Interest Expense 5.740 4.460 36 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 45 Other Data 46 Year-end Stock Price 47 # of shares (Thousands) 48 Lease payment (Thousands of Dollars) 49 Sinking fund payment (Thousands of Dollai 50 51 Ratio Analysis 52 Liomidit.Ratios 2019 $90.00 4,052 $20,000 $5,000 2018 $96.00 4,000 $20,000 $5,000 2019 2018 Industry Avg Build a Model + Ready