| A | B | C | D | |
| 1 | Amount Borrowed | 100000 | ||
| 2 | Starting interest | 0.055 | ||
| 3 | ||||
| 4 | Monthly Payment | |||
| 5 | Various Interest Rates below | 30 years | 15 years | Difference |
| 6 | =C2 | =PMT(A6/12,30*12,-$C$1) | =PMT(A6/12,15*12,-$C$1) | =C6-B6 |
| 7 | =A6+0.01 | =PMT(A7/12,30*12,-$C$1) | =PMT(A7/12,15*12,-$C$1) | =C7-B7 |
| 8 | =A7+0.01 | =PMT(A8/12,30*12,-$C$1) | =PMT(A8/12,15*12,-$C$1) | =C8-B8 |
| 9 | =A8+0.01 | =PMT(A9/12,30*12,-$C$1) | =PMT(A9/12,15*12,-$C$1) | =C9-B9 |
| 10 | =A9+0.01 | =PMT(A10/12,30*12,-$C$1) | =PMT(A10/12,15*12,-$C$1) | =C10-B10 |
| 11 | =A10+0.01 | =PMT(A11/12,30*12,-$C$1) | =PMT(A11/12,15*12,-$C$1) | =C11-B11 |
| 12 | ||||
| 13 | FINANCIAL CONSULTANT: | (your name goes here) | ||
| 14 | (1) Enter the data above | |||
| 15 | (2) Use Fill Handle for A8-A11 | |||
| 16 | (3)Change C2 to 5%, undo | |||
| 17 | (4) B6:=PMT(A6/12,30*12,-$C$1) | |||
| 18 | (5) B7:B11, Fill Handle | |||
| 19 | (6)Pointing&Dragging: D6:D11 | |||
| 20 | (7) Do Line 13 | |||
| 21 | (8) Save, Page Setup and Print |