FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 11 1. Retrieve the file HWChapter1l and solve Problem 11-2, Problem 11-3 and Problem 11-7 using the organizational design displayed in the worksheet file. Do not modify the fonts, format, or cell addresses. 2. Problem 11-7: Enter an equation that solves for the value required in Cell C33. 3. Problem 11-7: Enter values in Cells c36:C38 for the current (not Target) financing weights (proportions) Capital structure. 4. Problem 11-7: Enter an equation that solves for the value required in Cell C41. Apply the Current (not Target) financing weights entered in Part 7 and retain the values reported in Cells C29:C32. 9. Print the worksheet. view InsertPage Layout Formulas Data Review ome a %, bFormat aal Formatting , -, A.. ' Format as Table Cell Styles Editing Cells Alignment Number Font ste 8 Problem 11-7 urren 30% wa 5% w 65% ws Debt $300 6 Preferred stock $50 27 Common equity $250 28 29 30 31 32 Tax rate 40% 12% r, WACC- 34 35 What is the company's Current capital structure? 36 37 38 39 40 Calculate the weighted average cost of capital (WACC) using the Current weights. 41 WACC 42 43