Question: Problem 2 Concept- For Loop Complete this problem in Sheet3. You deposit an initial amount of money P in a savings account. This money is
Problem 2 Concept- For Loop 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, money=P 1 +R 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), money $10001+ 010194 40 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: ni 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, and 4 years. Also list the initial amount of money in the account. Below is an example of what your worksheet should look like after the run button is clicked years, 3 Year Maney 0 1000.00 1 1051.16 2 1104.94 1161.47 ni Rate(X/100 s Page 3 of 4 859 words 0 Type here to search
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
