Mr. Brown just won the lottery. The lottery will pay Mr. Brown 6 annual payments, with the first payment occurring today (Year 0) and the last payment occurring 5 years from today (Year 5). Todays payment will equal $150,000, and each payment thereafter will be 5% larger than the previous payment (e.g., the payment that occurs one year from today will be 5% larger than todays payment; the payment that occurs two years from today will be 5% larger than the payment that occurs one year from today, and so forth.).

1. Determine the present value of this payment stream. Assume a discount rate of 6%.
2. Determine the future value (5 years from today) of this payment stream. Assume an interest rate of 6%.

Excel PLS, thanks!