RM711: Homework on Module 6

1) Write a subroutine that asks the user (via input boxes) for:

• The deposit Amount (one time investment)

• The number of Years

• The interest Rate (APR)

  Then, display the future value of the users deposit each year for some number of years. You can do this using a loop inside your message box.

  Set your default deposit amount to $15,000 Set the default term to 10 years Set your default interest rate to 3.5%

  So, if I use the default values above, I should get the following values in my message box:

Year Future Value

1. 1 $15,525.00

2. 2 $16,068.38

3. 3 $16,630.77

4. 4 $17,212.85

5. 5 $17,815.29

6. 6 $18,438.83

7. 7 $19,084.19

8. 8 $19,752.14

9. 9 $20,443.46

10. 10 $21,158.98

Hints:

You will need 3 input boxes You will want to use a loop to output the results Inside the message box which outputs the answers, you will want to output each future value Chr(13) is the syntax for carriage return (new line)