Excel WACC function

tadXL v2.5

104 new financial functions for Excel 2007, 2010 & 2013

Example Frame

Download FREE

Try It | Buy It

104 new financial functions for Excel 2007, 2010 and 2013.

Try It | Buy It

10 new financial functions for Excel 2007, 2010 and 2013.

Try It | Buy It

Find benefit to cost ratio of an investment

Try It | Buy It

Find discounted payback period of an investment

Download FREE

Try It | Buy It

Find equivalent annual annuity of an investment

Try It | Buy It

Find equivalent annual cost of an investment

Try It | Buy It

Find internal rate of return of an investment

Try It | Buy It

Find modified internal rate of return of an investment

Download FREE

Try It | Buy It

Find net future value of an investment

Try It | Buy It

Find net present value of an investment

Try It | Buy It

Find profitability index of an investment

Try It | Buy It

Find simple payback period of an investment

From The Author

Welcome to FTWE 100

FTWE 100 is the financial treasure web index that offers you a host of financial products and services making it possible to analyze investments. The FTWE 100 index allows an analyst to determine the investor's return on investment - ROI using the financial software tools that we offer. FTWE 100 enables financial analysts like you to make informed decisions on investments thus ensuring the profitability of your company or personal gains. The FTWE 100 index is an indicator of sound invesment based upon financial analysis resulting from the use of our software tools. Keep us bookmarked in your web browser as the tools that we offer are not found elsewhere and are one of a kind in financial industry.

Download FTWE 100 free software

As stated earlier the FTWE 100 index is the result of financial calculations that are made possible using the financial software products that we offer for free. All of our software tools may be downloaded for personal and corporate use, however the complete versions of these software products cost a nominal price that allows for more complex options when finding the FTWE 100 index. For more details on downloading and using these software products, follow the read more link to find your return on investment - ROI […]

WACC - weighted average cost of capital

The WACC is an acronym for weighted average cost of capital that a company or entity has to pay to help finance a project. As it says it is an average where the weights are the proportions of debt, equity and preferrence stock. The three components are the cost of debt, cost of equity and cost of preferred stock. Thus a cost of debt is the interest rate that must be returned by the investment to pay for the financing. Anything above the WACC from the investment is to keep as profits by the company. If an investment projects fails to make enough returns to match the WACC then the company would have to pay out of its pockets to the lenders. Here I present you a WACC document as a Word file that will explore the topic of weighted average cost of capital in detail. A WACC formula will be provided along with example calculation of WACC. The document will also highlight the use of Excel WACC formula that may be used as worksheet function to find the weighted average cost of capital.

FREE download tadXL v2.5

You may go ahead and download tadXL v2.5 from the following download card. There are 104 financial functions in this add-in that allow finding return on investment, time value of money calculations, interest rates, and misc.

Item Description Trial Full
32-bit tadXL v2.5 104 financial functions for Excel Download Buy Now

Finding WACC in Excel

Up until Excel 2013, there were no native financial functions in Excel to find the WACC - weighted average cost of capital. In spring of 2012, tadXL add-in for finance was unleashed on the software market that offered its own set of financial functions. tadXL contains over 100 new financial functions that may be used as worksheet functions for Excel 2007, 2010 and 2013. The word spread quickly when the promotion videos for tadXL went viral on YouTube resulting in surge for orders for this unique and feature rich library of financial functions for Excel. The author of tadXL has his own sets of core values that he practices and this was one of the reasons he found himself left out of making big bucks off his crown jewel software product. But competition was in no mood to lose out on a quick large pile of cash and they decided to work their sets of financial functions that would be based on those found in tadXL. It would not surprise me if Microsoft were to introduce a new set of financial functions in upcoming Excel 2015 or 2016 but that would leave the author asking a very simple question. If nothing for financial functions in Excel changed in the last 24 years what brings about the inclusion of new set of financial functions in upcoming Excel. You would think that copy rights are only violated by companies and countries outside the US, but it would seem those who demand enforcement of copy protection against piracy do not give high regards to rights of other copy rights holders whose genuine ideas seem to be left out of the mass market.

Using tadXL functions such as tadWACC_1, tadWACC_2, and tadWACC_3 finding weighted average cost of capital in Excel 2007, 2010 and 2013 becomes really easy. Let us now briefly look at each of these three financial functions in tadXL to find WACC using Excel:

In the first example, CAPM is used for cost of equity.

=tadWACC_1( {PKd, Kd, taxrate, PKe, Rf, ERm, Beta} )
PKd - proportion or weightage of cost of debt
Kd - cost of debt
taxrate
PKd - proportion or weightage of cost of equity
Rf - risk free rate
ERm - expected market rate of return
Beta

In the second example, values for WACC components and their weightage is known.

=tadWACC_2( {PKd, Kd, taxrate, PKcs, Kcs, PKps, Kps} )
PKd - proportion or weightage of cost of debt
Kd - cost of debt
taxrate
PKcs - proportion or weightage of cost of commony stock
Kcs - cost of commony stock
PKps - proportion or weightage of cost of preferred stock
Kps - cost of preferred stock

In the third example, values for WACC components are unknown yet their weightage is known.

=tadWACC_3( {PKd, BT, Vb, C, T, taxrate, PKcs, Vcs, Dcs, G, PKps, Vps, Dps} )
PKd - proportion or weightage of cost of debt
BT - maturity value of debt
Vb - market price of debt
C - coupon rate of debt
T - years to maturity
taxrate
PKcs - proportion or weightage of cost of commony stock
Vcs - market price of common stock
Dcs - dividend paid by common stock
G - expected growth rate
PKps - proportion or weightage of cost of preferred stock
Vcs - market price of preferred stock
Dcs - dividend paid by preferred stock

Download tadXL to find WACC in Excel
(212) 555-1212
postmaster@thinkanddone.com
Monday To Sunday 9AM To 9PM Eastern Time