Buy to let basics

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1								Rental per night	75	£58.33		Capital		Interest
2	Purchase Price	£165,000		Gross Income	£10,646		36.97%	Average rental length	3
3	Cash	£61,000		Marketing Costs	£532			Changeover cost	£50.00			Income	£10,646	£10,646
4	Buying Costs	£2,000	£115,500	Utilities	£3,000			% occupancy	50.00%			Costs	£3,532	£3,532
5	Mortgage	£106,000	64%	Mortgage Costs	£8,845.50			Airbnb fees	5%			Net	£7,114	£7,114
6	Mortgage Rate	3.1%		Income Tax	£2,490							Tax	£2,845	£2,845
7	Mortgage Costs - Year	£8,845.50	£737.13					Gross Income	£10,646
8	Mortgage Period (years)	15		Net Income	-£4,222	£7,114		AirBnB Fees	£532			Total Costs	£6,378	£6,378
9				Monthly Income	-£352	£593		Net	£10,114			Mortgage Costs	£8,845.50	£3,286
10	Monthly Rental Rate	£650	£87.13					Utilities	£1,800
11	Occupancy	100%		Property Inflation	£222,068			Council tax	£1,200			Total Total Costs	£15,223.21	£9,664
12	Changeover Cost	£0		Property Profit	£57,068				£3,000			Income	£10,646	£10,646
13	Marketing Charges	5%						Net net	£7,114			Profit	-£4,577	£982
14	Gross Income	£10,646							-£4,355	-£362.89		Monthly Profit	-£381	£82
15	Property Inflation Rate	2%		£87.13		£7,800		Mortgage	£8,845.50
16		£7,800						Maintenance	1200
17											Tax
18											£1,422.71
19	Interest Only Mortgage	£3,286	£274	£650	£376
20	Capital + Interest		£132,682.56			£624
21	Extra Interest Paid		£26,682.56	Amount per month	£1,000	Yrs to pay		Total paid	Tax Saved	Tax Paid		Difference
22				In pension	£1,400	6.31		£75,714	£30,286	£17,953		-£12,332
23				Not Pension	£1,000	8.83		£106,000	0	£25,135		£25,135
24
25
26
27
28
29
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