pls indicate what formula to use on these problems

the following Excel functions to answer Questions 14-20: b. PV( nate, nper,pmt, [fV], [type]) c. =FV( nate, nper,pent, [ pv], [type]) c. -PMT(nate, nper,pv, (fv). (typo)] c. = NPER(rute,pmt,pv, [fv]. [type]) -RATE(nper,pmi,pv, [fv]. [type].[guess]) Show the formula or function and arguments that are necessary to solve each of the following problems. Your answer should work if it were typed, exactly as written, into the spreadsheet. You should not have to perform any calculations. (You are not required to provide answers to the questions, but rather just the required inputs.) 14. You have just won the lotteryl Your prize is $10,000,000, payable in equal annual installments of $1,000,000 over the next 10 years. Afternatively, you have the option of taking a one-time, lump-sum payout today. You want to determine the amount of the payout that you would receive if you take that option. Assume a 5% interest nate. The appropriate input to the spreadsheet is: 15. Jane is buying a home. The list price is $210,000, but Jane plans to offer $200,000. She plans to make a 10% down payment with the balance financed with a 30 -year mortgage at 6.75% anmul interest. Jane wants to determine her monthly "principal and interest" payments if her offer is accepted. The appropriate input to the spreadshect is: 6. You are planning to purchase a car, financing the purchase with a 5.99\%, 5-ycar loan. You belicve that you can afford monthly payments of $450 and wish to determine the maximum purchase price that you can finance. The appropriate input to the spreadsheet is