ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Rooms 300
4
Investment 5,000,000
5
ROI 15 %
6
tax rate 25 %
7
8
CHART 1
9
Depreciation
10
 Building
11
 Furniture -
12
Rates and insurance 340,000
13
Insurance 120,000
14
Admin and general expenses 150,000
15
Advertising and promotions 200,000
16
Power 100,000
17
Interest 250,000
18
Operating Expences 560,000 1,720,000
19
20
21
Profit After tax 750,000
22
Tax Percentage 25 %
23
Profit Before Tax 1,000,000
24
Cost 1,720,000
25
Total Cost 2,720,000
26
Restaurant and Bar Profit 100,000
27
Nett Revenue 2,620,000
28
29
Occupancy Rate 80 %
30
No of Rooms 300
31
32
Room Rate 29.91
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