110 likes | 270 Views
Valuation. FIN 449 Michael Dimond. Damodaran has resources online. http://pages.stern.nyu.edu/~adamodar/ His spreadsheets are not always as helpful as you might want… An example of a valuation summary he did in 2008. What Damodaran’s valuation summary looks like: September 2008.
E N D
Valuation FIN 449Michael Dimond
Damodaran has resources online • http://pages.stern.nyu.edu/~adamodar/ • His spreadsheets are not always as helpful as you might want… • An example of a valuation summary he did in 2008
What Damodaran’s valuation summary looks like: September 2008
Bear in mind, these were a summary. We will ultimately want something more detailed for a working document.
What does the DCF Model look like? • What drives the figures? • How sensitive are they to basic inputs?
To start, compute historic FCFF & FCFE for the past 5 years FCFF = NI + Int(1-t) + Depr - ΔFA - ΔNWC FCFE = NI + Depr - ΔFA - ΔNWC + ΔDebt - PfdDiv FCFF = FCFE + Int(1-t) - ΔDebt + PfdDiv FCFE = FCFF - Int(1-t) + ΔDebt - PfdDiv • How accurate would it be to extrapolate the future cash flows from the past FCFE figures? • In other words, can we simply assume FCFE will grow X% forever? • Here are the historic FCFE for a company: • Instead, we project the drivers of these figures for the future. • Compute FCFF & FCFE based on the forecast figures
Relationships in financials drives FCFF & FCFE We will start with financial statements and forecast expected reportings, then adjust to find expected future cash flows
Relationships in financials drives FCFF & FCFE We will start with financial statements and forecast expected reportings, then adjust to find expected future cash flows
We need to assess sensitivity to assumptions • What drives the figures? • How sensitive are they to basic inputs?
Coming up Exam (Thurs 1/16) Financial Statement & Cash Flow exercise (Tues 1/21) Template will be posted on the course webpage Have I/S, B/S & SoCF done, we will compute cash flows in class Begin valuation #1 (Thurs 1/28)