Archive for December, 2009

Precious metals ETFs, update

Monday, December 7th, 2009

A little over a month ago I put up a short post on how gains in a precious metal ETF might be taxed at the collectible rate of 28% instead of the normal long term capital gain rate of 15%. I said I would dig around to see if I could find more on it.

The IRS Office of Chief Counsel issued a memorandum in May 2008 stating that, generally speaking, metals-based ETFs are treated as if the shareholder held the metal itself. In other words, the 28% tax applies.

Something to keep in mind if you are considering taking profits on those GLD shares that have shot up and (recently) down.

Excel timesheet

Thursday, December 3rd, 2009

I put together a simple Excel timesheet that does a pretty good job of keeping track of tasks while working on the computer. It acts as a timer by allowing you to enter start and stop times.

timesheet

 

For date, keyboard shortcut is Ctl + ; (semicolon key)

For time, keyboard shortcut is Ctl + Shift + : (colon key)

When I start a task, I enter date, client, and then go over to the start cell and enter the time shortcut above. Then I tab over to the stop cell. When I stop, I enter the time shortcut again. If more than a minute has passed, the elapsed time will read in tenths of hours.

The time is automatically totalled. If you want to add rows, remember to copy the entire row above into the new rows to preserve the formulas.

Click to download