Now, my problem is, I would like to extend this code to also calculate the mean in row 27 and the standard deviation in row 28, for both 2013 and 2014 (i.e. columns C and D respectively).I'm not really sure how to do this-can you please help me solve this problem?ow, my problem is, I would like to extend this code to also calculate the mean in row 27 and the standard deviation in row 28, for both 2013 and 2014 (i.e. columns C and D respectively).
The weighted average cost of capital (WACC) is the rate that a company is expected to pay on average to all its security holders to finance its assets. The WACC is commonly referred to as the firmâs cost of capital. Importantly, it is not dictated by management.
Weighted Average Cost of Capital. Weighted average cost of capital (WACC) is the average of the minimum after-tax required rate of return which a company must earn for all of its security holders (i.e. common stock-holders, preferred stock-holders and debt-holders).e can also estimate it using MS Excel RATE function. For inclusion in WACC, we need after-tax cost of debt, which is 7.427% [= 10.61% Ã (1 â 30%)]. Having all the necessary inputs, we can plug the values in the WACC formula to get an estimate of 9.82%.