Question

In: Finance

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

    67,662

    58,320

Total liabilities

$133,791

$108,800

Common stock

178,440

178,440

Retained earnings

    72,125

    40,000

Total common equity

$250,565

$218,440

Total liabilities and equity

$384,356

$327,240

Income Statements (Millions of Dollars)

2019

2018

Sales

$420,000

$400,000

COGS excluding depreciation and amortization

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 (25%)

    16,750

    14,385

Net income

$ 50,250

$ 34,524

Common dividends

$ 18,125

$ 17,262

Additions to retained earnings

$ 32,125

$ 17,262

  1. Compute the following ratios for 2018 and 2019 and comment on any changes you see.
    1. Current ratio
    2. Inventory turnover
    3. Receivables turnover
    4. Total asset turnover
    5. Net profit margin
    6. Times interest earned
    7. ROE
    8. ROA
    9. Debt-equity ratio

Solutions

Expert Solution

a. Current Ratio of 2018 =Current Assets/Current Liabilities =127240/50480 =2.52
Current Ratio of 2019 =Current Assets/Current Liabilities =161259/66129 =2.44
Current Ratio has reduced showing that there is reduction in liquidity of firm, this is primarily due to increase in inventories.

b. Inventory Turnover of 2018 =(Cogs/Inventories) =298000/56000 =5.32
Inventory Turnover of 2019 =(Cogs/Inventories) =300000/84000=3.57
Inventory turnover ratio has decreased indicating lower operational efficiency and lower liquidity due to inventory.

c. Receivables Turnover of 2018 =Sales/Account Receivables =400000/32000=12.5
Receivables Turnover of 2019 =Sales/Account Receivables =420000/52500=9
Receivable turnover ratio has reduced meaning lower liquidity due to increase in account receivables.

d. Total Asset turnover of 2018=Sales/Total Assets =400000/327240 =1.22
Total Asset turnover of 2019=Sales/Total Assets =420000/384356 =1.09
Total asset turnover has reduced showing reduction in operational efficiency of the company


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 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...
ALLENDALE COMPANY Balance Sheets As of December 31 2019 2018 Assets Current assets Cash $ 40,000...
ALLENDALE COMPANY Balance Sheets As of December 31 2019 2018 Assets Current assets Cash $ 40,000 $ 36,000 Marketable securities 20,000 6,000 Accounts receivable (net) 54,000 46,000 Inventories 135,000 143,000 Prepaid items 25,000 10,000 Total current assets 274,000 241,000 Investments 27,000 20,000 Plant (net) 270,000 255,000 Land 29,000 24,000 Total assets $ 600,000 $ 540,000 Liabilities and Stockholders’ Equity Liabilities Current liabilities Notes payable $ 17,000 $ 6,000 Accounts payable 113,800 100,000 Salaries payable 21,000 15,000 Total current liabilities 151,800...
Balance Sheet as of December 31, 2018 (Thousands of Dollars) Cash $ 1,080 Accounts payable $...
Balance Sheet as of December 31, 2018 (Thousands of Dollars) Cash $ 1,080 Accounts payable $ 4,320 Receivables 6,480 Accruals 2,880 Inventories 9,000 Line of credit 0    Total current assets $16,560 Notes payable 2,100 Net fixed assets 12,600    Total current liabilities $ 9,300 Mortgage bonds 3,500 Common stock 3,500 Retained earnings 12,860    Total assets $29,160    Total liabilities and equity $29,160 Income Statement for January 1 - December 31, 2018 (Thousands of Dollars) Sales $36,000 Operating costs 32,440    Earnings before interest...
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...
PHAROAH COMPANY Balance Sheets December 31 (in thousands) 2022 2021 Current assets    Cash and cash equivalents...
PHAROAH COMPANY Balance Sheets December 31 (in thousands) 2022 2021 Current assets    Cash and cash equivalents $330 $360    Accounts receivable (net) 570 500    Inventory 640 570    Prepaid expenses 130 160      Total current assets 1,670 1,590 Property, plant, and equipment (net) 410 380 Investments 110 110 Intangibles and other assets 530 510      Total assets $2,720 $2,590 Current liabilities $920 $890 Long-term liabilities 660 560 Stockholders’ equity—common 1,140 1,140      Total liabilities and stockholders’ equity $2,720 $2,590 PHAROAH COMPANY Income Statements For the...
BETHESDA MINING COMPANY Balance Sheets as of December 31, 2018 and 2019 2018 2019 2018 2019...
BETHESDA MINING COMPANY Balance Sheets as of December 31, 2018 and 2019 2018 2019 2018 2019 Assets Liabilities and Owners’ Equity   Current assets   Current liabilities     Cash $ 42,646 $ 54,402      Accounts payable $ 191,422 $ 199,111     Accounts receivable 60,781 81,139      Notes payable 86,520 138,088     Inventory 127,265 193,375             Total $ 277,942 $ 337,199       Total $ 230,692 $ 328,916   Long-term debt $ 240,000 $ 176,750   Owners’ equity      Common stock and paid-in surplus $ 215,000 $ 215,000      Accumulated retained earnings 155,597 189,495...
Aires Corporation Comparative Balance Sheets December 31, 2020 and 2019 Assets 2020 2019 Change Cash $...
Aires Corporation Comparative Balance Sheets December 31, 2020 and 2019 Assets 2020 2019 Change Cash $ 21,000 $ 54,000 Accounts receivable (net) 421,000 480,000 Inventory 310,000 340,000 Prepaid expenses 17,000 15,000 Long Term Investments 70,000 80,000 Land 400,000 300,000 Equipment 1,730,000 1,590,000 Accumulated depreciation-equipment (610,000) (600,000) Patent 40,000 50,000 Total assets $2,399,000 $2,309,000 Liabilities Accounts payable $ 328,000 $ 335,000 Accrued liabilities 171,000 170,000 Income taxes payable 22,000 34,000 Bonds payable 410,000 700,000 Long-term note payable 130,000 0 Total liabilities...
Balance Sheet April 30 (in thousands of dollars) 2019 2018 2017 Assets:    Current assets $ 1,700...
Balance Sheet April 30 (in thousands of dollars) 2019 2018 2017 Assets:    Current assets $ 1,700 $1,120 $1,544    Plant and equipment (net) 8,110 7,830 5,404    Other assets   1,004    695    772    Total assets $10,814 $9,645 $7,720 Liabilities and Stockholders' Equity:    Current liabilities $   950 $  880 $  772    Long-term liabilities 2,023 1,591 1,544    Capital stock ($10 par) 4,600 4,600 3,000    Paid-in capital in excess of par 770 770 386    Retained earnings   2,471 1,804 2,018       Total liabilities and stockholders' equity $10,814 $9,645 $7,720 Income Statement...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT