On January 1, 2010, Magilla Inc. granted stock options to officers and key employees for the purchase of 20,000 shares of the company's $10 par common stock at $25 per share. The options were exercisable within a 5-year period beginning January 1, 2012, by grantees still in the the employ of the company, and expiring December 31, 2016. The service period for this award is 2 years. Assume that the fair value option-pricing model determines total compensation expense to be $400,000.
On April 1, 2011, 3,000 options were terminated when the employees resigned from the company. The market value of the common stock was $35 per share on this date.
On March 31, 2012, 12,000 options were exercised when the market value of the common stock was $40 per share.
Prepare journal entries to record issuance of the stock options, termination of the stock options, excercise of the stock options, and charges to compensation expense, for the years ended in December 31, 2010, 2011, and 2012.
Please use Excel and show all work.