Question

In: Finance

Construct a table and a graph showing the relationship between interest rates, time, and future value...

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 25-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 25-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.

Using Excel, please!

Solutions

Expert Solution

*Please comment if you face any difficulty and please don't forget to thumbs up

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

Construct a table and a graph showing the relationship between interest rates, time, and future value...
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 25-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 25-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...
Construct a table and a graph showing the relationship between interest rates, time, and future value...
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 25-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 25-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...
There are important relationships between Interest Rates and Time as it relates to Future Value: For...
There are important relationships between Interest Rates and Time as it relates to Future Value: For a given Interest Rate, what is the impact on Future Value if the Time Period is longer and for a given Time Period, what is the impact on Future Value if the Interest Rate is higher?
What is the relationship between the value of an annuity and the level of interest rates?...
What is the relationship between the value of an annuity and the level of interest rates? Suppose you just bought a 10-year annuity of$5,200 per year at the current interest rate of 10 percent per year. What happens to the value of your investment if interest rates suddenly drop to 5 percent? What if interest rates suddenly rise to 15%? Please use excel to calculate.
Explain the relationship between the present value and future value of a sum when the interest...
Explain the relationship between the present value and future value of a sum when the interest rate (opportunity cost) is zero.
The table below is illustrative of the relationship between changes in interest rates and bond prices...
The table below is illustrative of the relationship between changes in interest rates and bond prices Change in Interest Rate Change in Bond’s Value    Increase   Increase Decrease Decrease True False
Relationship between future value and present value: Mixed stream. Using the information in the accompanying table,...
Relationship between future value and present value: Mixed stream. Using the information in the accompanying table, answer the questions that follow. Year Cash Flow 0 0 1 800 2 900 3 1000 4 1500 5 2000 a.Determine the present value of the mixed stream of cash flows, using a 5% discount rate. b. Suppose you had a lump sum equal to your answer in part a on hand today. If you invested this sum for 5 years and earned a...
Explain the general relationship between inflation, interest rate and unemployment. 2-4 sentences, provide a graph showing...
Explain the general relationship between inflation, interest rate and unemployment. 2-4 sentences, provide a graph showing the last 20 years.
Explain the general relationship between "inflation", "interest rate", and "unemployment". 2-4 sentences, provide a graph showing...
Explain the general relationship between "inflation", "interest rate", and "unemployment". 2-4 sentences, provide a graph showing the last 20 years of employment in New York state (Could use FRED).
Describe how to find interest rates and time requirements forproblems using present value and future...
Describe how to find interest rates and time requirements for problems using present value and future value.
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT