Question

In: Finance

1. Selected financial information for Black Co. and for Blue Co. for 2017 and 2016 follow:...

1. Selected financial information for Black Co. and for Blue Co. for 2017 and 2016 follow: Black Co. Blue Co. 2017 2016 2017 2016 Net Income $65,000 $60,000 $25,000 $28,000 Income tax expense 18,200 17,000 5,000 5,500 Net sales 2,500,000 2,300,000 650,000 680,000 Total assets 500,000 490,000 200,000 210,000 Current assets 99,000 130,000 120,000 110,000 Operating assets 470,000 450,000 190,000 190,000 Operating liabilities 175,000 150,000 50,000 56,000 Weighted average shares Outstanding 85,000 85,000 75,000 75,000 Current liabilities 75,000 100,000 100,000 100,000 Total liabilities 350,000 350,000 75,000 74,000 Stockholder’s equity 150,000 140,000 115,000 136,000 Interest expense 5,000 6,000 1,500 1,000 Income before tax 83,200 77,000 30,000 33,500 Cash flow from operations 75,000 110,000 110,000 120,000 Cash paid for investments 74,000 100,000 70,000 60,000 Compute the following for both companies for 2017: a. Return on net operating assets. The effective tax rate for both companies is 37%. b. Net operating profit margin and net operating asset turnover. c. Return on equity. d. Financial leverage (FLEV) and spread. e. Are both companies using leverage effectively? Explain your answer. f. Compute basic earnings per share for both companies. g. Interpret the ROA versus ROE and EPS for both companies. h. Compute the current ratios. i. Compute times interest earned ratios. j. Compute free cash flow to total debt for both companies. k. Which firm would you invest in? Why?

Solutions

Expert Solution

Black Co. Blue Co.
2017 2016 2017 2016
Net Income        65,000        60,000        25,000        28,000
Income Tax Expense Q        18,200        17,000           5,000           5,500
Net Sales h 2,500,000 2,300,000      650,000      680,000
Total assets M      500,000      490,000      200,000      210,000
Current assets        99,000      130,000      120,000      110,000
Operating asset a      470,000      450,000      190,000      190,000
Operating liabilities b      175,000      150,000        50,000        56,000
Weighted averae shares o/s R        85,000        85,000        75,000        75,000
Current liabilities K        75,000      100,000      100,000      100,000
Total liabilities L      350,000      350,000        75,000        74,000
Stockholder's equity i      150,000      140,000      115,000      136,000
Interest expense c           5,000           6,000           1,500           1,000
Income before tax d        83,200        77,000        30,000        33,500
Cash flow from operations        75,000      110,000      110,000      120,000
Cash paid for investment        74,000      100,000        70,000        60,000
Solutions
Net Operating asset (g) a-b      295,000      300,000      140,000      134,000
EBIT (e ) c+d        88,200        83,000        31,500        34,500
EBIT after Tax (f) (e )*(1-0.37)        55,566        52,290        19,845        21,735
Return on net operating asset f/g 18.84% 17.43% 14.18% 16.22%
Net operating profit margin e/h 3.53% 3.61% 4.85% 5.07%
Net operating asset turnover h/g (Average balance)             8.40             4.74
Profit after tax (j) D-Q        65,000        60,000        25,000        28,000
Return on equity j / i 43.33% 42.86% 21.74% 20.59%
Total debt of the company (N) L-K      275,000      250,000       (25,000)       (26,000)
Total debt + Equity (O) N+i      425,000      390,000        90,000      110,000
Financial Leverage N/O 65% 64%                 -                   -   Blue Co. is debt free company and hence no financial Leverage
Interest expense after tax (P) (c)*(1-0.37)           3,150           3,780
Net Interest cost for the company P/N 1.15% 1.51% The Company is having net interest cost of 1.15% and the return on equity its generating is 43.33%. This shows the company is utilising its debt effectively, However the ROE of Blue Co. is lower and there is no debt, which symbolises blue co. should avail certain debt and increase their ROE.
Basic EPS J/R             0.76             0.71             0.33             0.37
Return on Asset (ROA) E/M 17.64% 16.94% 15.75% 16.43%
The return on Asset for Black co. is 17.64% whereas return on equity is 43.33% which is basically because the company is availing cheaper debt and generating return for company's shareholders. Whereas for Blue co. ROA is more than ROE which symbolises the company should avail some debt and generate return like Black Co.

Related Solutions

Black Co.                                Blue Co.         &
Black Co.                                Blue Co.                                                 2017                2016                 2017             2016 Net Income                           $65,000             $60,000           $25,000           $28,000 Income tax expense             18,200             17,000               5,000               5,500 Net sales                          2,500,000          2,300,000           650,000           680,000 Total assets                       500,000             490,000           200,000           210,000 Current assets                          99,000             130,000           120,000           110,000 Operating assets                 470,000             450,000           190,000           190,000 Operating liabilities           175,000             150,000           50,000           56,000 Weighted average shares             Outstanding                85,000             85,000           75,000           75,000 Current liabilities                 75,000             100,000           75,000           74,000 Total liabilities                   350,000            ...
The 2016 and 2017 financial statements of Ken’s Sportswear follow: Balance Sheet 2017 2016 Assets Cash...
The 2016 and 2017 financial statements of Ken’s Sportswear follow: Balance Sheet 2017 2016 Assets Cash $9,000 $7,000 Accounts receivable 12,000 9,000 Inventory 18,000 15,000 Property, plant, and equipment 60,000 50,000 Total assets $99,000 $81,000 Liabilities and Shareholders’ Equity Accounts payable $16,500 $12,000 Notes payable 46,000 40,000 Common stock 25,000 25,000 Retained earnings 11,500 4,000 Total liabilities and equity $99,000 $81,000 Income Statement Sales (all on credit) $72,000 Less: Cost of goods sold 30,000 Gross profit $42,000 Operating expenses 12,000...
Black Co. acquired 100% of Blue, Inc. on January 1, 2020. On that date, Blue had...
Black Co. acquired 100% of Blue, Inc. on January 1, 2020. On that date, Blue had land with a book value of $38,000 and a fair value of $49,000. Also, on the date of acquisition, Blue had a building with a book value of $250,000 and a fair value of $460,000. Blue had equipment with a book value of $340,000 and a fair value of $280,000. The building had a 10-year remaining useful life and the equipment had a 5-year...
The following is information for Palmer Co. 2017 2016 2015 Cost of goods sold $ 563,825...
The following is information for Palmer Co. 2017 2016 2015 Cost of goods sold $ 563,825 $ 346,650 $ 311,300 Ending inventory 104,400 94,750 99,500    Use the above information to compute inventory turnover for 2017 and 2016, and its days' sales in inventory at December 31, 2017 and 2016.
Lansing Company’s 2017 income statement and selected balance sheet data (for current assets and current liabilities) at December 31, 2016 and 2017, follow.
Lansing Company’s 2017 income statement and selected balance sheet data (for current assets and current liabilities) at December 31, 2016 and 2017, follow. LANSING COMPANYIncome StatementFor Year Ended December 31, 2017 Sales revenue $ 148,200 Expenses     Cost of goods sold   59,000 Depreciation expense   20,500 Salaries expense   35,000 Rent expense   10,700 Insurance expense   5,500 Interest expense   5,300 Utilities expense   4,500 Net income $ 7,700      LANSING COMPANYSelected Balance Sheet Accounts At...
Condensed data from the comparative statement of financial position of Greencastle Inc. follow: 2018 2017 2016...
Condensed data from the comparative statement of financial position of Greencastle Inc. follow: 2018 2017 2016 Current assets $ 118,000 $ 112,000 $ 104,000 Non-current assets 400,000 328,000 298,000 Current liabilities 110,000 99,000 95,000 Non-current liabilities 91,000 110,000 121,000 Common shares 110,000 101,000 101,000 Retained earnings 207,000 130,000 85,000 Part 1 Using horizontal analysis, calculate the percentage of a base-year amount, using 2016 as the base year. (Round answers to 1 decimal place, e.g. 15.2%.) GREENCASTLE INC. Horizontal Analysis of...
The balance sheet data of Pronghorn Company at the end of 2017 and 2016 follow. 2017...
The balance sheet data of Pronghorn Company at the end of 2017 and 2016 follow. 2017 2016 Cash $29,000 $35,400 Accounts receivable (net) 55,400 44,500 Inventory 64,300 44,600 Prepaid expenses 15,200 25,000 Equipment 90,800 74,800 Accumulated depreciation—equipment (18,100 ) (8,800 ) Land 79,900 39,600 $316,500 $255,100 Accounts payable $63,600 $49,000 Accrued expenses 15,000 18,000 Notes payable—bank, long-term –0– 22,800 Bonds payable 30,200 –0– Common stock, $10 par 200,400 160,100 Retained earnings 7,300 5,200 $316,500 $255,100 Land was acquired for $40,300...
The balance sheet data of Ivanhoe Company at the end of 2017 and 2016 follow. 2017...
The balance sheet data of Ivanhoe Company at the end of 2017 and 2016 follow. 2017 2016 Cash $29,000 $34,900 Accounts receivable (net) 55,200 44,900 Inventory 64,900 44,600 Prepaid expenses 15,100 24,900 Equipment 90,100 75,600 Accumulated depreciation—equipment (18,200 ) (7,200 ) Land 80,600 39,800 $316,700 $257,500 Accounts payable $67,200 $53,300 Accrued expenses 14,800 17,900 Notes payable—bank, long-term –0– 23,000 Bonds payable 29,700 –0– Common stock, $10 par 198,700 157,900 Retained earnings 6,300 5,400 $316,700 $257,500 Land was acquired for $40,800...
Selected financial statement information and additional data for Ronis Co. is presented below. Use this information...
Selected financial statement information and additional data for Ronis Co. is presented below. Use this information to answer the next (3) questions concerning in preparing a statement of cash flows for the year ending December 31, 2017. 2016                                             2017 Cash...........................................................        $60,000                                    $122,000 Accounts receivable (net)................................          67,000                                      100,000 Inventory....................................................        210,000                                      198,000 Land...........................................................        350,000                                      300,000 Equipment...................................................        385,000                                      405,000 Accumulated depreciation...............................     (280,000)                                   (260,000) TOTAL............................................     $792,000                                    $865,000 Accounts payable..........................................          42,000                                         40,000 Bonds payable - long-term...............................       ...
The following financial statements relate to Techmation Ltd for 2016 and 2017 respectively. Assets 2016 2017...
The following financial statements relate to Techmation Ltd for 2016 and 2017 respectively. Assets 2016 2017 Non current Assets 1 315 000 1 180 000 Inventory 150 000 170 000 Trade Debtors 525 000 450 000 1 990 000 1 800 000 Equity & Liabilities Ordinary share capital 1 000 000 1 000 000 Distributable Reserve 700 000 500 000 Bank Overdraft 80 000 110 000 Trade Creditors 210 000 190 000 1 900 000 1 800 000 2016 2017...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT