VWAP is calculated using the following formula. The weighted average cost per unit is therefore 25778 116000 450 units The ending inventory valuation is 45112 175 units 25778 weighted average cost while the cost of goods sold valuation is 70890 275 units 25778 weighted average cost. The average price paid.
To calculated a weighted average you can use the SUMPRODUCT function together with the SUM function.
SUMPRODUCT weights C5E5 SUM weights where weights is the named range I5K5. List the various prices at which you bought the stock along with the number of shares you acquired in each transaction. The formula below calculates the weighted average of these scores. The average price paid.