ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
M00848838Yusuf Hussain
3
M00853855Rick Darren Menezes
4
5
Income statement forevast for the 5 years 2023-2027, showing 2022 for reference.
6
7
ParticularsLast yearYear 1Year 2Year 3Year 4Year 5 Totals
8
202220232024202520262027
9
10
Revenue
11
1. Standard Rooms £ 277,074 £ 289,870 £ 299,586 £ 305,690 £ 310,982 £ 315,812 £ 1,799,014
12
2. Deluxe Rooms £ 206,280 £ 224,482 £ 239,925 £ 252,905 £ 264,747 £ 278,261 £ 1,466,599
13
3. Apartments - £ 69,420 £ 142,243 £ 162,445 £ 170,640 £ 177,830 £ 722,579
14
15
Total Revenue £ 483,354 £ 583,772 £ 681,754 £ 721,040 £ 746,369 £ 771,903 £ 3,988,192
16
17
Less : Cost of Sales
18
19
1. Laundry service £ 49,275 £ 59,130 £ 62,087 £ 65,191 £ 68,451 £ 71,874 £ 376,008
20
21
2. Toiletries pack £ 9,965 £ 10,264 £ 10,572 £ 10,889 £ 11,216 £ 11,552 £ 64,458
22
23
3. Room cleaning wages £ 28,750 £ 36,368 £ 43,754 £ 46,768 £ 49,954 £ 53,514 £ 259,108
24
25
Total Cost of Sales £ 87,990 £ 105,762 £ 116,413 £ 122,848 £ 129,621 £ 136,940 £ 699,574
26
27
Gross Profit £ 395,364 £ 478,010 £ 565,341 £ 598,192 £ 616,748 £ 634,963 £ 3,288,618
28
29
Overhead Expenses
30
31
Fixed Overhead expenses
32
33
1. Lease payments £ 120,000 £ 130,500 £ 138,000 £ 138,000 £ 138,000 £ 138,000 £ 802,500
34
35
2. Business rates £ 36,000 £ 39,150 £ 41,400 £ 41,400 £ 41,400 £ 41,400 £ 240,750
36
37
3. Depreciation cost £ 17,500 £ 21,000 £ 22,050 £ 23,153 £ 24,311 £ 25,527 £ 133,541
38
39
4. Insurances £ 1,500 £ 1,605 £ 1,717 £ 1,837 £ 1,966 £ 2,104 £ 10,729
40
41
5. Salaries £ 126,600 £ 134,196 £ 142,248 £ 150,783 £ 159,830 £ 169,420 £ 883,077
42
43
Variable Overhead Expenses
44
45
6. Utilities cost £ 54,704 £ 164,112 £ 170,676 £ 177,503 £ 184,603 £ 191,987 £ 943,585
46
47
7. Bad debts £ 2,417 £ 2,919 £ 3,409 £ 3,605 £ 3,732 £ 3,860 £ 19,942
48
49
8. Transportation cost £ 6,000 £ 6,420 £ 6,869 £ 7,350 £ 7,865 £ 8,416 £ 42,920
50
51
9. Advertising expenditure £ 4,834 £ 5,838 £ 6,818 £ 7,210 £ 7,464 £ 7,719 £ 39,883
52
53
10. Miscellaneous expenses
£ 1,522 £ 1,629 £ 1,743 £ 1,865 £ 1,995 £ 2,135 £ 10,889
54
55
11. Commissions Cost £ 6,188 £ 6,734 £ 7,198 £ 7,587 £ 7,942 £ 8,348 £ 43,997
56
57
Total Overhead Expenses £ 377,265 £ 514,103 £ 542,128 £ 560,293 £ 579,108 £ 598,916 £ 3,171,813
58
59
Operating profit £ 18,099 -£ 36,093 £ 23,213 £ 37,899 £ 37,640 £ 36,047 £ 116,805
60
61
Contribution to hotel profits
£ 18,099 -£ 17,994 £ 5,219 £ 43,118 £ 80,758 £ 116,805
62
63
64
Monthly cash flow forecasts for the year 2023
65
66
Particulars January FebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotal
67
68
69
Inflows
70
71
Sales receipts £ 8,464 £ 5,193 £ 11,825 £ 19,956 £ 61,556 £ 73,145 £ 74,895 £ 87,145 £ 90,557 £ 83,428 £ 33,526 £ 19,625 £ 569,315
72
73
Overdraft availed £ - £ 24,500 £ 67,400 £ 96,500 £ 94,900 £ 138,000 £ 131,900 £ 114,900 £ 127,300 £ 90,900 £ 91,500 £ 147,300 £ 1,125,100
74
75
Total inflows £ 8,464 £ 29,693 £ 79,225 £ 116,456 £ 156,456 £ 211,145 £ 206,795 £ 202,045 £ 217,857 £ 174,328 £ 125,026 £ 166,925 £ 1,694,415
76
77
Outflows
78
79
1. Laundry service £ 1,089 £ 411 £ 1,645 £ 1,645 £ 7,459 £ 7,459 £ 7,459 £ 8,849 £ 8,849 £ 8,849 £ 2,168 £ 2,168 £ 58,050
80
81
2. Toiletries pack £ 189 £ 71 £ 286 £ 286 £ 1,295 £ 1,295 £ 1,295 £ 1,536 £ 1,536 £ 1,536 £ 376 £ 376 £ 10,077
82
83
3.Room cleaning wages £ 253 £ 1,012 £ 1,012 £ 4,588 £ 4,588 £ 4,588 £ 5,443 £ 5,443 £ 5,443 £ 1,333 £ 1,333 £ 1,333 £ 36,369
84
85
4. Utilities payments £ 1,142 £ 4,566 £ 4,566 £ 20,703 £ 20,703 £ 20,703 £ 24,560 £ 24,560 £ 24,560 £ 6,017 £ 6,017 £ 6,017 £ 164,112
86
87
5. Advertising £ 208 £ 41 £ 162 £ 162 £ 736 £ 736 £ 736 £ 874 £ 874 £ 874 £ 214 £ 214 £ 5,832
88
89
6. Lease payments £ 30,000 £ 31,500 £ 34,500 £ 34,500 £ 130,500
90
91
7. Business rates £ 3,000 £ 3,000 £ 3,000 £ 3,263 £ 3,263 £ 3,263 £ 3,263 £ 3,263 £ 3,263 £ 3,263 £ 3,263 £ 3,263 £ 38,367
92
93
8. Transportation costs £ 230 £ 45 £ 179 £ 179 £ 810 £ 810 £ 810 £ 961 £ 961 £ 961 £ 235 £ 235 £ 6,415
94
95
9. Salaries £ 11,183 £ 11,183 £ 11,183 £ 11,183 £ 11,183 £ 11,183 £ 11,183 £ 11,183 £ 11,183 £ 11,183 £ 11,183 £ 11,183 £ 134,196
96
97
10. Insurances £ 134 £ 134 £ 134 £ 134 £ 134 £ 134 £ 134 £ 134 £ 134 £ 134 £ 134 £ 134 £ 1,608
98
99
11. Commissions cost £ 6,734 £ 6,734
100