Question

In: Accounting

I have the formulas for how to calculate ROI, Margin and Turnover. But I don't know...

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?

Solutions

Expert Solution



Related Solutions

Mastery Problem: Return on Investment, margin, and turnover Return on Investment (ROI) The manager of an...
Mastery Problem: Return on Investment, margin, and turnover Return on Investment (ROI) The manager of an investment center should be evaluated based on revenues, costs, and investments. An evaluation based on net income ignores the amount of investment the investment center required. One way to measure operating profit in relation to investment is a calculation called the return on investment. One formula for calculating return on investment is: Operating income Invested Assets ROI is effective because it takes into consideration...
Mastery Problem: Return on Investment, margin, and turnover Return on Investment (ROI) The manager of an...
Mastery Problem: Return on Investment, margin, and turnover Return on Investment (ROI) The manager of an investment center should be evaluated based on revenues, costs, and investments. An evaluation based on net income ignores the amount of investment the investment center required. One way to measure operating profit in relation to investment is a calculation called the return on investment. One formula for calculating return on investment is: Operating income Invested Assets ROI is effective because it takes into consideration...
I have a problem, and I have the answer but I don't know where the solution...
I have a problem, and I have the answer but I don't know where the solution comes from. ( I have to be able to solve these myself so please help me by answering the questions about the problem.) Here is the answer given to me by the professor: What is the density of SF4 vapor at 650 torr and 100 C? 650 torr (1atm/760 Torr)=0.855atm 100C=373K PV=nRT n/v=P/RT= 0.855atm/0.8206l-atm/molek) (373)=0.0279 mole/l M.W. of SF4=108.1 gm/mole Density=mass/volume 0.0279 mole/l(108.1gm/mole) Answer...
I know the what the answers are but I don't know how to get them. Can...
I know the what the answers are but I don't know how to get them. Can you please explain the process? Thank you. Part VII. Discontinued Operations and Earnings per Share (11 points) Todd Corporation had pre-tax income for 2017 of $2,500,000. On December 31, 2017, Boyd disposed of a component of its business that represented a strategic shift in operation. That component had a Loss on Discontinued Operations of $450,000 (pre-tax). Boyd received $1,000,000 net cash proceeds from the...
Margin, Turnover, ROI Required: 1. Consider the data for each of the following four independent companies....
Margin, Turnover, ROI Required: 1. Consider the data for each of the following four independent companies. Calculate the missing values in the table below. For margin and ROI, enter your answers as percentages, rounded to two decimal places. For example, the decimal value .03827 would be entered as "3.83" percent. For turnover, enter your answer as a decimal value rounded to two decimal places.    A    B    C    D Revenue $12,500 $49,000 $96,000 $fill in the blank 1 Expenses $10,000 $fill...
Below is a diffraction problem. I have the solutions to the problem but I don't know...
Below is a diffraction problem. I have the solutions to the problem but I don't know how to arrive at these solutions. A) In an experiment two slits are separated by 0.22mm and illuminated by light of wavelength 640nm. How far must a screen be placed in order for the bright fringes to be separated by 5 mm? (1.72 m) B) A soap film is illuminated by white light normal to its surface. The index of refraction of the film...
I don't know if you have the stats for this but I tried to put them...
I don't know if you have the stats for this but I tried to put them in here and it told me this is too long. I do not have Minitab so I would need it in Excel please and thank you so much. It will not let me put all the info in here. Says its too long. Refer to the Baseball 2016 data, which report information on the 30 Major League Baseball teams for the 2016 season. a....
Firm C has net income of $140,000, turnover of 1.91, and ROI of 23.60%. Calculate the...
Firm C has net income of $140,000, turnover of 1.91, and ROI of 23.60%. Calculate the firm's margin, sales, and average total assets.
Please let me know what the formulas are to calculate the following: I am seeing different...
Please let me know what the formulas are to calculate the following: I am seeing different answers and I don't know which is correct. E 15–26 Lease concepts; finance/sales-type leases; guaranteed and unguaranteed residual value Each of the four independent situations below describes a sales-type lease in which annual lease payments of $100,000 are payable at the beginning of each year. Each is a finance lease for the lessee. Determine the following amounts at the beginning of the lease: A....
Calculating Average Operating Assets, Margin, Turnover, Return on Investment (ROI) Forchen, Inc., provided the following information...
Calculating Average Operating Assets, Margin, Turnover, Return on Investment (ROI) Forchen, Inc., provided the following information for two of its divisions for last year: Small Appliances Division Cleaning Products Division Sales $34,670,000 $34,800,000 Operating income 2,773,600 1,392,000 Operating assets, January 1 6,394,000 5,600,000 Operating assets, December 31 7,474,000 6,000,000 Required: 1. For the Small Appliances Division, calculate: a. Average operating assets $ b. Margin % c. Turnover d. Return on investment (ROI) % 2. For the Cleaning Products Division, calculate:...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT