I need some one to work on the problem attached please

Using market value and book value (separately), find the adjusted WACC, using 30% tax rate. Component Debt Preferred Stock Common Stock Balance Sheet Value 5,000,000.00 4,000,000.00 2,000,000.00 $11,000,000.00 =SUM(B5:B7) Refer to the Solved Example 6 on Page 370 of your text. Book Value Weights Debt 45.45% Preferred Stock 36.36% Common Stock 18.18% FORMULAS Debt Preferred Stock Common Stock =B5/B8 =B6/B8 =B7/B8 Market Value 6,850,000.00 2,200,000.00 5,600,000.00 $14,650,000.00 =SUM(C5:C7) CC, using 30% tax rate. Cost of Capital 8% 10% 13% TAX 31% ANSWER Market Value Weights Debt 46.76% Preferred Stock 15.02% Common Stock 38.23% Adjusted WACC Market Value Book Value FORMULAS Debt Preferred Stock Common Stock FORMULAS =C5/C8 =C6/C8 =C7/C8 Market Value Book Value ANSWER Adjusted WACC FORMULAS Your company is considering three independent projects. Given the following cash flow information, calculate the If your company requires a three-year payback before an investment can be accepted, which project(s) would be a Cost Inflow year 1 Inflow year 2 Inflow year 3 Inflow year 4 Inflow year 5 Payback Period Project D 205,000.00 53,000.00 50,000.00 48,000.00 30,000.00 24,000.00 5 years Project E 179,000.00 51,000.00 87,000.00 41,000.00 52,000.00 40,000.00 3years Answer: Refer to the Solved Example 1 on Page 272 of your text. Calculations Year 1 Year 2 Year 3 Year 4 Year 5 $152,000.00 $102,000.00 $54,000.00 $24,000.00 $0.00 $128,000.00 $41,000.00 $0.00 -$52,000.00 -$92,000.00 Formulas Year 1 Year 2 Year 3 Year 4 Year 5 =B5-B6 =B19-B7 =B20-B8 =B21-B9 =B22-B10 =C5-C6 =C19-C7 =C20-C8 =C21-C9 =C22-C10 wing cash flow information, calculate the payback period for each. e accepted, which project(s) would be acCepted? Project F 110,000.00 25,000.00 55,000.00 21,000.00 9,000.00 35,000.00 4 years $85,000.00 $30,000.00 $9,000.00 $0.00 -$35,000.00 =D5-D6 =D19-D7 =D20-D8 =CD1-D9 =D22-D10