Question
To meet your retirement goals (and pay for that big trip around the world) you will need $85,000 in your travel account at the end
To meet your retirement goals (and pay for that big trip around the world) you will need $85,000 in your travel account at the end of 12 years. You are able to place $2800 in to the account at the end of each year. However, you know that this won't make it. Once the estate clears, you are expecting an inheritance from you late uncle in 5 years. (start the savings account now.. 5 years from now, you will have $$ from uncle). If you can get a 4.2% rate on you account (PYCY) how much do you need from you uncle to make work?
Is there a formula in Excel that I can use to complete this question?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started