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.
IRR is mostly used in capital budgeting, and it makes up the Net Present Value (NPV) using all the cash flows from a particular project and making them zero. In simple words, it is the rate of growth that a particular project is expected to make. On the other hand, WACC is the expected future cost of a fund. WACC WACC is the Weighted Average Cost of Capital. 2  Compare to the usual cost of capital, WACC is a tad bit difficult and complicated. 3  You are supposed to calculate the average future costs of all the funds in your company, whether they have been generated from within the organisation or with the help of debts.