Окупаемость инвестиций (1200$).xlsx

	A	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Investment Payback Calculation
2	1 Apartment (one room), 28 sq.m.
3
4	INFO	AMOUNT			Average $/m2			1 200
5	Appartments	1			Rep/Furnit/Access.			600
6	Total Area (M2)	28			Total Investment			50 400
7
8	Description	TOTAL	Jan	Feb	March	April	May	June	July	Aug	Sept	Oct	Nov	Dec
9	Rooms	1	1	1	1	1	1	1	1	1	1	1	1	1
10	Occupancy %	60%	28%	24%	34%	67%	78%	87%	93%	95%	86%	62%	34%	26%
11	Rate $/night	94	80	70	80	90	100	110	120	140	110	80	70	80
12	Days		31	28	31	30	31	30	31	31	30	31	30	31
13
14	Total Income	22 423	694	470	843	1 809	2 418	2 871	3 460	4 123	2 838	1 538	714	645
15
16	Complex Service Fee (1$/m2)	336	28	28	28	28	28	28	28	28	28	28	28	28
17
18	Company Share (40%)	9 305	306	216	365	752	995	1 176	1 412	1 677	1 163	643	314	286
19	Operating expenses
20	Utilities	545	22	17	26	50	60	65	72	74	65	48	26	20
21	Insurance	336	28	28	28	28	28	28	28	28	28	28	28	28
22	Cleaning, amenities, laundry	1 525	61	47	74	141	169	183	202	206	181	135	71	56
23	Rooms Maintenance	218	9	7	11	20	24	26	29	29	26	19	10	8
24	PR and Marketing	336	10	7	13	27	36	43	52	62	43	23	11	10
25	Booking Systems (online)	1 682	52	35	63	136	181	215	259	309	213	115	54	48
26	Tourist companies	448	14	9	17	36	48	57	69	82	57	31	14	13
27	General and Admin Costs	327	13	10	16	30	36	39	43	44	39	29	15	12
28	Income Tax*(on behalf of owner)	1 121	35	24	42	90	121	144	173	206	142	77	36	32
29
30	Management Profit	2 767	62	32	76	193	290	376	484	636	372	138	49	58
31
32	Owners Net Profit	13 118	389	254	478	1 057	1 423	1 695	2 048	2 446	1 675	895	400	359
33
34	Monthly Service Fee 1$/m2		NB:	The average occypancy rate is taken based on the statistical data in the region of Tbilisi
35	24/7 Security Service & Monitoring			The rate $/night is taken in average as per the market rate in Tbilisi.
36	24/7 Reception and Bellboy services			This calculation represents the assumtions and shall not be taken as commitment or obligation
37	General area technical maintenance
38	General area Cleaning & Maintenance
39	Elevator Maintenance
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