初创公司财务预测表

52,866,759
87,673,953
EBITA
892,043
百度文库
12,428,297
28,588,071
Monthly average Cum. loss Pay back period Income tax Interest Net profit
74337 892,043 0 (294,374)
1035691 12,428,297 0 (4,101,338)
4,368,000 1,080,000 288,000 0 240,000 1,560,000 0 1,200,000
29,440,000 7,776,000 2,592,000 6,000,000 288,000 6,880,000 2,304,000 3,600,000
100.00% 26.41% 8.80% 20.38% 0.98% 23.37% 7.83% 12.23%
100.00% 30.24% 13.10% 16.20% 0.28% 15.00% 8.96% 16.20%
249,722,112 89,579,520 41,803,776 36,000,000 497,664 33,953,280 23,887,872 24,000,000
100.00% 35.87% 16.74% 14.42% 0.20% 13.60% 9.57% 9.61%
100.00% 26.70% 11.98% 23.12% 4.83% 0.00% 23.97% 5.99% 1.80% 0.00% 1.62%
-106,379,360 -32,500,000 -14,800,000 -19,784,433 -4,942,800 0 -24,972,211 -6,386,000 -1,993,915 0 -1,000,000
62,626,432
Operation Cost 1. Set-up period 2. on-going period 3. management labor & overhead 4. Services Center 5. member card cost 6. Marketing promotion 7. Material cost 8. Post cost 9. Printing cost 10. Others
-3,257,557 -800,000 -367,500 -1,022,995 -255,540 0 -436,800 -255,440 -19,282 0 -100,000
-15,539,703 -3,000,000 -1,375,000 -6,147,524 -616,020 0 -2,944,000 -813,700 -143,458 0 -500,000
5.00%
-7,405,261
5.00%
-12,486,106
5.00%
95.00%
140,699,955
95.00%
237,236,006
95.00%
100.00% 24.97% 12.34% 29.69% 4.13% 0.00% 19.37% 5.06% 1.51% 0.00% 2.94%
-61,794,345 -16,500,000 -7,400,000 -14,284,816 -2,982,480 0 -14,810,522 -3,703,880 -1,112,647 0 -1,000,000
65,922,560 18,662,400 7,464,960 12,000,000 345,600 12,320,000 5,529,600 9,600,000
-218,400
-1,472,000
5.00%
-3,296,128
Gross Profit
4,149,600
27,968,000
95.00%
2382339 28,588,071 0 (9,434,064)
597669
8,326,959
19,154,008
2011
2012
2013
100.00% 28.31% 11.32% 18.20% 0.52% 18.69% 8.39% 14.56%
148,105,216 44,789,760 19,408,896 24,000,000 414,720 22,220,800 13,271,040 24,000,000
100.00% 30.55% 13.91% 18.60% 4.65% 0.00% 23.47% 6.00% 1.87% 0.00% 0.94%
78,905,610
130,856,647
6575468 78,905,610 0 (26,038,851)
10904721 130,856,647 0 (43,182,693)
100.00% 19.31% 8.85% 39.56% 3.96% 0.00% 18.95% 5.24% 0.92% 0.00% 3.22%
-34,038,361 -8,500,000 -4,200,000 -10,105,423 -1,404,840 0 -6,592,256 -1,722,160 -513,682 0 -1,000,000
Club Income Statement
(RMB) 2009 2010 2011
Revenue 1. Points Selling 2.Points Spending 3. Direct Marketing 4. Alliance Fee 5. Advertisement 6. credit card spending commission 7. Credit Card issue fee Business Tax (5%)