VBA

Complete this problem in Sheet3.

You deposit an initial amount of money P in a savings account. This money is called the "principal". In this account, you will earn interest on your money N times per year at an annual nominal rate R. If you reinvest this interest in the savings account, you will be earning interest on the interest, which is called "compound interest". If the interest is compounded N times per year, the amount of money in the savings account after T years would be,

For example, if the principal is $1000, the rate of return is 5%, the number of years is 2, and the money is compounded every month (12 times per year),

The user (me) will input the values of P, R, N, and T in cells E4-E7. Create a run button on Sheet3 that executes a macro named problem3. This macro performs the following tasks:

Obtain the values of P, R, N, and T from cells E4-E7.

Using a For loop, calculate the amount of money in the savings account at the end of every year. For example, if the value of T is 4, then you will need to calculate the amount of money after 1 year, 2 years, 3 years, and 4 years. Also list the initial amount of money in the account.

N25 e: 1 Year Money 1000.00 1 1051.16 4 2 1104.94 3 1161.47 6 4 1220.90 Yo 10 Hin 11. 13 Sheet Sheet Ready (1) Use a Do e loop instea of a ForToop Principal 1000 Rate (%/100) 0.05 12 Times compounded per year Time (years): Calculate Money