M.+Excel+Chapter+4

=Financial Functions, Data Tables, and Amortization Schedules=

Objectives

 * Control the color and thickness of outlines and borders
 * Assign a name to a cell and refer to the cell in a formula using the assigned name
 * Determine the monthly payment of a loan using the financial functions PMT
 * Use the financial functions PV (present value) and FV (future value)
 * Create a data table to analyze data in a worksheet
 * Add a pointer to a data table
 * Create an amortization schedule
 * Analyze worksheet data by changing values
 * Use names and print sections of a worksheet
 * Set print options
 * Protect and unprotect cells in a worksheet
 * Use the formula checking features of Excel
 * Hide and unhide cell gridlines, rows, columns, sheets, and workbooks

=//__**Notes** -__//=


 * 1) **What are some things that you will/have monthly payments for? Now or in the future? List at least 5-6**
 * 2) **How do you think Excel can help you with these monthly payments?**
 * 3) **What numbers (figures) do you need to figure a monthly payment?**
 * 4) **What is an amortization schedule?**
 * 5) **What is an interest rate?**
 * 6) **Figure the monthly payment with the following numbers:**
 * **Price: 250,000**
 * **Interest Rate: 6.00%**
 * **Years: 30**
 * **Monthly Payment:**

=//__**Assignments**__ -//=