Template Description The Macabacus DCF template implements key concepts and best practices related to DCF modeling. It computes the perpetuity growth rate implied by the terminal multiple method and vice versa, and sensitizes the analysis over a range of assumed terminal multiples and perpetuity growth rates without the use of slow Excel TABLEs. The model computes DCF valuations manually, and uses XNPV formulas to check the calculations. Please enable Javascript to download this file.
Free Discounted Cash Flow (dcf Spreadsheet For Mac Download
20kb created with 109,437 downloads since May 14, 2013 Last modified Sep 23, 2013.
. With time, the number of spreadsheets on this page has also increased.
To help you in finding the spreadsheet that you might want, I have categorized the spreadsheets into the following groups:.: These spreadsheets are most useful if you are interested in conventional corporate financial analysis. It includes spreadsheets to analyze a project's cashflows and viability, a company's risk profile, its optimal capital structure and debt type, andwhether it is paying out what it can afford to in dividends. This spreadsheet calculates the implied risk premium in a market.
This can be used in discounted cashflow valuation to do market neutral valuation. Valuation Model Reconciliation This spreadsheet allows you to reconcile the differences between the FCFE and the dividend discount models for estimating equity value. This spreadsheet allows you to reconcile the differences between the FCFF and the FCFE approaches to valuation. This spreadsheet reconciles a cost of capital DCF valuation with an EVA valuation of the same company This spreadsheet allows you to reconcile the differences between the Gross debt and Net debt approaches to valuation. All-in-one Valuation Models.
Free Discounted Cash Flow (dcf Spreadsheet For Mac Free
A complete dividend discount model that can do stable growth, 2-stage or 3-stage valuation. This is your best choice if you are analyzing financial service firms. A complete FCFE valuation model that allows you to capital R&D and deal with options in the context of a valuation model. A model to value the premium you should pay for growth in either an intrinsic valuation or a relative valuation.
Webcast A complete FCFF model that allows for changing margins and has default assumptions built in (to protect you from inconsistent assumptions). If you want a quick, all-in-one model to value a company with relatively few inputs, try this. This model tries to do it all, with all of the associated risks and rewards. I hate having to work with a dozen spreadsheets to value a firm, and I have tried to put them all into one spreadsheet - a ratings estimator, an earnings normalizer, an R&D converter, an operating lease converter, a bottom-up beta estimator and industry averages. Try it out and make your own additions. This model allows the user to enter a measure of company exposure to country risk (that is different from beta) in a FCFF valuation model.
It does not have many of the bells and whistles of teh fcffginzu model. Loose Ends in Valuation.
This spreadsheet allows you to measure the complexity in a company and give it a score. This spreadsheet allows you to value employee options and incorporate them into value. This spreadsheet allows you to understand why the gross and net debt approaches give you different estimates of value for a firm. Estimates the illiquidity discount that should be applied to a private firm as a function of the firm's size and financial health. Uses both restricted stock approach and bid-ask spread regression.
A generalised FCFF model, where the operating margins are allowed to change each year; best suited for firms in transition. Financial Service firms Estimates the value of equity in a bank by discounting expected excess returns to equity investors over time and adding them to book value of equity. Troubled firms Normalizes the earnings for a troubled firm, uising historical or industry averages. Estimates the likelihood that a troubled firm will not survive, based upon bond ratings as well as bond prices. Generalized FCFF model that allows you to value negative earnings firms as going concerns. Private firms Adjusts the discount rate (cost of equity) for a private firm to reflect the lack of diversification on the part of the owner (or potential buyer) Estimates the discount for a minority stake in a private business, based on the value of control. Estimates the illiquidity discount that should be applied to a private firm as a function of the firm's size and financial health.
Uses both restricted stock approach and bid-ask spread regression. High Growth Firms Estimates compounded revenue growth rate for a firm, based upon market share and market size assumptions.
This spreadsheet can be used to value tough-to-value firms, with negative earnings, high growth in revenues and few comparables. If you have a young or start-up firm, this is your best choice.