518 views
ABOUT THIS CONTENT
This spreadsheet shows how to estimate the enterprise value of a company by discounting free cash flow. One of the issues is to how to compute a terminal value at the end of the explicit forecast period. One approach is to assume a constant growth rate for cash flows after the explicit forecast period. The growth rate is driven by the Return on Incremental Investment and the Plowback Rate. The per-share value of the firm is computed from the enterprise value by adding marketable securities, subtracting debt, and dividing by the number of shares outstanding.Subjects: Finance, Spreadsheets
Source: Professor Kerry Back (Washington University in St. Louis) (visit original source)
Source: Professor Kerry Back (Washington University in St. Louis) (visit original source)