To meet your retirement goals (and pay for that big trip around the world) you will...

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?

Solutions

Expert Solution

5 year from now we have to receive 31821.47 from uncle

as per your request calculation is shown in excel

any doubt please comment

upvote if you like the answer

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

The big advantage to owning a home is that eventually (hopefully around retirement), you will no...

The big advantage to owning a home is that eventually (hopefully around retirement), you will no longer have a monthly payment for housing (although you will always have taxes and upkeep.) That said, home ownership is not always the good move. Do you own, or hope to own in the near future? If not, what are your reasons for preferring to rent/lease?

Congratulations! You entered a sweepstake and won a fantastic prize: a trip around the world. There’s...

Congratulations! You entered a sweepstake and won a fantastic prize: a trip around the world. There’s only one catch: you have to study the economy of each country (from the list below) that you visit, and identify the current phase of its business cycle. Be sure to explain your responses. Country 1. While the landscape is beautiful and the weather is superb, a lot of people seem unhappy. Business is slow, and production has dropped steadily for the past six...

Assignment Topic: The big advantage to owning a home is that eventually (hopefully around retirement), you...

Assignment Topic: The big advantage to owning a home is that eventually (hopefully around retirement), you will no longer have a monthly payment for housing (although you will always have taxes and upkeep.) That said, home ownership is not always the good move. Do you own, or hope to own in the near future? If not, what are your reasons for preferring to rent/lease? (20 pts.) Submission Format The length of your response is conditional on the question. Answer fully,...

On a trip home during the summer break, you pay your Uncle Davea visit at...

On a trip home during the summer break, you pay your Uncle Dave a visit at his record store. When you walk in, you notice there is not one single customer. “I have run this store since the 1980s,” Uncle Dave says with a sigh. “We were the first store in this whole town to sell compact discs! But now, it feels like we’re at least a decade or two behind the times. No one buys records anymore—or even CDs!...

3. In recent days, governments around the world are seeking to extend retirement age as the...

3. In recent days, governments around the world are seeking to extend retirement age as the productive segment of workers are approaching decline in an aging demographic. In personal wealth planning, individuals focus on the time horizon for short-term, intermediate-term, and long-term goals. Postulate the outcome in the imposition of such policies and its outcome. How can individuals cope with changes in such policy changes? (300 words)

1. In 2015, countries around the world agreed to develop a new set of global goals...

1. In 2015, countries around the world agreed to develop a new set of global goals to eradicate extreme poverty and achieve sustainable development by 2030 through 17 Sustainable Development Goals (SDGs) for the future of the world. No goal or target is considered met unless met for all people, whoever and wherever they are. a) Briefly explain what the concept of sustainable development means. b) Illustrate the three pillar model of sustainability. Comment on some of the challenges for...

Specify all the goals of the CB. Explain why almost all CB's around the world decide...

Specify all the goals of the CB. Explain why almost all CB's around the world decide to focus on price-stability .

accountability: when do you begin taking action to meet your goals? when do you see significant...

accountability: when do you begin taking action to meet your goals? when do you see significant progress ? when do you review your plan to check your progress?

q27. a) you are planning to buy a new caravan to make a trip around australia....

q27. a) you are planning to buy a new caravan to make a trip around australia. the cost of the van is $225000 and you can get a loan from the bank for that amount. if you can get a fifteen year loan at 8.75% per annum compounded fortnightly, how much do you need to pay every fortnight? b) suppose you are going to receive $2000 per year for five years. the appropriate interest is 6% per annum. what is...

Consider your work environment, domain of interest, or the world around you, and discuss when it...

Consider your work environment, domain of interest, or the world around you, and discuss when it might be more appropriate to use the mean, median, or mode for measures of central tendency.

Subjects