Termos Financeiros utilizados em Modelagem Financeira
Atualizado: 13 de abr. de 2020
Muitas vezes ao analisar uma Modelagem Financeira ou um Valuation, nos deparamos com termos e abreviações em inglês que desconhecemos. E, por mais que conhecemos as estruturas dos modelos e relatórios, estes termos desconhecidos acabam nos dificultando nas interpretações e análises.
Abaixo listamos os principais termos e definições em inglês. utilizados em Valuation, Modelagem Financeira em Excel:
A - Actual figure
Actual or present value/amount.
ARPU - Average Revenue per User
Defined as the total revenue divided by the number of subscribers.
Things that are resources owned by a company and which have future economic value that can be measured and can be expressed in dollars. Examples include cash, investments, accounts receivable, inventory, supplies, land, buildings, equipment, and vehicles.
Assets are part of the accounting equation and the balance sheet, both of which are presented in this format:
- Assets = Liabilities + Stockholders' (or Owner's) Equity.
Is one of the three fundamental financial statements and is key to both financial modeling and accounting. The balance sheet displays the company’s total assets, and how these assets are financed, through either debt or equity. It can also be referred to as a statement of net worth, or a statement of financial position. The balance sheet is based on the fundamental equation: Assets = Liabilities + Equity.
Beta is a numeric value that measures the fluctuations of a stock to changes in the overall stock market.
Beta measures the responsiveness of a stock's price to changes in the overall stock market. On comparison of the benchmark index for e.g. NSE Nifty to a particular stock returns, a pattern develops that shows the stock's openness to the market risk. This helps the investor to decide whether he wants to go for the riskier stock that is highly correlated with the market (beta above 1), or with a less volatile one (beta below 1).
B.O.T. - Build, Operate, and Transfer
A kind of Project that makes use of project finance structure.
Break Even Analysis in economics, business, and cost accounting refers to the point in which total cost and total revenue are equal. A break even point analysis is used to determine the number of units or dollars of revenue needed to cover total costs (fixed and variable costs).
CAC - Customer Acquisition Costs
Cost associated in convincing a customer to buy a product/service.
CAPEX - Capital Expenditures
Money spent by a business or organization on acquiring or maintaining fixed assets.
CAPM - Capital Asset Price Model
It is used to calculate the predicted rate of return of any risky asset. It compares the relationship between systematic risk and expected return. Typically, it’s used on stocks. However, CAPM can also be used throughout financial decision making to price riskier investments. When pricing them, it’s important to reach a balance between the price due to risk and the expected return – thus, using CAPM can help.
The main idea and impulse behind using CAPM is that investors need to be compensated for two things: the time value of money and the risk they are assuming. CAPM takes both into account.
Cash Flow (CF) is the increase or decrease in the amount of money a business, institution, or individual has. In finance, the term is used to describe the amount of cash (currency) that is generated or consumed in a given time period.
There are several types of Cash Flow, so it’s important to have a solid understanding of what each of them is. When someone refers to CF, they could mean any of the types listed below, so be sure to clarify which cash flow term is being used.
Types of cash flow include:
Cash from Operating Activities – Cash that is generated by a company’s core business activities – does not include cash flow from investing. This is found on the company’s Statement of Cash Flows (the first section).
Cash from Investing Activities include cash activities related to noncurrent assets. Noncurrent assets include long-term investments; property, plant, and equipment; and he principal amount of loans made to other entities.
Cash form Financing activities include cash activities related to noncurrent liabilities and owners’ equity. Noncurrent liabilities and owners’ equity items include the principal amount of long-term debt, stock sales and repurchases, and dividend payments.
Free Cash Flow to Equity (FCFE) – FCFE represents the cash that’s available after reinvestment back into the business (capital expenditures).
Free Cash Flow to the Firm (FCFF) – This is a measure that assumes a company has no leverage (debt). It is used in financial modeling and valuation.
Net Change in Cash – The change in the amount of cash flow from one accounting period to the next. This is found at the bottom of the Cash Flow Statement.
COGS - Cost of goods sold
Direct costs attributable to the production of the goods sold in a company.
A business’s contribution margin – also called the gross margin – is the money left over from sales after paying all variable expenses associated with producing a product. Subtracting fixed expenses, such as rent, equipment leases, and salaries from your contribution margin yields your net income, or profit.
CPC - Cost per Click
Also known as Pay per click, an internet advertising model used to direct traffic to websites, in which an advertiser pays a publisher (typically a website owner or a network of websites) when the ad is clicked.
Cum. - Cumulated
A current asset is an item on an entity's balance sheet that is either cash, a cash equivalent, or which can be converted into cash within one year. If an organization has an operating cycle lasting more than one year, an asset is still classified as current as long as it is converted into cash within the operating cycle. Examples of current assets are:
Cash, including foreign currency
Investments, except for investments that cannot be easily liquidated
Current (or short-term) liabilities are liabilities that a company is required to settle within the next twelve months or which it expects to settle within its normal operating cycle.
Liabilities are financial obligations which require transfer of assets (mainly cash) for settlement. They are classified into current and non-current liabilities based on the urgency of their settlement. Comparison of current liabilities with current assets helps creditors, debt-holders and investors assess a company’s liquidity position.
Here is a list of typical current liabilities:
Short-term debt payable
Short-term notes payable
Current lease liability
Current tax payable
D&A - Depreciation & Amortization
Used to determine the depreciation costs for both tangible and intangible assets.
Depreciation is the reduction in the utility of the fixed asset like plant & machinery, furniture & fixtures, vehicles, buildings, etc. because of obsolescence through technology or market conditions, natural wear and tear, the passage of time, exhaustion of subject matter and so on.
DCF - Discounted Free Cash Flows
Method of valuing a project, company, or asset using the concepts of the time value of money.
DPO - Days’ Payable Outstanding
A ratio used to measure a company’s ability to pay its invoices or bills to its suppliers, vendors or creditors.
DSI - Days’ Sales in Inventory
Also known as Days in Inventory, A ratio used to measure the average number of days a company was able to sell the average number of inventories they held during that time period of year.
DSO - Days’ Sales Outstanding
Also known as Days in Receivable, A ratio used to calculate the estimation of a company’s average collection period or in other words, used to assess a company’s management condition of their accounts receivables.
EBIT - Earnings before interest and taxes
Measure of a firm’s profit that includes all expenses except interest and income tax expenses.
EBITDA - Earnings before interest, taxes, depreciation and amortization
An accounting measure calculated using a company’s net earnings, before interest expenses, taxes, depreciation, and amortization are subtracted, as a proxy for a company’s current operating profitability.
In accounting equity is the value attributable to the owners of a business. The book valuae of equity is calculated as the difference between assets and liabilities on the company’s balance sheet, while the market value of equity is based on the current share price (if public) or a value that is determined by investors or valuation professionals. The account can also be called shareholders/owners/stockholders equity or net worth.
There are generally two types of equity:
F - Forecasted figure
Fixed expenses are those expenses that do not change when there is a change in production or sales level. Expenses like rent, insurance, payment on loans, management salaries, advertising are examples of fixed expenses. They change over a period of time.
FTE - Full Time Equivalent
Also known as whole time equivalent (WTE), it is a unit that indicates the workload of an employed person.
GP - Gross Profit
The profit a company makes after deducting the costs associated with making and selling its products, or the costs associated with providing its services.
Is one of the three important financial statements used for reporting a company's financial performance over a specific accounting period, with the other two key statements being the balance sheet and the statement of cash flows.
The inflation premium is a method used in investing and banking to calculate the normal rate of return on an asset or investment when the general cost of goods and services rises over time, known as inflation. The real return, therefore, or real rate of return, on an investment is reduced by the inflation premium, and this reduction tends to be greater the longer that the investment takes to mature. An example of this would be a government bond that yields a 6% return on the investment in one year, but with an inflation premium over the course of the same year of 2% for the increase in prices. This reduces the real return of the bond to 4% by the end of the year.
Is percentage, is the amount charged by a lender that a borrower must pay for using the lender’s principal. In other words, this is the extra amount beyond the premium that the borrow must repay the lender.