In: Accounting
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
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*******