Discounted Cash Flow (DCF) Calculator for Alibaba Group Holding Limited (BABA)
DCF
Analysis that automates a lot of the process and allows for real time sensitivity changes.
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.
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.