File Home Insert Draw Page Layout Formulas Data Review Arial 11 A A SEE 20 - A = = = = = = Paste B I J , P X Cut [ Copy $ Format Painter Clipboard . X Font Alignme 173 fx D E 2 Joshua & White Technologies: December 31 Balance Sheets 3 (Thousands of Dollars) 5 Assets 2016 2015 6 Cash and cash equivalents $21,000 $20,000 7 Short-term investments 3,759 3,240 8 Accounts Receivable 52,500 48,000 9 Inventories 8 4.000 56,000 10 Total current assets $161.259 $127.240 11 Net fixed assets 218,400 200,000 12 Total assets $379.659 $327 240 13 14 Liabilities and equity 15 Accounts payable $33,600 $32,000 16 Accruals 12,600 12.000 17 Notes payable 19,929 6,480 18 Total current liabilities $66,129 $50,480 19 Long-term debt 67,662 58,320 20 Total liabilities $133,791 $108.800 21 Common stock 183,793 178,440 22 Retained Earnings 62.075 40,000 23 Total common equity $245,868 $218,440 24 Total liabilities and equity $379,659 $327.240 25 26 Joshua & White Technologies December 31 Income Statements 27 (Thousands of Dollars) 2016 2015 29 Sales $420,000 $400,000 30 COGS except excluding depr. and amo 300,000 298,000 Assignment 2 28 Arial du Copy Format Painter Clipboard B.I UB MA aste Font X -73 X fx A 183,793 178,440 21 Common stock 62,075 40,000 22 Retained Earnings 23 Total common equity $245,868 $218,440 24 Total liabilities and equity $379.659 $327 240 25 26 Joshua & White Technologies December 31 Income Statements 27 (Thousands of Dollars) 2016 2015 29 Sales $420,000 $400,000 30 COGS except excluding depr. and amo 300,000 298,000 31 Depreciation and Amortization 19,660 18,000 32 Other operating expenses 27,600 22.000 33 EBIT $72,740 $62,000 34 Interest Expense 5,740 4,460 35 $67,000 $57,540 36 Taxes (40%) 26,800 23,016 37 Net Income $40.200 $34.524 38 39 Common dividends $18.125 $17.262 40 Addition to retained earnings $22.075 $17.262 42 Other Data 2016 2015 43 Year-end Stock Price $90.00 44 # of shares (Thousands) $96.00 4,052 45 Lease payment (Thousands of Dollars) 4,000 46 Sinking fund payment (Thousands of D $20,000 $20,000 $5,000 47 $5,000 48 Ratio Analysis 49 Liquidity Ratios 2016 2015 Industry Avg 50 Current Ratio 2.44 Assignment 2 2.52 2.58 Arial 11 AA == A & Cut Copy ~ Paste Format Painter Clipboard B.I U AE Font Alignme J73 2016 Base 2015 A B C 140 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 Accruals 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 Base 2015 2016 Base 2015 164 Percent Change Income Statements 165 Sales 166 COGS except excluding depr. and amort. 167 Depreciation and Amortization 168 Other operating expenses 169 EBIT Assignment 2 @ Type here to search Paste LG Copy Format Painter BIU Alignm Font Clipboard 2016 Base 2015 373 X fix 150 151 Liabilities and equity 152 Accounts payable 153 Accruals 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 168 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 2016 Base 2015 177 179 Assignment 2 Type here to search
