Project 7
Please do exercise 5 on page 131.
- Please add an additional column, in D that will hold extra payment.
- Cell e9 should be =d3
- Cell e10 should be =e9-(c10+d10)
- At the bottom of the sheet, (row 370) add up the interest column.
- Please print the first 20 rows of the sheet, make sure your name
in somewhere on this printout.
- Please write the answers to the following questions on your printout.
- If I don't pay any extra, how much does the loan cost?
- If I pay $10 extra each month, how much does the loan cost?
- How much does it save me to pay $1 extra on the first month
of the loan?