What is the purpose of a business valuation and in what circumstances might one be useful? What type of assets of a business need to be valued? The factors that can affect a valuation.

Learn the key differences between book value and market value and how each can be useful for different purposes. What is the relationship between book value and market value?

What is Discounted Cashflow Analysis (DCF) and how can it be used to assess the intrinsic value of a business?

Comparable company analysis is a market-based valuation analysis for publicly traded companies. It is based on the idea that companies with similar characteristics should have similar valuation multiples. Learn the steps for conducting a comparable company analysis. Learn the comps method of Trading Multiples.

Learn the comps method of Precedent Transactions.

Spreading Comps is the task of collecting and calculating relevant multiples from a number of different comparable companies.

What are the different valuation methods and their advantages and disadvantages?

What are the uses of financial models? How can they aid decision making? Tips for finding company financials and setting up financial models.

The debt schedule is designed to track every major type of debt a company has and the associated interest and payment schedules. It also helps track the cash available that could be used to pay down those debts and any interest income that could be generated from cash or cash equivalents available.

A firm's revolver is a line of short-term credit which the firm can access when it needs short-term funding to pay operating expenses. The revolver is always used for short-term financing, and is almost always paid off very quickly.

Sensitivity analysis is a way to ascertain the impact of a change in outcome for changes in inputs. It is a very important tool in financial modeling. Most of the sensitivity analyses use one or two variable inputs.

We will now set the scene and start creating a financial model. Download the financial model and follow along.

Data backed assumptions are those that are supported by data from a proper source. Qualitative assumptions are those for which any authentic data cannot be found. Therefore, these assumptions can be made using some kind of logical rationale.

In this tab the size of the target market is calculated. The data is linked form the data backed and qualitative assumptions tab.

This tab will show how customer traffic will flow over 5 years. We will project the demand for our products by the different market segments.

We will project how many customers will demand our product and service each year. We will work out the demand for 5 years.

This tab will show a table of start-up expenses and the amount of capital invested.

This is a depreciation schedule for 5 years for the company. The data is linked to the P & L statement and balance sheet.

This tab will show the P & L projection for 5 years. The data is taken from various tabs and the net profit or loss figure is then linked to the balance sheet and cash flow statement.

Cash flow for 5 years is projected. The data is linked from the start-up expenses tab and the P & L statement.

This is the last and most important statement of any financial model.

Bringing everything together we will calculate the business valuation.