Problem 1

i) Your company has just issued a $10,000 zero coupon bond. The issue date was Wednesday, April 20, 2022. The price of the bond at issue is estimated at $8,000. If the maturity of the bond is April 20, 2025.

A. Using cash flows, determine what is the current market rate (nominal annual)?

B. Using the market rate from point A and using the "price" formula, check that the current price of the bond is 8,000

ii) On December 30, 2020, the Colombian government had to issue debt to meet the spending needs to face the Covid 19 pandemic. The total debt issued in TES securities on this date was 20 million dollars and the issue was made up of 20,000 bonds of the same denomination. The bonds have a coupon rate of 6% per year and the coupons are paid quarterly until they mature on December 30, 2027. Proteccin SA took over 28% of the total issue, but since the market interest rate has risen to 8% due to inflation, Protection considers that holding these bonds is not profitable, for this reason, it wishes to sell all of these bonds. The estimated date for the sale is April 25, 2022. Your Boss at the Protection money desk wants to know how much money they would receive in such a sale (dirty price and clean price). You want to make the calculations using cash flows and using the Excel price formula to confirm that the figure given to your Boss is correct. What values should you give your Boss assuming that the year has 360 days?

if you cannot add excel file, add detailed photos with used formulas please