Solve the following questions using TVM functions in Excel. You will receive no credit if you type in numbers instead of using equations/functions/references in cells other than inputs.

2. What constant amount invested at the end of each year at a 11% annual interest rate will be worth $30,000 at the end of five years?

3. Your father will convey a property to you in 15 years. If the property is expected to be worth $600,000 when you receive it, what is the present value of the property? Your discount rate is 6%.

4. What is the NPV of $500 received for the next four years and $2,000 received at the end of the fifth year if your required return is 8%?