Mon Apr 11 6:46 PM o Q Insert e Share Comments V Y O @ AY Sensitivity v Sort & Filter Find & Select Analyze Data M . N 0 Excel File Edit View Insert Format Tools Data Window Help OO AutoSave OFF AAC ... FIN 350 Exam 3 Home Draw Page Layout Formulas Data Review View Developer Tell me Calibrl (Body) v 11 ' ' == 2 Conditional Formatting v General Insert v = = = Format as Table 2 Delete v Paste v A * $ % ) $ Cell Styles Format v H12 fx A B C D E F G H T J L 1 780 Put in the three numbers from your email address here. 2 (Replace 123 with the three numbers in your KU email address.) 3 Yield to Maturity= 5.780% This yield should contain the three digits from your email address. 4 4 5 For this problem, assume the bond pays semiannual coupon payments as discussed in lecture (the videos). 6 What is the price of the bond based on these parameters? 7 5 year bond 8 The yield to maturity is in cell C3 9 Coupon rate is 6.5% 10 Par value is $1000 11 12 Price= Put your answer here. 13 You can use Excel functions or simply type in what you find with your calculator, 14 I recommend using Excel, but check your work with the calculator. 15 Note: there are five tabs to complete! 16 17 18 19 20 Bond Valuation Part 1 Ch. 7 Bond Valuation Part 2 Ch. 7 Cost of Equity Ch. 8 Stock Valuation Part 1 Ch.9 Stock Valuation Part 2 Ch.9 Ready 17 + TI 152% APR 11 w "L