The Cost of Equity and WACC Calculator for Excel is a simple spreadsheet that
accepts several pieces of information about the business you are analyzing and
calculates its cost of equity and weighted-average cost of capital (WACC). Why
scour through costly textbooks for difficult-to-understand formulas when you can
just plug in a few pieces of information about the business and calculate the
cost of equity and WACC in seconds?
The Cost of Equity and WACC Calculator for Excel includes step-by-step
instructions for entering the necessary data from the company you are analyzing
and includes links to data sources for market information.
The spreadsheet is also flexible, allowing the practitioner to vary the outcome
of the calculation by changing his view on the expected return of the overall
stock market.
The Cost of Equity and WACC Calculator for Excel is a simple spreadsheet
designed to quickly calculate a company's cost of equity and weighted-average
cost of capital from publicly-available information.
This spreadsheet was developed by a CFA charterholder.
- Save time by using a pre-designed template as a basis for your analysis.
- Reduce formula errors caused when practitioners try to
manually calculate cost of equity and WACC. The calculations are already done for you. Simply enter the publicly-available information highlighted by the model, tweak it to match your expectations on the direction of the overall market, and view the completed valuation.
- Save money by spending your time on running your business or analyzing the results of the valuation rather than
scouring through costly textbooks for complicated formulas.
- The model is easy-to-use and flexible. Cells
requiring input are clearly highlighted within the model and are easily
populated with publicly-available information specific to the company you are
analyzing.
- The model was developed by a financial professional (CFA charterholder).
| Click the thumbnail below for a partial
screenshot of the Cost of Equity and WACC Calculator for Excel. |
WACC Calculation |
The Cost of Equity and WACC Calculator for Excel runs on any version of Excel from 97-2010.
It is fully compatible with Microsoft Windows 7, Windows Vista and Windows XP.
This product is also compatible with Excel 2004, Excel 2008 and Excel 2011 for Mac running
on Mac OSX Snow Leopard, Leopard or Tiger.
