Metal profit and loss calculator
Work out gross proceeds, net profit and return after buying and selling costs.
Quick answer: Profit = sale proceeds − selling fees − (purchase cost + buying fees + storage). Divide the profit by that total cost to get your percentage return.
Explore the numbers.
Calculate to update this worksheet from your inputs.
Scenario chart
Scenarios change one input while holding the others constant. They are calculations, not observed market prices or forecasts.
Detailed calculation table
The table contains the same inputs used for your result. Values are rounded for display; CSV preserves more precision.
| Calculate to load your worksheet. |
Measure return after the costs you enter
How to use this calculator
- Use one currency and one quantity unit for both purchase and sale prices.
- Enter total buy and sell fees, monthly storage costs and the holding period.
- Optionally apply an illustrative percentage deduction to positive net profit and inspect the break-even sale price.
Two units bought at 2,000 and sold at 2,300, with 50 in buying costs and 30 in selling costs, yield a 520 profit before optional storage and deductions.
Cost basis includes holding costs
The worksheet adds quantity times purchase price, purchase fees and storage costs over the entered number of months. Net sale proceeds subtract selling fees. Profit is the difference between these two amounts; percentage return divides profit by the total cost basis.
Interpret the optional deduction carefully
The percentage deduction applies only to positive profit after the entered costs. Losses receive no assumed refund. It is a scenario input, not a jurisdiction-specific tax calculation. Set it to zero if you do not want to model this deduction.
Read the sale-price scenarios
The chart changes the sale price while holding quantity and all costs fixed. The zero-profit line separates positive and negative arithmetic outcomes. Break-even is the sale price that covers those costs before any percentage deduction on gains. The worksheet reports a total holding-period return, not an annualised return.
Questions about this calculation
Is this a forecast?
No. The entered sale price and sensitivity range are scenarios. Nothing in the calculation predicts future prices.
Are currency movements included?
Only through your input prices. For a cross-currency transaction, first convert each actual cash flow at its applicable exchange rate, including conversion costs.
Continue your calculation.
All calculators →Explore gold prices, silver prices, the historical gold–silver ratio and our data methodology.