tcs - FCFF VALUATION MODEL Before you start The spreadsheet...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
FCFF VALUATION MODEL Before you start The spreadsheet has circular reasoning. This is not a problem. Go into calculation options (in excel) and check the iteration box. What the model d This model is designed to value firms with operating income that is either positive or can be normalized to be positive. It allows for up to 15 years of high growth, and can be used either as a 2-stage or a 3-stage model. Inputs The inputs are in the following pages: financial statements, and review and change the inputs for the valuation. Important: Be consistent about the units you use. If you use millions, use millions for all of your inputs. Options The spreadsheet can be used to value a company, with fixed inputs for a high growth phase and different inputs for a stable growth phase (2-stage model) or it can be adjusted to allow for a transition phase (3-stage model). To switch from one to the other, enter yes in the master input page to the question of whether you want the inputs adjusted during the second half of the high growth phase. You can even make it a stable growth model, by setting the length of the high growth period to zero. Other worksheets There are two other worksheets that you might find useful at the end of this spreadsheet 1. Bottom-up beta estimator: will estimate your levered beta, given an unlevered beta (which you will have to input. 2. Industry averages: Here, you can look up industry averages for variables such as beta, return on capital, reinvestment rates and working capital. Output The output is contained in the valuation model worksheet. 1. The bulk of the inputs are in the master inputs page . Here, you can input the numbers from the current 2. If you want to normalized operating income, use the earnings normalizer worksheet.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
An apology: I apologize for the number of inputs that are required on this sheet. Many of the inputs are required only if you choose the appropriate option, though. If you have negative operating income, you will either have to normalize it to make it positive, or use the highgrowth.xls spreadsheet. Master Input Sheet No ! Yes or No Do you want to convert operating leases to debt? No ! Yes or No Go to Operating lease converter Do you want to normalize operating income? No Go to Earnings Normalizer Inputs From Current Financials Current EBIT = ### ! If negative, go back and choose to normalize earnings. Current Interest Expense = INR 74.00 Current Capital Spending INR 9,786.00 INR 4,175.00 Tax rate (for computing after-tax operating income) = 15.55% Marginal tax rate = 33.99% Previous year-end Current Revenues = ### ### Current Non-cash Working Capital = ### Chg. Working Capital = INR 6,130.00Previous year-end Book Value of Debt = INR 403.70 INR 182.50 Book Value of Equity =
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 14

tcs - FCFF VALUATION MODEL Before you start The spreadsheet...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online