Revised Excel Value Analysis on Kohl'sI put together a valuation spreadsheet on Kohl's using data from Value Line.
Some interesting observations include:
1. Revenue, Cash Flow, Earnings Growth and Margins show Kohl's to be a model of healthy, steady consistent growth.
2. Current and Quick Ratios show a good financial position, although cash position is a bit lean.
3. At 61 days, inventory management could use improvement. Current Flow ratio is about double what it should be.
4. At about 15%, Return on Equity is O.K. but not spectacular.
5. At 2.45, the PEG ratio indicates that Kohl's stock is selling at a rich valuation. The P/E ratio is over double the growth rate.
6. Although the Projections section shows the current price to be in the buy range, it's no screaming bargain. It is selling for about 79% more than the intrinsic Present Value indicated using Warren Buffet's Sustainable Growth Rate model.
7. The current price seems to assume a growth rate of about 29% annually for the next five years. Is this realisitic?
You can check it out at https://www.analyzit.atfreeweb.com/KSS.htm
Any comments in response?