Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Construct a table and a graph showing the relationship between interest rates, time, and present value by showing how $10,000 pushed a year further into

Construct a table and a graph showing the relationship between interest rates, time, and present value by showing how $10,000 pushed a year further into the future over a 30-year period would be discounted at different interest rates. Use $10,000 for your future value and calculate the present value of this $10,000 each year over the 30-year period at 0%, 2%, 4%, 6%, 8%, 10%, 15%, and 20% compounded annually. Present 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 present values.

Please answer all parts, including the graph! Please and thank you!

Also, please send a copy of your excel/google sheet, I would love to see what functions did you use to solve the problem and how can I get the same answer!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Finance Discussion Papers A Framework For Economic Forecasting

Authors: United States Federal Reserve Board, Neil R. Ericsson, Jaime Marquez

1st Edition

1288733585, 9781288733583

More Books

Students also viewed these Finance questions