{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

Info icon This 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. 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.
Image of page 1

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

View Full Document Right 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 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 = $500.00 ! If negative, go back and choose to normalize earnings. Current Interest Expense = $85.00 Current Capital Spending $250.00 Current Depreciation & Amort'n = $150.00 Tax Rate on Income = 40.00% Previous year-end Current Revenues = $10,000.00 9000 Current Non-cash Working Capital = $750.00 Chg. Working Capital = $40.00 revious year-end Book Value of Debt = $900.00 850 Book Value of Equity = $1,500.00 1350 Cash & Marketable Securities = $125.00 Value of Non-operating Assets = $0.00 Market Data for your firm Is your stock currently traded? No If yes, enter the following: Current Stock Price = $51.90 Number of shares outstanding = 246.10
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern