Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Fintech In Islamic Finance Theory And Practice

Authors: Umar A. Oseni, S. Nazim Ali

1st Edition

1138494801, 978-1138494800

More Books

Students also viewed these Finance questions