Target Financial Analysis# Stock
m*o
1 楼
I did some Financial Analysis on Target through its 10-K and 10-Q forms.I am
willing to post it here for discussion.This is the result obtained through
the model built from this analysis. It is quite close the actual result of
Target.The difference between the earning per share in the model after 2012 and target estimation is
believed to originate the number of shares used for the model. Since Target
has the stock repurchase program in process, it boosts its annual earning in the
reality.
2007 2008 2009 2010 2011 2012 2013 2014
2015
Retail Sales 61087 62701 64315 65929 67825 69533 71242
72950 74658
Retail Costs 42066 43375 44683 45992 47471 48837 50202
51568 52934
Revenue 19020 19326 19631 19937 20354 20697 21039
21382 21724
SGA and Depreciation 14509 14899 15288 15678 16126 16536
16945 17354 17763
Er from Retail 4511 4427 4343 4259 4228 4161 4094
4028 3961
Er from Credit card 1059 455 401 744 954 800 800 800
800
Total Er 5570 4882 4744 5003 5182 4961 4894 4828
4761
Interest Payment 647 866 801 757 764 760 760 760
760
Taxation 1710 1498 1456 1536 1590 1523 1502 1482
1462
Profit 3214 2518 2487 2711 2827 2678 2632 2586
2539
EPS 3.79 3.25 3.31 3.73 4.17 3.99 3.93 3.86 3.79
PE ratio 12.5 12.5 12.5 12.5 12.5 12.5 12.5 12.5
12.5
Stock Price 47.32 40.60 41.34 46.62 52.12749216 49.
81495755 49.10168952 48.23892497 47.37616043
willing to post it here for discussion.This is the result obtained through
the model built from this analysis. It is quite close the actual result of
Target.The difference between the earning per share in the model after 2012 and target estimation is
believed to originate the number of shares used for the model. Since Target
has the stock repurchase program in process, it boosts its annual earning in the
reality.
2007 2008 2009 2010 2011 2012 2013 2014
2015
Retail Sales 61087 62701 64315 65929 67825 69533 71242
72950 74658
Retail Costs 42066 43375 44683 45992 47471 48837 50202
51568 52934
Revenue 19020 19326 19631 19937 20354 20697 21039
21382 21724
SGA and Depreciation 14509 14899 15288 15678 16126 16536
16945 17354 17763
Er from Retail 4511 4427 4343 4259 4228 4161 4094
4028 3961
Er from Credit card 1059 455 401 744 954 800 800 800
800
Total Er 5570 4882 4744 5003 5182 4961 4894 4828
4761
Interest Payment 647 866 801 757 764 760 760 760
760
Taxation 1710 1498 1456 1536 1590 1523 1502 1482
1462
Profit 3214 2518 2487 2711 2827 2678 2632 2586
2539
EPS 3.79 3.25 3.31 3.73 4.17 3.99 3.93 3.86 3.79
PE ratio 12.5 12.5 12.5 12.5 12.5 12.5 12.5 12.5
12.5
Stock Price 47.32 40.60 41.34 46.62 52.12749216 49.
81495755 49.10168952 48.23892497 47.37616043