Question

In: Finance

Joshua & White Technologies: December 31 Balance Sheets (Thousands of Dollars) Assets 2016 2015 Cash and...

Joshua & White Technologies: December 31 Balance Sheets
(Thousands of Dollars)
Assets 2016 2015
Cash and cash equivalents $21,000 $20,000
Short-term investments 3,759 3,240
Accounts Receivable 52,500 48,000
Inventories 84,000 56,000
  Total current assets $161,259 $127,240
  Net fixed assets 218,400 200,000
Total assets $379,659 $327,240
Liabilities and equity
Accounts payable $33,600 $32,000
Accruals 12,600 12,000
Notes payable 19,929 6,480
  Total current liabilities $66,129 $50,480
Long-term debt 67,662 58,320
  Total liabilities $133,791 $108,800
Common stock 183,793 178,440
Retained Earnings 62,075 40,000
  Total common equity $245,868 $218,440
Total liabilities and equity $379,659 $327,240
Joshua & White Technologies December 31 Income Statements
(Thousands of Dollars)
2016 2015
Sales $420,000 $400,000
COGS except excluding depr. and amort. 300,000 298,000
Depreciation and Amortization 19,660 18,000
Other operating expenses 27,600 22,000
  EBIT $72,740 $62,000
Interest Expense 5,740 4,460
  EBT $67,000 $57,540
Taxes (40%) 26,800 23,016
  Net Income $40,200 $34,524
Common dividends $18,125 $17,262
Addition to retained earnings $22,075 $17,262
Other Data 2016 2015
Year-end Stock Price $90.00 $96.00
# of shares (Thousands) 4,052 4,000
Lease payment (Thousands of Dollars) $20,000 $20,000
Sinking fund payment (Thousands of Dollars) $5,000 $5,000
e.  Perform a common size analysis. What has happened to the composition
     (that is, percentage in each category) of assets and liabilities?
Common Size Balance Sheets
Assets 2016 2015
Cash and cash equivalents
Short-term investments
Accounts Receivable
Inventories
  Total current assets
  Net fixed assets
Total assets
Liabilities and equity 2016 2015
Accounts payable
Accruals
Notes payable
  Total current liabilities
Long-term debt
  Total liabilities
Common stock
Retained Earnings
  Total common equity
Total liabilities and equity
Common Size Income Statements 2016 2015
Sales
COGS except excluding depr. and amort.
Depreciation and Amortization
Other operating expenses
  EBIT
Interest Expense
  EBT
Taxes (40%)
  Net Income

Solutions

Expert Solution

Joshua & White Technologies: December 31 Balance Sheets
(Thousands of Dollars)
% %
Assets 2016 2015
Cash and cash equivalents 21000 5.53% 20000 6.11%
Short-term investments 3,759 0.99% 3,240 0.99%
Accounts Receivable 52,500 13.83% 48,000 14.67%
Inventories 84,000 22.13% 56,000 17.11%
  Total current assets 161259 42.47% 127240 38.88%
  Net fixed assets 2,18,400 57.53% 2,00,000 61.12%
Total assets 379659 100.00% 327240 100.00%
Liabilities and equity
Accounts payable 33600 8.85% 32000 9.78%
Accruals 12,600 3.32% 12,000 3.67%
Notes payable 19,929 5.25% 6,480 1.98%
  Total current liabilities 66129 17.42% 50480 15.43%
Long-term debt 67,662 17.82% 58,320 17.82%
  Total liabilities 133791 35.24% 108800 33.25%
Common stock 1,83,793 48.41% 1,78,440 54.53%
Retained Earnings 62,075 16.35% 40,000 12.22%
  Total common equity 245868 64.76% 218440 66.75%
Total liabilities and equity 379659 100.00% 327240 100.00%
ANALYSIS:
*The % of current assets to total assets has gone up in 2016 by nearly 4% points.
*Of the current assets the % of inventory has gone up by more than 5% in 2016
*The total current liabilities has gone up by 2%, with the major increase in notes payable.
*There is an increase of 2% in total liabilities.
*Within equity, retained earnings composition has increased by more than 4%
Joshua & White Technologies December 31 Income Statements
(Thousands of Dollars)
2016 % 2015 %
Sales 420000 100.00% 400000 100.00%
COGS except excluding depr. and amort. 3,00,000 71.43% 2,98,000 74.50%
Depreciation and Amortization 19,660 4.68% 18,000 4.50%
Other operating expenses 27,600 6.57% 22,000 5.50%
  EBIT 72740 17.32% 62000 15.50%
Interest Expense 5,740 1.37% 4,460 1.12%
  EBT 67000 15.95% 57540 14.39%
Taxes (40%) 26,800 6.38% 23,016 5.75%
  Net Income 40200 9.57% 34524 8.63%
Common dividends 18125 4.32% 17262 4.32%
Addition to retained earnings 22075 5.26% 17262 4.32%
Other Data 2016 2015
Year-end Stock Price $90.00 $96.00
# of shares (Thousands) 4,052 4,000
Lease payment (Thousands of Dollars) $20,000 $20,000
Sinking fund payment (Thousands of Dollars) $5,000 $5,000
ANALYSIS:
The NI % has increased by about 1% only.
Though COGS has decreased in %, the operating expenses have gone up.

Related Solutions

Joshua & White Technologies: December 31 Balance Sheets (Thousands of Dollars) Assets 2016 2015 Cash and...
Joshua & White Technologies: December 31 Balance Sheets (Thousands of Dollars) Assets 2016 2015 Cash and cash equivalents $21,000 $20,000 Short-term investments 3,759 3,240 Accounts Receivable 52,500 48,000 Inventories 84,000 56,000 Total current assets $161,259 $127,240 Net fixed assets 218,400 200,000 Total assets $379,659 $327,240 Liabilities and equity Accounts payable $33,600 $32,000 Accruals 12,600 12,000 Notes payable 19,929 6,480 Total current liabilities $66,129 $50,480 Long-term debt 67,662 58,320 Total liabilities $133,791 $108,800 Common stock 183,793 178,440 Retained Earnings 62,075 40,000...
Joshua & White Technologies: December 31 Balance Sheets (Thousands of Dollars) Assets 2016 2015 Cash and...
Joshua & White Technologies: December 31 Balance Sheets (Thousands of Dollars) Assets 2016 2015 Cash and cash equivalents $21,000 $20,000 Short-term investments 3,759 3,240 Accounts Receivable 52,500 48,000 Inventories 84,000 56,000   Total current assets $161,259 $127,240   Net fixed assets 218,400 200,000 Total assets $379,659 $327,240 Liabilities and equity Accounts payable $33,600 $32,000 Accruals 12,600 12,000 Notes payable 19,929 6,480   Total current liabilities $66,129 $50,480 Long-term debt 67,662 58,320   Total liabilities $133,791 $108,800 Common stock 183,793 178,440 Retained Earnings 62,075 40,000...
Joshua & White Technology: December 31 Balance Sheets (Thousands of Dollars) 2019 2018 Assets Cash $...
Joshua & White Technology: December 31 Balance Sheets (Thousands of Dollars) 2019 2018 Assets Cash $ 21,000 $ 20,000 Short-term investments       3,759       3,240 Accounts receivable     52,500     48,000 Inventories     84,000     56,000 Total current assets $161,259 $127,240 Net fixed assets 223,097 200,000 Total assets $384,356 $327,240 Liabilities and Equity Accounts payable $ 33,600 $ 32,000 Accruals     12,600     12,000 Notes payable     19,929       6,480 Total current liabilities $ 66,129 $ 50,480 Long-term debt    ...
ARDUOUS COMPANY Comparative Balance Sheets December 31, 2016 and 2015 ($ in millions) 2016 2015   Assets...
ARDUOUS COMPANY Comparative Balance Sheets December 31, 2016 and 2015 ($ in millions) 2016 2015   Assets   Cash $ 116    $ 81      Accounts receivable 190    194      Investment revenue receivable 6    4      Inventory 205    200      Prepaid insurance 4    8      Long-term investment 156    125      Land 196    150      Buildings and equipment 412    400          Less: Accumulated depreciation (97) (120)   Patent 30    32    $ 1,218    $ 1,074...
Build a Model 26-11-2018 Chapter: 3 Problem: 15 Joshua & White Technologies: December 31 Balance Sheets...
Build a Model 26-11-2018 Chapter: 3 Problem: 15 Joshua & White Technologies: December 31 Balance Sheets (Thousands of Dollars) Assets 2019 2018 Cash and cash equivalents $21,000 $20,000 Short-term investments 3,759 3,240 Accounts Receivable 52,500 48,000 Inventories 84,000 56,000 Total current assets $1,61,259 $1,27,240 Net fixed assets 2,23,097 2,00,000 Total assets $3,84,356 $3,27,240 Liabilities and equity Accounts payable $33,600 $32,000 Accruals 12,600 12,000 Notes payable 19,929 6,480 Total current liabilities $66,129 $50,480 Long-term debt 67,662 58,320 Total liabilities $1,33,791 $1,08,800...
CONSOLIDATED BALANCE SHEET (millions of dollars) 2016 2015 Assets 2016 2015 Current assets 2016 2015 Cash...
CONSOLIDATED BALANCE SHEET (millions of dollars) 2016 2015 Assets 2016 2015 Current assets 2016 2015 Cash and cash equivalents 3,657 3,705 Notes and accounts receivable 21,394 19,875 Inventories: Crude oil, products and merchandise 10,877 12,037 Materials and supplies 4,203 4,208 Other current assets 1,285 2,798      Total current assets 41,416 42,623 Crude oil, products and merchandise inventories are carried at the lower of current market value or cost (generally determined under the last-in, first-out method – LIFO). Inventory costs include...
Simon Company's year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 32,777...
Simon Company's year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 32,777 $ 37,176 $ 38,353 Accounts receivable, net 93,117 65,721 51,648 Merchandise inventory 118,260 87,723 55,011 Prepaid expenses 10,346 9,958 4,304 Plant assets, net 295,546 273,600 238,084 Total assets $ 550,046 $ 474,178 $ 387,400 Liabilities and Equity Accounts payable $ 136,961 $ 80,937 $ 50,625 Long-term notes payable secured by mortgages on plant assets 102,375 109,061 83,903 Common stock, $10 par value 163,500 163,500...
Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 31,800...
Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 31,800 $ 35,625 $ 37,800 Accounts receivable, net 89,500 62,500 50,200 Merchandise inventory 112,500 82,500 54,000 Prepaid expenses 10,700 9,375 5,000 Plant assets, net 278,500 255,000 230,500 Total assets $ 523,000 $ 445,000 $ 377,500 Liabilities and Equity Accounts payable $ 129,900 $ 75,250 $ 51,250 Long-term notes payable secured by mortgages on plant assets 98,500 101,500 83,500 Common stock, $10 par value 163,500 163,500...
Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 34,308...
Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 34,308 $ 38,923 $ 40,958 Accounts receivable, net 96,509 66,739 54,060 Merchandise inventory 126,245 92,737 58,155 Prepaid expenses 11,048 10,114 4,735 Plant assets, net 301,972 282,937 259,992 Total assets $ 570,082 $ 491,450 $ 417,900 Liabilities and Equity Accounts payable $ 139,111 $ 83,886 $ 56,266 Long-term notes payable secured by mortgages on plant assets 108,247 115,294 91,432 Common stock, $10 par value 162,500 162,500...
imon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 31,800...
imon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 31,800 $ 35,625 $ 37,800 Accounts receivable, net 89,500 62,500 50,200 Merchandise inventory 112,500 82,500 54,000 Prepaid expenses 10,700 9,375 5,000 Plant assets, net 278,500 255,000 230,500 Total assets $ 523,000 $ 445,000 $ 377,500 Liabilities and Equity Accounts payable $ 129,900 $ 75,250 $ 51,250 Long-term notes payable secured by mortgages on plant assets 98,500 101,500 83,500 Common stock, $10 par value 163,500 163,500...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT