Question
4. Use Excel to answer the following question. You may use a financial calculator to check your work afterwards, but you must construct a spreadsheet
4. Use Excel to answer the following question. You may use a financial calculator to check your work afterwards, but you must construct a spreadsheet yourself to calculate the answers. Submit your spreadsheet file along with your written answers. How valuable is it if a fund saves you 50 basis points (i.e. 0.5%) per year in expenses? The following gives a sense: a) If you save $40,000/year and invest at a 4.0% rate of return, how long does it take to save $2 million? b) If you save at $40,000/year and invest at 4.5%, how long will it take? c) If you have $2 million and can invest at 4%, how many dollars can you spend per year and have nothing left after 30 years? d) How much can you spend per year if you can invest at 4.5%?
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