Question: Please use excel to construct a spreadsheet How valuable is it if a fund saves you 50 basis points (i.e. 0.5%) per year in expenses?
Please use excel to construct a spreadsheet
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
Get step-by-step solutions from verified subject matter experts
