• The above Banner is a Sponsored Banner.

    Upgrade to Premium Membership to remove this Banner & All Google Ads. For full list of Premium Member benefits Click HERE.

  • Join The Silver Forum

    The Silver Forum is one of the largest and best loved silver and gold precious metals forums in the world. Join today for FREE! Browse the sponsors topics (hidden to guests) for deals and offers, check out the bargains in the members trade section and join in with our community reacting and commenting on topic posts. If you have any questions whatsoever about precious metals collecting and investing please join and start a topic and we will be here to help with our knowledge :) happy stacking. 

D4N

Help calculating spot %

Recommended Posts

Hi, please can someone assist me in my math!

I am trying to calculate how much I have paid above/below spot as a financial value and as a percentage.

I think all my math is correct to this point but not sure how to get the percentages! And could do with someone having a quick check over what I have done.

I have attached a screen shot of my spreadsheet so far.

Thank you in advance!

 

Screen Shot 2017-09-30 at 23.09.57.png

Edited by D4N
Updated image

Share this post


Link to post
Share on other sites

Calculate the price per ounce you paid.

Subtract spot price per ounce from that. That gives you what you've paid above or below spot.

Divide the answer by Spot price per ounce and then multiply by 100 will give you the percentage over/under spot.

I think...lol

 

Share this post


Link to post
Share on other sites

Thanks :) so I have done this....

Price per oz 891.80

Spot price 954.89 - Price per oz 891.80 = -63.09

-63.09/954.89*100= -6.61

Does this then mean I have paid about 6.6% under spot?

Share this post


Link to post
Share on other sites

Just to clarify for anyone else wondering, I believe the above is correct, but also, to calculate into this the postage you would need to account for repeated postage costs to make 1oz for example I paid 6.65 postage for 1/20 oz coin, so for 1oz 6.65 x 20 + price per oz and so on as detailed above. I know I am not guaranteed to pay same postage on a future purchase but was interested to know how this cost impacted the %.

Share this post


Link to post
Share on other sites
51 minutes ago, D4N said:

Thanks :) so I have done this....

Price per oz 891.80

Spot price 954.89 - Price per oz 891.80 = -63.09

-63.09/954.89*100= -6.61

Does this then mean I have paid about 6.6% under spot?

You paid £891.80/oz

Quoted spot price £954.89/oz

So you paid £63.09 under spot

You got a discount of 63.09.

As a percentage of spot price the discount = {discount/spot} x 100 = {63.09/954.89} X 100 = 6.6%

If you want to factor in postage. 

{Price Paid + Postage} x 20 = Equivalent price with postage per ounce

{£44.59 + £6.65} x 20 = £1024.80

The premium is  £69.91 over spot 

As a percentage of spot price the premium = {premium/spot} x 100 = {-69.91/954.89} X 100 = -7.3%

So with the postage you paid 7.3% over spot price when scaled up to a full ounce. Since 1/20oz coins trade at a premium to spot depending on the actual coin you probably still came out ahead. 

 

Edited by sixgun

Share this post


Link to post
Share on other sites
9 hours ago, sixgun said:

You paid £891.80/oz

Quoted spot price £954.89/oz

So you paid £63.09 under spot

You got a discount of 63.09.

As a percentage of spot price the discount = {discount/spot} x 100 = {63.09/954.89} X 100 = 6.6%

If you want to factor in postage. 

{Price Paid + Postage} x 20 = Equivalent price with postage per ounce

{£44.59 + £6.65} x 20 = £1024.80

The premium is  £69.91 over spot 

As a percentage of spot price the premium = {premium/spot} x 100 = {-69.91/954.89} X 100 = -7.3%

So with the postage you paid 7.3% over spot price when scaled up to a full ounce. Since 1/20oz coins trade at a premium to spot depending on the actual coin you probably still came out ahead. 

 

Thank you very much for clarifying this :) And yes I think I did do well considering it's 1/20... I bought a 2000 kangaroo, which I saw goldsiver.be were asking nearly €130 for.

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now