Your parents gave you $$1,100$ a year before your graduation date so that you can take a trip when you graduate. You wisely decide to invest the money in a bank $CD$ that pays $7\mathrm{.}44$ percent interest. You know that the trip costs $$1,467$ right now and that inflation for the year is predicted to be $3\mathrm{.}60$ percent.

Excel Template

$($Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you've been given here, and be sure to update any values that may have been pre$-$entered in the template based on the textbook version of the problem.$)$

Calculate how much will the CD be worth at the end of the year? $($Round answers to $2$ decimal places, e$.$g$.17\mathrm{.}54.)$

CD$\text{'}$s worth $

What will be the price of the trip at the end of the year?

Price $

Will you have enough money in a year to purchase the trip?