ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Payment Options Calculator
Peter Kapitola Aug 2017
2
3
Instructions
4
1. Enter your information in the green cells. Some of these are already filled out as an example. You can just type over these.
5
2. Enter your interest rate in cell B10. This is related to what your money would be doing if you didn't pay the bill upfront. It might be your offset homeloan interest rate, or your savings account interest rate.
6
3. Enter your payment dates down the left in column A
7
4. Enter the amounts payable in columns B, C, D, and/or E. This will depend on what payment options are available. Leave the cells blank if the payment option is not allowed.
8
4. Look in Row 44 to see how much additional you pay if you don't pay up front. Then you have to make a personal decision on whether this amount of money is worth having the flexibility and easier budgeting of not paying up front.
9
10
Interest Rate5.59%/year
11
12
Number of Periods
13
Payment Dates1241226
14
4-Sep-2023 $ 2,336 $ 1,173 $ 591
15
6-Nov-2023 $ 1,173 $ 591
16
8-Jan-2024 $ 591
17
11-Mar-2024 $ 591
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
 $ 2,336 $ 2,345 $ 2,364 $ - $ -
39
Extra Cost $ 9 $ 27
40
41
Saved Interest $ 11.34 $ 5.72 $ - $ -
42
 $ 11.49 $ - $ -
43
 $ 17.31 $ - $ -
44
 $ - $ -
45
 $ - $ -
46
 $ - $ -
47
 $ - $ -
48
 $ - $ -
49
 $ - $ -
50
 $ - $ -
51
 $ - $ -
52
 $ -
53
 $ -
54
 $ -
55
 $ -
56
 $ -
57
 $ -
58
 $ -
59
 $ -
60
 $ -
61
 $ -
62
 $ -
63
 $ -
64
65
 $ - $ 11 $ 35 $ - $ -
66
67
Net $ 2,336 $ 2,334 $ 2,329 $ - $ -
68
69
Additional Cost - $ (2) $ (7)
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100