Amelia wants to use a formula in Excel to estimate her sales for each month. She believes her sales for the next year will be about 7% higher than this year’s. She also has a big new ad campaign running late this year that she thinks will add another $5,000 to January sales. Which of the following is an appropriate Excel formula for Amelia’s January sales?

a. =(LastyearsalesA2*1.07)+5000

b. =(Lastyearsales+5000*1.07)

c. =LastyearsalesA2+5000*.07

d. =LastyearsalesA2*5000*1.07