Instructions in photos
BOND DATA ISIN Name Country SSUEANCE Issuer Issue Volume US713448DF24 PEPSICO INC. 16/26 USA PepsiCo Inc 750,000,000 USD 99.92 Issue Price Issue Date 2/24/20 COUPON Coupon Denomination Quotation Type Payment Type Special Coupon Type Maturity Date Coupon Payment Date Payment Frequency No of Payments per Year Coupon Start Date Final Coupon Date 2.850% 1000 regular interest 2/24/2026 8/24/2019 2.0 Picture 8/24/2016 No Floater? Objectives on this tab: 1 Calculate the amount you would pay 2 Consider Tax Implications 3 Consider having a good time doing this 1 Assuming you were interested in taking the muni bond that matures in 2035 of February instead of the PEPSI nd on the previous tab, what would be the price you think it would trade for today?(Use the information on the right, as well as the assumption that these are annual bonds) PV I/Y PMT FV 2 Let's also assume that you are into paying less in taxes, using the chart below, what tax e would you be indifferent to the two bonds? (Highlight the closest tax rate) PEPSI YTM MUNI YTM After Tax Table: Tax Rate 20% 25% 30% 35% 40% 45% 50% 55% After Tax Yield 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 65% 70% 75% 80% Trade Time Security Description Coupon Price Yield Date Washingon Caty P3enb 2019 Septemb 3.000% 100.655 1.700 er 5.57pm Allegheny Cnty Pa Higher Ed Mellon Univ A Allegheny Cty Pa Higher Ed 2024 5.000% March 5:25pmBidg Auth Rev Ref Carnegie 5.000% 108.693 2.000 ture Bidg Auth Rev Ref Carnegie 5000% 5:25pm 5000% 108.693 2.000 March Mellon Univ A 512pm 0 Washington Cnty Pa 2019- Septemb 3.000% 100.655 1.700 er Pittsburgh & Allegheny Cnty Pa Sports & Exhib Auth Hotel Room Excise Tax Rev Ref 2035 5,000% February 5:12pm 5.000% 105.4 1.146 BOND DATA ISIN Name Country SSUEANCE Issuer Issue Volume US713448DF24 PEPSICO INC. 16/26 USA PepsiCo Inc 750,000,000 USD 99.92 Issue Price Issue Date 2/24/20 COUPON Coupon Denomination Quotation Type Payment Type Special Coupon Type Maturity Date Coupon Payment Date Payment Frequency No of Payments per Year Coupon Start Date Final Coupon Date 2.850% 1000 regular interest 2/24/2026 8/24/2019 2.0 Picture 8/24/2016 No Floater? Objectives on this tab: 1 Calculate the amount you would pay 2 Consider Tax Implications 3 Consider having a good time doing this 1 Assuming you were interested in taking the muni bond that matures in 2035 of February instead of the PEPSI nd on the previous tab, what would be the price you think it would trade for today?(Use the information on the right, as well as the assumption that these are annual bonds) PV I/Y PMT FV 2 Let's also assume that you are into paying less in taxes, using the chart below, what tax e would you be indifferent to the two bonds? (Highlight the closest tax rate) PEPSI YTM MUNI YTM After Tax Table: Tax Rate 20% 25% 30% 35% 40% 45% 50% 55% After Tax Yield 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 65% 70% 75% 80% Trade Time Security Description Coupon Price Yield Date Washingon Caty P3enb 2019 Septemb 3.000% 100.655 1.700 er 5.57pm Allegheny Cnty Pa Higher Ed Mellon Univ A Allegheny Cty Pa Higher Ed 2024 5.000% March 5:25pmBidg Auth Rev Ref Carnegie 5.000% 108.693 2.000 ture Bidg Auth Rev Ref Carnegie 5000% 5:25pm 5000% 108.693 2.000 March Mellon Univ A 512pm 0 Washington Cnty Pa 2019- Septemb 3.000% 100.655 1.700 er Pittsburgh & Allegheny Cnty Pa Sports & Exhib Auth Hotel Room Excise Tax Rev Ref 2035 5,000% February 5:12pm 5.000% 105.4 1.146
