suppose you are hired by your state government to determine the profitability of a lottery offering a grand prize of $10 million paid out in equal annual installments over 20 years. show how to calculate the cost of the state of paying out such a prize. assume payments are made at the end of each year. What excel financial function would you use?