Question

In: Accounting

Solano Company has sales of $760,000, cost of goods sold of $500,000, other operating expenses of...

Solano Company has sales of $760,000, cost of goods sold of $500,000, other operating expenses of $40,000, average invested assets of $2,250,000, and a hurdle rate of 11 percent.

1. Determine Solano’s return on investment (ROI), investment turnover, profit margin, and residual income. (Do not round your intermediate calculations. Enter your ROI and Profit Margin percentage answer to the nearest 2 decimal places, (i.e., 0.1234 should be entered as 12.34%). Round your Investment Turnover answer to 4 decimal places.)

2. Several possible changes that Solano could face in the upcoming year follow. Determine each scenario’s impact on Solano’s ROI and residual income. (Note: Treat each scenario independently.) (Enter your ROI percentage answers to 2 decimal places, (i.e., 0.1234 should be entered as 12.34%.))

a. Company sales and cost of goods sold increase by 40 percent. (Find ROI and Residual income)

b. Operating expenses decrease by $11,000. (Find ROI and Residual income)

c. Operating expenses increase by 20 percent. (Find ROI and Residual income)
d. Average invested assets increase by $430,000. (Find ROI and Residual income)

e. Solano changes its hurdle rate to 17 percent. (Find ROI and Residual income)

Solutions

Expert Solution

Operating income = Sales - COGS - operating Expenses

= 760000 - 500000 - 40000 = 220000

1. ROI = Net Operating income / Average Invested assets

= 220000/2250000*100

= 9.78%

Investment Turnover = sales/ investment = 760000/2250000 = .338

Profit margin is same as net operating income due to no taxes given

Residual Income = Net Operating income - ( Average Invested assets * hurdle rate )

= 220000 - (2250000*11%)

= $-27500

2 a.

Operating income = Sales - COGS - operating Expenses

= 760000*1.4 - 500000*1.4 - 40000 = 324000

ROI = Net Operating income / Average Invested assets

= 324000/2250000*100

= 14.4%

Residual Income = Net Operating income - ( Average Invested assets * hurdle rate )

= 324000 - (2250000*11%)

= $ 76500

Operating income = Sales - COGS - operating Expenses

= 760000 - 500000 - (40000-11000) = 231000

ROI = Net Operating income / Average Invested assets

= 231000/2250000*100

= 10.27%

Residual Income = Net Operating income - ( Average Invested assets * hurdle rate )

= 231000 - (2250000*11%)

= $-16500

Operating income = Sales - COGS - operating Expenses

= 760000 - 500000 - (40000*1.2) = 212000

ROI = Net Operating income / Average Invested assets

= 212000/2250000*100

= 9.42%

Residual Income = Net Operating income - ( Average Invested assets * hurdle rate )

= 212000 - (2250000*11%)

= $-35500

Operating income = Sales - COGS - operating Expenses

= 760000 - 500000 - 40000 = 220000

ROI = Net Operating income / Average Invested assets

= 220000/(2250000+430000)*100

= 8.21%

Residual Income = Net Operating income - ( Average Invested assets * hurdle rate )

= 220000 - (2680000*11%)

= $-74800

Operating income = Sales - COGS - operating Expenses

= 760000 - 500000 - 40000 = 220000

ROI = Net Operating income / Average Invested assets

= 220000/2250000*100

= 9.78%

Residual Income = Net Operating income - ( Average Invested assets * hurdle rate )

= 220000 - (2250000*17%)

= $-162500

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Solano Company has sales of $700,000, cost of goods sold of $470,000, other operating expenses of...

Solano Company has sales of $700,000, cost of goods sold of $470,000, other operating expenses of $50,000, average invested assets of $2,100,000, and a hurdle rate of 9 percent. Required: 1. Determine Solano’s return on investment (ROI), investment turnover, profit margin, and residual income. 2. Several possible changes that Solano could face in the upcoming year follow. Determine each scenario’s impact on Solano’s ROI and residual income. (Note: Treat each scenario independently.) a. Company sales and cost of goods sold...

Solano Company has sales of $720,000, cost of goods sold of $480,000, other operating expenses of...

Solano Company has sales of $720,000, cost of goods sold of $480,000, other operating expenses of $45,000, average invested assets of $2,150,000, and a hurdle rate of 10 percent. 1. Determine Solano’s return on investment (ROI), investment turnover, profit margin, and residual income. (Do not round your intermediate calculations. Enter your ROI and Profit Margin percentage answer to the nearest 2 decimal places, (i.e., 0.1234 should be entered as 12.34%). Round your Investment Turnover answer to 4 decimal places.) Return...

Solano Company has sales of $720,000, cost of goods sold of $480,000, other operating expenses of...

Solano Company has sales of $720,000, cost of goods sold of $480,000, other operating expenses of $45,000, average invested assets of $2,150,000, and a hurdle rate of 10 percent. Required: 1. Determine Solano’s return on investment (ROI), investment turnover, profit margin, and residual income. (Do not round your intermediate calculations. Enter your ROI and Profit Margin percentage answer to the nearest 2 decimal places, (i.e., 0.1234 should be entered as 12.34%). Round your Investment Turnover answer to 4 decimal places.)...

Solano Company has sales of $840,000, cost of goods sold of $540,000, other operating expenses of...

Solano Company has sales of $840,000, cost of goods sold of $540,000, other operating expenses of $70,000, average invested assets of $2,450,000, and a hurdle rate of 11 percent. Required: 1. Determine Solano’s return on investment (ROI), investment turnover, profit margin, and residual income. (Do not round your intermediate calculations. Enter your ROI and Profit Margin percentage answer to the nearest 2 decimal places, (i.e., 0.1234 should be entered as 12.34%). Round your Investment Turnover answer to 4 decimal places.)...

Solano Company has sales of $800,000, cost of goods sold of $520,000, other operating expenses of...

Solano Company has sales of $800,000, cost of goods sold of $520,000, other operating expenses of $35,000, average invested assets of $2,350,000, and a hurdle rate of 11 percent. 2. Several possible changes that Solano could face in the upcoming year follow. Determine each scenario’s impact on Solano’s ROI and residual income. (Note: Treat each scenario independently.) (Enter your ROI percentage answers to 2 decimal places, (i.e., 0.1234 should be entered as 12.34%.)) a. Company sales and cost of...

Solano Company has sales of $820,000, cost of goods sold of $530,000, other operating expenses of...

Solano Company has sales of $820,000, cost of goods sold of $530,000, other operating expenses of $60,000, average invested assets of $2,400,000, and a hurdle rate of 11 percent. Required: 1. Determine Solano’s return on investment (ROI), investment turnover, profit margin, and residual income. (Do not round your intermediate calculations. Enter your ROI and Profit Margin percentage answer to the nearest 2 decimal places, (i.e., 0.1234 should be entered as 12.34%). Round your Investment Turnover answer to 4 decimal places.)...

Solano Company has sales of $800,000, cost of goods sold of $520,000, other operating expenses of...

Solano Company has sales of $820,000, cost of goods sold of $530,000, other operating expenses of...

Solano Company has sales of $820,000, cost of goods sold of $530,000, other operating expenses of $60,000, average invested assets of $2,400,000, and a hurdle rate of 11 percent. 2. Several possible changes that Solano could face in the upcoming year follow. Determine each scenario’s impact on Solano’s ROI and residual income. (Note: Treat each scenario independently.) a. Company sales and cost of goods sold increase by 30 percent. b. Operating expenses decrease by $11,000. c. Operating expenses increase by...

Kaler Company has sales of $1,410,000, cost of goods sold of $785,000, other operating expenses of...

Kaler Company has sales of $1,410,000, cost of goods sold of $785,000, other operating expenses of $198,000, average invested assets of $4,400,000, and a hurdle rate of 11 percent. Required: 1. Determine Kaler’s return on investment (ROI), investment turnover, profit margin, and residual income. (Do not round your intermediate calculations. Enter your ROI and Profit Margin answer to the nearest whole percentage, (i.e., 0.1234 should be entered as 12%). Round your Investment Turnover answers to 4 decimal places.) Please calculate...

Kaler Company has sales of $1,450,000, cost of goods sold of $795,000, other operating expenses of...

Kaler Company has sales of $1,450,000, cost of goods sold of $795,000, other operating expenses of $208,000, average invested assets of $4,600,000, and a hurdle rate of 12 percent. Required: 1. Determine Kaler’s return on investment (ROI), investment turnover, profit margin, and residual income. 2. Several possible changes that Kaler could face in the upcoming year follow. Determine each scenario’s impact on Kaler’s ROI and residual income. (Note: Treat each scenario independently.) a. Company sales and cost of goods sold...

Subjects