1 Hard-code numbers/repsonses use equations/functions to compute Find Ford Motor Company bonds (you know how to do this, remember how we got CISCO? Now, find the "F.GL" Corporate bond. Assume today is 12/31/2020 for purposes of the example. You must show/label pertinent information of the bond (i.e. coupon payment, face value, etc.) employing formulas in as many settings as possible (I have to be able 2 to follow all that you do). 1) Please provide a visual representation of the entire original life of the bond AND the remaining life of the bond. 3 (consider this boc both blue and beige- no particular expectation) 4 Coupon rate 5 Maturity Date 6 Offering Date 7 Current Date 8 Face Value 9 Annual Coupon 10 11 Original Bond Life 12 periods 0 1 through 99 100 13 Cash Flow 14 Current Bond Life 15 periods 0 1 through 44 45 45 13 Cash Flow 14 Current Bond Life 15 periods 0 1 through 44 16 Cash Flow 17 18 19 20 21 Additional Questions 22 2) What is the coupon rate on the bond? Answers 23 3) What is the annual coupon payment on the bond? What is the annual coupon mean, simply? 24 4) What is the maturity date of the bond? 25 5) What is the current yield on the bond based on the October 19, 2020 trades? 26 6) Is this bond rated investment grade or speculative grade? 27 7) How much money was raised by Ford in this issuance? 28 8) Does Ford receive cash flows from bondholders after Time 0? 1 Hard-code numbers/repsonses use equations/functions to compute Find Ford Motor Company bonds (you know how to do this, remember how we got CISCO? Now, find the "F.GL" Corporate bond. Assume today is 12/31/2020 for purposes of the example. You must show/label pertinent information of the bond (i.e. coupon payment, face value, etc.) employing formulas in as many settings as possible (I have to be able 2 to follow all that you do). 1) Please provide a visual representation of the entire original life of the bond AND the remaining life of the bond. 3 (consider this boc both blue and beige- no particular expectation) 4 Coupon rate 5 Maturity Date 6 Offering Date 7 Current Date 8 Face Value 9 Annual Coupon 10 11 Original Bond Life 12 periods 0 1 through 99 100 13 Cash Flow 14 Current Bond Life 15 periods 0 1 through 44 45 45 13 Cash Flow 14 Current Bond Life 15 periods 0 1 through 44 16 Cash Flow 17 18 19 20 21 Additional Questions 22 2) What is the coupon rate on the bond? Answers 23 3) What is the annual coupon payment on the bond? What is the annual coupon mean, simply? 24 4) What is the maturity date of the bond? 25 5) What is the current yield on the bond based on the October 19, 2020 trades? 26 6) Is this bond rated investment grade or speculative grade? 27 7) How much money was raised by Ford in this issuance? 28 8) Does Ford receive cash flows from bondholders after Time 0
