ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Housing Payment Analysis - TemplateLegend:
2
InputCalculation - DO NOT TOUCH
3
4
 Scenario 1 Scenario 2
5
6
Annual Income
7
8
Monthly Income $ - $ -
9
10
Total Debt Capacity $ - $ -
11
12
Total Debt to Gross Income
13
14
Taxes & Insurance
15
16
Consumer Loans
17
18
Affordable Housing Payment Amount $ - $ -
19
20
Total Housing Debt to Gross Income#DIV/0!#DIV/0!
21
22
Interest Rate
23
24
Mortgage Payment Factor/$1000 of Mortgage
$2.78 $2.78
25
26
Mortgage Payment $ - $ -
27
28
Affordable Mortgage Amount $ - $ -
29
30
Down Payment Percentage
31
32
House Value $ - $ -
33
34
Equity $ - $ -
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