Question

Would you be able to solve this Finance problem in microsoft excel?

F30 X fr Balance Sheet Value Market Value Cost of Capital Component Debi Preferred Stock Common Stock F Su the total values in the yellow cell See 1519 for pl Ajented WACC Marko Vater Weights Book Valse Weights Debt Preferred Stock calculate the weight of each component based on booke see cell 16 for me calculate the we of each component based on market Market Book Ve Preferred Stock in 1 117. Be ware toeste WACC. which cause the aero de ERRRRRRRR CHECK TIGERE ADJUSTED WACC ENING MARKET VALLE 9.09 Instructions Problem 3 WACC Problem 1 NPV Problem 2 Payback

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

ALL CELL REFERENCES ARE ALSO PROVIDED

- 2x Σ AutoSum : A Insert Delete Format Cell Styles Clear Sort & Filter Editing Find & Select Cells ke - Microsoft Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View Add-Ins % Cut Calibri -11AA = = = Dr Wrap Text General Ea Copy Paste BIU - D A E E E s Fat Merce Merge & Center - Center $ Format Painter % % , , .0 .00 :.: Conditional Format Formatting as Table Clipboard Font Alignment Number Styles F3 - fx A B C D E F 2 3 4 COMPONENT BALANCESHEET VALUE MARKET VALUE COST OF CAPITAL TAX 5 DEBT 5000000 6850000 8% 30% 6 PREFERRED STOCK 4000000 2200000 10% 7 COMMON STOCK 2000000 5600000 13% 11000000 14650000 G H I J 11 12 13 14 15 BOOK VALUE WEIGHTS 16 DEBT 17 PREFERRED STOCK 18 COMMON STOCK 19 20 21 22 HIN NAME DIV YIELD ETEMADI beta Rea ferences 45.45% (=B5/B8] 36.36% (=B6/B8] 18.18% (=B7/B8] MARKET VALUE WEIGHTS DEBT PREFERRED STOCK COMMON STOCK 46.76% (=C5/C8] 15.02% (=C6/C8] 38.23% (=C7/08] (=E16*D5*(1-E5)+E17*D6+E18*D7] ANSWERS ADJUSTED WACC MARKET VALUE 9.09% BOOK VALUE 8.55% [=B16*D5*(1-E5)+B17*D6+B18*D7] Sheet2 DOUBLE Sheet4 Sheets Sheets Sheet7 Sheets Sheet9 ORGANIC PRODUCE WACC Sheet10 Sheet11 ► Sheet1 BO. 120% ODER 9 * * ENG 09-10-2019