In: Accounting
I have the formulas for how to calculate ROI, Margin and Turnover. But I don't know if I am using the right numbers and it gets frustrating. A worked out calculation for each would really be helpful so I know what numbers from what years you plugged in. Your time is valuable and would really appreciate the help. If the response is correct, I would not mind giving a like!
Return on Investment, Margin, Turnover
Ready Electronics is facing stiff competition from imported goods. Its operating income margin has been declining steadily for the past several years. The company has been forced to lower prices so that it can maintain its market share. The operating results for the past 3 years are as follows:
Year 1 | Year 2 | Year 3 | |
Sales | $10,000,000 | $ 9,500,000 | $ 9,000,000 |
Operating income | 1,200,000 | 1,045,000 | 945,000 |
Average assets | 15,000,000 | 15,000,000 | 15,000,000 |
For the coming year, Ready's president plans to install a JIT purchasing and manufacturing system. She estimates that inventories will be reduced by 70% during the first year of operations, producing a 20% reduction in the average operating assets of the company, which would remain unchanged without the JIT system. She also estimates that sales and operating income will be restored to Year 1 levels because of simultaneous reductions in operating expenses and selling prices. Lower selling prices will allow Ready to expand its market share.
(Note: Round all numbers to two decimal places.)
Required:
1. Compute the ROI, margin, and turnover for Years 1, 2, and 3.
Year 1 | Year 2 | Year 3 | |
ROI | % | % | % |
Margin | % | % | % |
Turnover |
2. Conceptual Connection: Suppose that in Year 4 the sales and operating income were achieved as expected, but inventories remained at the same level as in Year 3. Compute the expected ROI, margin, and turnover.
ROI | % |
Margin | % |
Turnover |
Why did the ROI increase over the Year 3 level?
3. Conceptual Connection: Suppose that the sales and net operating income for Year 4 remained the same as in Year 3 but inventory reductions were achieved as projected. Compute the ROI, margin, and turnover.
ROI | % |
Margin | % |
Turnover |
Why did the ROI exceed the Year 3 level?
4. Conceptual Connection: Assume that all expectations for Year 4 were realized. Compute the expected ROI, margin, and turnover.
ROI | % |
Margin | % |
Turnover |
Why did the ROI increase over the Year 3 level?