{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

tatasteel

# tatasteel - FCFF VALUATION MODEL Before you start The...

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

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. 3. If you have R&D or operating leases, you will need to input the required numbers in those worksheets. 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.

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

View Full Document
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 Do you want to capitalize R&D expenses? No ! Yes or No Go to R&D Converter 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 = INR 84,683.00 ! If negative, go back and choose to normalize earnings. Current Interest Expense = INR 11,527.00 Current Capital Spending INR 71,354.00 Current Depreciation & Amort'n = INR 9,734.00 Tax rate (for computing after-tax operating income) = 28.90% Marginal tax rate = 33.99% Previous year-end Current Revenues = ### ### Current Non-cash Working Capital = ### Chg. Working Capital = ### revious year-end Book Value of Debt = ### ### Book Value of Equity = ### ### Cash & Marketable Securities = INR 15,906.00 INR 4,650.00 Value of Non-operating Assets = ### ### 0.14508 Minority Interests (this is a liability) = INR 0.00
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 14

tatasteel - FCFF VALUATION MODEL Before you start The...

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

View Full Document
Ask a homework question - tutors are online