ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Debt Capacity Analysis
2
3
4
5
Agency:INSERT NONPROFIT NAME HERE
6
7
8
SUPPORT AND REVENUE
14
Ordinary total revenue $0
15
New Revenue Projected (if any)$0
16
New Government Grant (if any)$0
17
Total Revenue$0
18
19
EXPENSES
20
Salaries and benefits$0
21
Occupancy$0
22
Interest$0
23
Depreciation$0
24
Other$0
25
Total Expenses$0
26
27
Net Surplus/(Deficit)$0
28
29
Add: Interest$0
30
 Depreciation 0
31
 Other non cash (add back any projected savings from changing facilities; for example, rent that you budget for that will not be available for debt service payments)$0
32
Cash Flow for Debt Service$0
33
34
35
36
37
Enter req. min. DCR->Minimum DCR1.15x
38
39
Do Not Edit ->Maximum incremental debt service$0.00
40
41
CAN EDITAmortization (in years)15
42
43
CAN EDITInterest Rate (Based on amortization)6.50%
44
45
Do Not Edit ->Maximum incremental debt capacity$0
46
47
OPTIONAL: If you want to estimate loan payments
48
Payment Calculator
49
Principal0.00
50
Interest Rate6.50%
51
Amortization180
52
53
Monthly Payment$0.00
54
Annual Debt Service$0.00
55
200 bp Rate Shock Monthly$0.00
56
Annual w/ Rate Shock$0.00
57
58
59
60
61
62
63
64
65
66
67
Do not delete
68
69
Am
70
5
71
10
72
15
73
20
74
Rate
75
5.25%
76
5.25%
77
5.25%
78
6.25%
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105