Write a VBA program that does the following: A bank offers different interest rates on deposit accounts based on the size of the periodic deposit (CF). The first deposit is today. Write a future value function BankFV(CF, r, n) based on the following interest rates:

Periodic deposit Interest rate

<= $100.00 r

$100.01 to $499.99 r + 0.5%

$500.00 to $999.99 r + 1.1%

$1,000.00 to $4,999.99 r + 1.7%

>= $5,000 r + 2.1%

Please outline the code