Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Finance

Authors: Maurice D Levi

5th Edition

0415774594, 9780415774598

More Books

Students also viewed these Finance questions

Question

Be prepared to address excessive absenteeism

Answered: 1 week ago