Question

In: Accounting

Key information for the Plant City Division (PCD) of Barkley Industries for 2019 are as follows:...

Key information for the Plant City Division (PCD) of Barkley Industries for 2019 are as follows: Revenues $15,000,000 Operating Income 1,800,000 Total Assets 10,000,000 PCD managers are evaluated and rewarded on the basis of ROI defined as operating income divided by total assets. Barkley Industries expects its divisions to increase ROI each year. Next year, 2020, appears to be a difficult year for PCD. PCD had planned a new investment to improve quality but, in view of poor economic conditions, has postponed the investment. ROI for 2020 was certain to decrease if PCD had made the investment. Management is now considering ways to meet its target ROI of 20% for next year. It anticipates revenues to be steady at $15 million in 2020.

Required: (a) Calculate PCD’s return on sales and ROI for 2019.

(b) (1) By how much would PCD need to cut costs in 2020 to achieve its target ROI of 20%, assuming no change in total assets between 2019 and 2020?

(2) By how much would PCD need to decrease total assets in 2020 to achieve its target ROI of 20%, assuming no change in operating income between 2019 and 2020?

(c) Calculate PCD’s Residual Income (RI)* in 2019, assuming a required rate of return on investment of 15%.

(d) PCD wants to increase RI by 50% in 2020. Assuming it could cut costs by $45,000 in 2020, by how much would PCD need to decrease total assets in 2020?

(e) Barkley Industries is concerned that the focus on cost cutting, asset sales and no new investments will have an adverse long-run effect on PCD’s customers. Yet Barkley wants PCD to meet its financial goals. What other measurements, if any do you recommend that Barkley use? Explain briefly. * Residual Income = Operating Income – (Total Assets x Required Rate of Return) [Residual Income as a performance measure has the advantage of motivating managers to act in the best interest of the company as a whole.]

Solutions

Expert Solution

Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!
Plant City Division
Answer a Amount $ Note
Operating Income      1,800,000.00 A
Revenues    15,000,000.00 B
Return on sales 12.00% C=A/B
Operating Income      1,800,000.00 See A
Total Asset    10,000,000.00 D
ROI 18.00% E=A/D
Answer b 1
Total Asset    10,000,000.00 See D
Target ROI 20% F
Desired ROI      2,000,000.00 G=F*D
Current Operating Income      1,800,000.00 See A
Costs to be cut in 2020         200,000.00 H=G-A
Answer b 2
Desired ROI      2,000,000.00 See G
Current Operating Income      1,800,000.00 See A
Difference         200,000.00 See H
Target ROI 20% See F
Decrease in total assets in 2020      1,000,000.00 I=H/F
Answer c
Total Asset    10,000,000.00 See D
Required rate of return 15% J
Required return      1,500,000.00 K=D*J
Operating Income      1,800,000.00 See A
Residual Income         300,000.00 L=A-K
Answer d
Current Operating Income      1,800,000.00 See A
Reduction in costs            45,000.00 M
Revised Operating Income      1,845,000.00 N=A+M
Current Residual Income         300,000.00 See L
Increase by 50%         150,000.00 O=L*50%
Target Residual Income         450,000.00 P=L+O
Required return      1,500,000.00 See K
Operating Income      1,845,000.00 See N
Residual Income         345,000.00 Q=N-K
Target Residual Income         450,000.00 See P
Residual Income should increase by         105,000.00 R=P-Q
Required rate of return 15% See J
Decrease in total assets in 2020         700,000.00 S=R/J
Answer e
If Barkley Industries is really concerned that the focus on cost cutting, asset sales and no new investments will have an adverse long-run effect on PCD’s customers then it should give PCD opportunity to look for newer and better investment opportunities. Further it should also try to reduce costs as much as possible.

Related Solutions

The condensed income statement for the Consumer Products Division of Fargo Industries Inc. is as follows...
The condensed income statement for the Consumer Products Division of Fargo Industries Inc. is as follows (assuming no service department charges): Sales $1,008,000 Cost of goods sold 453,600 Gross profit $554,400 Administrative expenses 201,600 Income from operations $352,800 The manager of the Consumer Products Division is considering ways to increase the return on investment. a. 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...
1.The condensed income statement for the Consumer Products Division of Tri-State Industries Inc. is as follows...
1.The condensed income statement for the Consumer Products Division of Tri-State Industries Inc. is as follows (assuming no support department allocations): Sales $1,232,000 Cost of goods sold (554,400) Gross profit $677,600 Administrative expenses (431,200) Operating income $246,400 The manager of the Consumer Products Division is considering ways to increase the return on investment. a. 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 $3,080,000...
Plant acquisitions for selected companies are as follows. 1. Pina Industries Inc. acquired land, buildings, and...
Plant acquisitions for selected companies are as follows. 1. Pina Industries Inc. acquired land, buildings, and equipment from a bankrupt company, Torres Co., for a lump-sum price of $966,000. At the time of purchase, Torres’s assets had the following book and appraisal values. Book Values Appraisal Values Land $276,000 $207,000 Buildings 345,000 483,000 Equipment 414,000 414,000 To be conservative, the company decided to take the lower of the two values for each asset acquired. The following entry was made. Land...
Question: On December 31, 2019, Sterling Bank enters into a debt restructuring agreement with Barkley plc,...
Question: On December 31, 2019, Sterling Bank enters into a debt restructuring agreement with Barkley plc, ... On December 31, 2019, Sterling Bank enters into a debt restructuring agreement with Barkley plc, which is now experiencing financial trouble. The bank agrees to restructure a 12%, issued at par, $3,000,000 note receivable by the following modifications 1. Reducing the principal amount from $3,000,000 to 2,400,000. 2. Extending the maturity date from December 31, 2019, to January 1, 2023. 3. Reducing the...
Required information Following is the June 30, 2019, statement of net position for the City of...
Required information Following is the June 30, 2019, statement of net position for the City of Bay Lake Water Utility Fund. CITY OF BAY LAKE Water Utility Fund Statement of Fund Net Position June 30, 2019 Assets Current assets: Cash and investments $ 1,776,504 Accounts receivable (net of $13,377 provision for uncollectible accounts) 307,099 Accrued utility revenue 500,100 Due from General Fund 29,317 Interest receivable 82,017 Total current assets 2,695,037 Restricted assets: Cash 9,201 Capital assets: Land $ 1,782,497 Buildings...
Complete the balance sheet and sales information in the table that follows for Mendy Industries using...
Complete the balance sheet and sales information in the table that follows for Mendy Industries using the following financial data: Total assets turnover: 2 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 21% Total liabilities-to-assets ratio: 45% Quick ratio: 1.15 Days sales outstanding (based on 365-day year): 31.5 days Inventory turnover ratio: 6.0 Do not round intermediate calculations. Round your answers to the nearest whole dollar. Partial Income Statement Information Sales $   Cost of goods sold...
Complete the balance sheet and sales information in the table that follows for J. White Industries...
Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 1.7 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 25% Total liabilities-to-assets ratio: 50% Quick ratio: 1.10 Days' sales outstanding (based on 365-day year): 36.5 days Inventory turnover ratio: 3.75 Do not round intermediate calculations. Round your answers to the nearest whole dollar. Partial Income Statement Information Sales $   Cost of goods...
Complete the balance sheet and sales information in the table that follows for J. White Industries...
Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 1.9 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 25% Total liabilities-to-assets ratio: 40% Quick ratio: 1.00 Days' sales outstanding (based on 365-day year): 36.5 days Inventory turnover ratio: 3.50 Do not round intermediate calculations. Round your answers to the nearest whole dollar. Partial Income Statement Information Sales $   Cost of goods...
Complete the balance sheet and sales information in the table that follows for J. White Industries...
Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 2.8 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 26% Total liabilities-to-assets ratio: 45% Quick ratio: 1.15 Days sales outstanding (based on 365-day year): 38.5 days Inventory turnover ratio: 4.0 Do not round intermediate calculations. Round your answers to the nearest whole dollar. Partial Income Statement Information Sales $    Cost of goods...
The Asphalt Division of Sierra Industries is operated as a profit center. Sales for the division...
The Asphalt Division of Sierra Industries is operated as a profit center. Sales for the division were budgeted for 2016 at $1,200,000. The only variable costs budgeted for the division were cost of goods sold ($590,000) and selling and administrative ($80,000). Fixed costs were budgeted at $130,000 for cost of goods sold, $120,000 for selling and administrative and $95,000 for noncontrollable fixed costs. Actual results for these items were:                                             Sales                                       $1,185,000                                             Cost of goods sold                                                 Variable                                    545,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT