The Secret Of Financial Statement Modeling

The Secret Of Financial Statement Modeling

When it comes to getting filthy rich overnight, folks usually find the key to success to be investing in stock markets. The good news is that today in the era of tremendous technological advancement investing in stocks is now possible with one and only one condition: Have all the data available to make the best decision.

The first thing that must be learned towards gaining enough knowledge about investing in the stock market is to have a deep understanding of companies’ financial statements which are the most reliable data, audited by third-party firms.

Understand Company Financial Statements

A company has 3 financial statements: Income statement, Balance sheet statement and Cash flow statement. It publishes them every year.

Each of the Financial Statements Have a Purpose:

Statement of Profit & Loss Income Statement

Often, the first place an investor or analyst will look at is the income statement. The income statement shows the performance of the business in terms of Revenue, Cost of sales and Profit (Both Gross and Net Profit).

Key features:

  • Shows the revenues and expenses of a business
  • Expressed over a period of time (i.e., 1 year, 1 quarter, Year-to-Date, etc.)

Balance Sheet Statement:

The balance sheet displays the company’s assets, liabilities, and shareholder’s equity.

Key features:

  • Shows the financial position of a business
  • Expressed as a “snapshot” or financial picture of the company at a specified point in time (i.e., as of December 12, 2017)
  • Has three sections: assets, liabilities, and shareholders equity

Statement of Cash Flow

A cash flow statement is a financial statement that provides aggregate data regarding all cash inflows a company receives from its ongoing operations and external investment sources.

Key features:

  • Shows the increases and decreases in cash
  • Expressed over a period of time, an accounting period (i.e., 1 year, 1 quarter, Year-to-Date, etc.)
  • Shows the net change in the cash balance from start to end of the period

These three statements allow us to have a clear picture of a company's financial health at any given time frame.

For example for Apple Inc. 2018 Net Income is 59.53 billion USD, Total Assets represents 365.7 billion USD and its free cash flow 5.624 Billion.

Similarly, for Microsoft Inc, 2018 Net Income is 16.561 billion USD, Total Assets represents 258.848 billion USD and its free cash flow of 4.283 Billion USD.

All these figures are a positive and good indication for establishing a reputable trust on investors but there are also other aspects like key financial Ratios that must be taken into consideration while decision making about a particular stock.

These financial ratios are like ROI (Return On investment), Current Ratio, Debt/Equity Ratio, etc.

Hey Folks! Don’t be afraid of these jargons. These data are easily available for almost all listed stocks. You can find them as reported in the U.S. Securities and Exchange Commission (SEC) website.

Other than that we encounter many new methodologies in the market and we will discuss today the DCF Methodology.

I will explain to you in a few lines to give you a better understanding and will save your time roaming around.

DCF Methodology:

What is the DCF Model?

A basic DCF model involves projecting future cash flows and discounting them back to the present using a discount rate (weighted average cost of capital) that reflects the riskiness of the capital you then add up all those discounted cash flows and the sum is really the intrinsic value of the company (equity Value).

In this method we try to compare the Market Value of the Share price with the intrinsic value of the share price which is calculated under the DCF methodology through this formula:

Share Price = ((PV of Free Cash Flow) - Net debt ) / Shares Outstanding

Present Value: The values in the presence of a sum of money, in contrast to some future value it will have when it has been invested at compound interest.

Free Cash Flow: Free cash flow (FCF) is a measure of how much cash a business generates after accounting for capital expenditures such as buildings or equipment. This cash can be used for expansion, dividends, reducing debt, or other purposes.

Net Debt: The overall debt situation of a company by netting the value of the liabilities and debts of a company along with its cash and other similar liquid assets.

Shares Outstanding: Are all the shares of a corporation or financial asset that have been authorized, issued and purchased by investors and are held by them.

If you calculate it's discounted cash flow value called DCF. In simple terms, we want to project the company financial statements that we just analyzed for the next five years to determine if its value today is more or less than the company’s current share price.


Apple has the Following Information Furnished with Us

  •  PV of Free Cash Flow: $1,091,589
  • Net debt = $8,749 . Number of outstanding shares: $4,617
  • WACC: 11%
  • Growth Rate: 4% .

Let’s look deeper at Apple DCF:

Let's look at the formula for the DCF method

Share Price = ((PV of FCF) - Net debt )/Shares Outstanding.

Now we will put the figures of the example into the above formula. For more details of the above formula, please have a look at this Apple Terminal Value. You will see the whole breakdown of the calculation.

So if we use the formula we get:

Share Price = [1,091,589 - $8 , 749 ] / 4,617. Share Price = $238.28.

Is Apple Inc. overvalued or undervalued?

We see the intrinsic value as 2019 of Apple Inc. to be $238.28 which is below the current market price of $267.25, so clearly, Apple Inc. is overvalued.

In conclusion, based on this DCF value, we should only take a short position on this particular stock. Following the same reasoning, we can find good buying opportunities such as Facebook or Google. You can find all the details of the valuation and DCF rankings based on the best opportunities available on the market.

Similar Articles

How to Avoid Common Money Management Mistakes in Binary Options

Binary options trading can be a lucrative endeavor if approached with caution and the right strategies. One of the key aspects that can make or break success in this field is money management.


Before you enter the Forex market, you have to know about the different types of orders in Forex. In Forex, order means the way how you will choose to enter or exit the Forex market. 

Buy Bitcoin With Credit & Debit Card

Are you ready to buy your first Bitcoin? Bitcoin is a solid investment these days and perhaps everyone knows it by now! There are thousands of cryptocurrencies in the market today but bitcoin is the first and largest one. However, it's important to keep your investment safe.

Financial trading Bid and Spread prices

The forex market provides traders with some lucrative money making opportunities. However, not all traders end up rich. In fact, statistics indicate that most traders lose money and close their accounts within 3-6 months of joining the forex market. This could be partly because they jumped in without considering the potential implications of some aspects of forex trading, like the FX spread.

Kase Crude Oil and Natural Gas Price Forecasts

With the threat of volatility always looming in the energy markets it is imperative on the part of natural gas, WTI or Brent crude oil, diesel or gasoline traders to secure low-risk positions. They should be alert about the risks posed by the volatile energy markets and mitigate that risk in a timely manner so that they can lock in profits or minimize losses.


Foreign exchange market is quite a volatile market. Where the currencies vary a lot, a keen watch on the market is what will keep the trend going and allow the business to become fruitful and grow. If you are looking to invest in the foreign exchange business yourself you need to have an idea about the market

Risk Management in Trading

Any company that either produces or consumes large quantities of energy will most likely be interested in managing energy price risk. The energy markets are historically volatile, and these price fluctuations can have a huge impact on a company’s bottom-line. 

Leading Trade Signals

Systems and strategies also offer wins in the market.  If you want to change your strategy to reduce risk, then you will want to consider leading trade signals.  These offer forward – thinking tools that allow you to predict the changes in the market. 

leading market indicators

The strategy you use in the market determines the profit you get in return.  However, the uncertainty and changes that take place can lead to a strategy that is ineffective.  Boost your tactics by using leading market indicators.