Create your macro-enabled Excel file that does the following:

Part 1: An investment company offers a bond linked to a stock market index. On redemption, the bond pays the face value plus the larger of:

a) The face value times the change in the index (discrete compounding).

b) 6% annual interest compounded monthly.

For example, $100 invested when the index was 110 and redeemed 1 year later when the index was 125 will pay:

a) 125/110 * 100 = $113.636, and not,

b) 100 * (1 + 0.06/12)^(12 * 1 Year) = $106.17

Implement a VBA function Bond (Deposit, Years, BeginningIndexValue, EndingIndexValue).

Create a table to test out your user-defined function. Vary the number of years, beginning and ending index values, and deposit amount.