Discounted Cashflow Analysis

A discounted cash flow analysis (DCF) is one of the most widely used methods of calculating the intrinsic value of a business. This often involves spreadsheets that aren't the easiest to use, having to look at multiple places to find the data, or online calculators that over simplify the process by simply adding a multiplier to previous free cash flows.

That is why I created this calculutor, which shows you the last 5 years of data (green section below, you can hide/show it by the click of a button) , allows you to quickly and easily change specific variables, and finally shows you the entire picture on what your chosen variables mean for the company. It calculates the intrinsic value per share (based on your inputs), as well as shows you a table (yellow section below) that show what your growth rates mean in terms of future revenue/earnings over the next 10 years for the company. This allows you to quickly do a sensitivity analysis, as well as make sure the numbers make sense for the sector your company is in.

We are working on a guide on how to do a discounted cash flow calculation with this calculator: DCF Guide. Alternatively you can check one of my many personal valuations, where I breakdown how I personally value companies using this calculator.

I have based this off Professor Aswath Damodaran's teachings, with some slight modifications. Aswath Damodaran is a professor at Stern School of Business at New York University. He is known as the 'dean of valuation'. I would highly recommend reading some of his books on valuation if you haven't yet. I have suggested a few of my favourites below.

Please enter the stock ticker. Add .to for Canadian stocks.

Meta Platforms, Inc. - META - $473.23

Reported Currency: USD

Sector: Internet Content & Information

Industry: Engineering/Construction

Current Market Cap: $1,200,642,201,469

Industry Avg Sales To Capital: 3.73

Industry Avg Cost of Capital: 5.24%

Beta: 1.208

Industry Avg Operating Margin: 4.70%

	Current (TTM)	2023-12-31	2022-12-31	2021-12-31	2020-12-31	2019-12-31
Revenue Growth	5.79%	15.69%	-1.12%	37.18%	21.60%	-
Revenue	142,711,000,000	134,902,000,000	116,609,000,000	117,929,000,000	85,965,000,000	70,697,000,000
Operting Margin	37.38%	34.66%	24.82%	39.65%	38.01%	33.93%
Operating Income	53,342,000,000	46,751,000,000	28,944,000,000	46,753,000,000	32,671,000,000	23,986,000,000
Interest Expense	518,000,000	446,000,000	276,000,000	461,000,000	672,000,000	20,000,000
R&D Expense	38,921,000,000	38,483,000,000	35,338,000,000	24,655,000,000	18,447,000,000	13,600,000,000
Cash/Short Term Investments	58,204,000,000	65,403,000,000	40,738,000,000	47,998,000,000	61,954,000,000	54,855,000,000
Effective Tax Rate	15.74%	17.56%	19.50%	16.74%	12.16%	25.50%
BV of Equity	149,529,000,000	153,168,000,000	125,713,000,000	124,879,000,000	128,290,000,000	101,054,000,000
BV of Debt	37,633,000,000	37,234,000,000	26,591,000,000	13,873,000,000	10,654,000,000	10,324,000,000
Invested Capital	128,958,000,000	124,999,000,000	111,566,000,000	90,754,000,000	76,990,000,000	56,523,000,000
Sales To Capital	1.11	1.08	1.05	1.30	1.12	1.25

Your Variables

To unlock all sliders START A FREE TRIAL.

Revenue Growth Year 1

Revenue Growth Year 2-5

Revenue Growth Perpetuity

Operating Margin Year 1

Operating Margin Target

Year of Convergence

Tax Rate Year 1

Marginal Tax Rate

Sales to Capital Year 1

Sales to Capital Years 2-5

Sales to Capital Years 6-10

Cost of Capital Year 1 / Discount Rate

Cost of Capital Year 10 / Discount Rate

Does the firm have any cross holdings/other non operating assets that don't show up in operating income? Yes No

Output (Next 10 Years)

Terminal Cash Flow: $

Terminal Cost of Capital:

Terminal Value : $

Present Value (Terminal Value) : $

Present Value (CF of Next 10 Years): $

Sum of Present Values : $

Sum of Present Value - Debt + Cash: $

# of Shares: 2,537,121,910

Intrinsic Value Per Share: $

	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10	Terminal Year
Revenue Growth
Revenue
Operating Margin
Operating Income
Tax Rate
EBIT (1-t)
Reinvestment
FCFF
Cost of Capital
Cumulated Discount Factor											-
PV of FCFF											-

This calculator is meant for informational/entertainmenet purposes only. All numbers should be independantely verfied. We are not responsible for any investment losses related to decisions made with the help of this website. We recommend getting professional advice before making any investment decisions. This calculator is meant for informational/entertainment purposes.

Book Recommendations

Discounted Cash Flow (DCF) Calculator for Meta Platforms, Inc. (META)

DCF Analysis that automates a lot of the process and allows for real time sensitivity changes.