Average price paid
An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Stock was bought in four lots at different prices. Work out the average price paid per unit in C6, weighting each price by the units bought at that price.
What this exercise teaches
AVERAGE(C2:C5) treats a lot of 80 units the same as a lot of 500. A weighted average multiplies each price by its units first, then divides by the total units.
A hint if you get stuck
Total cost divided by total units. SUMPRODUCT(B2:B5,C2:C5) is the total cost.
Try it now, free, no account needed
Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.
Open this exerciseMore exercises in Finance
- Loan installment
- Is the project worth it?
- Growth over time
- Portfolio return
- Internal rate of return
- Value of an annuity
- Total interest on a loan
- Compound annual growth
- Break-even units
- Straight-line depreciation
- Monthly deposit for a goal
- Effective annual rate
- Months to clear a balance
- The rate behind a financing offer
- Interest and principal in one payment
- NPV on irregular dates