ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAF
1
Input data (all other cells calculated from these)
cost/yrcostcost/yr amortised over
2
number of years:5101520Notes
3
Total (inc. amortisation)
£69,369.99£52,892.31£48,058.07£45,640.96
4
Total yearly:£40,364.60£40,364.60£38,389.61£38,389.61£38,389.61
5
Staff£30,399.08£30,399.08£30,399.08£30,399.08£30,399.08
6
Hotel Manager£20,000.00£20,000.00£20,000.00£20,000.00£20,000.00
Nominal 48 hrs/week, but likely to be fewer in practice as large "advice/mentoring slots" won't always be filled
7
Hotel Manager (pay in kind [food and board])
£3,954.89
8
Hotel Manager (total effective pay)£23,954.89
9
Pay/hour:Holiday cover£1,923.08£1,923.08£1,923.08£1,923.08£1,923.08
10
£8.00Weekend cleaning staff£1,976.00£1,976.00£1,976.00£1,976.00£1,976.00
4.75 hours a week (assuming 2 rooms minimum occupied)
11
£10.00Weekend manager£6,500.00£6,500.00£6,500.00£6,500.00£6,500.00
12.5 hours over Sat and Sun
12
Bills£4,765.52£2,990.53£2,990.53£2,990.53£2,990.53
13
Electricity£369.50£369.50£369.50£369.50£369.50
Standing charge + average usage for 1 person (http://shrinkthatfootprint.com/average-household-electricity-consumption)
14
Gas£709.50£709.50£709.50£709.50£709.50
Standing charge + average usage for 1 person (https://www.onaverage.co.uk/consumption-averages/average-gas-usage). Useage adjusted upward by factor of 2 to account for big drafty building, and £240/month direct debit - £2880/year - from previous owners)
15
Water£428.83£428.83£428.83£428.83£428.83
Standing charge + average usage for 1 person (https://www.ccwater.org.uk/households/using-water-wisely/averagewateruse/). Standing charge based on water bill from previous occupants (inc. 92p/day sewerage charge!)
16
Council Tax£1,170.70£1,170.70£1,170.70£1,170.70£1,170.70
17
Internet£312.00£312.00£312.00£312.00£312.00
Vodaphone 18 month contract, via https://www.uswitch.com/broadband/postcode_checker/results/?postcode=FY1%205AQ
18
Insurance£1,774.99£1,774.99£1,774.99£1,774.99£1,774.99
Guy Penn (Premium + £35 placement fee)
19
Other running costs
20
Cleaning/Kitchen supplies£54.75
21
22
Maintenance£5,000.00£5,000.00£5,000.00£5,000.00£5,000.00
23
Other costs£200.00
24
Staff Training£200.00£200.00£200.00£200.00£200.00
25
26
Total yearly (amortised costs):
£29,005.39£14,502.70£9,668.46£7,251.35
27
Purchase & setting up£144,826.95£28,965.39£14,482.70£9,655.13£7,241.35
28
Hotel£130,000.00£26,000.00£13,000.00£8,666.67£6,500.00
Is an asset that should be able to be sold for what it was bought for hopefully
29
Initial repairs£10,000.00£2,000.00£1,000.00£666.67£500.00
30
furnishings£2,550.00£510.00£255.00£170.00£127.50
desk, chair, lamp, multiplug with usb in each room, washing machines and dryers, toaster and hot water dispensers
31
survey£440.00£88.00£44.00£29.33£22.00
32
conveyancing fees£1,836.95£367.39£183.70£122.46£91.85
33
Other£200.00£40.00£20.00£13.33£10.00
34
Licenses£200.00£40.00£20.00£13.33£10.00
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