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.
Signup and view all the answers
The Assumption Sheets summarize the ______ used in the financial model.
The Assumption Sheets summarize the ______ used in the financial model.
Signup and view all the answers
Net cash flow to the firm can be computed from net ______
Net cash flow to the firm can be computed from net ______
Signup and view all the answers
Non cash charges are added back to take into account ______ expenses.
Non cash charges are added back to take into account ______ expenses.
Signup and view all the answers
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.
Signup and view all the answers
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.
Signup and view all the answers
EBITDA stands for earnings before interest, taxes, depreciation, and ______.
EBITDA stands for earnings before interest, taxes, depreciation, and ______.
Signup and view all the answers
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 ______.
Signup and view all the answers
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 ______.
Signup and view all the answers
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 ______.
Signup and view all the answers
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.
Signup and view all the answers
Net Income Available to Common Shareholders is represented as Php ______.
Net Income Available to Common Shareholders is represented as Php ______.
Signup and view all the answers
Disclosure of future plans and strategies of the ______ is essential for stakeholders.
Disclosure of future plans and strategies of the ______ is essential for stakeholders.
Signup and view all the answers
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.
Signup and view all the answers
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 ______.
Signup and view all the answers
Due Diligence is necessary to verify any contingent ______ and other legal risks.
Due Diligence is necessary to verify any contingent ______ and other legal risks.
Signup and view all the answers
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.
Signup and view all the answers
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.
Signup and view all the answers
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.
Signup and view all the answers
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.
Signup and view all the answers
Investments in Fixed Capital are represented in cash flows as ______.
Investments in Fixed Capital are represented in cash flows as ______.
Signup and view all the answers
Usual growth indicators used are inflation, population growth, ______ or GDP growth.
Usual growth indicators used are inflation, population growth, ______ or GDP growth.
Signup and view all the answers
EBITDA, net of Taxes is represented as Php ______.
EBITDA, net of Taxes is represented as Php ______.
Signup and view all the answers
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.
Signup and view all the answers
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.
Signup and view all the answers
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.
Signup and view all the answers
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 ______.
Signup and view all the answers
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 ______.
Signup and view all the answers
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 ______.
Signup and view all the answers
Financial modelers may include professionals like economists, financial managers, and ______.
Financial modelers may include professionals like economists, financial managers, and ______.
Signup and view all the answers
When constructing financial models, historical information is often gathered from audited financial ______.
When constructing financial models, historical information is often gathered from audited financial ______.
Signup and view all the answers
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 ______.
Signup and view all the answers
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.
Signup and view all the answers
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.
Signup and view all the answers
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 ______.
Signup and view all the answers
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.
Signup and view all the answers
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.
Signup and view all the answers
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 ______.
Signup and view all the answers
The growth rate formula is similar to that of ______.
The growth rate formula is similar to that of ______.
Signup and view all the answers
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.
Signup and view all the answers
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 ______.
Signup and view all the answers
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.
Signup and view all the answers
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.
