4. Assume that you and your family want to go on vacation in 5 years. You are planning to save for the trip. The estimated cost of the trip will be $10,000. You have found an investment that will pay 6% annual interest for the next 5 years.

Required:

A. Calculate the dollar amount that will be required to invest today to reach the financial expense for your vacation. Use Excel --- show your work

B. Prove your answer with an Excel worksheet