Find the "F.GL" Corporate bond from http://finra-markets.morningstar.com/BondCenter/Default.jsp

Assume today is 12/31/2020 for purposes of the example. You must show/label pertinent information of the bond employing formulas in as many settings as possible.

show how to do in Excel.

Transcribed Image Text:

Coupon rate Maturity Date Offering Date Current Date Face Value Annual Coupon Original Bond Life periods Cash Flow Current Bond Life periods Cash Flow 0 1 through 99 0 1 through 44 100 45 Coupon rate Maturity Date Offering Date Current Date Face Value Annual Coupon Original Bond Life periods Cash Flow Current Bond Life periods Cash Flow 0 1 through 99 0 1 through 44 100 45

Answer rating: 100% (QA)

1 Data Retrieval First youll need to extract the necessary data from the website including Coupon ra... View the full answer