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