Question

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

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 12 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.) c. 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.)

Homework Answers

Answer #1

Here we use pmt formulae in excel to find the monthly deposit we need to make to become a millionaire when we retire

=pmt(rate,nper,pv,fv,type)

a)rate=12%/12=1%(since monthly)

nper=40*12

pv=0

fv=10^6

type=0

=PMT(12%/12,40*12,0,10^6,0)=85

b)rate=12%/12=1%(since monthly)

nper=30*12(since after 10 years deposits made so remaining is 40-10=30)

pv=0

fv=10^6

type=0

=PMT(12%/12,30*12,0,10^6,0)=286.13

c)rate=12%/12=1%(since monthly)

nper=20*12(since after 20 years deposits made so remaining is 40-20=20)

pv=0

fv=10^6

type=0

=PMT(12%/12,20*12,0,10^6,0)=1010.86

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
8. A check-cashing store is in the business of making personal loans to walk-up customers. The...
8. A check-cashing store is in the business of making personal loans to walk-up customers. The store makes only one-week loans at 8 percent interest per week. a. What APR must the store report to its customers? What EAR are customers actually paying? (Round your EAR answer to 2 decimal places. (e.g., 32.16)) b. Now suppose the store makes one-week loans at 8 percent discount interest per week. What’s the APR now? The EAR? (Round your answers to 2 decimal...
You want to have $2 million in real dollars in an account when you retire in...
You want to have $2 million in real dollars in an account when you retire in 30 years. The nominal return on your investment is 12 percent and the inflation rate is 3.6 percent.    What real amount must you deposit each year to achieve your goal? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
You want to have $1 million in real dollars in an account when you retire in...
You want to have $1 million in real dollars in an account when you retire in 30 years. The nominal return on your investment is 9 percent and the inflation rate is 4 percent.    What real amount must you deposit each year to achieve your goal? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)   Deposit amount $
You have 35 years left until retirement and want to retire with $2.5 million. Your salary...
You have 35 years left until retirement and want to retire with $2.5 million. Your salary is paid annually, and you will receive $75,000 at the end of the current year. Your salary will increase at 2 percent per year, and you can earn a return of 8 percent on the money you invest.    If you save a constant percentage of your salary, what percentage of your salary must you save each year? (Do not round intermediate calculations and...
ou have just made your first $5,200 contribution to your retirement account. Assume you earn a...
ou have just made your first $5,200 contribution to your retirement account. Assume you earn a return of 12 percent per year and make no additional contributions. a. What will your account be worth when you retire in 43 years? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What if you wait 10 years before contributing? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
You are planning to save for retirement over the next 25 years. To do this, you...
You are planning to save for retirement over the next 25 years. To do this, you will invest $850 per month in a stock account and $450 per month in a bond account. The return of the stock account is expected to be an APR of 10.5 percent, and the bond account will earn an APR of 6.5 percent. When you retire, you will combine your money into an account with an APR of 7.5 percent. All interest rates are...
You have $19,000 you want to invest for the next 28 years. You are offered an...
You have $19,000 you want to invest for the next 28 years. You are offered an investment plan that will pay you 8 percent per year for the next 14 years and 12 percent per year for the last 14 years. How much will you have at the end of the 28 years? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Account value $ If the investment plan pays you 12 percent per...
You believe you will spend $33,000 a year for 13 years once you retire in 26...
You believe you will spend $33,000 a year for 13 years once you retire in 26 years. If the interest rate is 5% per year, how much must you save each year until retirement to meet your retirement goal? (Do not round intermediate calculations. Round your answer to 2 decimal places.)
Your goal is to become a millionaire by retirement. How much do you need to save...
Your goal is to become a millionaire by retirement. How much do you need to save each month to have $1,000,000 assuming you have 35 years to invest in an account that earns 7.5% real rate of return? If you earn $5,000/month, what percentage of your monthly income do you need to invest for retirement?
A couple will retire in 40 years; they plan to spend about $31,000 a year in...
A couple will retire in 40 years; they plan to spend about $31,000 a year in retirement, which should last about 20 years. They believe that they can earn 7% interest on retirement savings. a. If they make annual payments into a savings plan, how much will they need to save each year? Assume the first payment comes in 1 year. (Do not round intermediate calculations. Round your answer to 2 decimal places.) b. How would the answer to part...