Mortgage-affordability-calculator (2)

	A	C
2	Mortgage Affordability Calculator
3	Only complete the white boxes, shaded boxes are not editable
4
5	Monthly Income
6	Net monthly income (Client 1)	£0.00
7	Net monthly income (Client 2)	£0.00
8	Other monthly income	£0.00
9	Total Monthly Income	£0.00
10
11	Monthly Expenditure
12
13	Mortgage/Rent	£0.00
14
15	Committed Expenditure
16	Loans/credit cards	£0.00
17	Hire purchase agreements	£0.00
18	Child maintenance	£0.00
19	The cost of a mortgage repayment strategy (ISA etc)	£0.00
20	Subtotal	£0.00
21
22	Basic Essential Expenditure
23	Housekeeping (food and washing)	£0.00
24	Gas, electric and other heating	£0.00
25	Water	£0.00
26	Telephone	£0.00
27	Council tax	£0.00
28	Building insurance	£0.00
29	Ground rent and service charge for leasehold properties	£0.00
30	Essential travel (including to work or school)	£0.00
31	Subtotal	£0.00
32
33	Basic Quality of living costs
34	Clothing	£0.00
35	Household goods (such as furntiure and appliances)	£0.00
36	Personal goods (such as toiletries)	£0.00
37	Basic recreation (TV, basic recreation activities, non-essential transport)	£0.00
38	Childcare (nursery fees etc)	£0.00
39	Subtotal	£0.00
40
41	Other (add in below if applicable)	£0.00
42		£0.00
43		£0.00
44		£0.00
45		£0.00
46	Subtotal	£0.00
47
48	Total Monthly Expenditure	£0.00
49
50	Income less Monthly Expenditure	£0.00
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
101