The Other Home _ Financial Model

	A	B	C	D	E
1	Summary of Accounts Till Date
2
3			2010*	2011	2012**
4	A	Turnover	53,767.0	1,030,436.0	516,343.5
5	B	Booking Amount	59,485.0	993,641.5	466,972.0
6	(A-B)	Gross Profit (Commission)	-5,718.0	36,794.5	49,371.5
7
8
9	The Other Home - Revenue
10	1	Particulars	2010*	2011	2012**
11	1a	Subscription Fees	7,000.0	0.0	0.0
12	1b	Commission through Booking	-5,718.0	36,794.5	49,371.5
13	1c	Advertising Revenue	0.0	16318.01	10,282.1
14		Total Revenue (In Rs.)	1,282.0	53,112.5	59,653.5
15
16	The Other Home - Expenses
17	2	Expenses	2010*	2011	2012**
18	2b	Advertisement Exp	33,171.9	252543.27	70,916.5
19	2c	Business Promotion	14,733.0	22,952.5	15,706.2
20	2d	Computers & Consumables	8,620.0	9,050.0	89,565.0
21	2e	Office Expenses	15,630.0	7,223.0	29,100.7
22	2f	Printing & Stationery	17,925.0	1,975.0	3,000.0
23	2g	Professional Charges	30,013.9	12,500.0	45,330.0
24	2h	Rent	25,600.0	61,510.0	126,000.0
25	2i	Salary & Wages	66,500.0	184,582.0	125,150.0
26	2j	Telephone Expenses	13,525.0	22,974.0	9,462.0
27	2k	Website Development	83,432.6	114,635.1	38,773.8
28	2l	Others	38,674.9	27,791.4	5,016.9
29		Total Expenditure (in Rs.)	404,157.33	717,736.32	558,021.04
30		Profit (+) / Loss (-)	-402,875.33	-664,623.84	-498,367.52
31
32	* August'10 to March'11
33	** April'12 to June'12
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