Question

In: Accounting

Financial data for Windsor, Inc. for last year appear below: Windsor, Inc. Statements of Financial Position...

Financial data for Windsor, Inc. for last year appear below:

Windsor, Inc.
Statements of Financial Position
Beginning
Balance
Ending
Balance
  Assets:
  Cash $ 250,000 $ 260,000
  Accounts receivable 120,000 135,000
  Inventory 230,000 205,000
  Plant and equipment (net) 420,000 380,000
  Investment in Pine Company 220,000 250,000
  Land (undeveloped) 430,000 430,000
  Total assets $ 1,670,000 $ 1,660,000
  Liabilities and owners equity:
  Accounts payable $ 160,000 $ 140,000
  Long-term debt 800,000 800,000
  Owners equity 710,000 720,000
  Total liabilities and owners equity $ 1,670,000 $ 1,660,000
Windsor, Inc.
Income statement
  Sales $ 1,750,000
  Less operating expenses 1,470,000
  Net operating income 280,000

  Less interest and taxes:

  Interest expense $ 96,000
  Tax expense 70,000 166,000
  Net income $ 114,000

The company paid dividends of $104,000 last year. The "Investment in Pine Company" on the statement of financial position represents an investment in the stock of another company.

Required:
a.

Compute the company's margin, turnover, and return on investment for last year.

  Margin         %
  Turnover     
  Return on investment %
b.

The Board of Directors of Windsor, Inc. has set a minimum required return of 25%. What was the company's residual income last year?

   Residual income $

C. Windor's CFO has heard about EVA and is curious about whether it might be a better measure to use for evaluating division managers. Windsor's long term debt trades at book value, with interest rate of 10% while its equity has a market value of $1,200,000. The company's cost of equity is 12%. Windsor's income tax rate is 40%. Calculate each of the following components of EVA for the company, as well as the final EVA figure:

a. Weighted average cost of capital

b. Investment, as measured for EVA calculations

Solutions

Expert Solution

Answer:-

a. Compute the company's margin, turnover, and return on investment for last year:-

Operating assets do not include investments in other companies or in undeveloped land:

Beginning balance Ending balance
Cash 250,000 260,000
Accounts Receivable 120,000 135,000
Inventory 230,000 205,000
Plant and Equipment (Net) 420,000 380,000
Total Operating Assets 1,020,000 980,000

Average operating assets = ($1,020,000 + $980,000)/2 = $1,000,000

Margin = Net Operating Income/Sales = $280,000 / $1,750,000 = 16%

Turnover = Sales / Average Operating Assets = $1,750,000 / $1,000,000 = 1.75

ROI = Margin x Turnover = 16% x 1.75 = 28%

b. The Board of Directors of Windsor, Inc., has set a minimum required return of 25%. What was the company's residual income last year:-

Net operating income 280,000
Minimum Required Return (25% x $1,000,000) 250,000
Residual Income 30,000

if you have any query please ask me in comment box i am here to helps you don't give direct Thumbs down.if you satisfied my work give Thumbs UP

******THANK YOU*******


Related Solutions

Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position...
Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position Beginning Balance Ending Balance Assets: Cash $ 346,000 $ 324,792 Accounts receivable 202,000 159,000 Inventory 298,000 299,000 Plant and equipment (net) 463,000 455,000 Investment in Cedar Company 318,000 293,000 Land (undeveloped) 237,000 237,000 Total assets $ 1,864,000 $ 1,767,792 Liabilities and owners' equity: Accounts payable $ 249,000 $ 228,000 Long-term debt 855,000 855,000 Owners' equity 760,000 684,792 Total liabilities and owners' equity $ 1,864,000...
Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position...
Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position Beginning Balance Ending Balance Assets: Cash $ 295,000 $ 336,524 Accounts receivable 178,000 180,000 Inventory 275,000 222,000 Plant and equipment (net) 480,000 441,000 Investment in Cedar Company 306,000 322,000 Land (undeveloped) 273,000 273,000 Total assets $ 1,807,000 $ 1,774,524 Liabilities and owners' equity: Accounts payable $ 224,000 $ 197,000 Long-term debt 824,000 824,000 Owners' equity 759,000 753,524 Total liabilities and owners' equity $ 1,807,000...
Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position...
Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position Beginning Balance Ending Balance Assets: Cash $ 260,000 $ 217,450 Accounts receivable 157,000 149,000 Inventory 288,000 284,000 Plant and equipment (net) 496,000 450,000 Investment in Cedar Company 233,000 347,000 Land (undeveloped) 335,000 335,000 Total assets $ 1,769,000 $ 1,782,450 Liabilities and owners' equity: Accounts payable $ 213,000 $ 171,000 Long-term debt 803,000 803,000 Owners' equity 753,000 808,450 Total liabilities and owners' equity $ 1,769,000...
Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position...
Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position Beginning Balance Ending Balance Assets: Cash $ 346,000 $ 324,792 Accounts receivable 202,000 159,000 Inventory 298,000 299,000 Plant and equipment (net) 463,000 455,000 Investment in Cedar Company 318,000 293,000 Land (undeveloped) 237,000 237,000 Total assets $ 1,864,000 $ 1,767,792 Liabilities and owners' equity: Accounts payable $ 249,000 $ 228,000 Long-term debt 855,000 855,000 Owners' equity 760,000 684,792 Total liabilities and owners' equity $ 1,864,000...
Question 6 Comparative statements of financial position for Campbell Inc. appear below: CAMPBELL INC. Comparative Statements...
Question 6 Comparative statements of financial position for Campbell Inc. appear below: CAMPBELL INC. Comparative Statements of Financial Position ––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––– Assets                                                                                                 Dec. 31, 2016 Dec. 31, 2015 Cash                                                                                        $ 29,000         $15,000 Accounts receivable                                                                   28,000         19,000 Prepaid expenses                                                                         9,000         12,000 Merchandise inventory                                                               37,000         27,000 Long-term investments                                                               35,000         53,000 Equipment                                                                                   75,000         48,000 Accumulated depreciation—equipment                                   (26,000)        (22,000) Total assets                                                                             $187,000         $152,000 Liabilities and Shareholders' Equity Accounts payable                                                                  ...
Financial data for Bingham Company for last year appear below: Bingham Company Balance Sheet For the...
Financial data for Bingham Company for last year appear below: Bingham Company Balance Sheet For the years ended Dec 31 2018 and 2019 ASSETS Dec 31, 2018 Dec 31, 2019 Cash 135,000 266,000 Accounts Receivable 225,000 475,000 Inventory 314,000 394,000 Plant+Equipment (net) 940,000 860,000 Investment in Carr Corp. 104,000 101,000 Land 198,000 65,000 Total Assets 1,916,000 2,161,000 LIABILITIES + EQUITY Accounts Payable 88,000 119,000 Long-Term Debt 585,000 665,000 Owner’s equity 1,243,000 1,377,000 Total Liabilities + Equity 1,916,000 2,161,000 Bingham Company...
Financial data for Bingham Company for last year appear below: Bingham Company Balance Sheet For the...
Financial data for Bingham Company for last year appear below: Bingham Company Balance Sheet For the years ended Dec 31 2018 and 2019 ASSETS Dec 31, 2018 Dec 31, 2019 Cash 135,000 266,000 Accounts Receivable 225,000 475,000 Inventory 314,000 394,000 Plant+Equipment (net) 940,000 860,000 Investment in Carr Corp. 104,000 101,000 Land 198,000 65,000 Total Assets 1,916,000 2,161,000 LIABILITIES + EQUITY Accounts Payable 88,000 119,000 Long-Term Debt 585,000 665,000 Owner’s equity 1,243,000 1,377,000 Total Liabilities + Equity 1,916,000 2,161,000 Bingham Company...
Financial data for three different divisions of the same company, for last year, appear below: Division                         &
Financial data for three different divisions of the same company, for last year, appear below: Division                                     A          %             B         %              C          % Company Total % Sales                                  $3,200,000            $3,500,000           $5,000,000 Variable Costs                    1,450,000              1,750,000             2,750,000 Traceable Fixed Costs        1,250,000              1,350,000             1,450,000 Segment Margin Common Fixed Costs:                                                                                              1,500,000 PART I: Complete the above table showing the Contribution Margin Ratio(CMR), and the segment margin for each of the segments. Determine the CMR for the company as a whole . If the company were to add a new division, what information from the above would you use to assist in...
The financial statements of Morgan Ltd appear below: Morgan LTD Comparative Statement of Financial Position 31...
The financial statements of Morgan Ltd appear below: Morgan LTD Comparative Statement of Financial Position 31 December 2018 ________________________________________________________________________________________ Assets                                                                                                         2018                    2017    Cash ..................................................................................................     $ 25,000              $ 40,000 Marketable securities ...........................................................................         15,000                 60,000 Accounts receivable (net) .....................................................................         50,000                 30,000 Inventory ............................................................................................       150,000                170,000 Property, plant and equipment (net) ......................................................       160,000                200,000       Total assets ..................................................................................     $400,000              $500,000 Liabilities and equity Accounts payable ................................................................................     $ 20,000              $ 30,000 Short-term notes payable .....................................................................         40,000                 90,000 Bonds payable...
The most recent financial statements for Scott, Inc., appear below. Sales for 2020 are projected to...
The most recent financial statements for Scott, Inc., appear below. Sales for 2020 are projected to grow by 20 percent. Interest expense will remain constant; the tax rate and the dividend payout rate also will remain constant. Costs, other expenses, current assets and accounts payable increase spontaneously with sales. SCOTT, INC. 2019 Income Statement   Sales $763,000   Costs 598,000   Other expenses 34,000   Earnings before interest and taxes $131,000   Interest expense 30,000   Taxable income $101,000   Taxes (25%) 25,250   Net income $75,750 Dividends...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT