11.You want to be a millionaire when you retire in 40 years. a. How much do...

11.You want to be a millionaire when you retire in 40 years.

a. How much do you have to save each month if you can earn an annual return of 9.7 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

b. How much do you have to save each month if you wait 10 years before you begin your deposits? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.). How much do you have to save each month if you wait 20 years before you begin your deposits? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

Solve with steps instead of Excel.

Expert Solution

ONLY WRITTEN IN EXCEL. ONLY MANUAL CALCULATIONS WITH FORMULAS. THANK YOU

jeff jeffy answered 1 year ago

You want to be a millionaire when you retire in 35 years. How much do you...

You want to be a millionaire when you retire in 35 years. How much do you have to save each month if you can earn an annual return of 11.5 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Savings per month $ How much do you have to save each month if you wait 15 years before you begin your deposits? (Do not round intermediate calculations and round your answer to 2...

If you want to be a millionaire when you retire in 50 years, how much must...

If you want to be a millionaire when you retire in 50 years, how much must you save each month if you can earn a 6% annual rate of return? what is the effective annual interest rate on the imvestment? please use formula and show work

You have decided that you want to be a millionaire when you retire in 44 years....

You have decided that you want to be a millionaire when you retire in 44 years. 1. .If you can earn an annual return of 11.22 percent, how much do you have to invest today? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) 2. .What if you can earn an annual return of 5.61 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) 1. amount to...

You want to retire has a millionaire. How much do you need to put away each month if

You want to retire has a millionaire. How much do you need to put away each month if:You use common stocks and have an average return of 10%?You use corporate bonds and have an average return of 6%?You use government bonds and have an average return of 4%?You put your money in a CD at 2.5% interest rate?(use your own age. If you are over 45, solve for saving a $100,000.)

I want to retire in 40 years. When I retire, I want to withdraw $20,000 every...

I want to retire in 40 years. When I retire, I want to withdraw $20,000 every 6 months from my savings for a period of 10 years. However, at the end of years two and three in my retirement, I will need to spend $40,000 and $60,000 respectively to send my grandson to culinary school. Assuming I can earn 4% compounded semi-annually, answer the following question: How much money will I need at year 40 to fund sending my grandson...

1- ) You want to have $3 million when you retire in 40 years. If you...

1- ) You want to have $3 million when you retire in 40 years. If you can earn 12% per year, how much do you need to deposit on a monthly basis if the first payment is made in one month? 2- ) What if the first payment is made today? 3- ) You are considering ABC’s preferred stock that is expected to pay a quarterly dividend of $1.00 forever. If your desired return is 10% per year, how much...

you will work for 40 years then you will retire. when yiu retire, you will make...

you will work for 40 years then you will retire. when yiu retire, you will make the first of 40 annual investments of $7549 in a fund. the fund is expected to return 9.9% per year, how much will you have on the day that you make your last deposit?

You plan to retire in 40 years. After that, you want to receive an annuity of...

You plan to retire in 40 years. After that, you want to receive an annuity of 5000 per month for 25 years, beginning immediately upon retirement. If you can earn 6% per year, compounded monthly, how much must you invest at the end of each month before retirement?

How much money do you need to save each year to be a millionaire by the...

How much money do you need to save each year to be a millionaire by the time you are 65 if you can earn an interest rate of 8% and you start saving when you were born? Please use two decimals rounded up.

How much do you need when you retire to provide a $2,500 monthly check that will...

How much do you need when you retire to provide a $2,500 monthly check that will last for 25 years? Assume that you're savings earn .5% monthly and you receive the check each month. a) 361,526.14 b) 388,017.16 c) 402,766.67 d) 414,008.24

Question