INTC Sales declined -8%
Current 30 Target 32 +7%
1/27/2023
1 minute read
Sales declined -8%
Last 5 quarters quarterly sales growth, quarterly ales
7% -11% -17% 0% -8%
20,528 ; 18,353 ; 15,321 ; 15,338 ; 14,042 million dollars
Margin down profit down
Last 5 quarters cash margin, profit
38% 37% 25% 38% 26%
4,623 ; 8,113 ; -454 ; 1,019 ; -661 million dollars
Cashflow positive again
Last 5 quarters operating, investment cashflow
5,797 ; 5,891 ; 809 ; 1,030 ; 7,703 million dollars
-5,034 ; -2,640 ; 168 ; -4,574 ; -3,431 million dollars
Net cash up
Last 5 quarters cash, liabilities
4,827 ; 6,215 ; 4,390 ; 4,529 ; 11,144 million dollars
73,015 ; 73,220 ; 69,200 ; 74,956 ; 78,817 million dollars
Capital (raised)
Last 5 quarters capital (raised) paid from liabilities, equity
2,180 ; 299 ; 1,688 ; -4,661 ; -2,675 million dollars
1,626 ; 1,564 ; 1,114 ; 978 ; 332 million dollars
Current 30 Target 32 +7%
1/27/2023
1 minute read
- Last 12 months sales growth -32%
- Last 12 months cash flow + 4% of market cap
- Last 12 months Capital (debt & equity) paid (raised) -1% of market cap
- Latest cash minus liabilities -55% of market cap
Sales declined -8%
Last 5 quarters quarterly sales growth, quarterly ales
7% -11% -17% 0% -8%
20,528 ; 18,353 ; 15,321 ; 15,338 ; 14,042 million dollars
- Sales declined -8% in the fourth quarter to 14,042 million dollars ; our total forecasts v actual sales are -100% now.
- This brings the average to -9% growth.
- We predict average growth of 1% in this next 12 months to bring sales to 14,608 million dollars in the fourth quarter 2023.
Margin down profit down
Last 5 quarters cash margin, profit
38% 37% 25% 38% 26%
4,623 ; 8,113 ; -454 ; 1,019 ; -661 million dollars
- The cash margin went from 38% to 26% profit from 1,019 to -661 million dollars in the fourth quarter.
- The average cash margin is at 31% now.
- We use a 31% cash margin to predict a 1,583 million dollars profit in the fourth quarter 2023.
Cashflow positive again
Last 5 quarters operating, investment cashflow
5,797 ; 5,891 ; 809 ; 1,030 ; 7,703 million dollars
-5,034 ; -2,640 ; 168 ; -4,574 ; -3,431 million dollars
- Free cashflow went from -3,544 to 4,272 million dollars in the fourth quarter with -3,431 million dollars investment cashflow.
- Average quarterly Cashflow is at 1,239 million dollars now.
- We assume -2,619 million dollars investment spending which with higher sales gives 1,823 million dollars average Cashflow in the next 12 months.
Net cash up
Last 5 quarters cash, liabilities
4,827 ; 6,215 ; 4,390 ; 4,529 ; 11,144 million dollars
73,015 ; 73,220 ; 69,200 ; 74,956 ; 78,817 million dollars
- Cash increased 4,529 to 11,144 million dollars in the fourth quarter.
- Liabilities increased 74,956 to 78,817 million dollars so net cash was up -70,427 to -67,673 million dollars .
- With our forecast cashflow & a -2,338 million dollars equity payout -4,954 million dollars liabilities net cash will be -62,719 million dollars in 12 months time.
Capital (raised)
Last 5 quarters capital (raised) paid from liabilities, equity
2,180 ; 299 ; 1,688 ; -4,661 ; -2,675 million dollars
1,626 ; 1,564 ; 1,114 ; 978 ; 332 million dollars
- INTC (raised) -2,343 million dollars in the fourth quarter -2,675 million dollars liabilities 332 million dollars equity, will pay 7,292 million dollars this next 12 months.
- At the current market cap of 122,572 million dollars based on our forecasts it’s at 0.68 X assets with a 23 years payback & a 2% yield.
- Our cashflow forecast is 7,292 million dollars which means a 17 X valuation. A 18 X valuation gives a +7% higher target price 32 dollars.