Podcast
Questions and Answers
The reasonable cost of capital typically includes the cost of ______ and cost of equity.
The reasonable cost of capital typically includes the cost of ______ and cost of equity.
debt
In financial modeling, DCF is a method commonly used to calculate ______.
In financial modeling, DCF is a method commonly used to calculate ______.
value
What-If Analysis is used to create new ______ and gather immediate results of settings.
What-If Analysis is used to create new ______ and gather immediate results of settings.
scenarios
The Title Page provides an overview of the project being ______ or assessed.
The Title Page provides an overview of the project being ______ or assessed.
The Assumption Sheets summarize the ______ used in the financial model.
The Assumption Sheets summarize the ______ used in the financial model.
Net cash flow to the firm can be computed from net ______
Net cash flow to the firm can be computed from net ______
Non cash charges are added back to take into account ______ expenses.
Non cash charges are added back to take into account ______ expenses.
Net investment in fixed capital consists of purchases and ______ of fixed capital investments.
Net investment in fixed capital consists of purchases and ______ of fixed capital investments.
Net cash flows to the firm can also be derived from the statement of cash flows under ______ activities.
Net cash flows to the firm can also be derived from the statement of cash flows under ______ activities.
EBITDA stands for earnings before interest, taxes, depreciation, and ______.
EBITDA stands for earnings before interest, taxes, depreciation, and ______.
Net cash flows equity represent the cash flows available to equity stockholders after deducting net ______.
Net cash flows equity represent the cash flows available to equity stockholders after deducting net ______.
Net cash flow to the firm is adjusted by considering proceeds from borrowing and debt ______.
Net cash flow to the firm is adjusted by considering proceeds from borrowing and debt ______.
Dividends on preferred shares are subtracted when calculating net cash flows to the ______.
Dividends on preferred shares are subtracted when calculating net cash flows to the ______.
Notes to the Financial Statement provides the summary of important ______ that should be considered in the valuation.
Notes to the Financial Statement provides the summary of important ______ that should be considered in the valuation.
Net Income Available to Common Shareholders is represented as Php ______.
Net Income Available to Common Shareholders is represented as Php ______.
Disclosure of future plans and strategies of the ______ is essential for stakeholders.
Disclosure of future plans and strategies of the ______ is essential for stakeholders.
It is important for the modelers to know the existing ______ and the covenants contained in it.
It is important for the modelers to know the existing ______ and the covenants contained in it.
In the statement of Cash Flows, Cash Flows from Operating Activities is also recorded as Php ______.
In the statement of Cash Flows, Cash Flows from Operating Activities is also recorded as Php ______.
Due Diligence is necessary to verify any contingent ______ and other legal risks.
Due Diligence is necessary to verify any contingent ______ and other legal risks.
Adjustments in Working Capital may either be added or ______ based on the company's financial position.
Adjustments in Working Capital may either be added or ______ based on the company's financial position.
Peer information provides more context and supports the ______ identified in the valuation process.
Peer information provides more context and supports the ______ identified in the valuation process.
The Terminal Value determines a company's value into ______ beyond a set forecast period.
The Terminal Value determines a company's value into ______ beyond a set forecast period.
Drivers are suggested to be those validated and represented by ______ like government or experts.
Drivers are suggested to be those validated and represented by ______ like government or experts.
Investments in Fixed Capital are represented in cash flows as ______.
Investments in Fixed Capital are represented in cash flows as ______.
Usual growth indicators used are inflation, population growth, ______ or GDP growth.
Usual growth indicators used are inflation, population growth, ______ or GDP growth.
EBITDA, net of Taxes is represented as Php ______.
EBITDA, net of Taxes is represented as Php ______.
In Economics, inflation is the result of the movement of ______ from a year to another.
In Economics, inflation is the result of the movement of ______ from a year to another.
Proceeds from Borrowing are included in the calculation of ______ Cash Flows to the Firm.
Proceeds from Borrowing are included in the calculation of ______ Cash Flows to the Firm.
Dividends on Preferred Shares are considered a ______ when calculating Net Cash Flows to the Equity.
Dividends on Preferred Shares are considered a ______ when calculating Net Cash Flows to the Equity.
The formula for estimating terminal value (TV) involves net cash flow at its farthest point, known as C𝐹𝑛+1, divided by the difference of the cost of capital (r) and the ______.
The formula for estimating terminal value (TV) involves net cash flow at its farthest point, known as C𝐹𝑛+1, divided by the difference of the cost of capital (r) and the ______.
The growth rate is computed using the Compounded Annual Growth Rate Formula: g = (NC𝐹𝑛 / NCF0)^(1/n) - 1 x 100%. Here, NCF0 represents net cash flow at the ______.
The growth rate is computed using the Compounded Annual Growth Rate Formula: g = (NC𝐹𝑛 / NCF0)^(1/n) - 1 x 100%. Here, NCF0 represents net cash flow at the ______.
In Discounted Cash Flow (DCF) Analysis, it is critical to have validated operational and financial ______.
In Discounted Cash Flow (DCF) Analysis, it is critical to have validated operational and financial ______.
Financial modelers may include professionals like economists, financial managers, and ______.
Financial modelers may include professionals like economists, financial managers, and ______.
When constructing financial models, historical information is often gathered from audited financial ______.
When constructing financial models, historical information is often gathered from audited financial ______.
Steps in creating financial models include gathering historical information, establishing drivers for growth, and determining the reasonable cost of ______.
Steps in creating financial models include gathering historical information, establishing drivers for growth, and determining the reasonable cost of ______.
Changes in equity reflect how much is the claim and dividend ______ of the company.
Changes in equity reflect how much is the claim and dividend ______ of the company.
Scenario and sensitivity analysis are applied based on the ______ obtained from financial model computations.
Scenario and sensitivity analysis are applied based on the ______ obtained from financial model computations.
The formula for calculating inflation is given by (CPI_n - CPI_0) / CPI_0 x 100%, where CPI_n is the consumer price index of the ______.
The formula for calculating inflation is given by (CPI_n - CPI_0) / CPI_0 x 100%, where CPI_n is the consumer price index of the ______.
If the CPI increased from 151 to 155, the ______ rate for that year can be calculated using the inflation formula.
If the CPI increased from 151 to 155, the ______ rate for that year can be calculated using the inflation formula.
In 2020, if the CPI decreased to 149, it signifies ______ instead of inflation.
In 2020, if the CPI decreased to 149, it signifies ______ instead of inflation.
The cost of communication in 2021, after incorporating an inflation rate of 2.65%, will be calculated as 5,000,000 x ______.
The cost of communication in 2021, after incorporating an inflation rate of 2.65%, will be calculated as 5,000,000 x ______.
The growth rate formula is similar to that of ______.
The growth rate formula is similar to that of ______.
In Barangay A, the population growth from 25,200 in 2021 to 26,460 in 2022 results in a growth rate of ______ percent.
In Barangay A, the population growth from 25,200 in 2021 to 26,460 in 2022 results in a growth rate of ______ percent.
To find the estimated number of pandesal to be sold in 2022, one would need to multiply the projected population of 26,460 by ______.
To find the estimated number of pandesal to be sold in 2022, one would need to multiply the projected population of 26,460 by ______.
Trend analysis is used to help establish the trajectory of ______ rate for better financial forecasting.
Trend analysis is used to help establish the trajectory of ______ rate for better financial forecasting.
Flashcards
Net Cash Flows to the Firm
Net Cash Flows to the Firm
The cash available to lenders and shareholders after operating expenses, taxes, capital expenditures, and working capital adjustments.
Net Cash Flow to the Firm Calculation (Indirect Approach)
Net Cash Flow to the Firm Calculation (Indirect Approach)
Calculating NCFF by starting with Net Income and adjusting for non-cash charges, interest (net of taxes), working capital changes, and capital investments.
Net Cash Flow to the Firm Calculation (Statement of Cash Flows)
Net Cash Flow to the Firm Calculation (Statement of Cash Flows)
Using operating cash flows, adding interest after tax, and subtracting investing cash flows to get NCFF.
Net Cash Flow to the Firm Calculation (EBITDA)
Net Cash Flow to the Firm Calculation (EBITDA)
Signup and view all the flashcards
Net Cash Flows Equity
Net Cash Flows Equity
Signup and view all the flashcards
Net Cash Flows Equity Calculation
Net Cash Flows Equity Calculation
Signup and view all the flashcards
Non-Cash Charges
Non-Cash Charges
Signup and view all the flashcards
Working Capital Adjustments
Working Capital Adjustments
Signup and view all the flashcards
Terminal value
Terminal value
Signup and view all the flashcards
EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization)
EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization)
Signup and view all the flashcards
Liquidity Value
Liquidity Value
Signup and view all the flashcards
Investments in Fixed Capital
Investments in Fixed Capital
Signup and view all the flashcards
Debt Service
Debt Service
Signup and view all the flashcards
What are some important disclosures to look for in financial statements?
What are some important disclosures to look for in financial statements?
Signup and view all the flashcards
What kind of information do corporate disclosures provide?
What kind of information do corporate disclosures provide?
Signup and view all the flashcards
Why are contracts important in valuation?
Why are contracts important in valuation?
Signup and view all the flashcards
What is peer information and how is it used?
What is peer information and how is it used?
Signup and view all the flashcards
What are two key factors to consider when evaluating information?
What are two key factors to consider when evaluating information?
Signup and view all the flashcards
What is a growth driver and how is it determined?
What is a growth driver and how is it determined?
Signup and view all the flashcards
What are some examples of data provided by the government?
What are some examples of data provided by the government?
Signup and view all the flashcards
What are common growth indicators used in valuation?
What are common growth indicators used in valuation?
Signup and view all the flashcards
What is the Cost of Capital?
What is the Cost of Capital?
Signup and view all the flashcards
How is Cost of Capital used in Valuation?
How is Cost of Capital used in Valuation?
Signup and view all the flashcards
What is Sensitivity Analysis?
What is Sensitivity Analysis?
Signup and view all the flashcards
What are the Components of a Financial Model?
What are the Components of a Financial Model?
Signup and view all the flashcards
What is the Purpose of a Financial Model?
What is the Purpose of a Financial Model?
Signup and view all the flashcards
Inflation Rate
Inflation Rate
Signup and view all the flashcards
Deflation Rate
Deflation Rate
Signup and view all the flashcards
Growth Rate
Growth Rate
Signup and view all the flashcards
Consumer Price Index (CPI)
Consumer Price Index (CPI)
Signup and view all the flashcards
Cost of Capital
Cost of Capital
Signup and view all the flashcards
Trend Analysis
Trend Analysis
Signup and view all the flashcards
Financial Modeling
Financial Modeling
Signup and view all the flashcards
Assumptions
Assumptions
Signup and view all the flashcards
Terminal Value (TV)
Terminal Value (TV)
Signup and view all the flashcards
Growth Rate (g)
Growth Rate (g)
Signup and view all the flashcards
Cost of Capital (r)
Cost of Capital (r)
Signup and view all the flashcards
DCF Analysis Most Applicable When
DCF Analysis Most Applicable When
Signup and view all the flashcards
Gather Historical Information
Gather Historical Information
Signup and view all the flashcards
Audited Financial Statements
Audited Financial Statements
Signup and view all the flashcards
Corporate Disclosures
Corporate Disclosures
Signup and view all the flashcards
Study Notes
Discounted Cash Flows Methods
- Discounted cash flow analysis involves determining the present value of the net cash flow of an investment opportunity.
- Cash flows are categorized as operating, investing, and financing activities.
Net Cash Flows
- Net cash flows represent the amount of cash available for distribution to both debt and equity claims of a business or assets.
- Going concern business opportunity (GCBO) net cash flow is based on operating and investing activities.
Net Cash Flows Preferred
- Net cash flows are preferred as a valuation basis if the company does not pay dividends, or pays dividends significantly different from its capacity, or if net cash flows and profits align within a reasonable forecast period, or if investors have a control perspective.
Using Net Cash Flows
- Using net cash flows is more advantageous in valuation activities because it can be directly used as input in a discounted cash flow (DCF) model.
- Other cash flow metrics like EBITDA, EBIT, net income, and cash flow from operations may not be as accurate because they might either miss or double-count items.
Reasons for Using Net Cash Flows
- EBITDA and EBIT are before-tax metrics, while cash flows available to investors are after-tax.
- EBITDA and EBIT do not consider differences in capital structures, interest payments, dividends for preference shares, or funds sourced from bondholders to fund additional investments.
- These measures also do not consider reinvestment of cash flows into the firm for additional working capital and fixed assets investment, which are necessary to maximize long-term business stability.
Analyzing Cash Flows
- Analyzing cash flows and their sources helps analysts understand the source of financing for needed investments, reliance on debt financing, and quality of earnings.
Two Levels of Net Cash Flows
- Net Cash Flow to the Firm is the amount made available to both debt and equity claims.
- It's generated from operating and financing activities intended to pay required returns on funds provided.
Net Cash Flows to the Firm
- This refers to the cash flow available to lenders and shareholders after all operating expenses, including taxes, and investing capital expenditures and working capital, are paid.
Computing Net Cash Flows Using Approaches
- A. Based from Net Income (or Indirect Approach):
- Add Non-cash charges (net)
- Add Interest expense (net of Taxes)
- Adjust working capital
- Deduct net investments in fixed capital (purchases-sales of fixed capital investments)
- B. From Statement of Cash Flows:
- Add Interest expenses (net of Taxes) from operating activities
- Deduct Cash flows from investing activities
- C. From Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA):
- Add tax savings on noncash charges
- Add/less working capital adjustments
- Deduct investments in fixed capital
Net Cash Flows Equity
- Net cash flows equity represent the cash available to equity shareholders after deducting net debt, outstanding liabilities to creditors, and available cash balance.
- It can be calculated from the net cash flow to the firm by considering items related to lenders and preferred shareholders.
Net Cash Flow Formula
- Add: Proceeds from borrowing
- Less: Debt service
- Add: Proceeds from preferred shares issuance
- Less: Dividends on preferred shares
- Net Cash Flows to the Equity
NCFE Calculation Approaches
- A. Based from Net Income (or Indirect Approach):
- Net Income available to common shareholders
- Non-cash charges (net)
- Interest expense (net of Taxes)
- Adjustments in Working Capital
- Net Investments in Fixed Capital (Purchases−Sales of Fixed Capital Investments)
- Net Cash Flows to the Firm
- Proceeds from Borrowing
- Debt Service
- Proceeds from preferred shares issuance
- Dividends on Preferred Shares
- Net Cash flows to the Equity
- B. From Statement of Cash Flows:
- Add Interest Expenses (net of Taxes) from operating activities
- Less Cash Flows from Investing Activities
- Net Cash Flows to the Firm
- Add Proceeds from Borrowing
- Less Debt Service
- Add Proceeds from Preferred Shares Issuance
- Less Dividends on Preferred Shares
- Net Cash Flows to the Equity
- C. From Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA):
- EBITDA, net of Taxes
- Tax savings on Noncash Charges
- Working Capital Adjustments
- Investments in Fixed Capital
- Net Cash Flows to the Firm
- Proceeds from Borrowings
- Debt Service
- Proceeds from Preferred Shares Issuance
- Dividends on Preferred Shares
- Net Cash Flows to the Equity
Terminal Value
- Terminal value is the value of an asset, business, or project beyond the forecasted period when future cash flows are estimated. Value is determined into perpetuity beyond a set forecast period, usually five years.
Basis of Terminal Value
- 1. Liquidity Value
- 2. Estimated Perpetual Value: TV = CFn+1 / (r - g)
- TV = Terminal value
- CFn+1 = farthest net cash flow
- r = Cost of Capital
- g = growth rate
Growth Rate
- g = [(NCFn / NCF0)(1/n) - 1] x 100%
- NCFn = latest net cash flow
- NCF0 = net cash flow at the beginning
- n = Latest Time
Constant Growth
- Constant Growth
- Scientific Estimates
DCF Analysis Applicability
- Validated operational and financial information
- Reasonable appropriated cost of capital or required rate of return
- New quantifiable information
Financial Model in DCF Analysis
- Sophisticated and confidential activity in a company or for an analyst.
- Information can be a competitive advantage.
- Companies often hire financial modelers to validate estimates and explore opportunities. Modelers possess extensive experience and expertise, often consisting of economists, financial managers, and accountants.
Steps in Creating Financial Models
- Gather historical information and references
- Establish drivers for growth and assumptions
- Determine reasonable cost of capital
- Apply formulas to compute for the value
- Make scenario and sensitivity analysis based on results
Gather Historical Information and References
- Historical information is necessary for financial modeling and is gathered from various sources including audited financial statements, corporate disclosures, contracts, and peer information.
Historical Information
- Audited Financial Statements: used to assess future performance based on past performance
- Financial Performance: used to determine historical financial performance
- Financial Position: used to determine the book value of assets and disclosed stakes of debt and equity financiers
- Cash flows: illustrate how a company historically finances operations and investments
- Changes in Equity: answers how much is the claim and dividend background of the company
- Notes: to the Financial Statement provides important disclosures
- Corporate Disclosures: of future plans and strategies
- Contracts: formal agreements between parties.
- Due Diligence: to verify contingent liability and other legal risks to quantify accordingly for conservative value.
- Peer Information: provides context, supports identified risks, includes analysts, industry experts, and consultants; research and studies and data shared in conventions, forums are additional relevant input for development of financial model and valuation.
Gather Historical Information
- Financial models must filter necessary information for valuation based on relevance and reliability.
- Materiality is a key consideration; only relevant items should be considered during valuation.
Establishing Driver for Growth and Assumptions
- Financial analysis helps in establishing drivers and assumptions.
- Validated drivers and assumptions are represented by authorities, such as government bodies or experts.
- Business growth often tied to consumer goods, population.
- While service businesses follow industry growth.
- Data from government entities including Philippine Statistics Authority, Bangko Sentral ng Pilipinas and the National Economic and Development Authority. (Government sources).
Establishing Drivers for Growth
- Population growth, GDP, GNP growth, and inflation rates are usual growth indicators for businesses.
- Calculating Inflation: Inflation = [(CPIn - CPI0) / CPI0] * 100% (where CPIn is the consumer price index for the current year and CPI0 is the consumer price index for the base year.)
Illustration of Inflation/Deflation Calculation
- Examples provided calculating inflation or deflation rate from CPI values.
Communication Cost Example
- Illustrates how to calculate communication cost adjusted for inflation
Population Growth Rate
- Population growth rates serve as growth drivers for product demand; the formula parallels inflation calculations.
Growth Rate (Illustration) Calculation
- Example showing growth rate calculation given population figures.
Determining the Reasonable Cost of Capital
- Trend analysis helps determine growth trajectory.
- Financial modelers must determine if the company can sustain the projected pattern or apply a more conservative growth assumption.
- The cost of debt and equity are generally weighted to determine a reasonable cost of capital for valuation.
Applying Formulae to Compute for the Value
- DCF analysis, used in financial modeling to calculate value, can utilize other capital budgeting techniques, such as internal rate of return and profitability index, given available financial information.
Making Scenarios and Sensitivity Analysis
- What-if analysis produces different scenarios and gathers immediate results from these scenarios.
Components of Financial Model
- Title Page: Overview of the project being assessed.
- Data Key Results: Summarized results of the study.
- Assumption Sheets: Assumptions used in the model.
- Pro-forma Financial Statements: Presents financial statements and key ratios.
- Supporting Schedules: Supporting computations for components within the proforma financial statements.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Related Documents
Description
This quiz explores the principles of discounted cash flow (DCF) analysis, which is essential for evaluating investment opportunities. It discusses how net cash flows are categorized and the advantages of using net cash flows in valuation activities. Test your understanding of cash flow concepts and their significance in financial analysis.