Question

10.00 points Dear Financial Adviser My spouse and I are each 62 and hope to retire in three years. After retirement we will receive $9,200 per month after taxes from our employers pension plans and $3,200 per month after taxes from Social Security. Unfortunately our monthly living expenses are $16,700. Our social obligations preclude further economies We have S830 000 invested in a high-grade, tax-free municipal bond mutual fund. The return on the fund is 40% per year. We plan to make annual withdrawals from the mutual fund to cover the difference between our pension and Social Security income and our living expenses. How many years before we run out of money? Sincerely Luxury Challenged Marblehead, MA You can assume that the withdrawals (one per year) will sit in a checking account (no interest) until spent. The couple will use the account to cover the monthly shortfals. How many years before Luxury Challenged runs out of money? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Number of years

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

File Home Page Layout FormulasData Review View dd-Ins Define Name PUse in Formula Trace Precedents Show Formulas t Trace Depe

Add a comment
Know the answer?
Add Answer to:
10.00 points Dear Financial Adviser My spouse and I are each 62 and hope to retire...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 10.00 points Dear Financial Adviser My spouse and I are each 62 and hope to retire...

    10.00 points Dear Financial Adviser My spouse and I are each 62 and hope to retire in three years. After retirement we will receive $9,200 per month after taxes from our employers' pension plans and $3,200 per month after taxes from Social Security. Unfortunately our monthly living expenses are $16,700. Our social obligations preclude further economies We have S830 000 invested in a high-grade, tax-free municipal bond mutual fund. The return on the fund is 40% per year. We plan...

  • Dear Financial Adviser, My spouse and I are each 62 and hope to retire in three...

    Dear Financial Adviser, My spouse and I are each 62 and hope to retire in three years. After retirement we will receive $8,200 per month after taxes from our employers’ pension plans and $2,200 per month after taxes from Social Security. Unfortunately our monthly living expenses are $15,700. Our social obligations preclude further economies. We have $1,070,000 invested in a high-grade, tax-free municipal-bond mutual fund. The return on the fund is 3.0% per year. We plan to make annual withdrawals...

  • Dear Financial Adviser, My spouse and I are each 62 and hope to retire in three...

    Dear Financial Adviser, My spouse and I are each 62 and hope to retire in three years. After retirement we will receive $8,800 per month after taxes from our employers pension plans and $2,800 per month after taxes from Social Security. Unfortunately our monthly living expenses are $16,300. Our social obligations preclude further economies. We have $750,000 invested in a high-grade ta ree munica a bond mutual fund. The return on he fund 1s 4,5% per ear. we an to...

  • I found 31.08 or 32 years and it says it's wrong. Dear Financial Adviser, My spouse...

    I found 31.08 or 32 years and it says it's wrong. Dear Financial Adviser, My spouse and I are each 62 and hope to retire in three years. After retirement we will receive $8,500 per month after taxes from our employers' pension plans and $2,500 per month after taxes from Social Security. Unfortunately our monthly living expenses are $16,000. Our social obligations preclude further economies. We have $1,100,000 invested in a high-grade, tax-free municipal-bond mutual fund. The return on the...

  • a. The cost of a new automobile is $11,900 lf he interest rate is 4%, how...

    a. The cost of a new automobile is $11,900 lf he interest rate is 4%, how much would you have to set aside now to provide this sum in four years? Do not round intermediate calculations. Round your answer to 2 decimal places.) Present value b, You have to pay $15,000 a year in school fees at the end of each of the next five years. If the Interest rate is 7%, how much do you need to set aside...

  • An individual is currently 30 years old and she is planning her financial needs upon retirement. She will retire at age...

    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...

  • Part 1: Barry and Samantha Harris – Retirement Savings (15 points) Barry and Samantha are startin...

    Part 1: Barry and Samantha Harris – Retirement Savings (15 points) Barry and Samantha are starting to take their retirement planning seriously. They are both 46 and plan to retire in 20 years at the age of 66. They expect to live 20 years in retirement (a life expectancy of 86). Between their 401k and IRA accounts they currently have $92,400 in retirement savings. They currently have a combined income of $85,000 per year and expect to be able to...

  • I ONLY NEED HELP IN SOLVING QUESTION #4, I'VE DONE THE REST JUST NEED FORMULAS TO...

    I ONLY NEED HELP IN SOLVING QUESTION #4, I'VE DONE THE REST JUST NEED FORMULAS TO #4. PLEASE SHOW WORK, I HAVE TO TURN IT IN ON EXCEL. THANK YOU. Matt and Debra Baxter live in an upscale neighborhood in Orem, Utah. Matt is a partner in the family owned business. Debra stays home with their child, Brady, who is age 5. After visiting with their financial planner, the couple became concerned that they were spending too much and not...

  • please with steps 2.) Brent and Sharon are getting close to retirement and want to make...

    please with steps 2.) Brent and Sharon are getting close to retirement and want to make sure they are on track for a comfortable lifestyle. They currently make $120,000 per year in gross income. They pay FICA taxes of $9.180; have commuting expenses of S2,000 per year, Uniform expenses (inc, dry cleaning) of $1,200 per year, a monthly mortgage payment of S950 per month and will be paid off in 10 more years. They eat lunch out at work often...

  • I need to help a couple with their finances for this assignment. I hace to prepare...

    I need to help a couple with their finances for this assignment. I hace to prepare a vertical analysis of their statement of fiancial position and income and expense. Can anyone please help me using these photos? 2 Statement of Income and Expenses $100,000 68.770 Total $3.500 Statement of income and Expenses Ryan and Turany Pierce Statement of Income and Expenses for Past Year (2019) and Expected (Approximate) For This Year (2020) Cash Inflows Ryan's Salary Tiffany's Salary ML Brokerage...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT