程式計算預估Q2營收成長率 - 股票
By Catherine
at 2018-05-26T13:23
at 2018-05-26T13:23
Table of Contents
程式大批計算,電腦差,算好幾天。
預估Q2營收成長率優於去年的公司。
且4月營收創新高
算法:
A. 4月已公布營收
B. 預估5月營收=A*(1+去年5月營收成長%)
C. 預估6月營收=B*(1+去年6月營收成長%)
D. 預估Q2營收=A+B+C
E. 預估Q2營收成長率=(D-Q1營收)/Q1營收
ANS:
如果E>去年Q2營收成長率=資優生加分
EXCEL清單(包含4月營收沒創新高的)
https://drive.google.com/open?id=1R0zxmkuHbXHwo5bQMGWcfaQgmY4SA2d3
部落:
https://www.facebook.com/ownbuddy.life/posts/245265086051302
--
預估Q2營收成長率優於去年的公司。
且4月營收創新高
算法:
A. 4月已公布營收
B. 預估5月營收=A*(1+去年5月營收成長%)
C. 預估6月營收=B*(1+去年6月營收成長%)
D. 預估Q2營收=A+B+C
E. 預估Q2營收成長率=(D-Q1營收)/Q1營收
ANS:
如果E>去年Q2營收成長率=資優生加分
EXCEL清單(包含4月營收沒創新高的)
https://drive.google.com/open?id=1R0zxmkuHbXHwo5bQMGWcfaQgmY4SA2d3
部落:
https://www.facebook.com/ownbuddy.life/posts/245265086051302
--
Tags:
股票
All Comments
By Elvira
at 2018-05-28T17:27
at 2018-05-28T17:27
By Charlie
at 2018-05-31T06:13
at 2018-05-31T06:13
By Ursula
at 2018-06-04T05:23
at 2018-06-04T05:23
By Lauren
at 2018-06-05T03:24
at 2018-06-05T03:24
By Heather
at 2018-06-09T12:38
at 2018-06-09T12:38
By Ina
at 2018-06-12T05:36
at 2018-06-12T05:36
By Harry
at 2018-06-13T01:08
at 2018-06-13T01:08
By Ida
at 2018-06-17T18:28
at 2018-06-17T18:28
By Charlotte
at 2018-06-18T12:04
at 2018-06-18T12:04
By Carolina Franco
at 2018-06-18T14:35
at 2018-06-18T14:35
By Zora
at 2018-06-23T01:23
at 2018-06-23T01:23
By Carolina Franco
at 2018-06-23T14:12
at 2018-06-23T14:12
By Puput
at 2018-06-24T07:53
at 2018-06-24T07:53
By Zenobia
at 2018-06-25T19:42
at 2018-06-25T19:42
By Skylar Davis
at 2018-06-30T05:31
at 2018-06-30T05:31
By Oscar
at 2018-07-03T06:10
at 2018-07-03T06:10
By Kama
at 2018-07-06T04:30
at 2018-07-06T04:30
By Agatha
at 2018-07-07T00:42
at 2018-07-07T00:42
By Lily
at 2018-07-11T08:06
at 2018-07-11T08:06
By Aaliyah
at 2018-07-15T20:04
at 2018-07-15T20:04
By Annie
at 2018-07-18T01:29
at 2018-07-18T01:29
By Tristan Cohan
at 2018-07-20T05:04
at 2018-07-20T05:04
By Jack
at 2018-07-23T09:31
at 2018-07-23T09:31
Related Posts
三陽毛利率怎麼這麼低?
By Agnes
at 2018-05-26T09:17
at 2018-05-26T09:17
中鋼盤價可望 連四漲 十年最旺
By Eden
at 2018-05-26T09:07
at 2018-05-26T09:07
宏達電拿下中國逾半 VR 江山,建構 VR
By Hazel
at 2018-05-26T07:10
at 2018-05-26T07:10
鴻海FII在陸掛牌 1,400萬戶瘋搶
By Vanessa
at 2018-05-26T06:57
at 2018-05-26T06:57
中石化(一生一逝)
By Yuri
at 2018-05-26T06:47
at 2018-05-26T06:47