B Cancel Chapter 10 Lab - PB 10-1, page 459 Enter formulas or descriptions in these fields Given data: Fence Brick Sales Cost of Goods Sold and Op. Exp. Income Fence $2,200,000 $1,700,000 $500,000 Brick $1,300,000 $1,000,000 $300,000 1 Margin Turnover ROI, Margin * Turnover Margin Turnover Average Assets $4,100,000 3,000,000 ROI, NOI/AOA Operating Income/Avg. Operating Assets Current Hurtle Rate New Hurtle Rate 12% 9% Residual Income 12% 9% 2.a. Operating income increase ROI Residual Income a. Operating income increase b. Operating income decrease c. Additional investment d. Additional income 10% 10% $400,000 $80,000 10% 10% $400,000 $80,000 2.b. Operating income decrease ROI Residual Income 2.c. Add'l. Invest & Income ROI Residual Income 2.d. New rate, old data ROI Residual Income