What is the equation to find the answers to these question?
Thank you!
Withdrawals per year = $50,000
Number of years = 25
Amount required at the end of 20 years i.e. at the age of 65 will be equal to the present value of all future withdrawals
i.e. Amount = $50,000*PVAF(11%, 25 years)
= $50,000*8.422
=$421,100
Let the amounts she invests today is x
Then, x(1.11)20 = $421,100
X = $52,230.68
a.The amount Emily must aside now = $52,230.68
b.Amount required at the age of 65 years = $50,000*PVAF(8%, 25 years)
= $50,000*10.675
= $533,750
Let the amounts she invests today is x
Then, x(1.11)20 = $533,750
X = $66,203.10
The amount Emily must aside to achieve her goal = $66,203.10
c.Amount at the age of 65 years = 75,000(1.11)20
= $604,673.37
Amount withdrawn in present value terms = $533,750
Amount left after last withdrawal = $70,923.37*(1.08)25 = $485,716.94
What is the equation to find the answers to these question? Thank you! Personal Finance Problem...
Funding your retirement Emily Jacob is 45 years old and has saved nothing for retirement. Fortunately, she just inherited S75,000. Emily plans to put a large portion of that money into an investment account earning a(n) 11% return. She will let the money accumulate for 20 years, when she will be ready to retire. She would like to deposit enough money today so she could begin making withdrawals of $50,000 per year starting at age 66 (21 years from now)...
Funding your retirement Emily Jacob is 45 years old and has saved nothing for retirement. Fortunately, she just inherited S75,000. Emily plans to put a large portion of that money into an investment account earning a(n) 11% return. She will let the money accumulate for 20 years, when she will be ready to retire. She would like to deposit enough money today so she could begin making withdrawals of S50,000 per year starting at age 66 (21 years from now)...
Your 40-year aunt wants to start saving for her retirement. She expects to retire at 65. She thinks that she will have saved $500,000 by the time she retires. She expects to live to 90.a) How much annual cash flow will your aunt have if she expects her retirement fund return to be 8% per year compounded annually. Assume she makes her first annual withdrawal at the end of the first year of retirement, and the last withdrawal when she...
Advanced Time Value of Money Problems Question (Retirement planning) You have just graduated Hofstra University at age 22. You hard work has paid off as you already have a job as an investment banker at Goldman Sachs waiting for you. You plan to work continuously until age 65 and retire exactly on that day. You expect to live until exactly 90 and enjoy your golden years and leave you heirs NOTHING. Assume your investments earn 8% per year. You plan...
How to solve this problem in Excel Sheet? Assume that you are now 35 years old. You would like to retire at age 65 and have a retirement fund of $5,000,000 at the time of your retirement. You have already $100,000 in the retirement account. You expect to earn 6% per year. The amount of money you must set aside each month beginning one month from now to reach your retirement goal is:
answer both please 12. Now let's work backwards. Assume that you will all live until 100 (a good news!), but will have to retire by 65 (a bad news^^). You estimate that you will need to draw at least $3,000 per month of living expenses out of your retirement account after you retire (assume no inflation). Suppose that your retirement account will keep earning 6% APR after you retire. If you want to ensure that your retirement account will not...
An individual is currently 30 years old and she is planning her financial needs upon retirement. She will retire at age 65 (exactly 35 years from now) and she plans on funding 20 years of retirement with her investments. Ignore any social security payments and ignore any taxes. She made $106,000 last year and she estimates she will need 75% of her current income in today's dollars to live on when she retires. She believes that inflation will average 3...
10. Assume that you are now 25 years old. You would like to retire at age 65 and have a retirement fund of $5,000,000 at the time of your retirement. You have already $50,000 at age 25 in the retirement account. You expect to earn 7% per year. The amount of money you must set aside each month to reach your retirement goal is: A. $4,377.98 B. $1594.18 C. $3500.00 D. $2500.00
Can you please solve these on Excel and show me how you solved it. Thank you so much. 6) You would like to have $5 million dollars when you retire at age 65. You are 25 years old and you want to make your first savings payment immediately. You have not saved any money for your retirement as of yet. Assume interest rate is 7%, how much money must you set aside per year until and including your 65th birthday?...
An individual is currently 30 years old and she is planning her financial needs upon retirement. She will retire at age 65 (exactly 35 years from now) and she plans on funding 20 years of retirement with her investments. Ignore any social security payments and ignore any taxes. She made $131,000 last year and she estimates she will need 75% of her current income in today's dollars to live on when she retires. She believes that inflation will average 3...