Ex 10-7 Name:
Enter the appropriate amounts in the shaded cells in column C and E.
1) ROI forYear 1 Furniture Division
Margin xTurnover
NOI x Sales
Sales Avg Op. Assets
x =
Margin xTurnover =ROI
x =
ROI for Year 2 Furniture Division
Margin xTurnover
NOI x Sales
Sales Avg Op. Assets
x =
Margin xTurnover =ROI
x =
2) ROI forYear 1 Houseware Division
Margin xTurnover
NOI x Sales
Sales Avg Op. Assets
x =
Margin xTurnover =ROI
x =
ROI for Year 2 Houseware Division
Margin xTurnover
NOI x Sales
Sales Avg Op. Assets
x =
Margin xTurnover =ROI
x =
Ex 10-7 Name: SOLUTION
Enter the appropriate amounts in the shaded cells in column C and E.
1) ROI forYear 1 Furniture Division
Margin xTurnover
NOI x Sales
Sales Avg Op. Assets
ROI for Year 2 Furniture Division
Margin xTurnover
NOI x Sales
Sales Avg Op. Assets
2) ROI forYear 1 Houseware Division
Margin xTurnover
NOI x Sales
Sales Avg Op. Assets
ROI for Year 2 Houseware Division
Margin xTurnover
NOI x Sales
Sales Avg Op. Assets
Ex 10-8 Name:
Enter the appropriate amounts in the shaded cells in columns D, F, H, and J.
1) ROI Espresso-Pro Mini-Prep
Operating income
Operating assets
ROI
2) ROI Add Add Add Both Maintain
Espresso-Pro Mini-Prep Projects Status Quo
Operating income
Avg. Op. assets
ROI
SOLUTION
Ex 10-8 Name:
Enter the appropriate amounts in the shaded cells in columns D, F, H, and J.
1) ROI Espresso-Pro Mini-Prep
Operating income 27,500$ 19,000$
Operating assets 250,000$ 200,000$
SOLUTION
Ex 10-9 Name:
Enter the appropriate amounts in the shaded cells in columns D, F, H, and J.
1) Residual Income
Espresso-Pro
Mini-Prep
Operating income
Less: Minimum income*
Residual Income
2) Add Add Add Both Maintain
Residual Income
Espresso-Pro
Mini-Prep Projects Status Quo
Operating income
Less: Minimum income*
Residual Income
* Minimum income = Operating assets x Minimum required rate of return
Ex 10-9 Name:
Enter the appropriate amounts in the shaded cells in columns D, F, H, and J.
1) Residual Income
Espresso-Pro
Mini-Prep
Operating income 27,500$ 19,000$
Less: Minimum income* 22,500 18,000
* Minimum income = Operating assets x Minimum required rate of return
SOLUTION
Espresso-Pro
Ex 10-10 Name:
Enter the appropriate amounts in columns D and F.
1) Source of capital After-tax cost
Bond rate + Premium
Common stock + =
(1 -tax rate) x int. rate
10-year bonds x =
Enter the appropriate amounts in columns F, H, and K.
Percent After-tax cost Weighted cost
Common stock x =
10-year bonds x =
Total
Weighted cost
x Equity employed
Weighted average cost of capital
Calculation of EVA
After-tax profit
Less: Weighted average cost of capital
EVA
2) Year 1 Percent After-tax cost Weighted cost
Common stock x =
10-year bonds x =
Total
Weighted cost
x Equity employed
Weighted average cost of capital
Calculation of EVA
After-tax profit
Less: Weighted average cost of capital
EVA
Year 2 Percent After-tax cost Weighted cost
Common stock x =
10-year bonds x =
Total
Weighted cost
x Equity employed
Weighted average cost of capital
Calculation of EVA
After-tax profit
Less: Weighted average cost of capital
EVA
3) Original data Percent After-tax cost Weighted cost
Common stock x =
10-year bonds x =
Total
Weighted cost
x Equity employed
Weighted average cost of capital
Calculation of EVA
After-tax profit
Less: Weighted average cost of capital
EVA
Year 1 Percent After-tax cost Weighted cost
Common stock x =
10-year bonds x =
Total
Weighted cost
x Equity employed
Weighted average cost of capital
Calculation of EVA
After-tax profit
Less: Weighted average cost of capital
EVA
Year 2 Percent After-tax cost Weighted cost
Common stock x =
10-year bonds x =
Total
Weighted cost
x Equity employed
Weighted average cost of capital
Calculation of EVA
After-tax profit
Less: Weighted average cost of capital
EVA
Ex 10-10 Name:
Enter the appropriate amounts in columns D and F.
1) Source of capital After-tax cost
Bond rate + Premium
Common stock 4% +12% =0.160
Enter the appropriate amounts in columns F, H, and K.
Percent After-tax cost Weighted cost
Common stock 45% x0.160 = 0.0720
10-year bonds 55% x0.036 = 0.0198
Calculation of EVA
After-tax profit 192,000$
2) Year 1 Percent After-tax cost Weighted cost
Common stock 45% x0.140 = 0.0630
10-year bonds 55% x0.036 = 0.0198
Calculation of EVA
After-tax profit 192,000$
Year 2 Percent After-tax cost Weighted cost
Common stock 45% x0.110 = 0.0495
10-year bonds 55% x0.036 = 0.0198
Calculation of EVA
After-tax profit 192,000$
3) Original data Percent After-tax cost Weighted cost
Common stock 80% x0.160 = 0.1280
10-year bonds 20% x0.036 = 0.0072
SOLUTION
Calculation of EVA
After-tax profit 375,000$
Less: Weighted average cost of capital 405,600
Year 1 Percent After-tax cost Weighted cost
Common stock 80% x0.140 = 0.1120
10-year bonds 20% x0.036 = 0.0072
Calculation of EVA
After-tax profit 375,000$
Less: Weighted average cost of capital 357,600
Year 2 Percent After-tax cost Weighted cost
Common stock 80% x0.110 = 0.0880
10-year bonds 20% x0.036 = 0.0072
Calculation of EVA
After-tax profit 375,000$
Ex 10-11 Name:
Enter the appropriate amounts in the shaded cells in columns D, F, and H.
1) Home Restaurant Speciality Total
Sales
Cost of goods sold
Gross profit
Selling & admin. Expenses
Division profit
Income taxes
After-tax income
2) After-Tax Weighted
Weighted Average Cost of Capital Percent Cost Cost
Common stock x
Bonds x
Weighted average cost of capital
3) Cost of capital Home Restaurant Specialty
Capital employed (000’s)
Weighted average cost of capital
Cost of capital
Economic Value Added Home Restaurant Specialty Total
After-tax income
Cost of capital
EVA
Xenold, Inc.
Income Statement (in thousands)
For the Year 20XX
Ex 10-11 Name:
Enter the appropriate amounts in the shaded cells in columns D, F, and H.
1) Home Restaurant Speciality Total
Sales 4,140$ 3,600$ 2,520$ 10,260$
Cost of goods sold 2,900 2,640 1,700 7,240
2) After-Tax Weighted
Weighted Average Cost of Capital Percent Cost Cost
Common stock 75% x0.090 0.0675
3) Cost of capital Home Restaurant Specialty
Capital employed (000’s) 2,600$ 1,700$ 740$
Weighted average cost of capital 0.0750 0.0750 0.0750
SOLUTION
Xenold, Inc.
For the Year 20XX
Income Statement (in thousands)