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

Videos

Watch full video on YouTube

News

This article was written by Follow The Value Portfolio specializes in building retirement portfolios and utilizes a fact-based research strategy to identify investments. This...

News

Dear International Growth Fund Shareholder: Baron International Growth Fund® (BINIX, the Fund) gained 8.07% (Institutional Shares) during the third quarter of 2024, while its...

Videos

Watch full video on YouTube