Selma and Troy are planning to take a second honeymoon in two years. They estimate that the cost will be roughly $7,985.74. They plan to make monthly payments of $275 and expect to receive 10% annual interest on their savings. Given this information: a) Would they be able to take the vacation (what is the exact amount over or under their goal)? b) What must the annual interest rate be in order to make their goal exactly? c) What must their monthly savings payments be in order to reach their goal if the annual interest rate drops 4.5% below the rate found in part b of this problem?

I have to enter the info into a spreadsheet like this:

Relevant Information
Annual Interest Rate
Periods Per Year
Number of Years
Needed Information
Present Value					PV
Future Value					FV
Payment					PMT
Rate					RATE
Number of Periods					NPER
Additional Calculations (if needed)
Answer: