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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!