8 of 19 (13 complete) This Quiz 19 pis poss (Spreadsheet problem in 16 years, you would like to have $260,000 to buy a vacation home. If you have only $40,000, at what rate must be compounded annually for it to grow to $250,000 in 16 years? you have only 540,000, at what rate must be compounded arrually for it to grow to $260,000 in 16 years? Round to two decimal places) Which Excel formula below would correctly solve this problem? (Select the best choice below) OA RATE(16.- 40000.0 280000) OBRATE/0.16. - 20000 200000) OCRATE(16,0.- 40000 200000) ODERATE - 40000 100 200000)