Using only the input data highlighted in green on the tab create a macro in Visual...

 

 

Transcribed Image Text:

Using only the input data highlighted in green on the tab create a macro in Visual Basic for Applications (VBA) that uses a For Next loop to calculate the Price (at time 0) of a semi-annual coupon paying bond with the following set of semi-annual cash flows. To receive full credit for this question you must keep the data structure/locations (in green) as given to you in the Excel template. Six Month YTM Time Period 1 IN 3 st in 197 2 4 3 $ 5 7 86555GEERE 600 9 6 $ 10 11 12 13 14 15 16 17 18 $ 19 20 $ $ $ $ $ $ $ 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 $ 25.00 25.00 25.00 $ $ $ $ $ Cash Flow $ 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 $ 1,025.00 2.2500% Now suppose that there are 184 days in the upcoming six month coupon period. What will be the clean price of the bond 87 days from now? Answer this question by creating a macro in Visual Basic for Applications using only the data highlighted in green below provided on the tab and the price of the bond (at time 0) that you calculated in Problem (in yellow): above Days in Coupon Period # of days in future Price = Six Month YTM Time Period 1 $ Cash Flow 25.00 184 87 2.2500% Using only the input data highlighted in green on the tab create a macro in Visual Basic for Applications (VBA) that uses a For Next loop to calculate the Price (at time 0) of a semi-annual coupon paying bond with the following set of semi-annual cash flows. To receive full credit for this question you must keep the data structure/locations (in green) as given to you in the Excel template. Six Month YTM Time Period 1 IN 3 st in 197 2 4 3 $ 5 7 86555GEERE 600 9 6 $ 10 11 12 13 14 15 16 17 18 $ 19 20 $ $ $ $ $ $ $ 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 $ 25.00 25.00 25.00 $ $ $ $ $ Cash Flow $ 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 $ 1,025.00 2.2500% Now suppose that there are 184 days in the upcoming six month coupon period. What will be the clean price of the bond 87 days from now? Answer this question by creating a macro in Visual Basic for Applications using only the data highlighted in green below provided on the tab and the price of the bond (at time 0) that you calculated in Problem (in yellow): above Days in Coupon Period # of days in future Price = Six Month YTM Time Period 1 $ Cash Flow 25.00 184 87 2.2500%

Answer rating: 100% (QA)

VBA Macro for Bond Price Calculation vba Sub CalculateBondPrice Declare variables Dim ytm As Double ... View the full answer