A B D E Hard-code numbers/repsonses F G H use equations/functions to compute 1 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 2 settings as possible (I have to be able 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 3 the bond. (consider this boc both blue and beige- no particular expectation) 4 Coupon rate 7.75% 5 Maturity Date 6/15/2043 6 Offering Date 6/10/1993 7 Current Date 8 Face Value 9 Annual Coupon $ 77.50 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 16 Cash Flow 17 18 19 20 21 Additional Questions 22 2) What is the coupon rate on the bond? Answers 7.75% 15-Jun-43 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? 277) How much money was raised by Ford in this issuance? 28 8) Does Ford receive cash flows from bondholders after Time 0? Speculative Bond Detail Lockup Symbol: F FORD MTR CO DEL ADD TO WATCHLIST Maturity Date Symbol Next Call Date Callable Coupon Rate 7.750% 06/15/2043 F.GL CUSIP 345370BM Last Trade Price Last Trade Yield Last Trade Date us Treasury $122.89 5.888% 04/01/2021 Yield Trade History Price/Yield Chart Classification Elements Price Chart Yield Chart Bond Type 04/01/2021 2: SD 1M 3M YTD 1Y BY SY 10Y Max Debt Type Price US Corporate Debentures Senior Unsecured Debenture Industrial Manufacturing CORP Corporate Bond Industry Group Industry Sub Group Sub-Product Asset Sub-Product Asset Type State Use of Proceeds Security Code Pris 120.00 100.00 Special Characteristics Medium Term Note N 80.00 Issue Elements 60.00 2016 2017 2018 2019 2020 06/10/1993 06/15/1993 12/15/1993 $200,000.00 $72,653.00 Credit and Rating Elements BOE (03/25/2020) B8+ (03/25/2020) High Yield Moody's Rating Standard & Poor's Rating TRACE Grade Default Bankruptcy Insurance Mortgage Insurer Pre-Refunded/Escrowed Additional Description Offering Date Dated Date First Coupon Date Original Offering Amount Outstanding Series Issue Description Project Name Payment Frequency Day Count Form Depository/Registration N Semi-Annual 30/360 Book Entry Depository Trust Company Senior Senior Unsecured Debenture Security Level Collateral Pledge Capital Purpose dollar amount in thousands Put & Redemption Provisions Call Date Call Price Call Frequency Bond Elements 200,000.00 72,653.00 Put Date Put Price Put Frequency Original Maturity Size Amount Outstanding Size Yield at Offering Price at Offering Coupon Type Escrow Type dollar amount in thousands 7.86% $98.68 Fived A B D E Hard-code numbers/repsonses F G H use equations/functions to compute 1 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 2 settings as possible (I have to be able 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 3 the bond. (consider this boc both blue and beige- no particular expectation) 4 Coupon rate 7.75% 5 Maturity Date 6/15/2043 6 Offering Date 6/10/1993 7 Current Date 8 Face Value 9 Annual Coupon $ 77.50 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 16 Cash Flow 17 18 19 20 21 Additional Questions 22 2) What is the coupon rate on the bond? Answers 7.75% 15-Jun-43 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? 277) How much money was raised by Ford in this issuance? 28 8) Does Ford receive cash flows from bondholders after Time 0? Speculative Bond Detail Lockup Symbol: F FORD MTR CO DEL ADD TO WATCHLIST Maturity Date Symbol Next Call Date Callable Coupon Rate 7.750% 06/15/2043 F.GL CUSIP 345370BM Last Trade Price Last Trade Yield Last Trade Date us Treasury $122.89 5.888% 04/01/2021 Yield Trade History Price/Yield Chart Classification Elements Price Chart Yield Chart Bond Type 04/01/2021 2: SD 1M 3M YTD 1Y BY SY 10Y Max Debt Type Price US Corporate Debentures Senior Unsecured Debenture Industrial Manufacturing CORP Corporate Bond Industry Group Industry Sub Group Sub-Product Asset Sub-Product Asset Type State Use of Proceeds Security Code Pris 120.00 100.00 Special Characteristics Medium Term Note N 80.00 Issue Elements 60.00 2016 2017 2018 2019 2020 06/10/1993 06/15/1993 12/15/1993 $200,000.00 $72,653.00 Credit and Rating Elements BOE (03/25/2020) B8+ (03/25/2020) High Yield Moody's Rating Standard & Poor's Rating TRACE Grade Default Bankruptcy Insurance Mortgage Insurer Pre-Refunded/Escrowed Additional Description Offering Date Dated Date First Coupon Date Original Offering Amount Outstanding Series Issue Description Project Name Payment Frequency Day Count Form Depository/Registration N Semi-Annual 30/360 Book Entry Depository Trust Company Senior Senior Unsecured Debenture Security Level Collateral Pledge Capital Purpose dollar amount in thousands Put & Redemption Provisions Call Date Call Price Call Frequency Bond Elements 200,000.00 72,653.00 Put Date Put Price Put Frequency Original Maturity Size Amount Outstanding Size Yield at Offering Price at Offering Coupon Type Escrow Type dollar amount in thousands 7.86% $98.68 Fived