1. Build an amortization table for an automobile loan. The user should be able to enter the amount they wish to finance, the interest rate, and the term of the loan. Have the amortization table show the number of monthly payments, the total payment in each period, the amount paid in interest in each period, thee amount paid to the principal in each period and the remaining balance for each period. Set this table up using the PMT, PPMT, IPMT functions. Also, make your table such that the user can only choose among loans that last 24, 36, 48, 60, or 72 months using either a scrolling or drop-down menu. Set up the table so that a 24 month loan shows exactly 24 payments, a 36 month loan shows exactly 36 payments, etc. Learning Objectives: Introduce students to Excel financial, lookup, and logical functions. Students will learn to develop complex spreadsheets incrementally by starting with a simple amortization table and modifying it to meet the requirements of the problem. Students will learn to use absolute, relative and mixed cell address references to build the spreadsheet through copying Students will learn how to incorporate roll-down menus and spinners (or sliders) into a spreadsheet to list and restrict user options. Students will learn how to use lookup and other reference functions. Students will learn cell formatting techniques to "hide" cell contents and be introduced to logical operators through the lF function Suggested Functions: PMT, PPMT, IPMT, IF, INDEX, LOOKUP (VLOOKUP and/or HLOOKUP)