In: Accounting
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
Income Statement
For the year ended December 31 2019
Dec 31, 2018 |
Dec 31, 2019 |
|
Sales |
4,040,000 |
4,464,000 |
Operating Expenses |
3,700,000 |
4,291,000 |
Income before Interest + Taxes |
260,000 |
353,000 |
Interest Expense |
55,000 |
90,000 |
Tax Expense |
85,000 |
129,000 |
Operating Income |
120,000 |
134,000 |
The "Investment in Carr 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.
b) The Board of Directors of Beaker Company have set a minimum
required return of 15%. What was the company's residual income last
year?
Solution: | |||
a) | Margin = Income before interest and taxes /Sales | ||
= 353,000/4,464,000 | |||
= 7.91% | |||
Operating Assets | 31-Dec-18 | 31-Dec-19 | |
Cash | 135,000 | 266,000 | |
Accounts receivable | 225,000 | 475,000 | |
Inventory | 314,000 | 394,000 | |
Plant+Equipment(Net) | 940,000 | 860,000 | |
Total | 1,614,000 | 1,995,000 | |
Operating assets do not include investment in other companies, and land . | |||
Average Operating Assets = (1,614,000 + 1,995,000)/2 = 1,804,500 | |||
Turnover = Sales / average operating assets | |||
= 4,464,000/1,804,500 | |||
= 2.47 | |||
ROI = Income before interest and taxes / Average operating assets | |||
= 353,000/1,804,500 | |||
= 19.56% | |||
b) | Income before interest and taxes | 353,000 | |
Minimum required return(1,804,500*15%) | -270,675 | ||
Residual Income | 82,325 |