(Spreadsheet problem) In 22 years, you would like to have $270,000 to buy a vacation home. If you have only $60,000, at what rate must it be compounded annually for it to grow to $270,000 in 22 years? If you have only $60,000, at what rate must it be compounded annually for it to grow to $270,000 in 22 years? % (Round to two decimal places.) Which Excel formula below would correctly solve this problem? (Select the best choice below.) A. = RATE(22,0, - 60000,270000) B. = RATE( - 60000,22,0,270000) O C. = RATE(0,22, -60000,270000) OD. = RATE(22, - 60000,0,270000)