Please show work / or show how on excel. Thanks!

Question 3 (20 points) Mr. Brown just won the lottery. The lottery will pay Mr. Brown 5 annual payments, with the first payment occurring today (Year 0) and the last payment occurring 4 years from today (Year 4). Today's payment will equal $150.000, and each payment thereafter will be 3% larger than the previous payment (e.g., the payment that occurs one year from today will be 3% larger than today's payment; the payment that occurs two years from today will be 3% larger than the payment that occurs one year from today, and so forth.). a. Determine the present value of this payment stream. Assume a discount rate of 5%. b. Determine the future value (4 years from today) of this payment stream. Assume an interest rate of 5%. Question 4 (20 points) You have decided to loan your cousin $8.000 today. He will pay back the loan with annual, end-of-year payments over the next 6 years, with the first payment occurring a year from today (Year 1) and the last payment occurring 6 years from today (Year 6). He will pay an amount of $X in Years 1, 2, and 3 and $1.5X in Years 4, 5, and 6. a. Suppose that you have decided to set X=$1.800. Use the IRR function to determine the annual interest rate that you are charging your cousin on this loan. (USE THE SHEET CALLED "4a") b. Ignore part a. Suppose that you have decided to charge your cousin an annual interest rate of 10%. What does the value of X need to be? (USE THE SHEET CALLED "4b") Question 5 (20 points) Many years ago, Mr. Blonde opened an IRA account (Account 1) and made a deposit of $10,000. Since opening Account 1, it has earned an annual return of 5% per year. Exactly two years ago, Mr. Blonde opened two more IRA accounts (Account 2 and Account 3) and deposited $15,000 into Account 2 and $20,000 into Account 3. Account 2 has earned an annual return of 5% each year since it was opened. Account 3 earned an annual return of 4% in the first year after it was opened and an annual return of 9% in the year after that. Today, the sum of the three account balances is $64,479.00. Assume that he did not make any additional deposits or withdrawals. How many years have passed since Mr. Blonde opened Account 1