please use excel with future value and present value to answer

1.

You found an investment with the following cash flows:

End of year Cash Received

1 $500

2 $550

3 $600

What is the most you are willing to pay if you believe investments of this risk warrant a 7% return?

2.

You have just made your first $5,000 contribution to your retirement account. Assume you earn a return of 10 percent per year and make no additional contributions.

What will your account be worth when you retire in 45 years?

What if you wait 10 years before contributing?

After calculating parts a and b, what is the lesson learned?