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
f.  Perform a percent change analysis.  What does this tell you about the change in profitability
     and asset utilization?
Percent Change Balance Sheets Base
Assets 2016 2015
Cash and cash equivalents
Short-term investments
Accounts Receivable
Inventories
  Total current assets
  Net fixed assets
Total assets
Base
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
Base
Percent Change 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 % Change
Cash and cash equivalents $21,000 $20,000 5.00%
Short-term investments 3,759 3,240 16.02%
Accounts Receivable 52,500 48,000 9.38%
Inventories 84,000 56,000 50.00%
  Total current assets $161,259 $127,240 26.74%
  Net fixed assets 218,400 200,000 9.20%
Total assets $379,659 $327,240 16.02%
Liabilities and equity
Accounts payable $33,600 $32,000 5.00%
Accruals 12,600 12,000 5.00%
Notes payable 19,929 6,480 207.55%
  Total current liabilities $66,129 $50,480 31.00%
Long-term debt 67,662 58,320 16.02%
  Total liabilities $133,791 $108,800 22.97%
Common stock 183,793 178,440 3.00%
Retained Earnings 62,075 40,000 55.19%
  Total common equity $245,868 $218,440 12.56%
Total liabilities and equity $379,659 $327,240 16.02%
Joshua & White Technologies December 31 Income Statements
(Thousands of Dollars)
2016 2015 0.05%
Sales $420,000 $400,000 5.00%
COGS except excluding depr. and amort. 300,000 298,000 0.67%
Depreciation and Amortization 19,660 18,000 9.22%
Other operating expenses 27,600 22,000 25.45%
  EBIT $72,740 $62,000 17.32%
Interest Expense 5,740 4,460 28.70%
  EBT $67,000 $57,540 16.44%
Taxes (40%) 26,800 23,016 16.44%
  Net Income $40,200 $34,524 16.44%

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