complete the yellow area

File Home Insert Page Layout Formulas Data Review View Help Share Comments Calibri 11 AA General AY X Cut (6 Copy & Format Painter AutoSum Fill Clear 5 === a Wrap Text IEEE Merge & Center Paste BIU A Ideas Insert Delete Format $ % 8 28 Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas D15 X G . J K L M N A B E F 1 Solar Cells, Inc. is considering the acquisition of two startups: Batteries 4 Future or Capacity LLC. 2 Batteries 4 Future Capacity LLC 3 Equity: 2000000 Equity: 4. Operating profit: 400000 Operating profit: 5 itr= 10% itr= 6 CoC= 12% CoC= 7 Tax rate= Tax rate= 8 900000 200000 10% 14% 25% 25% 9 10 Complete the sections highlighted in yellow and answer the questions below. 11 ROE perspective: EVA perspective: 12 NOPAT (Batteries 4 Future)= CoC(Batteries 4 Future)= 13 NOPAT(Capcity LLC) COC(Capacity LLC)= 14 ROE(Batteries 4 Future)= EVA(Batteries 4 Future)= 15 ROE(Capcity LLC)= EVA(Capacity LLC)= 16 17 Based on ROE, which startup is more attractive? Based on EVA, which startup is more attractive? 18 19 20 Problem 1 Problem 2 Problem 3 + Ready --- 1 130%