# MATH 215Intro to Financial Mathematicsspring 2016

MATH 215Intro to Financial MathematicsSpring 2016

1. Merge A1, B1, and C1. Then type in: “loan parameters”
2. Widen columns E, F, G, H, and I.
3. Merge E1, F1, G1, H1, I1 and type in: “output variables”
4. Cell A3: type in “years”
5. Cell B3: type in 25
6. Cell A4: type in “rate/year”
7. Cell B4: format as percentage and then type in “6”
8. Cell A5: type in “loan amt.”
9. Cell B5: format as currency and then type in “100,000”
10. Merge E3 and F3 and then type in “monthly payment”
11. Cell G3 type in the equation below:
1. Type in the following words: “number “ in cell E5, “payment” in cell F5, “principal” in cell G5, “interest” in cell H5, and “balance” in cell I5
2. In cell E6 type in the number “1”
3. In cell E7 type in the equation: =1+E6
4. Select cells E7 down through E305 and then use fill down (instructor demonstrated)
5. Format Cells F6 through I6 as currency
6. In cell F6 type in the equation below (IF is in the LOGICAL menu under the FORMULAS tab):
1. Select F6 down through F305 and fill down.
2. In Cell H6 type in the equation:
3. In Cell G6 type in the equation:
4. In Cell I6 type in the equation:
5. In Cell H7 type in the equation:
6. In Cell G7 type in the equation:
7. In Cell I7 type in the equation:
8. Finally, select G7 – I7 down to G305 – I 305 and fill down
9. Now check the calculations in the spreadsheet by hand to eliminate any bugs.