May Financial Projection Phyathai 123
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 May Financial Projection Phyathai 123 as PDF for free.
More details
- Words: 860
- Pages: 10
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
8.12
(2.74)
16.74
Percent Diff Last year Percent Diff Target
IPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
9
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.49
(0.73)
8.32
(8.51)
(15.50)
(7.84)
Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
Total GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
(19)
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.47
2.67
17.49
Percent Diff Target
(0.99)
(9.48)
3.47
EBITDA
B1Jan-07
B1Feb-07
B1Mar-07
(6)
B1Apr-07
Actual 2007
24,570,969
1,673,711
18,305,080
Actual 2006
19,358,833
17,008,649
14,196,215
13,725,148
5,212,136
(15,334,938)
4,108,865
(13,725,148)
Percent Diff Last year
26.92
(90.16)
28.94
(100.00)
EBITDA to Gross Sale
20.36%
1.61%
14.58%
0.00%
Diff Last Year
Total Revenue From OPD 59,417,005.62 Total Revenue From IPD 49,025,369.20 Total Trade Discount (5,743,884.13) Net Sales 102,698,490.69
Total Non Hospital Income 2,199,473.25 Total Revenue
104,897,963.94
B1Dec-07
YTD.
Total
Growth%
236,978,974 56,970,798
201,233,326
662,609,127
62,214,731
219,752,049
723,589,433
(56,970,798)
35,745,648
(62,214,731)
17,226,924
(100)
8
B1Dec-07
YTD.
Total
9.2%
Growth%
221,750,655 50,391,889
215,473,956
673,593,019
59,256,482
253,223,868
791,784,725
(50,391,889)
6,276,699
(59,256,482)
(31,473,213)
(100)
(12)
B1Dec-07
YTD.
Total
17.5%
Growth%
458,729,629 107,362,686
416,707,282
1,336,202,146
121,471,213
472,975,917
1,515,374,158
(107,362,686)
42,022,347
(121,471,213)
(14,246,288)
(100)
(3)
B1Dec-07
YTD.
Total
13.4%
Growth%
44,549,760 (3,926,896)
64,288,845
158,809,623
3,926,896
(19,739,086)
(114,259,864)
(100.00)
(19,739,086)
#DIV/0!
64,288,845
D 59,417,005.62 m IPD 49,025,369.20 unt (5,743,884.13) 102,698,490.69
-171.9%
l Income 2,199,473.25 104,897,963.94
Financial Report Phyathai 2 Hospital OPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007 Actual 2006 Target Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
IPD GROSS REVENUE Actual 2007 Actual 2006 Target Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
Total GROSS REVENUE Actual 2007 Actual 2006 Target Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
EBITDA Actual 2007 Actual 2006 Diff Last Year Percent Diff Last year EBITDA to Gross Sale
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
Growth%
B1Nov-07
B1Dec-07
YTD.
Total
Growth%
B1Nov-07
B1Dec-07
YTD.
Total
Growth%
B1Nov-07
B1Dec-07
YTD.
Total
Growth%
Financial Report Phyathai 3 Hospital OPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
59,617,947
52,754,123
65,189,898
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
(49,936,353)
Diff Target
4,477,982
(1,484,280)
9,347,367
(54,531,150)
18.07
6.21
27.48
8.12
(2.74)
16.74
Percent Diff Last year Percent Diff Target
IPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
(100)
B1Apr-07
Actual 2007
61,059,420
51,335,389
60,330,477
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
(51,260,200)
(5,680,610)
(9,413,867)
(5,133,274)
(60,270,831)
7.49
(0.73)
8.32
(8.51)
(15.50)
(7.84)
Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
Total GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
(100)
B1Apr-07
Actual 2007
120,677,367
104,089,512
125,520,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
(101,196,553)
Diff Target
(1,202,629)
(10,898,146)
4,214,093
(114,801,981)
Percent Diff Last year
12.47
2.67
17.49
Percent Diff Target
(0.99)
(9.48)
3.47
EBITDA
B1Jan-07
B1Feb-07
B1Mar-07
(100)
B1Apr-07
Actual 2007
24,570,969
1,673,711
18,305,080
Actual 2006
19,358,833
17,008,649
14,196,215
13,725,148
5,212,136
(15,334,938)
4,108,865
(13,725,148)
Percent Diff Last year
26.92
(90.16)
28.94
(100.00)
EBITDA to Gross Sale
20.36%
1.61%
14.58%
#DIV/0!
Diff Last Year
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
54,569,469
54,583,840
58,248,202
59,943,525
60,519,304
56,028,123
59,591,412
59,608,408
63,609,995
65,458,993
66,089,440
61,183,234
(54,569,469)
(54,583,840)
(58,248,202)
(59,943,525)
(60,519,304)
(56,028,123)
(59,591,412)
(59,608,408)
(63,609,995)
(65,458,993)
(66,089,440)
(61,183,234)
(100)
(100)
(100)
(100)
(100)
(100)
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
58,293,778
53,417,548
57,126,365
65,289,033
54,956,773
63,949,974
68,525,984
62,834,597
67,164,572
76,729,106
64,591,127
75,147,540
(58,293,778)
(53,417,548)
(57,126,365)
(65,289,033)
(54,956,773)
(63,949,974)
(68,525,984)
(62,834,597)
(67,164,572)
(76,729,106)
(64,591,127)
(75,147,540)
(100)
(100)
(100)
(100)
(100)
(100)
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
112,863,248
108,001,388
115,374,566
125,232,558
115,476,078
119,978,097
128,117,396
122,443,005
130,774,568
142,188,099
130,680,567
136,330,774
(112,863,248)
(108,001,388)
(115,374,566)
(125,232,558)
(115,476,078)
(119,978,097)
(128,117,396)
(122,443,005)
(130,774,568)
(142,188,099)
(130,680,567)
(136,330,774)
(100)
(100)
(100)
(100)
(100)
(100)
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
13,140,629
14,835,497
14,550,787
20,982,020
10,055,042
14,087,495
(13,140,629)
(14,835,497)
(14,550,787)
(20,982,020)
(10,055,042)
(14,087,495)
(100.00)
(100.00)
(100.00)
(100.00)
(100.00)
(100.00)
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
B1Nov-07
B1Dec-07
YTD.
Total
60,512,542
56,970,798
66,081,170
62,214,731
(60,512,542)
(56,970,798)
0
(66,081,170)
(62,214,731)
(165,220,899)
(100)
(100)
(100)
B1Nov-07
B1Dec-07
662,609,127 165,220,899
YTD.
Total
50,391,889
673,593,019
64,311,450
59,256,482
791,784,725
(54,693,702)
(50,391,889)
0
(64,311,450)
(59,256,482)
0
(100)
(100)
#DIV/0!
B1Dec-07
YTD.
Total
115,206,244
107,362,686
130,392,620
121,471,213
(115,206,244)
(107,362,686)
0
(130,392,620)
(121,471,213)
(165,220,899)
(100)
(100)
(100)
B1Nov-07
B1Dec-07
-
723,589,433
54,693,702
B1Nov-07
Growth%
Growth%
-
Growth%
1,336,202,146 165,220,899
YTD.
1,515,374,158
Total
10,796,205
(3,926,896)
158,809,623
(10,796,205)
3,926,896
(158,809,623)
(100.00)
(100.00)
(100.00)
#DIV/0!
#DIV/0!
#REF!
-
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
8.12
(2.74)
16.74
Percent Diff Last year Percent Diff Target
IPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
9
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.49
(0.73)
8.32
(8.51)
(15.50)
(7.84)
Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
Total GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
(19)
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.47
2.67
17.49
Percent Diff Target
(0.99)
(9.48)
3.47
EBITDA
B1Jan-07
B1Feb-07
B1Mar-07
(6)
B1Apr-07
Actual 2007
24,570,969
1,673,711
18,305,080
Actual 2006
19,358,833
17,008,649
14,196,215
13,725,148
5,212,136
(15,334,938)
4,108,865
(13,725,148)
Percent Diff Last year
26.92
(90.16)
28.94
(100.00)
EBITDA to Gross Sale
20.36%
1.61%
14.58%
0.00%
Diff Last Year
Total Revenue From OPD 59,417,005.62 Total Revenue From IPD 49,025,369.20 Total Trade Discount (5,743,884.13) Net Sales 102,698,490.69
Total Non Hospital Income 2,199,473.25 Total Revenue
104,897,963.94
B1Dec-07
YTD.
Total
Growth%
236,978,974 56,970,798
201,233,326
662,609,127
62,214,731
219,752,049
723,589,433
(56,970,798)
35,745,648
(62,214,731)
17,226,924
(100)
8
B1Dec-07
YTD.
Total
9.2%
Growth%
221,750,655 50,391,889
215,473,956
673,593,019
59,256,482
253,223,868
791,784,725
(50,391,889)
6,276,699
(59,256,482)
(31,473,213)
(100)
(12)
B1Dec-07
YTD.
Total
17.5%
Growth%
458,729,629 107,362,686
416,707,282
1,336,202,146
121,471,213
472,975,917
1,515,374,158
(107,362,686)
42,022,347
(121,471,213)
(14,246,288)
(100)
(3)
B1Dec-07
YTD.
Total
13.4%
Growth%
44,549,760 (3,926,896)
64,288,845
158,809,623
3,926,896
(19,739,086)
(114,259,864)
(100.00)
(19,739,086)
#DIV/0!
64,288,845
D 59,417,005.62 m IPD 49,025,369.20 unt (5,743,884.13) 102,698,490.69
-171.9%
l Income 2,199,473.25 104,897,963.94
Financial Report Phyathai 2 Hospital OPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007 Actual 2006 Target Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
IPD GROSS REVENUE Actual 2007 Actual 2006 Target Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
Total GROSS REVENUE Actual 2007 Actual 2006 Target Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
EBITDA Actual 2007 Actual 2006 Diff Last Year Percent Diff Last year EBITDA to Gross Sale
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
B1Nov-07
B1Dec-07
YTD.
Total
Growth%
B1Nov-07
B1Dec-07
YTD.
Total
Growth%
B1Nov-07
B1Dec-07
YTD.
Total
Growth%
B1Nov-07
B1Dec-07
YTD.
Total
Growth%
Financial Report Phyathai 3 Hospital OPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
B1Apr-07
Actual 2007
59,617,947
52,754,123
65,189,898
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
(49,936,353)
Diff Target
4,477,982
(1,484,280)
9,347,367
(54,531,150)
18.07
6.21
27.48
8.12
(2.74)
16.74
Percent Diff Last year Percent Diff Target
IPD GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
(100)
B1Apr-07
Actual 2007
61,059,420
51,335,389
60,330,477
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
(51,260,200)
(5,680,610)
(9,413,867)
(5,133,274)
(60,270,831)
7.49
(0.73)
8.32
(8.51)
(15.50)
(7.84)
Diff Last Year Diff Target Percent Diff Last year Percent Diff Target
Total GROSS REVENUE
B1Jan-07
B1Feb-07
B1Mar-07
(100)
B1Apr-07
Actual 2007
120,677,367
104,089,512
125,520,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
(101,196,553)
Diff Target
(1,202,629)
(10,898,146)
4,214,093
(114,801,981)
Percent Diff Last year
12.47
2.67
17.49
Percent Diff Target
(0.99)
(9.48)
3.47
EBITDA
B1Jan-07
B1Feb-07
B1Mar-07
(100)
B1Apr-07
Actual 2007
24,570,969
1,673,711
18,305,080
Actual 2006
19,358,833
17,008,649
14,196,215
13,725,148
5,212,136
(15,334,938)
4,108,865
(13,725,148)
Percent Diff Last year
26.92
(90.16)
28.94
(100.00)
EBITDA to Gross Sale
20.36%
1.61%
14.58%
#DIV/0!
Diff Last Year
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
54,569,469
54,583,840
58,248,202
59,943,525
60,519,304
56,028,123
59,591,412
59,608,408
63,609,995
65,458,993
66,089,440
61,183,234
(54,569,469)
(54,583,840)
(58,248,202)
(59,943,525)
(60,519,304)
(56,028,123)
(59,591,412)
(59,608,408)
(63,609,995)
(65,458,993)
(66,089,440)
(61,183,234)
(100)
(100)
(100)
(100)
(100)
(100)
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
58,293,778
53,417,548
57,126,365
65,289,033
54,956,773
63,949,974
68,525,984
62,834,597
67,164,572
76,729,106
64,591,127
75,147,540
(58,293,778)
(53,417,548)
(57,126,365)
(65,289,033)
(54,956,773)
(63,949,974)
(68,525,984)
(62,834,597)
(67,164,572)
(76,729,106)
(64,591,127)
(75,147,540)
(100)
(100)
(100)
(100)
(100)
(100)
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
112,863,248
108,001,388
115,374,566
125,232,558
115,476,078
119,978,097
128,117,396
122,443,005
130,774,568
142,188,099
130,680,567
136,330,774
(112,863,248)
(108,001,388)
(115,374,566)
(125,232,558)
(115,476,078)
(119,978,097)
(128,117,396)
(122,443,005)
(130,774,568)
(142,188,099)
(130,680,567)
(136,330,774)
(100)
(100)
(100)
(100)
(100)
(100)
B1May-07
B1Jun-07
B1Jul-07
B1Aug-07
B1Sep-07
B1Oct-07
13,140,629
14,835,497
14,550,787
20,982,020
10,055,042
14,087,495
(13,140,629)
(14,835,497)
(14,550,787)
(20,982,020)
(10,055,042)
(14,087,495)
(100.00)
(100.00)
(100.00)
(100.00)
(100.00)
(100.00)
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
B1Nov-07
B1Dec-07
YTD.
Total
60,512,542
56,970,798
66,081,170
62,214,731
(60,512,542)
(56,970,798)
0
(66,081,170)
(62,214,731)
(165,220,899)
(100)
(100)
(100)
B1Nov-07
B1Dec-07
662,609,127 165,220,899
YTD.
Total
50,391,889
673,593,019
64,311,450
59,256,482
791,784,725
(54,693,702)
(50,391,889)
0
(64,311,450)
(59,256,482)
0
(100)
(100)
#DIV/0!
B1Dec-07
YTD.
Total
115,206,244
107,362,686
130,392,620
121,471,213
(115,206,244)
(107,362,686)
0
(130,392,620)
(121,471,213)
(165,220,899)
(100)
(100)
(100)
B1Nov-07
B1Dec-07
-
723,589,433
54,693,702
B1Nov-07
Growth%
Growth%
-
Growth%
1,336,202,146 165,220,899
YTD.
1,515,374,158
Total
10,796,205
(3,926,896)
158,809,623
(10,796,205)
3,926,896
(158,809,623)
(100.00)
(100.00)
(100.00)
#DIV/0!
#DIV/0!
#REF!
-
Growth%
-
Related Documents
May Financial Projection Phyathai 123
November 2019 1
Financial Projection Phyathai 123 April 2007
November 2019 0
Financial Projection Restoran
April 2020 15
Projection
December 2019 51
Astral Projection
June 2020 32