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.

7. If your tenant pays you rent of $30,000 a year for 10 years at the beginning of each year, what is the present value of the series of payments discounted at 7% annually