1. Business
  2. Finance
  3. need help filling in all yellow blocks thank you in...

Question: need help filling in all yellow blocks thank you in...

Question details

Need Help filling in all yellow blocks. Thank you in advance!

2 Joshua & White Technologies: December 31 Balance Sheets 3 Thousands of Dollars) 2016 21,000 3,759 52,500 Assets 6 Cash and cash equivalents Short-term investments 8 Accounts Receivable g Inventories 10 Total current assets 11 Net fixed assets 12 Total assets 2015 20,000 3,240 48,000 84000 56.000 $161,259 $127,240 218400 200,000 $379,659 $327 240 4 Liabilities and equity 15 Accounts payable 16 Accruals 17 Notes payable 18 Total current liabilities 19 Long-term debt 20 Total liabilities 21 Common stock 22 Retained Eamings 23 Total common equity 24 Total liabilities and equity 25 26 Joshua & White Technologies December 31 Income Statements 27 (Thousands of Dollars) 28 29 Sales 30 COGS except excluding depr. and amort.300,000 298,000 31 Depreciation and Amortization 32 Other operating expenses 33 EBIT 34 Interest Expense 35 EBT 36 Taxes (40%) 37 Net Incon 38 39 Common dividends 40 Addition to retained earnings $33,600$32.000 12,000 12,600 $66,129$50.480 6766258320 $133,791 $108,800 183,793 178.440 $245,868 $218,440 $379.659 $327.240 2015 $420,000 $400,000 2016 19,660 27,600 18,000 $72,740 $62.000 5,740 $67,000 $57,540 26,800 23,016 $40 200 $34524 $18,125 $17,262 $22,075 $17.262 42 Other Data 43 Year-end Stock Price 44 # of shares ( 1 housands) 45 Lease payment (Thousands of Dollars) 46 Sinking fund payment (Thousands of Do 2016 $90.00 4,052 2015 $96.00 4,000 0.000 $20,000 $5,000 $%2 $5,000

47 48 Ratio Analysis 49 Liquidity Ratios 50 Current Ratio 51Quick Ratio 52 Asset Management Ratios 53 Inventory Turnover Total COGSInwentories) 54 Days Sales Outstanding 55 Fixed Assets Turnover 56 Total Assets Turnover 57 Debt Management Ratios 58 Debt Ratio (Total debt-to-assets) 59 Liabilities-to-assets ratio 6Times-interest-earned ratio 61 EBITDA coverage ratio 62 Profitability Ratios 63 Profit Margin 64BasSiC Eaming Power 65Return on Assets 66 Return on Equity 67 Market Value Ratios 68 Earnings per share 69 Price-to-earnings ratio 70 Cash flow per share 71 Price-to-cash flow ratio 72 Book Value per share 73 Market-to-book ratio 74 75a. Has Joshua & Whites liquidity position improved or worsened? Explain. 76 2016 2015 Industry Avg 2.58 1.53 7.69 47.45 2.04 1.23 20.0% 32.1% 15.33 4.18 8.86% 19.48% 10.93% 16.10% NA 10.65 NA 7.11 NA 1.72 78 79 80 b. Has Joshua & Whites ability to manage its assets improved or worsened? Explain. 82 83 84 85 C. How has Joshua & Whites profitability changed during the last year? 86 87 88 d. Perform an extended Du Pont analysis for Joshua & White for 2008 and 2009 89 90 2016 91 2015 92 93 94 95 ROE PM X TA Tumover x Equity Multiplier

94 95 96 97 e. Perform a common size analysis. What has happened to the composition 98 (that is, percentage in each category) of assets and liabilites? 100 Common Size Balance Sheets 101 Assets 102 Cash and cash equivalents 103 Short-term investments 104 Accounts Receivable 105 Irwentories 106 Total current assets 107 Net fixed assets 108 Total assets 109 110 Liabilities and equity 111 Accounts payable 1 12 Accruals 113 Notes payable 14 Total current liabilities 115 Long-term debt 16 Total liabilities 117 Common stock 118 Retained Earnings 119 Total common equity 120 Total liabilities and equity 121 122 Common Size Income Statements 123 Sales 124 COGS except excluding depr. and amort. 125 Depreciation and Amortization 126 Other operating expenses 127 EBIT 128 Interest Expense 129 EBT 130 Taxes (40%) 131 Net Income 132 133 134 135 2016 2015 2016 2015 2016 2015

135 136 137f. Perform a percent change analysis. What does this tell you about the change in profitability 138 and asset utilization? 139 10 Percent Change Balance Sheets 141 Assets 142 Cash and cash equivalents 143 Short-term investments 144 Accounts Receivable 145 Inventories 146 Total current assets 147 Net fixed assets 148 Total assets 149 150 151 Liabilities and equity 152 Accounts payable 153 Accruas 154 Notes payable 155 Total current liabilities 156 Long-term debt 157 Total liabilities 158 Common stock 159 Retained Earnings 160 Total common equity 161 Total liabilities and equity 162 163 164 Percent Change Income Statements 165 Sales 166 COGS except excluding depr. and amort. 167 Depreciation and Amortization 168 Other operating expenses 169 EBIT 170 Interest Expense 171 EBT 172 Taxes (40%) 173 Net Income 174 175 176 Base 2015 2016 Base 2015 2016 Base 2015 2016 178 179

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution