ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Debt Service-Debt Exclusion Calculator
2
3
This calculator is provided by the Division of Local Services only as a guide to assist communities in projecting debt service. Refer to M.G.L. Ch. 44 s.7 (inside debt limit) and Ch. 44 s.8 (outside debt limit) to determine allowable borrowing terms for various financing purposes. Any premiums and the cost of borrowing (i.e., legal or bond counsel fees) are not accounted for. We strongly advise municipalities to confirm borrowing conditions and calculations with the city or town treasurer and financial advisor.
4
5
Make entries or adjustments in "blue" encircled cells only.
6
7
8
1)Enter amount to be borrowed.
9
10
2)Enter borrowing conditions:Interest Rate (%)
11
Term (years)
12
13
3)Indicate ("x") payment type. Check both for comparisons.
14
15
a.
Projected annual payments: Level Debt Service
16
17
b.
Projected annual payments: Level Principal
18
19
20
Projected total payments over term.Total principle & interestTotal interest only
21
22
Level Debt Service
 0
23
24
Level Principal
 0
25
26
27
28
29
YearLevel debt serviceLevel principal
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
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