FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT:Chapter 6 1. Retrieve the file HWChapter6 and solve Problem 6-9, Problem 6-10, using the organizational design displayed in the worksheet file. Do not modify the fonts, format, or cell addresses 2. Problem 6-9: Enter equations that solve for the values required in Cells C1l, C15, C19 3. Problem 6-10: Enter an equation that solves for the value required in Cell 26. Enter the appropriate value in Cell C29 Enter equations that solve for the values required in Cells C30, C32, C34 1 Problem 6-9 3 Corporate bond: tax rate on interest income 4 Municipal bond: tax rate on interest income 5 Preferred stock: tax rate on dividend income 6 Preferred stock: dividend income exclusion 7 Preferred stock: net tax rate on dividend income 35% 0% 35% 70% 10.50% -30(35) 9 Corporate Bond 10 11 yield after taxes 12 13 Municipal Bond 14 yield 15 vield after taxes 16 17 Preferred Stock 18 dividend vield 19 yield after taxes 20 21 22 Problem 6-10 23 24 Net cash flow (NCF)-Net income + Depreciation and amortization 25 26 27 28 29 30 31 32 eld 7.50% 5.00% 6.00% EBITDA DA EBIT S200,000 depreciation expense S750,000 The company is financed 100% with equity. Debt-$0 EBT T (40%) Net income DA NCF $0 S200,000 depreciation expense 34 3.5