Explore BrainMass
Share

# Retirement Planning

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Thomas is considering retiring and migrating to a rental property in the Virgin Islands. Thomas presently owns a home appraised at \$595,000 with \$300,000 remaining on the home loan. He has about \$350,000 in savings right now. The Virgin Island rent will be \$1,000 a month and he estimates that he and his wife can live on \$3,000 a month in the Virgin islands. He figures that he will live for 25 additional years and can earn 5% in his funds.

a. Does he have sufficient resources to retire in the Virgin Islands?
b. A friend noted that he also will get social security benefits but also will have top pay taxes on funds coming from his tax-deferred retirement fund and the social security. If he expects \$1,500 in social security income and 18% of the income coming from the retirement funds are deducted for taxes, can he afford the retirement plan at this time?

https://brainmass.com/economics/finance/retirement-planning-411969

#### Solution Preview

Please refer attached file for better clarity of functions in MS Excel.

a. Does he have sufficient resources to retire in the Virgin Islands?

Value of home=\$595,000.00
Loan due= \$300,000.00
Net expected value of home=595000-300000=\$295,000.00
Savings=\$350,000.00
Total worth in hand=350000+295000=\$645,000.00

Let us see what monthly payments he can get at 5% rate.
Present value of annuity=PV=\$645,000.00
Interest Rate=RATE=5%/12=0.4167% per month
Number of ...

#### Solution Summary

Solution determines if the current financial resources can meet the retirement target in the given case.

\$2.19