Be sure your initial post is at least 100 words. Then reply to at least 3 classmates posts over 3 different days.

Access the attached Future Value Excel file and fill in the blank cells corresponding to monthly payment, number of years to invest, and a specific rate of return.

Part 1

How much you will save each month to invest? Choose an amount between $100 and $600 to use as your monthly contribution.

How many years are you going to invest? Choose a number of years between 20 and 35.

Choose an interest rate between 4.00% and 10.00%. The interest will be compound monthly for this example (so 12 times a year).

What is the future value of your account? Excel will calculate this for you.

Part 2

Keeping all other factors the same, decrease the number of years you invest (choose between 5 and 15 years). What is the future value of your account under this scenario?

Part 3

Compare your future value amounts in Part 1 and Part 2. Were you surprised at the difference?

the picture is the Excel file

Math201 Week 2 Future Value Calculator Investing Early Versus Investing Late Determine the Future Value of your investment fund based on a fixed n ent and a 20 year minimum investment strategy between $100 and $600, This is the amount that you will deposit into the account each n 12 Don't entor anylhing This is et to 12 csince interest is compounded moeily in our example ENTER a number of years between 20 and 35 for your investment account to unding Periods Per Year umber of years to invest Rate of Return Future Value of our account ETER an interest rate between 4% and 10% $0.00 Compounding Periods Per Year umber of years to invest Rate of Return s between S and 15 for your investment account to grovw ENTER a number of This is the interest rate from your first calculation (B7 0 00%