In the "1st Buy at" field, enter the price at which you made the first purchase.
In the "Quantity" field next to the "1st Buy at" price, enter the quantity you purchased at the first price.
In the "2nd Buy at" field, enter the price at which you made the second purchase.
In the "Quantity" field next to the "2nd Buy at" price, enter the quantity you purchased at the second price.
If you want to clear all the entered values, click the reset button (with the reset icon). This will remove the data you’ve entered in both price and quantity fields.
Once you’ve entered both the prices and quantities, click the "Calculate" button to determine the average price based on the data you provided.
This will help you calculate the average price for your purchases.
The formula used to calculate the average price is based on the weighted average cost method. The formula is:
Average Price = (Price1 * Quantity1 + Price2 * Quantity2) / (Quantity1 + Quantity2)
This formula calculates the total cost of the two purchases by multiplying each price by its respective quantity, then dividing the sum of those values by the total quantity. This gives you the average price of the combined purchases.
Example:
Suppose you bought the following:
Using the formula:
Average Price = (100 * 5 + 120 * 3) / (5 + 3)
Now, calculate:
Therefore, the Average Price = 860 / 8 = $107.50.