chapter 11 only tabs at bottom of worksheet
0.12 20 50000 7.4690000000000003 50000 7.4690000000000003 373450 0.2 5 -2000 2000 2.488 4976 2.488 0.15 3 4976 4976 1.5209999999999999 7568.5 1.5209999999999999 0.08 11 2000 15.645 2000 15.645 31290 1000 0.11 30 770.33 0.14000000000000001 110 20 7.0030000000000001 790.33 0.02 1000 0.11 15 675.62 0.14000000000000001 110 140 6.1420000000000003 815.62 0.14000000000000001 1000 0.11 1 96.47 0.14000000000000001 110 877 0.877 973.47 0.877 1000 0.03 0.12 0.05 20 0.04 0.1 0.1 120 8.5139999999999993 0.03 0.14899999999999999 0.03 0.03 0.04 0.1 1021.68 149 1170.68 8 0.08 0.06 0.08 0.1 0.2 0.12 0.35 0.106 0.35 4.4000000000000004 50 2 0.35 7.0000000000000007E-2 0.15 0.1 0.5 0.13 Western Sweepstakes Discount Rate = i Periods = n Annuity PVIFA Solution: A = PVA Bruce Sutter PV FVIF FV Present Value of Investment Information FVIFA FVA PVIF Total Present Value or Price of the Bond = Present Value of Principal Payment at Maturity = Annuity = A Present Value of Principal Payment at Maturity = FV * PVIF Yield to Maturity = i Present Value of Interest Payments = Time to Maturity=n Present Value of Interest Payments = A * PVIFA Interest Par Value c) b) a) Total Return Risk Premium Inflation Rate Real Rate of Return Inflation Rate in 5 years Tom Cruise Lines, Inc. Price of Preferred Stock CURRENT VALUE ORIGINAL PRICE New Required Rate of Return Original Required Rate of Return Annual Dividend North Pole Cruise Lines United Business Forms Capital Structure Debt Aftertax Cost of Debt Preferred Stock Cost of Preferred Stock Common Equity Cost of Common Equity Cost (aftertax) Weights Weighted Cost Debt (Kd) Preferred Stock (Kp) Common Equity (Ke) Name: FINC 400 Principles of Financial Management Complete the following problems: Problem 9-17 Problem 9-19 Problem 9-27 Problem 10-6 Problem 10-13 Problem 10-24 Problem 11-19 Week 4 Homework Problems Example: FinanceA-FINC400-4 Problem 9-17 – Refer to problems at…
Attachments:
pollockashlee….xlsx