If you have a column list of data and you want to split them into several columns by a specific delimiter just like the below screenshots shown, how can you split them in Excel? Maybe some of users think of the Text to Column function only, but now I will introduce not only Text to Columns function, but also a VBA code for you.
When using the weighted average method, divide the cost of goods available for sale by the number of units available for sale, which yields the weighted-average cost per unit. In this calculation, the cost of goods available for sale is the sum of beginning inventory and net purchases.he total of all purchased or beginning inventory units is 450 (150 beginning inventory + 300 purchased). The weighted average cost per unit is therefore $257.78 ($116,000 Ã· 450 units.).
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