Hi, I am in search of a what I think would be a very simple spread sheet to keep track of antiques that are bought and sold. I would need it to consist of:
-Date of purchase
-Description of item
-Cost of item
-Date of sale
-Sold for cost
I would like this to automatically calculate monthly & yearly profit/loss and allow easy addition of newly purchased items. I have never used excel before so I am not sure how to go about this but I can not seem to find a template like this anywhere. Any help or guidance is greatly appreciated.
-Date of purchase
-Description of item
-Cost of item
-Date of sale
-Sold for cost
I would like this to automatically calculate monthly & yearly profit/loss and allow easy addition of newly purchased items. I have never used excel before so I am not sure how to go about this but I can not seem to find a template like this anywhere. Any help or guidance is greatly appreciated.