SA Tax Calculations

	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2	Harbut Road
3			Months	2010/11	2011/12	2013/14	2014/15	2015/16	2016/17	2017/18	2018/19	2019/20
4	Total Rent	£1,365.00	12	£16,380.00	£16,380.00	£16,800.00	16,800.00	£12,400.00	£18,311.00	£19,500.00
5	Rent paid by Samual Estates									£14,190.00
6	Rent lost to maint & fees									£5,310.00
7	Mortgage	£1,057.72	12	£12,692.64	£12,692.64	£9,139.08	£9,139.08	£6,853.00	£9,123.72	£11,457.00
8	Rent, rates, insurance, ground rents etc						£500.00	£500.00	£500.00	£500.00
9	Maintenance				£1,000.00	£1,000.00	£2,000.00	£6,343.00	£1,475.51	£2,655.00
10	Legal fees				£700.00	£700.00	£700.00	£700.00	£700.00	£2,655.00
11	10% wear and tear			£1,638.00	£1,638.00	£1,680.00	£1,680.00	£1,240.00	£1,831.10	£1,950.00
12	Profit or loss						£2,780.92
13
14	Greendale
15			Months	2010/11	2011/12	2013/14	2014/15	2015/16	2016/17	2017/18	2018/19	2019/20
16	Rent	£1,550.00	12				£17,050.00	£17,050.00	£19,375.00	£17,825.00
17	Mortgage	£882.52	12				£9,707.72	£10,668.00	£11,557.90	£13,553.00
18	Rent, rates, insurance, ground rents etc						£500.00	£500.00	£500.00	£500.00
19	Maintenance						£4,000.00	£3,000.00	£3,000.00	£2,945.00
20	Legal fees						£700.00	£700.00	£700.00	£700.00
21	10% wear and tear						£1,705.00	£1,705.00	£1,937.50	£1,782.50
22	Losses
23
24	Alberta Steet
25				2010/11	2011/12	2013/14	2014/15	2015/16	2016/17	2017/18	2018/19	2019/20	50% of current year
26	Rent					£16,949.00	£16,139.00	£16,139.00	16139.00	16139.00			8069.5
27	Mortgage					£10,335.00	£10,335.00	£10,335.00	10335.00	10335.00			3875.625	75% of this
28	Maintenance					£2,731.00	£1,065.00	£1,065.00	1065.00	1065.00			532.5
29	Legal fees												0
30	10% wear and tear					£1,695.00	£1,614.00	£1,614.00	1614.00	1614.00			807
31													0
32
33	Losses
34
35
36
37
38	TOTALS FOR TOM			2010/11	2011/12	2013/14	2014/15	2015/16	2016/17	2017/18	2018/19	2019/20
39
40	Rent								37686.00	37325.00
41	Mortgage								20681.62	25010.00
42	75% of mortgage									18757.50
43	Rent, rates, insurance, ground rents etc								1000.00	1000.00
44	Maintenance								4475.51	5600.00
45	Legal fees								1400.00	3355.00
46	10% wear and tear								3768.60	3732.50
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