Use Excel PMT Function and Labeled Calculator Grid. Car Loan Payments (15 Points) - Start with a new, blank Excel workbook. - Save the workbook to the desktop. Put your name in the file name. - Word Problem: Bridget is getting a loan for a car from Auto Land. Auto Land sells cars and finances loans. She is buying a car that costs $67,500, paying $2000 for the down payment, and financing the rest (getting a loan for the rest). Auto Land has offered an annual interest rate (APR) of 6.5% for monthly payments over 5 years for the loan. - Using a blank worksheet, build from scratch the labeled calculator grid that answers the following questions utilizing the PMT function covered in class: What is the periodic payment? What is the lender profit? - Required for credit: Build the full "calculator" as taught in class with the appropriate labels. - Use cell references where possible to create a fully dynamic and flexible "calculator" as practiced in class. - Label your answers dearly. - Name the worksheet tab "PMT" (double-click on the tab to rename it). - Re-save the workbook to the desktop. Use Excel FV Function and Labeled Calculator Grid. IRA Investment (15 Points) - Add a new, blank Excel worksheet within the same workbook - Word Problem: Assume that you plan to contribute $6,000 annually to an IRA for 42 years, and that you expect the IRA to earn 10% interest annually (APR is 10% ). - On a blank worksheet in the existing workbook build a labeled calculator grid that answers the following questions utilizing the FV function covered in class: What is the future value of the investment? Also, what is the investor profit? (The interest earned.) - Required for credit: Build the full "calculator grid" as taught in class with the appropriate labels. Use cell references where possible to create a fully dynamic and flexible "calculator" as practiced in class. - Label your answers clearly. - Name the worksheet tab "FV". - Re-save the workbook to the desktop. Make sure your name is in the file name. - Close the workbook