Discounted Cash Flow Model Tour
Premium Features
-
Input historic financials and key forecast drivers to estimate unlevered free cash flow. The premium model includes a detailed working capital schedule to enable more accurate forecasting.
-
The Premium DCF model includes toggles to estimate partial year cash flows and the mid-point convention to align the timing of cash flows with discount periods.
-
The Premium Discounted Cash Flow model includes both perpetuity growth rate and terminal EBITDA multiple methods for calculating terminal value.
-
Upon checkout, we will provide an instantly downloadable MS Excel file with detailed instructions on how to use the DCF Model.
-
The DCF Model comes with a 7 day satisfaction guarantee.
FAQs
-
The DCF Model Template was designed for private companies, including those in the consumer discretionary, consumer staples, industrial, information technology, communication services, and certain healthcare and energy industry segments.
It’s not recommended for publicly traded companies, banks, insurance companies, biotech or real estate companies or companies in industries that use industry-specific metrics.
If you’d like help in those sectors, please contact us for a bespoke solution.
-
The Premium DCF Model Template (the “Model”) is an annual financial model that includes 3 years of historic actual financials and 5 years of projected financials.
The Premium model includes detailed cash flow drivers, a separate working capital schedule, a weighted average cost of capital (WACC) calculator, and detailed scenario analyses.
-
You do not need advanced MS Excel or financial modeling skills to use the DCF Model. Upon checkout, we will provide an instantly downloadable MS Excel file with detailed instructions. With basic knowledge of MS Excel you will be able to incorporate your historic financial performance into the DCF model and use the existing model drivers to create a forecast.
If you would like more hands-on support, please contact us. We’re glad to offer financial consulting services to compliment your efforts.
-
No. The model only supports a single currency. If you need additional currencies, please contact us for a custom solution.
-
Yes! Please contact us to discuss a customized solution to meet your goals. We are have deep modeling and valuation experience.