Question

In: Accounting

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

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?

Solutions

Expert Solution

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

Related Solutions

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 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...
Carr Corporation's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet...
Carr Corporation's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet Ending Balance Beginning Balance Cash and cash equivalents $ 3,090 $ 24,610 Accounts receivable 88,000 76,680 Inventory 39,800 47,940 Prepaid expenses 9,810 15,750 Long-term investments 254,400 210,000 Property, plant, and equipment 540,750 504,000 Less accumulated depreciation 329,600 312,700 Total assets $ 606,250 $ 566,280 Accounts payable $ 9,540 $ 25,500 Accrued liabilities 24,480 17,850 Income taxes payable 53,400 48,300 Bonds payable 176,000 216,000 Common...
Carr Corporation's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet...
Carr Corporation's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet Ending Balance Beginning Balance Cash and cash equivalents $ 3,270 $ 25,300 Accounts receivable 88,800 78,100 Inventory 39,800 49,820 Prepaid expenses 9,630 15,450 Long-term investments 247,200 216,000 Property, plant, and equipment 566,500 523,200 Less accumulated depreciation 345,600 324,500 Total assets $ 609,600 $ 583,370 Accounts payable $ 9,720 $ 25,750 Accrued liabilities 25,440 18,190 Income taxes payable 51,900 50,600 Bonds payable 171,200 206,000 Common...
Carr Corporation's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet...
Carr Corporation's comparative balance sheet and income statement for last year appear below: Comparative Balance Sheet Ending Balance Beginning Balance Cash and cash equivalents $ 3,300 $ 24,840 Accounts receivable 90,500 72,420 Inventory 42,900 51,230 Prepaid expenses 9,810 16,350 Long-term investments 254,400 206,000 Property, plant, and equipment 551,050 513,600 Less accumulated depreciation 348,800 315,650 Total assets $ 603,160 $ 568,790 Accounts payable $ 9,810 $ 27,500 Accrued liabilities 24,720 17,850 Income taxes payable 51,900 48,760 Bonds payable 164,800 210,000 Common...
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...
Condensed financial data of Tebow Company appear below: TEBOW COMPANY Comparative Balance Sheet December 31 2017...
Condensed financial data of Tebow Company appear below: TEBOW COMPANY Comparative Balance Sheet December 31 2017 2016 Assets Cash $ 70,000 $ 35,000 Accounts receivable 82,000 53,000 Inventories 120,000 132,000 Prepaid expenses 19,000 25,000 Investments 80,000 65,000 Plant assets 310,000 250,000 Accumulated depreciation (65,000) (60,000) Total $616,000 $500,000 Liabilities and Stockholders' Equity Accounts payable $ 95,000 $ 75,000 Accrued expenses payable 22,000 24,000 Bonds payable 120,000 150,000 Common stock 245,000 170,000 Retained earnings 134,000 81,000 Total $616,000 $500,000 TEBOW COMPANY...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT