Investor’s Craft

Intrinsic value of Dell Technologies Inc. (DELL)

[per Chepakovich valuation model]

➔ other valuations of DELL

[per Chepakovich valuation model]  ➔ See other valuations of DELL stock

Previous Close$98.43
Intrinsic Value$71.97
Upside potential  -27%
Previous Close
$98.43
Intrinsic Value
$71.97
Potential        
-27%

VALUATION INPUT DATA

Revenue, mln $
Initial revenue growth rate (norm.), %
Variable cost ratio, %
Fixed operating expenses, mln $
Production assets / Revenue, %
Working capital / Revenue, %
Interest rate on debt, %
Life of production assets, yrs
Initial discount rate, %
Shares outstanding, mln
Adjusted equity ratio
Adjusted assets / Revenue
Based on fiscal year data as of 2021-01-31 and quarterly data as of 2021-01-31.
NOTE: The bar chart shows historic and forecasted yearly revenue growth rates. Its purpose is to help you in determining what initial revenue rate you want to base your stock valuation on. Please make sure that you are confident in the value you select - for most stocks it is by far the most important parameter in valuation.
  1. Annual
  2. Quarterly YoY
  3. Quarterly QoQ

Annual revenue growth rates, % (past and forecasted)

show cash flow forecast

FINANCIAL STATEMENTS FORECAST and PRESENT VALUE CALCULATION

Fiscal year2021(a)2022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046

INCOME STATEMENT

Revenue growth rate, %2.3NaN
Revenue, $94224NaN
Variable operating expenses, $mNaN
Fixed operating expenses, $mNaN
Total operating expenses, $m89080NaN
Operating income, $m5144NaN
EBITDA, $m10534NaN
Interest expense (income), $mNaN
Earnings before tax, $m3415NaN
Tax expense, $m165NaN
Net income, $m3250NaN

BALANCE SHEET

Cash and short-term investments, $m14201NaN
Total assets, $m123415NaN
Adjusted assets (=assets-cash), $m109214NaN
Average production assets, $m63771NaN
Working capital, $m-10565NaN
Total debt, $m41622NaN
Total liabilities, $m115862NaN
Total equity, $m7553NaN
Debt-to-equity ratio5.511NaN
Adjusted equity ratio-0.061NaN

CASH FLOW

Net income, $m3250NaN
Depreciation, amort., depletion, $m5390NaN
Funds from operations, $mNaN
Change in working capital, $mNaN
Cash from operations, $m11407NaN
Maintenance CAPEX, $mNaN
New CAPEX, $mNaN
Total CAPEX, $m-2082NaN
Free cash flow, $m13489NaN
Issuance/(repurchase) of shares, $mNaN
Retained Cash Flow, $mNaN
Pot'l extraordinary dividend, $m-10565
Cash available for distribution, $mNaN
Discount rate, %NaN
PV of cash for distribution, $mNaN
Current shareholders' claim on cash, %NaN
CONTACT USAboutSite newsQ&A
Valuation modelValuation theoryInvesting
Privacy policyTerms of use
Copyright © InvestorsCraft.com 2005-2021. All rigths reserved.