Question: Construct a table and a graph showing the relationship between interest rates, time, and future value by showing how $10,000 would grow each successive year

Construct a table and a graph showing the relationship between interest rates, time, and future value by showing how $10,000 would grow each successive year over a 30-year period at different interest rates. Use $10,000 for your present value and calculate the future value of this $10,000 each year over the 30-year period at 0%, 2%, 4%, 6%, 8%, 10%, 15%, and 20% compounded annually. Future Value should be the y-axis for your graph and years (or time) should be your x-axis and you should end up with a line for each interest rate on your graph.

Please insert your graph (chart) under your table of future values.

Please also attach a link to the google sheet/excel! I would love to see what functions you used to get the answers and how I can get it! (Or please show a picture of all functions you used to get the answer!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!