Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (2024)

Table of Contents
United States of America Apple Inc. (AAPL) DCF Excel Template Zoom Video Communications, Inc. (ZM) DCF Excel Template Tesla, Inc. (TSLA) DCF Excel Template PayPal Holdings, Inc. (PYPL) DCF Excel Template Exxon Mobil Corporation (XOM) DCF Excel Template Rivian Automotive, Inc. (RIVN) DCF Excel Template United Kingdom Manchester United plc (MANU) DCF Excel Template Sensata Technologies Holding plc (ST) DCF Excel Template Lloyds Banking Group plc (LYG) DCF Excel Template HSBC Holdings plc (HSBC) DCF Excel Template Diageo plc (DEO) DCF Excel Template Rio Tinto Group (RIO) DCF Excel Template Canada Lululemon Athletica Inc. (LULU) DCF Excel Template Shopify Inc. (SHOP) DCF Excel Template Canada Goose Holdings Inc. (GOOS) DCF Excel Template Zymeworks Inc. (ZYME) DCF Excel Template TFI International Inc. (TFII) DCF Excel Template SSR Mining Inc. (SSRM) DCF Excel Template China X Financial (XYF) DCF Excel Template JD.com, Inc. (JD) DCF Excel Template Bilibili Inc. (BILI) DCF Excel Template Baidu, Inc. (BIDU) DCF Excel Template ZTO Express (Cayman) Inc. (ZTO) DCF Excel Template China Southern Airlines Company Limited (ZNH) DCF Excel Template Israel ZIM Integrated Shipping Services Ltd. (ZIM) DCF Excel Template SolarEdge Technologies, Inc. (SEDG) DCF Excel Template InMode Ltd. (INMD) DCF Excel Template CyberArk Software Ltd. (CYBR) DCF Excel Template XTL Biopharmaceuticals Ltd. (XTLB) DCF Excel Template WalkMe Ltd. (WKME) DCF Excel Template Hong Kong Futu Holdings Limited (FUTU) DCF Excel Template UTStarcom Holdings Corp. (UTSI) DCF Excel Template uCloudlink Group Inc. (UCL) DCF Excel Template TROOPS, Inc. (TROO) DCF Excel Template Takung Art Co., Ltd. (TKAT) DCF Excel Template SPI Energy Co., Ltd. (SPI) DCF Excel Template Germany voxeljet AG (VJET) DCF Excel Template VIA optronics AG (VIAO) DCF Excel Template trivago N.V. (TRVG) DCF Excel Template Tio Tech A (TIOA) DCF Excel Template SIGNA Sports United N.V. (SSU) DCF Excel Template Sono Group N.V. (SEV) DCF Excel Template Switzerland UBS Group AG (UBS) DCF Excel Template Chubb Limited (CB) DCF Excel Template WISeKey International Holding AG (WKEY) DCF Excel Template TE Connectivity Ltd. (TEL) DCF Excel Template STMicroelectronics N.V. (STM) DCF Excel Template Sportradar Group AG (SRAD) DCF Excel Template Ireland Navitas Semiconductor Corporation (NVTS) DCF Excel Template Medtronic plc (MDT) DCF Excel Template Trane Technologies plc (TT) DCF Excel Template Trinity Biotech plc (TRIB) DCF Excel Template Seagate Technology Holdings plc (STX) DCF Excel Template STERIS plc (STE) DCF Excel Template Communication Services Netflix, Inc. (NFLX) DCF Excel Template Manchester United plc (MANU) DCF Excel Template The Walt Disney Company (DIS) DCF Excel Template Activision Blizzard, Inc. (ATVI) DCF Excel Template Roku, Inc. (ROKU) DCF Excel Template Spotify Technology S.A. (SPOT) DCF Excel Template Basic Materials Ecolab Inc. (ECL) DCF Excel Template Olympic Steel, Inc. (ZEUS) DCF Excel Template Nucor Corporation (NUE) DCF Excel Template Vale S.A. (VALE) DCF Excel Template SSR Mining Inc. (SSRM) DCF Excel Template SilverCrest Metals Inc. (SILV) DCF Excel Template Consumer Cyclical Tesla, Inc. (TSLA) DCF Excel Template Rivian Automotive, Inc. (RIVN) DCF Excel Template Lululemon Athletica Inc. (LULU) DCF Excel Template YETI Holdings, Inc. (YETI) DCF Excel Template Malibu Boats, Inc. (MBUU) DCF Excel Template Carrols Restaurant Group, Inc. (TAST) DCF Excel Template Consumer Defensive PepsiCo, Inc. (PEP) DCF Excel Template The Coca-Cola Company (KO) DCF Excel Template Philip Morris International Inc. (PM) DCF Excel Template Walmart Inc. (WMT) DCF Excel Template Unilever PLC (UL) DCF Excel Template Energy Exxon Mobil Corporation (XOM) DCF Excel Template Chevron Corporation (CVX) DCF Excel Template Ecoark Holdings, Inc. (ZEST) DCF Excel Template Shell plc (SHEL) DCF Excel Template TotalEnergies SE (TTE) DCF Excel Template Pioneer Natural Resources Company (PXD) DCF Excel Template Financial Services PayPal Holdings, Inc. (PYPL) DCF Excel Template The Goldman Sachs Group, Inc. (GS) DCF Excel Template Visa Inc. (V) DCF Excel Template FTAC Zeus Acquisition Corp. (ZING) DCF Excel Template X Financial (XYF) DCF Excel Template Healthcare Zynerba Pharmaceuticals, Inc. (ZYNE) DCF Excel Template Zentalis Pharmaceuticals, Inc. (ZNTL) DCF Excel Template Pfizer Inc. (PFE) DCF Excel Template Dr. Reddy's Laboratories Limited (RDY) DCF Excel Template Moderna, Inc. (MRNA) DCF Excel Template Eli Lilly and Company (LLY) DCF Excel Template Industrials Frontier Group Holdings, Inc. (ULCC) DCF Excel Template The Boeing Company (BA) DCF Excel Template American Airlines Group Inc. (AAL) DCF Excel Template United Airlines Holdings, Inc. (UAL) DCF Excel Template Raytheon Technologies Corporation (RTX) DCF Excel Template 3M Company (MMM) DCF Excel Template Real Estate Equinix, Inc. (EQIX) DCF Excel Template WeWork Inc. (WE) DCF Excel Template Prologis, Inc. (PLD) DCF Excel Template Veris Residential, Inc. (VRE) DCF Excel Template Mid-America Apartment Communities, Inc. (MAA) DCF Excel Template Medical Properties Trust, Inc. (MPW) DCF Excel Template Technology Apple Inc. (AAPL) DCF Excel Template Zoom Video Communications, Inc. (ZM) DCF Excel Template NVIDIA Corporation (NVDA) DCF Excel Template Wipro Limited (WIT) DCF Excel Template Intel Corporation (INTC) DCF Excel Template First Solar, Inc. (FSLR) DCF Excel Template Utilities The Southern Company (SO) DCF Excel Template NextEra Energy, Inc. (NEE) DCF Excel Template Vistra Corp. (VST) DCF Excel Template Brookfield Renewable Partners L.P. (BEP) DCF Excel Template The York Water Company (YORW) DCF Excel Template Xcel Energy Inc. (XEL) DCF Excel Template FAQs References

Search

Cart 0/$0.00

United States of America

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (4)

Apple Inc. (AAPL) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (5)

Zoom Video Communications, Inc. (ZM) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (6)

Tesla, Inc. (TSLA) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (7)

PayPal Holdings, Inc. (PYPL) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (8)

Exxon Mobil Corporation (XOM) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (9)

Rivian Automotive, Inc. (RIVN) DCF Excel Template

$9.00

View More

United Kingdom

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (10)

Manchester United plc (MANU) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (11)

Sensata Technologies Holding plc (ST) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (12)

Lloyds Banking Group plc (LYG) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (13)

HSBC Holdings plc (HSBC) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (14)

Diageo plc (DEO) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (15)

Rio Tinto Group (RIO) DCF Excel Template

$9.00

View More

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (16)

Lululemon Athletica Inc. (LULU) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (17)

Shopify Inc. (SHOP) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (18)

Canada Goose Holdings Inc. (GOOS) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (19)

Zymeworks Inc. (ZYME) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (20)

TFI International Inc. (TFII) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (21)

SSR Mining Inc. (SSRM) DCF Excel Template

$9.00

View More

China

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (22)

X Financial (XYF) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (23)

JD.com, Inc. (JD) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (24)

Bilibili Inc. (BILI) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (25)

Baidu, Inc. (BIDU) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (26)

ZTO Express (Cayman) Inc. (ZTO) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (27)

China Southern Airlines Company Limited (ZNH) DCF Excel Template

$9.00

View More

Israel

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (28)

ZIM Integrated Shipping Services Ltd. (ZIM) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (29)

SolarEdge Technologies, Inc. (SEDG) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (30)

InMode Ltd. (INMD) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (31)

CyberArk Software Ltd. (CYBR) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (33)

WalkMe Ltd. (WKME) DCF Excel Template

$9.00

View More

Hong Kong

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (34)

Futu Holdings Limited (FUTU) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (35)

UTStarcom Holdings Corp. (UTSI) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (36)

uCloudlink Group Inc. (UCL) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (37)

TROOPS, Inc. (TROO) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (38)

Takung Art Co., Ltd. (TKAT) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (39)

SPI Energy Co., Ltd. (SPI) DCF Excel Template

$9.00

View More

Germany

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (40)

voxeljet AG (VJET) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (41)

VIA optronics AG (VIAO) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (42)

trivago N.V. (TRVG) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (43)

Tio Tech A (TIOA) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (44)

SIGNA Sports United N.V. (SSU) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (45)

Sono Group N.V. (SEV) DCF Excel Template

$9.00

View More

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (46)

UBS Group AG (UBS) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (47)

Chubb Limited (CB) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (48)

WISeKey International Holding AG (WKEY) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (49)

TE Connectivity Ltd. (TEL) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (50)

STMicroelectronics N.V. (STM) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (51)

Sportradar Group AG (SRAD) DCF Excel Template

$9.00

View More

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (52)

Navitas Semiconductor Corporation (NVTS) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (53)

Medtronic plc (MDT) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (54)

Trane Technologies plc (TT) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (55)

Trinity Biotech plc (TRIB) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (56)

Seagate Technology Holdings plc (STX) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (57)

STERIS plc (STE) DCF Excel Template

$9.00

View More

Communication Services

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (58)

Netflix, Inc. (NFLX) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (59)

Manchester United plc (MANU) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (60)

The Walt Disney Company (DIS) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (61)

Activision Blizzard, Inc. (ATVI) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (62)

Roku, Inc. (ROKU) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (63)

Spotify Technology S.A. (SPOT) DCF Excel Template

$9.00

View More

Basic Materials

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (64)

Ecolab Inc. (ECL) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (65)

Olympic Steel, Inc. (ZEUS) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (66)

Nucor Corporation (NUE) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (67)

Vale S.A. (VALE) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (68)

SSR Mining Inc. (SSRM) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (69)

SilverCrest Metals Inc. (SILV) DCF Excel Template

$9.00

View More

Consumer Cyclical

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (70)

Tesla, Inc. (TSLA) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (71)

Rivian Automotive, Inc. (RIVN) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (72)

Lululemon Athletica Inc. (LULU) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (73)

YETI Holdings, Inc. (YETI) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (74)

Malibu Boats, Inc. (MBUU) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (75)

Carrols Restaurant Group, Inc. (TAST) DCF Excel Template

$9.00

View More

Consumer Defensive

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (76)

PepsiCo, Inc. (PEP) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (77)

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (78)

The Coca-Cola Company (KO) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (79)

Philip Morris International Inc. (PM) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (80)

Walmart Inc. (WMT) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (81)

Unilever PLC (UL) DCF Excel Template

$9.00

View More

Energy

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (82)

Exxon Mobil Corporation (XOM) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (83)

Chevron Corporation (CVX) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (84)

Ecoark Holdings, Inc. (ZEST) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (85)

Shell plc (SHEL) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (86)

TotalEnergies SE (TTE) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (87)

Pioneer Natural Resources Company (PXD) DCF Excel Template

$9.00

View More

Financial Services

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (88)

PayPal Holdings, Inc. (PYPL) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (89)

The Goldman Sachs Group, Inc. (GS) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (90)

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (91)

Visa Inc. (V) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (92)

FTAC Zeus Acquisition Corp. (ZING) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (93)

X Financial (XYF) DCF Excel Template

$9.00

View More

Healthcare

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (94)

Zynerba Pharmaceuticals, Inc. (ZYNE) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (95)

Zentalis Pharmaceuticals, Inc. (ZNTL) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (96)

Pfizer Inc. (PFE) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (97)

Dr. Reddy's Laboratories Limited (RDY) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (98)

Moderna, Inc. (MRNA) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (99)

Eli Lilly and Company (LLY) DCF Excel Template

$9.00

View More

Industrials

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (100)

Frontier Group Holdings, Inc. (ULCC) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (101)

The Boeing Company (BA) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (102)

American Airlines Group Inc. (AAL) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (103)

United Airlines Holdings, Inc. (UAL) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (104)

Raytheon Technologies Corporation (RTX) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (105)

3M Company (MMM) DCF Excel Template

$9.00

View More

Real Estate

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (106)

Equinix, Inc. (EQIX) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (107)

WeWork Inc. (WE) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (108)

Prologis, Inc. (PLD) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (109)

Veris Residential, Inc. (VRE) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (110)

Mid-America Apartment Communities, Inc. (MAA) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (111)

Medical Properties Trust, Inc. (MPW) DCF Excel Template

$9.00

View More

Technology

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (112)

Apple Inc. (AAPL) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (113)

Zoom Video Communications, Inc. (ZM) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (114)

NVIDIA Corporation (NVDA) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (115)

Wipro Limited (WIT) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (116)

Intel Corporation (INTC) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (117)

First Solar, Inc. (FSLR) DCF Excel Template

$9.00

View More

Utilities

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (118)

The Southern Company (SO) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (119)

NextEra Energy, Inc. (NEE) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (120)

Vistra Corp. (VST) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (121)

Brookfield Renewable Partners L.P. (BEP) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (122)

The York Water Company (YORW) DCF Excel Template

$9.00

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (123)

Xcel Energy Inc. (XEL) DCF Excel Template

$9.00

View More

Discounted Cash Flow financial models and WACC for all stocks | DCF.fm (2024)

FAQs

What is the discounted cash flow model using WACC? ›

The discounted cash flow (DCF) formula is equal to the sum of the cash flow in each period divided by one plus the discount rate (WACC) raised to the power of the period number.

What is the discounted cash flow model for stocks? ›

Discounted cash flow (DCF) valuation is a type of financial model that determines whether an investment is worthwhile based on future cash flows. A DCF model is based on the idea that a company's value is determined by how well the company can generate cash flows for its investors in the future.

When would you not use a DCF? ›

Also, since the very focus of DCF analysis is long-term growth, it is not an appropriate tool for evaluating short-term profit potential. Besides, as an investor, it's wise to avoid being too reliant on one method over another when assessing the value of stocks.

What is the alternative to WACC for DCF? ›

Unlike WACC used in discounted cash flow, the adjusted present value seeks to value the effects of the cost of equity and cost of debt separately. The adjusted present value isn't as prevalent as the discounted cash flow method.

What is the relationship between WACC and DCF? ›

A DCF requires projecting future cash flows and then discounting them back to their present-day values using the WACC rate as the “discount rate”. The sum of all projected future cash flows (discounted by the WACC) gives an estimate of the “fair value” for a company.

What is the difference between WACC and discount rate in DCF? ›

The discount rate is an investor's desired rate of return, generally considered to be the investor's opportunity cost of capital. The Weighted Average Cost of Capital (WACC) represents the average cost of financing a company debt and equity, weighted to its respective use.

Why is discounted cash flow the best method? ›

The main Pros of a DCF model are:

Extremely detailed. Includes all major assumptions about the business. Determines the “intrinsic” value of a business. Does not require any comparable companies.

What is the difference between NPV and DCF? ›

The main difference between discounted cash flow vs. net present value is that net present value subtracts upfront year 0 costs (in actual dollars estimated) from the sum of the present value of the cash flows. The discounted cash flow method doesn't subtract these initial costs that include capital expenditures.

What is a good DCF value? ›

If the DCF is greater than the present cost, the investment is profitable. The higher the DCF, the greater return the investment generates. If the DCF is lower than the present cost, investors should rather hold the cash.

What is the biggest drawback of the DCF? ›

The reliance on assumptions is the main drawback of the DCF approach, in which minor adjustments to key assumptions could have material impacts on the DCF valuation.

How accurate is DCF valuation? ›

DCF Valuation is extremely sensitive to assumptions related to perpetual growth rate and discount rate. Any minor tweaking here and there, and the DCF Valuation will fluctuate wildly and the fair value so generated won't be accurate. It works best only when there is a high degree of confidence about future cash flows.

Who uses DCF models? ›

Discounted cash flow analysis is widely used in investment finance, real estate development, corporate financial management, and patent valuation.

When can't WACC be used? ›

What is WACC used for? The Weighted Average Cost of Capital serves as the discount rate for calculating the value of a business. It is also used to evaluate investment opportunities, as WACC is considered to represent the firm's opportunity cost of capital. Thus, it is used as a hurdle rate by companies.

Should DCF use cost of equity or WACC? ›

When a company analyzes whether it should invest in a certain project or purchase new equipment, it usually uses its weighted average cost of capital (WACC) as the discount rate to evaluate the DCF. The WACC incorporates the average rate of return that shareholders in the firm are expecting for the given year.

Do you add or subtract CapEx in a DCF? ›

Finally, we subtract Capital Expenditures (CapEx) since these also reduce the company's cash flow; we calculated these in a previous step. Unlevered FCF growth should slow down over time, and by the end of 10 years, it should be around the GDP growth rate or inflation rate (1-3%), which it is here.

How do you calculate WACC using CAPM? ›

WACC is calculated with the formula: WAC = [ % Equity x Cost of Equity ] + [ % Preferred x Cost of Preferred ] + [ % Debt x Cost of Debt x (1 – Tax Rate) ]. CAPM is used to calculate the cost of equity which is used in the WACC formula.

How to do a DCF model? ›

The following steps are required to arrive at a DCF valuation:
  1. Project unlevered FCFs (UFCFs)
  2. Choose a discount rate.
  3. Calculate the TV.
  4. Calculate the enterprise value (EV) by discounting the projected UFCFs and TV to net present value.
  5. Calculate the equity value by subtracting net debt from EV.
  6. Review the results.

Is WACC used to calculate NPV? ›

WACC is used in financial modeling as the discount rate to calculate the net present value of a business. More specifically, WACC is the discount rate used when valuing a business or project using the unlevered free cash flow approach.

References

Top Articles
Latest Posts
Article information

Author: Wyatt Volkman LLD

Last Updated:

Views: 5917

Rating: 4.6 / 5 (66 voted)

Reviews: 89% of readers found this page helpful

Author information

Name: Wyatt Volkman LLD

Birthday: 1992-02-16

Address: Suite 851 78549 Lubowitz Well, Wardside, TX 98080-8615

Phone: +67618977178100

Job: Manufacturing Director

Hobby: Running, Mountaineering, Inline skating, Writing, Baton twirling, Computer programming, Stone skipping

Introduction: My name is Wyatt Volkman LLD, I am a handsome, rich, comfortable, lively, zealous, graceful, gifted person who loves writing and wants to share my knowledge and understanding with you.