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 The weighted average cost of capital (WACC) is a common topic in the financial management examination. This rate, also called the discount rate, is used in evaluating whether a project is feasible or not in the net present value (NPV) analysis, or in assessing the value of an asset. Previous examinations have revealed that many students fail to understand how to calculate or understand WACC. WACC is calculated as follows: WACC = E/V x Re + D/V x Rd x (1-tax rate) WACC is the proportional average of each category of capital inside a firm â common shares, preferred shares, bonds and any other long-term debt â where: Re = cost of equity Rd = cost of debt E = market value of the firmâs equity D = market value of the firmâs debt V = E + D = firm value E/V = percentage of financing that is equity