for formulas and calculations, refer to the image below -
C2 segment segment A segment B segment C segment D segment E 457,000 305,000 $ 104,00077,300 420,000 68,550 $ 6,100 S 1,000,000 1,546,000 3,024,000 sales revenue operating income tax rate total assets current liabilities corporate required return weighted average cost of capital margin asset turnover return on investments residual income economic value added 4 30% 25% 20% 31.00% 20% $ 530,000 515,333 1,400,000 571,250 124,460 40,130$ 10,580 42,200 S 46.,800 S 1 $ 141,333 15% 12% 10.40% 1.89 19.62% 18% 14% 5.00% 3.00 15.00% 20% 15% 13.89% 2.16 30.00% 12.00% 10% 15.00% 0.80 12.00% 20% 18% 2.00% 2.45 4.90% $ (18,792) 10 12 13 14 15 16 17 18 $ 140,000 24,500 (15,460) $ 14,264 $(7,620) $ 147,200(5,813) $ (15,618) EVA = (Operating income * (1-tax rate))-((Total Assets-Current Liabilities) * Weighted average cost of capital)
segment A segment B 1546000 E11*E6 -оз"D10 1420000 0.25 D3/D11 1400000 46800 0.18 0.14 0.05 segment A segment C segment D segment E 1000000 104000 0.3 530000 42200 0.15 457000 68550 -1-((F14+((F6-F7)*F9))/F4) 0.2 571250 305000 sales revenue operating income tax rate total assets current liabilities corporate required return weighted average cost of capital 0.12 margin asset tumover return on investments residual income economic value added -G3 G10 0.2 124460 10580 0.2 0.18 0.02 2.45 -G4/G6 (((E4 (1-E5)-E14)/E9)-E6) 40130 0.2 0.15 F4/F6 0.1 0.15 -F3/F6 0.12 0 C4/C3 -C3/C6 -C4/C6 E4/E3 2.16 10 12 13 14 15 16 17 18 -D4/D6 0.3 15460 |-7620 40000 18792 -c4*(1-C5)-((C6-C7)*C9) 147200 5813 G4 (1-G5)-((G6-G7) *G9) EVA = (Operating Income * (1-tax rate))-((Total Assets-Current Liabilities)" weighted average cost of capital)