Question: SOLVE PART C USING EXCEL You are currently 23 years old. You started working in a job and will retire at the age of 60.

 SOLVE PART C USING EXCEL You are currently 23 years old.

SOLVE PART C USING EXCEL

You are currently 23 years old. You started working in a job and will retire at the age of 60. Answer the following questions based on the pension plan that you will develop: A. If the monthly interest rate is 1.1%, when should you start saving (after how many months from now) EGP 1,500 per month to receive EGP 12,000 per month after you retire for 25 years? B. If you are willing to save EGP 100 per month in the pension plan to receive EGP 14,000 per month after you retire for 25 years, what will be the required monthly interest rate to achieve it? c. If you save EGP 90 per month, starting now, in the pension plan that pays an interest rate of 1.1%, how much can you withdraw monthly after you retire forever

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!