Company: RedSeer Consulting
About RedSeer Consulting (www.redseerconsulting.com) RedSeer Consulting, a management consulting firm, has been founded with focus on providing enduring results to organizations in emerging markets. We work alongsid
Timestamp,Name,Colgate Tooth Paste is my first preference,"I will not buy other brands, if Colgate Toothpaste is available at 3/14/2010 17:26:00,1,1,1,2,2,1,1,1,2,5,2,2,2,2,2,2,2,2,2,1,1,1,1,5,4,5,5,2,2,2,1,2,2,4,1,1,1,1,2,1,2,1,1,1,1,1,1,5 3/14/20
VALUING SYNERGY: WORKSHEET
SYNERGY VALUATION WORKSHEET
Enter the following information on the bidding firm Current Financial Information Revenues in current year = COGS as % of Revenues = Tax Rate on income = Interest Expenses = Current Depreciation =
FCFF Stable Model
FCFF STABLE GROWTH MODEL
This model is designed to value a stable firm on the basis of free cashflows to firm.
Assumptions in the model: 1. The firm is in steady state and will grow at a stable rate forever. 2. The firm's leverage is kno
Inputs for synthetic rating estimation
Enter the type of firm = 1 (Enter 1 if large manufacturing firm, 2 if smaller or riskier firm, 3 if financial service firm) Enter current Earnings before interest and taxes (EBIT) = 10000 (Add back only long t
Timestamp,Name,Colgate Tooth Paste is my first preference,"I will not buy other brands, if Colgate Toothpaste is available at 3/14/2010 17:26:00,1,1,1,2,2,1,1,1,2,5,2,2,2,2,2,2,2,2,2,1,1,1,1,5,4,5,5,2,2,2,1,2,2,4,1,1,1,1,2,1,2,1,1,1,1,1,1,5,3 3/14/
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
A B C D INFLATION AND THE REAL RATE OF INTEREST Interest rate Inflation rate Real interest rate EXAMPLE Cash today Plus interest Cash next year Price today Plus inflation Price next year 100.00 12.00 112.00 106
CHOOSING THE RIGHT VALUATION MODEL
This program is designed to help in choosing the right model to use for any occassion.
Inputs to the model Level of Earnings Are your earnings positive ? Yes (in currency) (Yes or No)
Two-Stage FCFE Discount Model
This model is designed to value the equity in a firm, with two stages of growth, an initial period of higher growth and a subsequent period of stable growth.
Assumptions 1. The firm is expected to gr
The Free Cash Flow Business Valuation Model
Instructions: Change any of the forecasting variables shown in red below and observe the effect on the model's outputs in the section below. To what variable is the business value conclusion most sensitive? To w
ESTIMATING THE WEIGHTED AVERAGE COST OF CAPITAL
Input cells are in yellow. Comparable Companies Firm 1 DATA Amount of equity Amount of debt Tax rate Equity beta 1+ (1-T)D/E Unlevered equity beta Project or Acquisition DATA % Debt % Equity Tax rate 1+ (1-T
FCFE Stable Model
FCFE STABLE GROWTH MODEL
This model is designed to value the equity in a stable firm on the basis of free cashflows to equity, especially when they are different from dividends paid.
Assumptions in the model: 1. The firm is in steady sta
INPUT SHEET: MERGER & LBO VALUATION
STEP 1: Estimate the total cost of the deal Price per share= # shares outstanding (mil)= Total cost of the deal= 201 21.9 6201.9 Debt outstanding currently (mil)= Other costs (Investmen
Cash Gap Days Worksheet
Annual Sales Gross Margin
Place Mouse here for instructions
Annual $25,000,000 11% $22,250,000
Cost of goods(Material, labor, subcontractors)
Month Ending Balance Inventory Cost in Excess Accounts Receivable B
IM&C GUANO PROJECT The following worksheet contains the same information as Tables 6-2 through 6-7 in Brealey-Myers. You can use this worksheet as a template for most capital budgeting problems. Cost of capital Year Depreciation (for taxes) Net working ca
THREE-STAGE FCFE DISCOUNT MODEL
This model is designed to value the equity in a firm with three stages of growth - an initial period of high growth, a transition period of declining growth and a final period of stable growth.
This is a free resource from StrategyExpert.com which contains lots more useful tools, templates and resources Not to be sold or published. Ratio Tree for Company X
Item Profit bf. Int & tax Total capital Turnover Current assets Current
Two-Stage FCFF Discount Model
This model is designed to value a firm, with two stages of growth, an initial period of higher growth and a subsequent period of stable growth.
Does your company provide goods (1) or services (2) Sales by Year Gross Profit Percentage Fixed Expenses by Year (excluding interest expense) Cost of Money Tax Rate Investment in Fixed Assets Average Fixed Ass
NPV AND IRR RULES
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
A B C NPV RULE FOR CAPITAL BUDGETING
Choose a project if it costs less than the PV of its cash flows. More generally: take a project if its Net Present Value is positive.
GENERAL Definition: A cash flow projection is a forecast of cash funds a business anticipates receiving and paying out throughout the course of a given span of time, and the anticipated cash position at specific times during the period being pr
Sheet1 This spreadsheet analyzes the lease/purchase decision. In the case of a purchase, it is assumed sales tax is paid on the negotiated price at the time of purchase, and property taxes are paid annually. In the case of a lease, it is assumed sales tax
Sales 1000 Contribution 600 EBIT 200 Operating Profit 120 Profit Margin 12.0% RONA 15.0% Operating Profit 120 EVA 42.24 Cost of Capital 77.76 x WACC 9.7% x Net Assets 800 x Total Net Asset Turnover 1.25 : Sales 1000 Assets : Net Assets 800 Interest Free L