In this exercise, you will be creating your own Excel spreadsheets. Create your spreadsheets so that anyone can look at it and know what it is about. In other words, include a title and the column and row headings as well as the numeric data and results from your formulas. Using FV (Future Value Built-In Function) You are wanting to start putting aside some of your paycheck each month into your savings account. There is a 5-year CD that you can get that pays 3.5% annual interest rate. You decide to contribute $50 each month for 5 years. How much money would you have after 5 years if you invest in this CD? Create a spreadsheet in Excel that lays out the information needed to calculate the Future Value of your investment. Save this file as Chapter 10-investment $50 each month 5 years 3.5% annual interest rate Use the FV built-in Excel function to help you to figure out how much money you would have after 5 years. Using PMT (Payment Built-in Function) You want to buy a car that costs $34,000. You can get a 3-year loan for $30,000 from Bank of America at 3.2% annual interest rate. What would your monthly payment be? Create an Excel Spreadsheet that has the loan information laid out so that you can submit this spreadsheet to me so that I can see what the monthly payment would be. Save this file as Ch10-carpayment Use the PMT built-in Excel function to help you to figure out what your monthly car payment would be. $30,000 loan 3 years 3.2% annual interest rate