You have a retirement account that earns 5 percent annual interest with the tota

Question

You have a retirement account that earns 5 percent annual interest with the total account balance of $400,000. How much a year can you withdraw for next 20 years if your first withdrawal starts a year from today? Round to the nearest cent. Do not include any unit (If your answer is $111.11, then type 111.11 without $ sign.)

Daria plans to retire in 20 years and wants to know how much she will need to have in her account when she retires. She wants to be able to withdraw $5,000 per month for 25 years of retirement, and she expects her account to earn a nominal rate of 9 percent per year. Round to the nearest cent. Do not include any unit (If your answer is $111.11, then type 111.11 without $ sign.)

Today, you start working for a univeristy as an administrative staff. You decided to invest $500 a month in a fund that is expected to earn 6 percent annual interest. If you start monthly contribution of $500 today for 35 years, how much will you have in 35 years? Round to the nearest cent. Do not include any unit (If your answer is $111.11, then type 111.11 without $ sign.)

Your company is projected to make $100,000 forever and the company’s cost of capital is 8 percent. What is the value of this perpetuity? Round to the nearest cent. Do not include any unit (If your answer is $111.11, then type 111.11 without $ sign.)

You are considering investment that is going to pay $1,500 a month starting 20 years from today for 15 years. If you can earn 8 percent return on any investment, compounded monthly, how much at most are you willing to pay for this investment opportunity? Round to the nearest cent. Do not include any unit (If your answer is $111.11, then type 111.11 without $ sign.)

Today, you graduated from high school. You are planning to go to college starting 2 years from now after volunteering abroad. The tuition will be due at the beginning of school year. You will start paying tuitions in two years, and the amount will be $15,000, $15,750, $16,550, and $17,700. How much do you need to have in your account today if you can earn 8% on your account compounded annually? Round to the nearest cent. Do not include any unit (If your answer is $111.11, then type 111.11 without $ sign.)

Explanation / Answer

1.
=PMT(5%,20,400000) or =400000*0.05/(1-1/1.05^20)
=32097.03
2.
=PV(9%/12,12*25,5000) or =5000/(9%/12)*(1-1/(1+9%/12)^(25*12))
=595808.11
3.
=FV(6%/12,12*35,500,0,1) or =500/(6%/12)*(1-1/(1+6%/12)^(12*35))*(1+6%/12)*(1+6%/12)^(12*35)
=715916.93
4.
=100000/8%
=1250000

P.S.: I am allowed to answer only 4 questions

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.