Coin Community Family of Web Sites Join Thousands of Coin, Bullion, & Money Collectors
300,000 items to help build your collection! Join Thousands of Coin, Bullion, & Money Collectors Royal Canadian Mint products, Canadian, Polish, American, and world coins and banknotes. Specializing in Modern Numismatics Coin, Banknote and Medal Collectors's Online Mall Vancouvers #1 Coin and Paper Money Dealer Royal Estate Auctions - $1 Coin Auctions








Username:
Password:
Save Password
Forgot your Password?


This page may contain links that result in small commissions to keep this free site up and running.

Welcome Guest! Registering and/or logging in will remove the anchor (bottom) ads. It's Free!

Do You Keep Detailed Prices Of Each Pm Purchase?

To participate in the forum you must log in or register.
Author Previous TopicReplies: 19 / Views: 2,383Next Topic
Page: of 2
Rest in Peace
biggfredd's Avatar
United States
9104 Posts
 Posted 09/15/2011  08:17 am  Show Profile   Bookmark this reply Add biggfredd to your friends list Get a Link to this Reply

Quote:
if I buy a 1 oz bar at $20 and sell at $30, that means I raked in 50% in profit. But if I then buy again at a later date for $40, even when I can sell for higher than $40, before I sell again my books will say I've only broke even with that first $30 sale.


Don't understand your example. You made a 50% ($10) profit. Your book is now clear, and $40 is a new starting point. This is how brokers figure their biz. It doesn't matter that they are now paying more than they sold for as long as they make money on the new one. The $10 profit is on the books, and stays there regardless of what they have/get for the new one.

Four systems, pick one and be consistent:

LIFO: Last in first out. Popularized by Scrooge McDuck. fill your money bin, add and subtract from the top. Reflects cost best in a rising market, likewise tends to show lower profits.

FIFO: First in, first out. Like a vending machine, you add at the top, sell the older stuff on the bottom. Shows higher profits in a rising market.

Cost: Often used by dealers, those funny letters on their holders. MDIV means they paid $2375 or whatever.

Average: You need to know your cost per and quantity. When you add more, you add the new cost to the old total cost, and divide it by the new total quantity.
Rest in Peace
biggfredd's Avatar
United States
9104 Posts
 Posted 09/15/2011  08:46 am  Show Profile   Bookmark this reply Add biggfredd to your friends list Get a Link to this Reply

Quote:
Of course - otherwise how else does one know how much capital gains is payable on any profit one has made


Keep in mind that CG only applies if you held it for a certain time, and not at all for dealers.

If a dealer sells something he bought five years ago, it's the same as if he bought it yesterday.
Rest in Peace
biggfredd's Avatar
United States
9104 Posts
 Posted 09/15/2011  09:02 am  Show Profile   Bookmark this reply Add biggfredd to your friends list Get a Link to this Reply

Quote:
I have a little word document saved...somewhere


Right-click on start > find > an odd word or number that would only be in that document (or better yet, a term in the title if you remember) and let your computer's fingers do the walking.
Edited by biggfredd
09/15/2011 8:28 pm
Pillar of the Community
poboxw's Avatar
Canada
1502 Posts
 Posted 09/15/2011  11:54 am  Show Profile   Bookmark this reply Add poboxw to your friends list Get a Link to this Reply
The only way I know how to set up the excel sheet is to do the averaging system, which works alright for some but grossly underestimates profit for other more frequent repurchase and sales items. Still haven't figured out a way to do LIFO or FIFO within excel without separately naming each purchase of the same item.
  Previous TopicReplies: 19 / Views: 2,383Next Topic
Page: of 2

To participate in the forum you must log in or register.



    




Disclaimer: While a tremendous amount of effort goes into ensuring the accuracy of the information contained in this site, Coin Community assumes no liability for errors. Copyright 2005 - 2026 Coin Community Family- all rights reserved worldwide. Use of any images or content on this website without prior written permission of Coin Community or the original lender is strictly prohibited.
Contact Us  |  Advertise Here  |  Privacy Policy / Terms of Use

Coin Community Forum © 2005 - 2026 Coin Community Forums
It took 0.24 seconds to rattle this change. Forums