Connect with us

Hi, what are you looking for?

News

Cisco (CSCO): Getting Better With Age Of AI And Splitting Dividend

Investment Thesis

I have identified Cisco Systems (NASDAQ:CSCO) as a technically attractive stock that provides an attractive dividend with a low payout ratio while providing a space for healthy growth of revenues and maintaining strong fundamentals. It seems to be

Inputs

Values for CSCO July 24, 2023

Source

Payout ratio or “1- g/ROE”

0.4286

Seeking Alpha

gEPS – 3-5 years CAGR forward growth prediction by analysts/ to use also as a proxy for g of Sales on EV/IC

0.0542

EPS FWD Long Term Growth (3-5Y CAGR), Seeking Alpha

LN of gEPS for the PEG calculation

-2.915

own calculation

B – beta of company

0.8

Seeking Alpha

ROE = NI/ BV Equity TTM

0.2774

Seeking Alpha

ROIC – Return on invested capital = ROC = EBIT (1-t) / (BV of Debt + BV of Equity-Cash) TTM

0.2223

Morningstar

DFR = Debt to capital ratio = Total Debt/(Total Debt + Market value of equity) Q3 2023

0.0424

own calculation, data from Seeking Alpha (in $ B: Market Cap: 214.47; Total Debt Q3 2023: 9.493)

Tax rate = Effective tax rate = Taxes paid/ Taxable Income: FY 2023 guidance assumes an effective tax provision rate of 20% for GAAP

0.20

Q3 2023 Earnings report

Operating Margin = Pre-tax Operating Income/ Sales TTM

0.2650

as EBIT margin, Seeking Alpha

Regression equations for year 2022

R-squared

Predicted multiples

EV/Invested Capital= 3.53 + 1.30 g + 7.30 ROIC – 4.20 DFR

0.567

5.045

PEG = 6.71 + 1.20 Payout – 1.57 ln(gEPS) -0.77 Beta

0.566

11.185

PBV= 2.32 + 4.60 gEPS – 1.33 Beta + 8.90 ROE + 0.80 Payout Ratio

0.369

4.317

EV/Sales = 2.32 + 2.60 g + 10.60 Oper Margin -1.40 DFR- 3.50 Tax rate

0.306

4.511

PE = 8.63 + 2.23 Beta + 46.20 gEPS + 19.30 Payout

0.25

21.179

Multiple

Predicted multiples

Currently trading at

Source of current multiple

Undervalued or overvalued by the US market values

EV/IC

5.045

n/a

own calculation

n/a

PEG

11.185

2.55

Seeking Alpha, forward PEG (forward Non-GAAP PE Ratio divided by EPS long-term growth consensus estimate for 3 to 5 year CAGR)

-77.20%

PBV

4.317

5.07

Seeking Alpha

17.44%

EV/Sales

4.511

3.66

Seeking Alpha

-18.86%

P/E

21.179

18.87

Seeking Alpha

-10.90%

Read the full article here

Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

You May Also Like

News

Follow Play Earnings CallPlay Earnings Call Disc Medicine, Inc. (IRON) Discusses ASH Conference Data Updates and Portfolio Progress Including Anemia and Iron Restriction Programs...

Videos

Watch full video on YouTube