Description
The assignment is attached. Need an excel file.
Unformatted Attachment Preview
RM711: Homework #5 (Module 6)
1) Write a subroutine that asks the user for:
•
•
•
•
The deposit Amount
The additional contribution (deposit) each year (must be the same amount each year)
The number of Years
The interest Rate (APR)
Then, display the future value of the user’s account each year over the entire time frame. Also
show the growth from the original investment only. You can do this using a loop inside your
message box.
Set your default deposit amount to $5,000
Set your default annual contribution to $250
Set the default term to 3 years
Set your default interest rate to 5%
For example, if I were to use the default values above, I should get the following values in my
message box:
1st Year: $5,500.00 Growth $500.00
2nd Year: $6,025.00 Growth $1,025.00
3rd Year: $6,576.25 Growth $1,576.25
Hints:
You will need several input boxes
Inside the message box which outputs the answers, you will want to output each future value and
the growth from the original investment only (the growth amount will include interest and annual
contributions).
You will want to use a loop to output the results.
Within a message box, to make it neat, if you’d like you can use the following:
Chr(13) is the syntax for carriage return (new line)
Chr(9) is the syntax for tab (inserting a few spaces)
Purchase answer to see full
attachment
