There are 12 questions on the next sheet of this workbook. For each question, the correct solution figure is given to you in a cell highlighted in gray. Your task is to create a formula using an Excel function in the answer cell highlighted in yellow that results in the same, correct, figure. You must use an Excel function to get the answer. Functions may include pv, fv, pmt, nov, nper, rate, effect, nominal, average, stdev, etc. Question 7 Another nice gentleman emails you to inform you that you have won an international lottery. Although the winnings are typically paid out in British Pounds, the man advises you the government will convert the funds to US Dollars and pay the wire $490,957 transfer fees, all at no cost to you. After the disappointment of how much you would need to save each month in Question 6 4 points to achieve your original dream, you feel like your luck has turned back around. You now just have to decide if you would like your winnings paid out in a lump sum of $500,000 or receive annual end of year payments of $33,000 for 20 years. Assuming again that your money can earn 3% a year, what is the present value of the annuity stream option? (round to the nearest dollar)