Do the following calculation in excel:

1. What is the future value of $500 invested for 10 years at 12%?

2. Suppose you are offered an investment that will pay you $5000 in 3 years and $7000 in 6 years. If the required return is 10%, how much should you be willing to pay? If the investment costs you $7,600, should you take it?

Please show the formulas used in excel.