Using Visual Basic for Applications (VBA), and only the input data given below, create a macro...

Transcribed Image Text:

Using Visual Basic for Applications (VBA), and only the input data given below, create a macro in Excel that calculates the Macauley's Duration for the given bond using a For Next loop. The inputs for the macro code should be restricted to the data in green below: $ 69 69 69 69 69 69 9.38 9.38 $ 9.38 $ 9.38 $ 9.38 $1,009.38 Cash Flow $ Time Period Price = Asked yield 1 2 3 456 2.345 Problem #4 (20 points) PV of Cash Flow 9.27 9.16 9.05 8.95 8.84 941.19 986.4610 For the same bond, create a separate macro that calculates the Modified Duration. For this problem you may use only the information in green above, as well as the Macauley's Duration you calculate in Problem #3. Using Visual Basic for Applications (VBA), and only the input data given below, create a macro in Excel that calculates the Macauley's Duration for the given bond using a For Next loop. The inputs for the macro code should be restricted to the data in green below: $ 69 69 69 69 69 69 9.38 9.38 $ 9.38 $ 9.38 $ 9.38 $1,009.38 Cash Flow $ Time Period Price = Asked yield 1 2 3 456 2.345 Problem #4 (20 points) PV of Cash Flow 9.27 9.16 9.05 8.95 8.84 941.19 986.4610 For the same bond, create a separate macro that calculates the Modified Duration. For this problem you may use only the information in green above, as well as the Macauley's Duration you calculate in Problem #3.

Answer rating: 100% (QA)

Here is the VBA code to calculate Macauleys Duration and Modified Duration for the given bond us... View the full answer