financial-analysis-example

Financial Analysis Example For Complete Beginners

A financial analysis comprises the set of tools, frameworks, and methodologies to analyze the primary financial statements of companies to make internal (to make managerial decisions) and external (to determine the firm’s value or context) assessments. Financial analysis helps determine the state of a company’s valuation based on its main financial statements: balance sheet, income statement, and cash flow statement.

Analysis set up

We are going to perform this analysis up by taking three simple steps. But before we do that we have to have all the information needed available. Where do we find this information? Easy, we look at the target company’s website.

Analysis Overview – make a very few assumptions

In many financial analyses (especially those based on forecasts and financial models), the starting point is to make assumptions. In our analysis, instead, we want to make as few assumptions as possible.

In fact, we are going to let the financials speak for themselves. How? Through three simple steps: in step number one, we are going to select a set of financial ratios that we will use as analytical tools to understand our target company.

In step number two, we are going to perform a DuPont analysis to understand how the profitability evolved over time. Indeed, since we want to make very few assumptions, we are going to drill-down into the ROE and see what influenced it.

And in step number three we are going to compare the financial ratios of our target company against its main comparable. Therefore, before we do that we will have to select a group of comparable companies.

Let’s proceed with order:

Step-One: financial ratios set-up & two-year comparison

In this step, we are going to select a set of ratios that will guide us toward our analysis. Financial ratios are metrics that help us in comprehending the main financial statements. To have a more detailed account of how they work check out our previous article on ratio analysis here.

In this phase, we have to select some ratios to assess few main aspects of the business model that we will divide into four main categories: profitability, liquidity, leverage and efficiency. In this phase, we are going to leave valuation out, which we are going to include in the third step of our analysis.

Once selected these ratios we have to run them for the current and previous year. This is because we want to understand how the company’s trend evolved over time. In this specific case, I decided to do an analysis for 2014 and 2015 for simplicity sake.

You can expand the trend analysis to three or five years if you like. I picked some ratios to analyze Apple Inc. and run them through. See the results in the following table:

1

As you can see from the above table I picked ten different ratios and run them to understand how Apple Inc. performance changed from 2014 to 2015. The table shows increased profitability, liquidity, leverage and efficiency.

The only negative number that you see in this table is a good sign. This is because the receivable in days ratio tells us how long it takes for the company to collect the money from the customers that buy on credit.

In short, the shortest the time it takes for a company to collect money from its customers the more it becomes liquid over time. In Apple Inc. specific case, the receivable in days decreased by 12%, from 30.5 days to 26.8 days.

This is definitely a good sign. In fact, usually a number, which goes below 60 days, is positive, and in this case below 30 days is an extremely positive result.

After completing step one, we can move forward to our second step.

Step number two: DuPont analysis

In this phase, we are going to analyze why the profitability increased and what were the factors the influenced it so much. In short, we are going to drill-down into the ROE to see what is going on there.

In fact, as you can see from the previous table our ROE increased from 33% to 46%.

To know more in detail how to perform this analysis check out our previous article on DuPont Analysis here:

2

As you can see from this table, although the ROE increased substantially it did so due to leverage and profitability. In short, the company was able to improve its revenues but also to contract more debt.

These two factors combined made the company ROE skyrocket. We are ready to move to our third and last step.

Step three: select comparable set-up and comparative analysis completion

In this phase here we have to select some comparable. In short, we want to select companies, which present the same features as our target firm. Afterward, we can relate the main financial ratios of our target company against those of the comparable.

The objective here is to understand the competitive context. In short, although we can make a first assessment of the company’s financials through the first and second step, we are still missing some pieces to complete our puzzle.

Consequently, we are going to use two criteria to select our comparable companies: business model and financial profile. These two profiles will be our guidelines.

Business profile

The business profile attains to qualitative aspects of the business model, which we can synthesize in four properties:

  • Sector – in what sector does the target company operate?
  • Product and services – what are the core products and services the target company offers?
  • Distribution channelhow does the target company get to its end customers?
  • Geography – what is the main market where our target company operates?

For instance, Apple Inc. operates in the consumer goods category and electronic equipment category. Its main products are iPhone, iPod, MAC (which make up most of its revenues).

Apple Inc. distributes its products mainly through its own retails stores, and the primary market is the U.S. (although the company operates worldwide and currently Greater China makes up for 25% of the company’s sales).

Financial profile

The financial profile attains to quantitative aspects of the business. We are going to consider five main aspects:

  • Size – Market cap, revenues, net income
  • Profitability – Average net margin, or gross margin last three or five years
  • Growth profile – Where does the revenue growth come from? Geography and product analysis
  • Return on investment
  • Credit profile – What rating was the company assigned lately? Or what level of liquidity the company has?

For instance, Apple Inc. 2015 market cap surpassed $500 billion dollars, with over $230 billion dollars in revenues and over $50 billion in net profit.

In addition, as for the profitability, the company showed an average net margin (net income/sales) of 23% in the last 5 years. Its revenue growth came mainly from one product, the iPhone and one market, Greater China.

Select Comparable  

 It is time to select Apple’s main comparable.

For simplicity sake, here I want to highlight the fact that when selected Apple comparable I gave more importance to criteria such as geography, products and services, size, and profitability.

In fact, Apple has been able to achieve a powerful position in so many different industries in the tech world and therefore it has also several direct competitors. For instance, in the smartphone industry, Apple’s direct competitors are Samsung, Sony, Lenovo and so on.

In the personal computer industry, Apple’s main competitors are Microsoft, Dell, HP, and Lenovo. We could go on forever.

Although, my assumption here is that de facto Apple’s success was mainly due to its ability to integrate several products through a very intuitive interface that differentiated it from its competitors.

In short, I am assuming (sometimes we have to use assumptions) that the future battle in the tech industry will be played on the software side, rather than the hardware. Therefore, the two biggest players, which are competing against Apple in this respect, are Microsoft and Google.

Perform comparative analysis

We can now run the main financial ratios for Apple Inc. and assess them against Google and Microsoft.

3

In this table is summarized the financial performance of Apple Inc. in comparison with Microsoft and Google for 2015. As you can see from the date Apple has better profitability and efficiency ratios but also worse liquidity, leverage and market valuation ratios.

Wrap-up and Conclusions

In this article, we saw how to set up a financial analysis in three steps. In the first step we selected a set of financial data useful to comprehend the performance of our target company.

In step-two, we went further and analyzed how the ROE evolved over time.

Eventually in step-three, we sleeted comparable companies, and performed a comparative analysis to determine how our target company performed in comparison to the group of company, which operate in the same context.

From the above analysis, you can already be able to draw some conclusions but also investigate further what is going on with our target company. But I hope this article wasn’t too long. Therefore, we will remand our further investigations to another future occasion.

Resources for your business

Popular case studies from the blog:

Connected Business Concepts

Financial Structure

financial-structure
In corporate finance, the financial structure is how corporations finance their assets (usually either through debt or equity). For the sake of reverse engineering businesses, we want to look at three critical elements to determine the model used to sustain its assets: cost structure, profitability, and cash flow generation.

CAPM Model

capital-asset-pricing-model
In finance, the capital asset pricing model (or CAPM) is a model or framework that helps theoretically assess the rate of return required for an asset to build a diversified portfolio able to give satisfactory returns.

Capital Structure

capital-structure
The capital structure shows how an organization financed its operations. Following the balance sheet structure, usually, assets of an organization can be built either by using equity or liability. Equity usually comprises endowment from shareholders and profit reserves. Where instead, liabilities can comprise either current (short-term debt) or non-current (long-term obligations).

Financial Modeling

financial-modeling
Financial modeling involves the analysis of accounting, finance, and business data to predict future financial performance. Financial modeling is often used in valuation, which consists of estimating the value in dollar terms of a company based on several parameters. Some of the most common financial models comprise discounted cash flows, the M&A model, and the CCA model.

Behavioral Finance

behavioral-finance
Behavioral finance or economics focuses on understanding how individuals make decisions and how those decisions are affected by psychological factors, such as biases, and how those can affect the collective. Behavioral finance is an expansion of classic finance and economics that assumed that people always rational choices based on optimizing their outcome, void of context.

Value Investing

value-investing
Value investing is an investment philosophy that looks at companies’ fundamentals, to discover those companies whose intrinsic value is higher than what the market is currently pricing, in short value investing tries to evaluate a business by starting by its fundamentals.

Balanced Scorecard

balanced-scorecard
First proposed by accounting academic Robert Kaplan, the balanced scorecard is a management system that allows an organization to focus on big-picture strategic goals. The four perspectives of the balanced scorecard include financial, customer, business process, and organizational capacity. From there, according to the balanced scorecard, it’s possible to have a holistic view of the business.

Buffet Indicator

buffet-indicator
The Buffet Indicator is a measure of the total value of all publicly-traded stocks in a country divided by that country’s GDP. It’s a measure and ratio to evaluate whether a market is undervalued or overvalued. It’s one of Warren Buffet’s favorite measures as a warning that financial markets might be overvalued and riskier.

Double Entry Accounting

double-entry-accounting
Double-entry accounting is the foundation of modern financial accounting. It’s based on the accounting equation, where assets equal liabilities plus equity. That is the fundamental unit to build financial statements (balance sheet, income statement, and cash flow statement). The basic concept of double entry is that a single transaction, to be recorded, will hit two accounts.

Income Statement

income-statement
The income statement, together with the balance sheet and the cash flow statement is among the key financial statements to understand how companies perform at fundamental level. The income statement shows the revenues and costs for a period and whether the company runs at profit or loss (also called P&L statement).

Financial Statements

financial-statements
Financial statements help companies assess several aspects of the business, from profitability (income statement) to how assets are sourced (balance sheet), and cash inflows and outflows (cash flow statement). Financial statements are also mandatory to companies for tax purposes. They are also used by managers to assess the performance of the business.

Revenue Modeling

revenue-modeling
Revenue modeling is a process of incorporating a sustainable financial model for revenue generation within a business model design. Revenue modeling can help to understand what options make more sense in creating a digital business from scratch; alternatively, it can help in analyzing existing digital businesses and reverse engineer them.

Financial Accounting

financial-accounting
Financial accounting is a subdiscipline within accounting that helps organizations provide reporting related to three critical areas of a business: its assets and liabilities (balance sheet), its revenues and expenses (income statement), and its cash flows (cash flow statement). Together those areas can be used for internal and external purposes.

Connected Video Lectures

Leave a Reply

Scroll to Top
FourWeekMBA