Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You have started saving $10,000 per year for your retirement. You want to know for annual rates of return on your investment from 4% to
You have started saving $10,000 per year for your retirement. | ||||||
You want to know for annual rates of return on your investment from 4% to 12% the amount | ||||||
of money you will have in your account after saving from 10-15 years (the fields that change will be B8 and B9, respectively). | ||||||
Perform a sensitivity analysis using a two-way Data Table. | ||||||
Amount per Year | $10,000 | |||||
Return | 5% | |||||
Years | 11 | |||||
Future Value | *You will use the formula =FV(return,years,-Amount per Year,0,0) , note the Amount per Year has to have a minus sign in front of it) | |||||
*remember that in a two-way table, the formula is placed in the upper left hand corner |
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