I need the two tabs filed out for the template provided. Please enter any formulas along with the assignment. Please ask questions if there are any problems.

Module 5 Problem-Solution Assignment: Problem 1 On January 1, 2010 Boxer Company had 110,000 share of common stock which was outstanding. During 2010 the following transactions took place: April 1- Repurchased 2000 shares which was accounted for as Treasury Stock August 30-Sold all the treasury shares December 1-Sold 10,000 shares for cash December 31-Reported Net Income in the amount of $200,000 Paid preferred dividends of 20,000 These transactions occurred in 2011: January 15: Declared and then issued at 20% stock dividend December 31: Boxer Company reported net income in the amount of $238,500 Requirements: 1 Calculate Boxer Company's EPS for a simple capital structure for the both years to be presented in comparative financial statements. Since these are to be comparative statements the stock dividend declared and preferred dividend will be applied to both years. The financial statements will then be prepared at the end of 2011. Problem 2 Carmen Company reported 557.5 million in net income in 2010. Then on January 1, 2010 the company had 600 million shares of common stock outstanding. On April 1, 2010 34 million shares of common stock were sold for cash. On June 1, 2010 Carmen Company's stock split 2 for 1. On July 2010 9 million shares were reacquired as treasury stock. Requirements: 2 Take the information in Problem 2 and compute Carmen Company's Earnings per Share for the year ended December 31, 2010. Problem 1 On January 1, 2010 Boxer Company had 110,000 share of common stock which was outstanding. During 2010 the following transactions took place: April 1- Repurchased 2000 shares which was accounted for as Treasury Stock August 30-Sold all the treasury shares December 1-Sold 10,000 shares for cash December 31-Reported Net Income in the amount of $200,000 Paid preferred dividends of 20,000 These transactions occurred in 2011: January 15: Declared and then issued at 20% stock dividend December 31: Boxer Company reported net income in the amount of $238,500 Requirements: 1 Calculate Boxer Company's Basic EPS for a simple capital structure for the both years that are to be presented in comparative financial statements. The preferred dividends will be applied to both years calculation of earnings per share. Be mindful that stock dividends need to be restated as if it happened at the beginning of the year. You will need to computer the Weighted Average Shares to solve for this problem 2010 Weighted-Average Number of Shares Outstanding Date 1-Jan 1-Apr 30-Aug 1-Dec 31-Dec 2010 Shares Outstanding, Ending Balance Share Changes Shares Outstanding Beginning Balance XXXX Repurchased 2000 shares Treasury Stock XXXX XXXX Sold all treasury shares XXXX XXXX Sold 10,000 shares for cash XXXX Ending balance XXXX Dates Outstanding Jan 1 - Apr 1 Apr 1 - Aug 30 Aug 30 - Dec 1 Dec 1 - Dec 31 Shares Outstanding XXXX XXXX XXXX XXXX Fraction of Year XXXX XXXX XXXX XXXX Weighted-average number of shares outstanding Weighted Shares XXXX XXXX XXXX XXXX XXXX EPS at end of 2010: XXXX 2011 Weighted-Average Number of Shares Outstanding 2011 Shares Outstanding, Ending Balance Date Share Changes Shares Outstanding 1-Jan Beginning Balance XXXX 15-Jan (20% stock dividend) XXXX 31-Dec Ending Balance XXXX EPS For 2011: XXXX Dates Shares Fraction of Weighted Outstanding Outstanding Restatement Year Shares Jan 1 - Jan 15 XXXX XX XX XXXX Jan 15 - Dec 31 XXXX XX XX XXXX Weighted-average number of shares outstanding: XXXX Problem 2 Carmen Company reported 557.5 million in net income in 2010. Then on January 1, 2010 the company had 600 million shares of common stock outstanding. On April 1, 2010 34 million shares of common stock were sold for cash. On June 1, 2010 Carmen Company's stock split 2 for 1. On July 2010, 9 million shares were reacquired as treasury stock. Be mindful that you need to restate the stock split as if it happened at the beginning of the year. You will need compute the Weighted Average Shares Outstanding to solve for the Basic EPS. Requirements: 2 Take the information in Problem 2 and compute Carmen Company's Earnings per Share for the year ended December 31, 2010. 2010 Shares Outstanding, Ending Balance Date 1-Jan 1-Apr Share Changes Beginning Balance Issues 34,000,000 shares for cash 1-Jun 2-for-1 stock split 1-Jul 31-Dec Purchased 9,000,000 treasury shares Ending balance Shares Outstanding XXXX XXXX XXXX XXXX XXXX XXXX XXXX Earnings per share for the year ended December 31, 2010: XXXX 2010 Weighted-Average Number of Shares Outstanding Dates Outstanding Jan 1 - Apr 1 Apr 1 - Jun 1 Jun 1 - July 1 July 1 - Dec 31 Shares Outstanding XXXX XXXX XXXX XXXX Restatement XX XX XX XX Weighted-average number of shares outstanding: Fraction of Year XX XX XX XX Weighted Shares XXXX XXXX XXXX XXXX XXXX