A family friend has asked your help in analyzing the operations of three anonymous companies operating in the same service sector industry. Supply the missing data in the table below: (Loss amounts should be indicated by a minus sign. Do not round your intermediate calculations.) Sales Net operating income Average operating assets Return on investment (ROI) Minimum required rate of return: Percentage Dollar amount Residual income Company A $ 470,000 $ 163,000 18 % 18 % Company B $ 780,000 $ 41,000 $ 19% 40,000 % Company C $ 670,000 $ 150,000 $ % 15 % 8,000

A family friend has asked your help in analyzing the operations of three anonymous companies operating in the same service sector industry. Supply the missing data in the table below: (Loss amounts should be indicated by a minus sign. Do not round your intermediate calculations.) Sales Net operating income Average operating assets Return on investment (ROI) Minimum required rate of return: Percentage Dollar amount Residual income Company A $ 470,000 $ 163,000 18 % 18 % Company B $ 780,000 $ 41,000 $ 19% 40,000 % Company C $ 670,000 $ 150,000 $ % 15 % 8,000

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter9: Responsibility Accounting And Decentralization

Section: Chapter Questions

Problem 5PA: Financial information for BDS Enterprises for the year-ended December 31, 20xx, was gathered from an...

See similar textbooks

Similar questions

Financial information for BDS Enterprises for the year-ended December 31, 20xx, was gathered from an accounting intern, who has asked for your guidance on how to prepare an income statement format that will be distributed to management. Subtotals and totals are included in the information, but you will need to calculate the values. A. In the correct format, prepare the income statement using the following information: B. Calculate the profit margin, return on investment, and residual income. Assume an investment base of $100,000 and 6% cost of capital. C. Prepare a short response to accompany the income statement that explains why uncontrollable costs are included in the income statement.
A family friend has asked your help in analyzing the operations of three anonymous companies operatingin the same service sector industry. Supply the missing data in the table below:CompanyA B CSales .............................................................. $9,000,000 $7,000,000 $4,500,000Net operating income ................................... $ ? $ 280,000 $ ?Average operating assets ............................. $3,000,000 $ ? $1,800,000Return on investment (ROI) .......................... 18% 14% ?Minimum required rate of return:Percentage ................................................ 16% ? 15%Dollar amount ............................................ $ ? $ 320,000 $ ?Residual income ............................................ $ ? $ ? $ 90,000
Krall Company recently had a computer malfunction and lost a portion of its accounting records. The company has reconstructed some of its financial performance measurements including components of the return on investment calculations.Required:Help Krall rebuild its information database by completing the following table: (Do not round your intermediate calculations. Round your final answers to 2 decimal places, (i.e. 0.1234 should be entered as 12.34%.).) Return on Investment Profit Margin Investment Turnover Operating Income Sales Revenue Average Invested Assets % % $50,000.00 $714,000.00 $1.550.000.00 % 9.80 % 0.50 $1,23,970.00 $2,530,000.00 % 15.70 % 1.15 $1,955,000.00 11.10 % % 2.80 $505,000.00
A company is a wholesale distributor of electronic equipment who has been experiencing losses for some time, as shown by its most recent monthly contribution format income statement: Sales P 1,000,000Variable expenses 390,000Contribution Margin 610,000Fixed Expenses 625,000Net operating Income (loss) P(15,000) In an effort to resolve the problem, the company would like to prepare an income statement segmented by division. Accordingly, the Accounting Department has developed the following information: Division East Central WestSales P250,000 P400,000 P350,000Variable expenses as a percentage of sales 52% 30% 40%Traceable Fixed Expenses P160,000 P200,000 P175,000 Required: a. Prepare a contribution format income statement segmented by the division. East Central West b. The marketing department has proposed increasing the West Division’s monthly advertising by P15,000 believing that it…
Comparative data on three companies in the same service industry are given below:CompanyA B CSales ....................................................... $600,000 $500,000 $ ?Net operating income .............................. $ 84,000 $ 70,000 $ ?Average operating assets ........................ $300,000 $ ? $1,000,000Margin ...................................................... ? ? 3.5%Turnover .................................................. ? ? 2ROI .......................................................... ? 7% ?Required:1. What advantages are there to breaking down the ROI computation into two separate elements, marginand turnover?2. Fill in the missing information above, and comment on the relative performance of the three companiesin as much detail as the data permit. Make specific recommendations about how to improve the ROI.
Krall Company recently had a computer malfunction and lost a portion of its accounting records. The company has reconstructed some of its financial performance measurements including components of the return on investment calculations. 1. Help Krall rebuild its information database by completing the following table: Note: Round your intermediate calculations to 2 decimal places. Round your final answers to 2 decimal places, (i.e. 0.1234 should be entered as 12.34%.). Return on Investment Profit Margin Investment Turnover Operating Income Sales Revenue Average Invested Assets $51,000.00 $709,000.00 $1,420,000.00 4.06% 9.90% 0.41 $105,128.10 $2,590,000.00 24.14% 14.20% 1.70 $3,043,000.00 11.205 5.09% 2.20 $519,000.00
A family friend has asked your help in analyzing the operations of three anonymous companies operating in the same service sector industry. Supply the missing data in the table below: (Loss amounts should be indicated by a minus sign. Round your percentage answers to nearest whole percent and other amounts to whole dollars.)
The condensed income statement for the Consumer Products Division of Tri-State Industries Inc. is as follows (assuming no support department charges): Sales $210,000,000 Cost of goods sold 117,200,000 Gross profit $92,800,000 Administrative expenses 67,400,000 Operating income $25,400,000 The manager of the Consumer Products Division is considering ways to increase the return on investment. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on investment of the Consumer Products Division, assuming that $125,550,000 of assets have been invested in the Consumer Products Division. Round your answers for the profit margin and the rate of return on investment to the nearest whole number, round your answer for the…
Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as shown by its most recent monthly contribution format income statement: Sales $ 1,644,000 Variable expenses 608,620 Contribution margin 1,035,380 Fixed expenses 1,139,000 Net operating income (loss) $ (103,620) In an effort to resolve the problem, the company would like to prepare an income statement segmented by division. Accordingly, the Accounting Department has developed the following information: Division East Central West Sales $ 444,000 $ 650,000 $ 550,000 Variable expenses as a percentage of sales 48% 27% 40% Traceable fixed expenses $ 282,000 $ 335,000 $ 200,000 Required: 1. Prepare a contribution format income statement segmented by divisions. 2-a. The Marketing Department has proposed increasing the West Division's monthly advertising by $20,000 based on the belief that it would increase that division's sales by 14%. Assuming…
Bovine Company, a wholesale distributor of umbrellas, has been experiencing losses for some time, as shown by its most recent monthly contribution format income statement: Sales $ 2,070,000 Variable expenses 895,880 Contribution margin 1,174,120 Fixed expenses 1,319,000 Operating loss $ (144,880 ) In an effort to isolate the problem, the president has asked for an income statement segmented by geographic market. Accordingly, the Accounting Department has developed the following: Geographic Market South Central North Sales $ 607,000 $ 806,000 $ 657,000 Variable expenses as a percentage of sales 50 % 36 % 46 % Traceable fixed expenses $ 320,000 $ 480,000 $ 307,000 Required:1. Prepare a contribution format income statement segmented by geographic market, as requested by the president. 2-a. The company’s sales manager believes that sales in the Central…
You are a financial analyst working for a financial services provider. The financial information provided below is for two companies operating in the same industry: Statements of comprehensive income for year ended 31 December 2020 Tiger (Pty) Ltd Lion (Pty) Ltd Sales revenue 8 200 000 6 300 000 Less: variable costs 6 430 000 4 420 000 Cost of sales Selling expenses 6 230 000 200 000 4 160 000 260 000 Contribution 1 770 000 1 880 000 Less: fixed costs 840 000 690 000 Administration costs Production costs Selling costs 180 000 600 000 60 000 140 000 510 000 40 000 Earnings before interest and tax expense 930 000 1 190 000 Less: Finance costs 100 000 90 000 Profit before tax 830 000 1 100 000 Less: Income tax expense 249 000 330 000 Total comprehensive income for the year 581 000 770 000 Statements of changes in equity for year ended 31 December 2020 Tiger (Pty) Ltd…
A recent accounting graduate from Divine Word University evaluated the operating performance of Boswell Company's four divisions. The following presentation was made to Boswell's Board of Directors. During the presentation, the accountant made the recommendation to eliminate the Southern Division stating that total net income would increase by P40,000. (See analysis below.) Other Three Divisions Southern Division Total Sales P2,000,000 P480,000 P2,480,000 Cost of Goods Sold 950,000 400,000 1,350,000 Gross Profit…