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 6/15/2022 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 to follow all that you do). 1) Please provide the information on the bond and complete the timeline representation of the entire original life of 4 the bond AND the remaining life of the bond 5 Coupon rate 7.75% Maturity Date 6/15/2043 7 Offering Date 6/10/1993 8 Current Date 6/15/2022 9 Face Value 1,000.00 10 Original Bond Price 986.80 11 Annual Coupon 77.50 12 13 Original Bond Life 14 periods 0 1 through 99 100 15 Cash Flow 16 Current Bond Life 17 periods 0 1 through 41 42 18 Cash Flow 19 20 21 22 23 Additional Questions Answers 24 2) Using your timeline and excel function, what was the YTM on the bond the day it was issued? % to 3 decimal places 25 3) Using your timeline and excel function, what is the calcualted YTM on the bond today? % to 3 decimal places 6 4) Using your timeline and excel function, what would be the price of the bond today if the YTM goes up to 9%%? 27 5) Calculate the current yield on the bond based on the October 18, 2022 trades? 28 6) Is this bond rated investment grade or speculative grade? 29 7) How much money was raised by Ford in this issuance? 30 8) Does Ford receive cash flows from bondholders after Time 0? 31