Question
Answers to each question are below in bold: Enter an amount between $100 and $500 that you think you can afford to save each month
Answers to each question are below in bold:
Enter an amount between $100 and $500 that you think you can afford to save each month for retirement into the spreadsheet.
Calculate how many years it will be until you reach age 67. Enter this amount into the spreadsheet. answers from spread sheet are below in bold
Choose an interest rate between 1% and 7% and enter it into the spreadsheet.
Add 10 years to your previous age calculation to determine how much more you could have accumulated if you started 10 years ago.
The investment calculator will show you how much you can save if you invest today and how much you could have accumulated if you had started your investing 10 years ago. In your post, include the following information and answer the questions:
The amount you chose to save each month. The number of years until you reach 67. The interest rate you used. The result of your two investment scenarios. How much more would you have for your retirement if you had started saving 10 years ago? Did the results surprise you in any way? Explain. Do you think the amounts you have calculated will be enough to retire on?
What was entered into to investment calculator:
Monthly investment is 150 a month.
number of years until i am 67: 41
interest rate: 0.035
Amount in account: 164,102.53 ( amount in account if start saving today )
Number of years until you are 67+ 10 = 51
amount in account beginning 10 years ago: 254,268.85
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started