Financial Projection Phyathai 123 April 2007
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Financial Projection Phyathai 123 April 2007 as PDF for free.
More details
- Words: 1,276
- Pages: 11
Financial Report Phyathai 1 Hospital OPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
59,617,947
52,754,123
65,189,898
59,417,006
Actual 2006
50,492,504
49,667,717
51,136,752
49,936,353
Target
55,139,965
54,238,403
55,842,531
54,531,150
Diff Last Year
9,125,443
3,086,406
14,053,146
9,480,653
Diff Target
4,477,982
(1,484,280)
9,347,367
4,885,856
18.07
6.21
27.48
18.99
8.12
(2.7)
16.74
9
Percent Diff Last year Percent Diff Target
IPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
61,059,420
51,335,389
60,330,477
49,025,369
Actual 2006
56,802,542
51,712,985
55,698,229
51,260,200
Target
66,740,030
60,749,256
65,463,751
60,270,831
4,256,878
(377,596)
4,632,248
(2,234,831)
(5,680,610)
(9,413,867)
(5,133,274)
(11,245,462)
7.5
(0.7)
8.3
(4.4)
(8.5)
(15.5)
(7.8)
(18.7)
Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
Total GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
120,677,367
104,089,512
125,520,375
108,442,375
Actual 2006
107,295,046
101,380,701
106,834,981
101,196,553
Target
121,879,996
114,987,658
121,306,282
114,801,981
Diff Last Year
13,382,321
2,708,811
18,685,394
7,245,822
Diff Target
(1,202,629)
(10,898,146)
4,214,093
(6,359,607)
Percent Diff Last year
12.5
2.7
17.5
7.2
Percent Diff Target
(1.0)
(9.5)
3.5
(5.5)
EBITDA
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
24,570,969
1,673,711
18,305,080
6,149,182
Actual 2006
19,358,833
17,008,649
14,196,215
13,725,148
5,212,136
(15,334,938)
4,108,865
(7,575,966)
Percent Diff Last year
26.92
(90.2)
28.94
(55.2)
EBITDA to Gross Sale
20.36%
1.61%
14.58%
5.67%
Diff Last Year
Seasonal from 2006 OPD IPD
B1Jan-06
7.6% 8.4%
B1Feb-06
7.5% 7.7%
B1Mar-06
7.7% 8.3%
B1Apr-06
7.5% 7.6%
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
54,569,469
54,583,840
58,248,202
59,943,525
60,519,304
59,591,412
59,608,408
63,609,995
65,458,993
66,089,440
(54,569,469)
(54,583,840)
(58,248,202)
(59,943,525)
(60,519,304)
(59,591,412)
(59,608,408)
(63,609,995)
(65,458,993)
(66,089,440)
(100.0)
(100.0)
(100.0)
(100.0)
(100.0)
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
58,293,778
53,417,548
57,126,365
65,289,033
54,956,773
68,525,984
62,834,597
67,164,572
76,729,106
64,591,127
(58,293,778)
(53,417,548)
(57,126,365)
(65,289,033)
(54,956,773)
(68,525,984)
(62,834,597)
(67,164,572)
(76,729,106)
(64,591,127)
(100)
(100)
(100)
(100)
(100)
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
112,863,248
108,001,388
115,374,566
125,232,558
115,476,078
128,117,396
122,443,005
130,774,568
142,188,099
130,680,567
(112,863,248)
(108,001,388)
(115,374,566)
(125,232,558)
(115,476,078)
(128,117,396)
(122,443,005)
(130,774,568)
(142,188,099)
(130,680,567)
(100.0)
(100.0)
(100.0)
(100.0)
(100.0)
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
13,140,629
14,835,497
14,550,787
20,982,020
10,055,042
(13,140,629)
(14,835,497)
(14,550,787)
(20,982,020)
(10,055,042)
(100.0)
(100.0)
(100.0)
(100.0)
(100.0)
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
B1May-06
8.2% 8.7%
B1Jun-06
8.2% 7.9%
B1Jul-06
B1Aug-06
8.8% 8.5%
9.0% 9.7%
B1Sep-06
9.1% 8.2%
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
56,028,123
60,512,542
56,970,798
61,183,234
66,081,170
62,214,731
165,220,899
(56,028,123)
(60,512,542)
(56,970,798)
0
(61,183,234)
(66,081,170)
(62,214,731)
(165,220,899)
(100.0)
(100.0)
(100.0)
(100.0)
B1Oct-07
B1Nov-07
B1Dec-07
662,609,127
YTD.
723,589,433
Total
63,949,974
54,693,702
50,391,889
673,593,019
75,147,540
64,311,450
59,256,482
791,784,725
(63,949,974)
(54,693,702)
(50,391,889)
0
(75,147,540)
(64,311,450)
(59,256,482)
0.00
(100)
(100)
(100)
#DIV/0!
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
119,978,097
115,206,244
107,362,686
136,330,774
130,392,620
121,471,213
165,220,899
(119,978,097)
(115,206,244)
(107,362,686)
0
(136,330,774)
(130,392,620)
(121,471,213)
(165,220,899)
(100.0)
(100.0)
(100.0)
(100.0)
B1Oct-07
B1Nov-07
B1Dec-07
1,336,202,146
YTD.
Total
14,087,495
10,796,205
(3,926,896)
158,809,623
(14,087,495)
(10,796,205)
3,926,896
(158,809,623)
(100.0)
(100.0)
(100.0)
(100.0)
#DIV/0!
#DIV/0!
#DIV/0!
#REF!
B1Oct-06
8.5% 9.5%
B1Nov-06
9.1% 8.1%
B1Dec-06
8.6% 7.5%
1,515,374,158
100.0% 100.0%
Growth%
-
Growth%
-
Growth%
-
Growth%
-
Financial Report Phyathai 2 Hospital OPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
79,731,311
72,728,954
86,365,769
74,465,565
Actual 2006
68,878,708
66,697,998
70,295,057
68,305,477
Diff Last Year
10,852,603
6,030,957
16,070,712
6,160,089
Diff Target
79,731,311
72,728,954
86,365,769
74,465,565
15.76
9.04
22.86
9.02
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Target
Percent Diff Last year Percent Diff Target
IPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
82,980,437
80,619,137
91,178,524
88,813,262
Actual 2006
75,905,902
73,968,571
79,152,984
73,070,111
7,074,535
6,650,566
12,025,539
15,743,151
82,980,437
80,619,137
91,178,524
88,813,262
9.32
8.99
15.19
21.55
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Target Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
Total GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
162,711,748
153,348,091
177,544,292
163,278,828
Actual 2006
144,784,611
140,666,569
149,448,041
141,375,588
Target Diff Last Year Diff Target
-
-
-
17,927,138
12,681,522
28,096,252
21,903,240
162,711,748
153,348,091
177,544,292
163,278,828
12.38
9.02
18.80
15.49
Percent Diff Last year Percent Diff Target
EBITDA
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
22,800,690
17,553,590
32,871,035
18,812,872
Actual 2006
26,733,953
22,885,880
25,191,849
20,192,866
Diff Last Year
(3,933,263)
(5,332,290)
7,679,186
(1,379,995)
Percent Diff Last year
(14.7)
(23.3)
30
(6.8)
EBITDA to Gross Sale
14.01%
11.45%
Seasonal from 2006 OPD IPD
B1Jan-06
7.6% 7.8%
B1Feb-06
7.4% 7.6%
18.51%
B1Mar-06
7.8% 8.1%
11.52%
B1Apr-06
7.5% 7.5%
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
76,195,223
69,977,701
81,464,655
80,476,531
77,059,972
(76,195,223)
(69,977,701)
(81,464,655)
(80,476,531)
(77,059,972)
0
0
0
0
0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
80,002,178
76,795,741
88,052,965
89,268,250
90,464,350
(80,002,178)
(76,795,741)
(88,052,965)
(89,268,250)
(90,464,350)
0
0
0
0
0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
B1May-07
B1Jun-07 -
B1Jul-07 -
B1Aug-07 -
B1Sep-07 -
-
156,197,401
146,773,443
169,517,620
169,744,781
167,524,322
(156,197,401)
(146,773,443)
(169,517,620)
(169,744,781)
(167,524,322)
0
0
0
0
0
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
20,632,606
14,842,600
28,960,732
28,344,987
25,078,029
(20,632,606)
(14,842,600)
(28,960,732)
(28,344,987)
(25,078,029)
(100.0)
(100.0)
(100.0)
(100.0)
(100.0)
B1May-06
8.4% 8.2%
B1Jun-06
7.7% 7.9%
B1Jul-06
B1Aug-06
9.0% 9.1%
8.9% 9.2%
B1Sep-06
8.5% 9.3%
B1Oct-07
B1Nov-07
83,762,551
B1Dec-07
83,372,283
YTD.
Total
80,364,211
906,850,365 -
-
(83,762,551)
(83,372,283)
(80,364,211)
0
0
0
0
0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
B1Oct-07
B1Nov-07
88,884,213
B1Dec-07
78,801,517
YTD.
Total
78,504,095
972,870,879 -
(88,884,213)
(78,801,517)
(78,504,095)
0
0
0
0
0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
B1Oct-07
B1Nov-07 -
B1Dec-07 -
172,646,763
YTD.
Total
-
162,173,800
158,868,306
1,879,721,244 -
-
(172,646,763)
(162,173,800)
(158,868,306)
0
0
0
0
0
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
24,023,250
20,320,349
7,678,669
264,885,770
(24,023,250)
(20,320,349)
(7,678,669)
(264,885,770)
(100.0)
(100.0)
(100.0)
(100.0)
B1Oct-06
9.2% 9.1%
B1Nov-06
9.2% 8.1%
B1Dec-06
8.9% 8.1%
100.0% 100.0%
Growth%
###
Growth%
###
Growth%
###
Growth%
###
Financial Report Phyathai 3 Hospital OPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
54,039,946
49,341,024
56,651,955
52,394,072
Actual 2006
44,311,760
41,927,174
45,931,199
43,532,467
9,728,186
7,413,850
10,720,756
8,861,605
54,039,946
49,341,024
56,651,955
52,394,072
21.95
17.68
23.34
20.36
Target Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
IPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
54,896,399
49,547,402
56,601,340
47,467,012
Actual 2006
45,411,779
43,825,119
51,311,585
44,515,774
9,484,620
5,722,283
5,289,755
2,951,238
54,896,399
49,547,402
56,601,340
47,467,012
20.89
13.06
10.31
6.63
Target Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
Total GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
108,936,345
98,888,426
113,253,295
99,861,085
Actual 2006
89,723,539
85,752,293
97,242,784
88,048,241
Target Diff Last Year Diff Target
-
-
-
-
19,212,806
13,136,133
16,010,512
11,812,844
108,936,345
98,888,426
113,253,295
99,861,085
21.41
15.32
16.46
13.42
Percent Diff Last year Percent Diff Target
EBITDA
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
21,472,950
12,746,997
18,691,007
13,138,701
Actual 2006
19,813,074
17,875,423
18,502,988
15,691,155
1,659,877
(5,128,426)
188,018
(2,552,453)
Percent Diff Last year
8.4
(28.7)
1.0
(16.3)
EBITDA to Gross Sale
19.71%
12.89%
Diff Last Year
Seasonal from 2006 OPD IPD
B1Jan-06
7.5% 7.6%
B1Feb-06
7.1% 7.3%
16.50%
B1Mar-06
7.8% 8.5%
13.16%
B1Apr-06
7.4% 7.4%
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
47,484,186
47,260,718
53,047,818
53,400,390
51,494,449
53,225,770
(47,484,186)
(47,260,718)
(53,047,818)
(53,400,390)
(51,494,449)
(53,225,770)
0
0
0
0
0
0
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
48,073,647
50,592,180
54,610,649
59,514,624
54,508,886
49,978,868
(48,073,647)
(50,592,180)
(54,610,649)
(59,514,624)
(54,508,886)
(49,978,868)
0
0
0
0
0
0
B1May-07
B1Jun-07
95,557,833
B1Jul-07
97,852,898
-
B1Aug-07
107,658,467
-
B1Sep-07
112,915,014
-
B1Oct-07
106,003,334
-
103,204,638
-
-
(95,557,833)
(97,852,898)
(107,658,467)
(112,915,014)
(106,003,334)
(103,204,638)
0
0
0
0
0
0
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
13,925,627
13,971,827
22,131,284
19,552,585
16,765,769
13,533,183
(13,925,627)
(13,971,827)
(22,131,284)
(19,552,585)
(16,765,769)
(13,533,183)
(100.0)
(100.0)
(100.0)
(100.0)
(100.0)
(100.0)
B1May-06
8.1% 8.0%
B1Jun-06
8.1% 8.4%
B1Jul-06
B1Aug-06
9.0% 9.1%
9.1% 9.9%
B1Sep-06
8.8% 9.1%
B1Oct-06
9.1% 8.3%
B1Nov-07
B1Dec-07
51,665,350
YTD.
Total
53,803,570
587,084,851 -
(53,803,570)
0
0
0
0
B1Dec-07
48,302,527
75,524,276.68
-
(51,665,350)
B1Nov-07
Growth%
YTD.
Total
50,194,666
Growth%
600,840,303
72,752,715.63
(48,302,527)
(50,194,666)
0
0
0
0
B1Nov-07
B1Dec-07
99,967,877
YTD.
103,998,236
-
Total
-
-
1,187,925,154
-
(103,998,236)
0
0
0
0
B1Dec-07
YTD.
Total
11,570,964
5,335,313
188,669,191
(11,570,964)
(5,335,313)
(188,669,191)
(100.0)
(100.0)
(100.0)
B1Nov-06
8.8% 8.0%
B1Dec-06
9.2% 8.4%
###
-
(99,967,877)
B1Nov-07
Growth%
100.0% 100.0%
Growth%
###
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
59,617,947
52,754,123
65,189,898
59,417,006
Actual 2006
50,492,504
49,667,717
51,136,752
49,936,353
Target
55,139,965
54,238,403
55,842,531
54,531,150
Diff Last Year
9,125,443
3,086,406
14,053,146
9,480,653
Diff Target
4,477,982
(1,484,280)
9,347,367
4,885,856
18.07
6.21
27.48
18.99
8.12
(2.7)
16.74
9
Percent Diff Last year Percent Diff Target
IPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
61,059,420
51,335,389
60,330,477
49,025,369
Actual 2006
56,802,542
51,712,985
55,698,229
51,260,200
Target
66,740,030
60,749,256
65,463,751
60,270,831
4,256,878
(377,596)
4,632,248
(2,234,831)
(5,680,610)
(9,413,867)
(5,133,274)
(11,245,462)
7.5
(0.7)
8.3
(4.4)
(8.5)
(15.5)
(7.8)
(18.7)
Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
Total GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
120,677,367
104,089,512
125,520,375
108,442,375
Actual 2006
107,295,046
101,380,701
106,834,981
101,196,553
Target
121,879,996
114,987,658
121,306,282
114,801,981
Diff Last Year
13,382,321
2,708,811
18,685,394
7,245,822
Diff Target
(1,202,629)
(10,898,146)
4,214,093
(6,359,607)
Percent Diff Last year
12.5
2.7
17.5
7.2
Percent Diff Target
(1.0)
(9.5)
3.5
(5.5)
EBITDA
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
24,570,969
1,673,711
18,305,080
6,149,182
Actual 2006
19,358,833
17,008,649
14,196,215
13,725,148
5,212,136
(15,334,938)
4,108,865
(7,575,966)
Percent Diff Last year
26.92
(90.2)
28.94
(55.2)
EBITDA to Gross Sale
20.36%
1.61%
14.58%
5.67%
Diff Last Year
Seasonal from 2006 OPD IPD
B1Jan-06
7.6% 8.4%
B1Feb-06
7.5% 7.7%
B1Mar-06
7.7% 8.3%
B1Apr-06
7.5% 7.6%
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
54,569,469
54,583,840
58,248,202
59,943,525
60,519,304
59,591,412
59,608,408
63,609,995
65,458,993
66,089,440
(54,569,469)
(54,583,840)
(58,248,202)
(59,943,525)
(60,519,304)
(59,591,412)
(59,608,408)
(63,609,995)
(65,458,993)
(66,089,440)
(100.0)
(100.0)
(100.0)
(100.0)
(100.0)
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
58,293,778
53,417,548
57,126,365
65,289,033
54,956,773
68,525,984
62,834,597
67,164,572
76,729,106
64,591,127
(58,293,778)
(53,417,548)
(57,126,365)
(65,289,033)
(54,956,773)
(68,525,984)
(62,834,597)
(67,164,572)
(76,729,106)
(64,591,127)
(100)
(100)
(100)
(100)
(100)
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
112,863,248
108,001,388
115,374,566
125,232,558
115,476,078
128,117,396
122,443,005
130,774,568
142,188,099
130,680,567
(112,863,248)
(108,001,388)
(115,374,566)
(125,232,558)
(115,476,078)
(128,117,396)
(122,443,005)
(130,774,568)
(142,188,099)
(130,680,567)
(100.0)
(100.0)
(100.0)
(100.0)
(100.0)
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
13,140,629
14,835,497
14,550,787
20,982,020
10,055,042
(13,140,629)
(14,835,497)
(14,550,787)
(20,982,020)
(10,055,042)
(100.0)
(100.0)
(100.0)
(100.0)
(100.0)
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
B1May-06
8.2% 8.7%
B1Jun-06
8.2% 7.9%
B1Jul-06
B1Aug-06
8.8% 8.5%
9.0% 9.7%
B1Sep-06
9.1% 8.2%
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
56,028,123
60,512,542
56,970,798
61,183,234
66,081,170
62,214,731
165,220,899
(56,028,123)
(60,512,542)
(56,970,798)
0
(61,183,234)
(66,081,170)
(62,214,731)
(165,220,899)
(100.0)
(100.0)
(100.0)
(100.0)
B1Oct-07
B1Nov-07
B1Dec-07
662,609,127
YTD.
723,589,433
Total
63,949,974
54,693,702
50,391,889
673,593,019
75,147,540
64,311,450
59,256,482
791,784,725
(63,949,974)
(54,693,702)
(50,391,889)
0
(75,147,540)
(64,311,450)
(59,256,482)
0.00
(100)
(100)
(100)
#DIV/0!
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
119,978,097
115,206,244
107,362,686
136,330,774
130,392,620
121,471,213
165,220,899
(119,978,097)
(115,206,244)
(107,362,686)
0
(136,330,774)
(130,392,620)
(121,471,213)
(165,220,899)
(100.0)
(100.0)
(100.0)
(100.0)
B1Oct-07
B1Nov-07
B1Dec-07
1,336,202,146
YTD.
Total
14,087,495
10,796,205
(3,926,896)
158,809,623
(14,087,495)
(10,796,205)
3,926,896
(158,809,623)
(100.0)
(100.0)
(100.0)
(100.0)
#DIV/0!
#DIV/0!
#DIV/0!
#REF!
B1Oct-06
8.5% 9.5%
B1Nov-06
9.1% 8.1%
B1Dec-06
8.6% 7.5%
1,515,374,158
100.0% 100.0%
Growth%
-
Growth%
-
Growth%
-
Growth%
-
Financial Report Phyathai 2 Hospital OPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
79,731,311
72,728,954
86,365,769
74,465,565
Actual 2006
68,878,708
66,697,998
70,295,057
68,305,477
Diff Last Year
10,852,603
6,030,957
16,070,712
6,160,089
Diff Target
79,731,311
72,728,954
86,365,769
74,465,565
15.76
9.04
22.86
9.02
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Target
Percent Diff Last year Percent Diff Target
IPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
82,980,437
80,619,137
91,178,524
88,813,262
Actual 2006
75,905,902
73,968,571
79,152,984
73,070,111
7,074,535
6,650,566
12,025,539
15,743,151
82,980,437
80,619,137
91,178,524
88,813,262
9.32
8.99
15.19
21.55
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Target Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
Total GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
162,711,748
153,348,091
177,544,292
163,278,828
Actual 2006
144,784,611
140,666,569
149,448,041
141,375,588
Target Diff Last Year Diff Target
-
-
-
17,927,138
12,681,522
28,096,252
21,903,240
162,711,748
153,348,091
177,544,292
163,278,828
12.38
9.02
18.80
15.49
Percent Diff Last year Percent Diff Target
EBITDA
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
22,800,690
17,553,590
32,871,035
18,812,872
Actual 2006
26,733,953
22,885,880
25,191,849
20,192,866
Diff Last Year
(3,933,263)
(5,332,290)
7,679,186
(1,379,995)
Percent Diff Last year
(14.7)
(23.3)
30
(6.8)
EBITDA to Gross Sale
14.01%
11.45%
Seasonal from 2006 OPD IPD
B1Jan-06
7.6% 7.8%
B1Feb-06
7.4% 7.6%
18.51%
B1Mar-06
7.8% 8.1%
11.52%
B1Apr-06
7.5% 7.5%
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
76,195,223
69,977,701
81,464,655
80,476,531
77,059,972
(76,195,223)
(69,977,701)
(81,464,655)
(80,476,531)
(77,059,972)
0
0
0
0
0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
80,002,178
76,795,741
88,052,965
89,268,250
90,464,350
(80,002,178)
(76,795,741)
(88,052,965)
(89,268,250)
(90,464,350)
0
0
0
0
0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
B1May-07
B1Jun-07 -
B1Jul-07 -
B1Aug-07 -
B1Sep-07 -
-
156,197,401
146,773,443
169,517,620
169,744,781
167,524,322
(156,197,401)
(146,773,443)
(169,517,620)
(169,744,781)
(167,524,322)
0
0
0
0
0
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
20,632,606
14,842,600
28,960,732
28,344,987
25,078,029
(20,632,606)
(14,842,600)
(28,960,732)
(28,344,987)
(25,078,029)
(100.0)
(100.0)
(100.0)
(100.0)
(100.0)
B1May-06
8.4% 8.2%
B1Jun-06
7.7% 7.9%
B1Jul-06
B1Aug-06
9.0% 9.1%
8.9% 9.2%
B1Sep-06
8.5% 9.3%
B1Oct-07
B1Nov-07
83,762,551
B1Dec-07
83,372,283
YTD.
Total
80,364,211
906,850,365 -
-
(83,762,551)
(83,372,283)
(80,364,211)
0
0
0
0
0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
B1Oct-07
B1Nov-07
88,884,213
B1Dec-07
78,801,517
YTD.
Total
78,504,095
972,870,879 -
(88,884,213)
(78,801,517)
(78,504,095)
0
0
0
0
0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
B1Oct-07
B1Nov-07 -
B1Dec-07 -
172,646,763
YTD.
Total
-
162,173,800
158,868,306
1,879,721,244 -
-
(172,646,763)
(162,173,800)
(158,868,306)
0
0
0
0
0
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
24,023,250
20,320,349
7,678,669
264,885,770
(24,023,250)
(20,320,349)
(7,678,669)
(264,885,770)
(100.0)
(100.0)
(100.0)
(100.0)
B1Oct-06
9.2% 9.1%
B1Nov-06
9.2% 8.1%
B1Dec-06
8.9% 8.1%
100.0% 100.0%
Growth%
###
Growth%
###
Growth%
###
Growth%
###
Financial Report Phyathai 3 Hospital OPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
54,039,946
49,341,024
56,651,955
52,394,072
Actual 2006
44,311,760
41,927,174
45,931,199
43,532,467
9,728,186
7,413,850
10,720,756
8,861,605
54,039,946
49,341,024
56,651,955
52,394,072
21.95
17.68
23.34
20.36
Target Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
IPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
54,896,399
49,547,402
56,601,340
47,467,012
Actual 2006
45,411,779
43,825,119
51,311,585
44,515,774
9,484,620
5,722,283
5,289,755
2,951,238
54,896,399
49,547,402
56,601,340
47,467,012
20.89
13.06
10.31
6.63
Target Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
Total GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
108,936,345
98,888,426
113,253,295
99,861,085
Actual 2006
89,723,539
85,752,293
97,242,784
88,048,241
Target Diff Last Year Diff Target
-
-
-
-
19,212,806
13,136,133
16,010,512
11,812,844
108,936,345
98,888,426
113,253,295
99,861,085
21.41
15.32
16.46
13.42
Percent Diff Last year Percent Diff Target
EBITDA
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
21,472,950
12,746,997
18,691,007
13,138,701
Actual 2006
19,813,074
17,875,423
18,502,988
15,691,155
1,659,877
(5,128,426)
188,018
(2,552,453)
Percent Diff Last year
8.4
(28.7)
1.0
(16.3)
EBITDA to Gross Sale
19.71%
12.89%
Diff Last Year
Seasonal from 2006 OPD IPD
B1Jan-06
7.5% 7.6%
B1Feb-06
7.1% 7.3%
16.50%
B1Mar-06
7.8% 8.5%
13.16%
B1Apr-06
7.4% 7.4%
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
47,484,186
47,260,718
53,047,818
53,400,390
51,494,449
53,225,770
(47,484,186)
(47,260,718)
(53,047,818)
(53,400,390)
(51,494,449)
(53,225,770)
0
0
0
0
0
0
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
48,073,647
50,592,180
54,610,649
59,514,624
54,508,886
49,978,868
(48,073,647)
(50,592,180)
(54,610,649)
(59,514,624)
(54,508,886)
(49,978,868)
0
0
0
0
0
0
B1May-07
B1Jun-07
95,557,833
B1Jul-07
97,852,898
-
B1Aug-07
107,658,467
-
B1Sep-07
112,915,014
-
B1Oct-07
106,003,334
-
103,204,638
-
-
(95,557,833)
(97,852,898)
(107,658,467)
(112,915,014)
(106,003,334)
(103,204,638)
0
0
0
0
0
0
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
13,925,627
13,971,827
22,131,284
19,552,585
16,765,769
13,533,183
(13,925,627)
(13,971,827)
(22,131,284)
(19,552,585)
(16,765,769)
(13,533,183)
(100.0)
(100.0)
(100.0)
(100.0)
(100.0)
(100.0)
B1May-06
8.1% 8.0%
B1Jun-06
8.1% 8.4%
B1Jul-06
B1Aug-06
9.0% 9.1%
9.1% 9.9%
B1Sep-06
8.8% 9.1%
B1Oct-06
9.1% 8.3%
B1Nov-07
B1Dec-07
51,665,350
YTD.
Total
53,803,570
587,084,851 -
(53,803,570)
0
0
0
0
B1Dec-07
48,302,527
75,524,276.68
-
(51,665,350)
B1Nov-07
Growth%
YTD.
Total
50,194,666
Growth%
600,840,303
72,752,715.63
(48,302,527)
(50,194,666)
0
0
0
0
B1Nov-07
B1Dec-07
99,967,877
YTD.
103,998,236
-
Total
-
-
1,187,925,154
-
(103,998,236)
0
0
0
0
B1Dec-07
YTD.
Total
11,570,964
5,335,313
188,669,191
(11,570,964)
(5,335,313)
(188,669,191)
(100.0)
(100.0)
(100.0)
B1Nov-06
8.8% 8.0%
B1Dec-06
9.2% 8.4%
###
-
(99,967,877)
B1Nov-07
Growth%
100.0% 100.0%
Growth%
###
Related Documents
Financial Projection Phyathai 123 April 2007
November 2019 0
May Financial Projection Phyathai 123
November 2019 1
Financial Projection Restoran
April 2020 15
Projection
December 2019 51
April 2007
December 2019 25