NOTE: I need these 4 questions answered in EXCEL with formulas used if applicable(this means do not just type the answer in).

1. Fifteen years ago, Mr.F paid $50,000 for a single premium annuity contract. This year he began receiving a $1,300 monthly payment that will continue for his life. on the basis of his age, he can expect to receive $312,000. How much of each monthly payment is taxable income to Mr. F?

2. In 2013 Mr. Dale paid 47,600 for 3,400 shares of GKL mutual fund and elected to reinvest dividends in additional shares. in 2013 and 2014 he received form 1099's reporting the following:

2013: dividends reinvested $4,920, shares purchased 312, price per share $15.769, total shares owned 3712

2014: dividends reinvested 5,873, shares purchased 340, price per share $17.274, total shares owned 4052

A. If Mr. Dale sells his 4052 shares for $18 a share, compute his recognized gain

B. If he sells only 800 shares for $18 a share and uses the FIFO method to determine basis, compute his recognized gain.

C. If he sells only 800 shares for $18 a share and uses the average basis method, compute his recognized gain

3. In 2000 Ms. Ennis, a head of household, contributed $50,000 in exchange for 500 shares of Sets stock. Seta is a qualified small business. This year Ms. Ennis sold all 500 shares for $117,400. Her only other investment income was was an $8,600 long term capital gain from the sale of land. Her taxable income before consideration of her two capital transactions is $590,000.

A. Compute Ms. Ennis' income tax and medicare contribution tax for the year.

B. How would the computation change if Ms. Ennis had acquired the Seta stock in 2012 instead of 2000.

4. In 2004 Mr. EF, a single taxpayer, contributed $45,000 in exchange for 500 shares of DB stock. In 2007, he paid $40,000 to another shareholder to purchase 1,000 more DB shares. All DB's stock qualified as section 1244 stock when it was issued. This year Mr. EF sold all 1,500 DB shares for $16 per share. His only income item was his $80,000 salary.

A. Compute Mr. EF's AGI

B. How would AGI change if if he recognized a $20,000 capital gain on the sale of other securities?