Question

Data on three unrelated companies are given in the following table. (Click the icon to view the table.) Fill in the missing i

I can't get to the numbers I'm suppose to be getting.. Can Someone help me out?

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Cole Inc Sweeney Company Sesnie Industries
Sales $ 120,000 $                800,000 $            530,000
Operating Income $   36,000 $                120,000 $              63,600
Total Assets $   75,000 $                160,000 $            212,000
Sales margin 30% 15% 12%
Capital Turnover 1.6 5.00 2.5
Return on investment (ROI) 48% 75% 30%
Target rate of return 11% 20% 21%
Residual Income $   27,750 $                  88,000 $              19,080

Here is the formula version

A В E Sesnie Industries Cole Inc Sweeney Company =D5/D7 Sales 120000 530000 -E4* E7 Operating Income 36000 120000 D4/D8 -E5/E

Add a comment
Know the answer?
Add Answer to:
I can't get to the numbers I'm suppose to be getting.. Can Someone help me out? Data on three unrelated companies are g...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Data on three unrelated companies are given in the following table.... ​(Click the icon to view...

    Data on three unrelated companies are given in the following table.... ​(Click the icon to view the​ table.) Sales . . . . . . . . . . . . . . . . . . $ 105,000 ? $ 525,000 Operating income . . . . . . . . . . $ 37,800 $ 129,600 ? Total assets . . . . . . . . . . . . . . $ 84,000 ? ? Sales...

  • Data on three unrelated companies are given in the.following table. EEB (Click the icon to view...

    Data on three unrelated companies are given in the.following table. EEB (Click the icon to view the table.) Fill in the missing information in the preceding table. (Enter the capital turnover to two decimal places X.XX) Austen Company Plumb Industries 100,000 Sales 40,000 $ 110,600 Operating income $ 80,000 Total assets 40 % Sales margin 14 % 125 4.00 Capital turnover. 50% % Return on investment (ROI) 10% 21 % Target rate of return. 32,000 Residual income 69 Austen Company...

  • Data on three unrelated companies are given in the following table. E: (Click the icon to...

    Data on three unrelated companies are given in the following table. E: (Click the icon to view the table.) Fill in the missing information in the preceding table. (Enter the capital turnover to two decimal places X.XX.) Preston, Inc. Sales .......................$ Operating income ............ $ Total assets ............... .......$ 114,000 39,900 71,250 Sales margin ................. Capital turnover.......... Return on investment (ROI) .... Target rate of return... 10 % Residual income .............. Hoffman Industries $ 525,000 Sales ..................... $ Operating income...

  • s. There are three unrelated companies, Cole Company, LaChut Industries, and Gable, Inc. (1) (4 points) Write down...

    s. There are three unrelated companies, Cole Company, LaChut Industries, and Gable, Inc. (1) (4 points) Write down the formulae, respectively, for Sales margin, Capital turnover, RO, and Residual Income. Answer: (2) (11 points) Fill in the missing numbers in the preceding table. (Round your answers to two decimal places if needed) Cole Company LaChut Industries Gable, Inc. $ 522,000 $108,000 Sales $ 110,600 $ 43,200 Operating income 180,000 $ 72,000 Total assets 10% 14% Sales margin 4.001076 Capital turnover...

  • Results from First ​Corporation's most recent year of operations are presented in the following table. Requirements...

    Results from First ​Corporation's most recent year of operations are presented in the following table. Requirements 1. Calculate the sales​ margin, capital​ turnover, and return on investment​ (ROI). 2. Calculate the residual income​ (RI). turnover, and return on investment (ROI). Data Table nargin, the sa Operating income ................$ Total assets. ................. $ Current liabilities............... 9,100 14,000 4,200 35,000 16 % the ca Sales........................ ..........$ Target rate of return. .............. the RO Print Done Results from First Corporation's most recent year...

  • 13. The following information pertains to the three divisions of Marlow Company: Division Z Division Y...

    13. The following information pertains to the three divisions of Marlow Company: Division Z Division Y Division X $1,250,000 $75,000 Sales ? ? Net operating income $36,000 $25,000 Average operating $300,000 ? ? assets Return on ? 20% 15% investment Margin 0.10 0.05 ? Turnover 1.2 ? ? Target ROI 15% 12% 10% What is the residual income for Division X? А. $36,000 $45,000 $(9,000) $(36,000) В. С. D. The Auto Division of a department store had a net operating...

  • Problem 11-15 Return on Investment (ROI) and Residual Income [LO11-1. LO11-2] Financial data for Joel de...

    Problem 11-15 Return on Investment (ROI) and Residual Income [LO11-1. LO11-2] Financial data for Joel de Paris, Inc, for last year follow 1 de Paris, Inc Balance Sheet Ending Beginning Assets Cash Accounts receivable Inventory Plant and equipment, net Investment in Buisson, S.A Land (undeveloped) Total assets s 140,80012,000 456,808 328,880 688,600 258,800 188,080 530,000 380,800 620,980 288,888 170,908 $ 2,828,98032,100,8 Liabilities and Stockholders Equity Accounts payable Long-term debt Stockholders equity S360,8803S310,880 1,500,000 1,580,800 168,000 ::: m 290,aee Total liabilities...

  • Ending Balance Joel de Paris, Inc. Balance Sheet Beginning Balance Assets Cash $ 140,000 Accounts receivable 450,000 I...

    Ending Balance Joel de Paris, Inc. Balance Sheet Beginning Balance Assets Cash $ 140,000 Accounts receivable 450,000 Inventory 320,000 Plant and equipment, net 680,000 Investment in Buisson, S.A. 250,000 Land (undeveloped) 180,000 Total assets $2,020,000 Liabilities and Stockholders' Equity Accounts payable $ 360,000 Long-term debt 1,500,000 Stockholders' equity 160,000 Total liabilities and stockholders' $2,020,000 equity $ 120,000 530,000 380,000 620,000 280,000 170,000 $2,100,000 $ 310,000 1,500,000 290,000 $2,100,000 Joel de Paris, Inc. Income Statement Sales Operating expenses Net operating income...

  • (Just need Req 2 for both questions) Comparative data on three companies in the same service...

    (Just need Req 2 for both questions) Comparative data on three companies in the same service industry are given below: Required: 2. Fill in the missing information. (Round the "Margin" answers to 1 decimal place and "Turnover" answers to 2 decimal places.) Company В C $ $ Sales 600,000 500,000 84,000 70,000 Net operating income $ $ 300,000 1,000,000 Average operating assets 3.5% Margin % % Turnover 2.00 % 7 % Return on investment (ROI) % Exercise 10-12 Evaluating New...

  • Consider the following condensed financial statements of Safe Money, Inc. The​ company's target rate of return is 20​%:...

    Consider the following condensed financial statements of Safe Money, Inc. The​ company's target rate of return is 20​%: Safe Money, Inc. Comparative Balance Sheet As of December 31, 2018 and 2017 2018 2017 Assets Cash $82,000 $71,000 Accounts Receivable 61,600 27,500 Supplies 400 500 Property, Plant, and Equipment, net 299,000 197,000 Patents, net 158,000 103,000 Total Assets $601,000 $399,000 Liabilities and Stockholders' Equity Accounts Payable $31,000 $33,000 Short-term Notes Payable 149,000 49,000 Long-term Notes Payable 199,000 129,000 Common Stock, no...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT