Accounting -In 2013, Ginger Graham, age 46 and wife of Greg Graham

January 31, 2017

Question
I need the solution to this Tax Question and a excel spreadsheet showing calculation:

In 2013, Ginger Graham, age 46 and wife of Greg Graham, engaged in the transactions
described below. Determine Ginger’s gift tax liability for 2013 if she and Greg elect gift
splitting and Greg gave their son Stevie stock valued at \$80,000 during 2013. Ginger’s
grandmother Mamie died November 12, 2010, and Mamie’s will bequeathed \$250,000
to Ginger. On March 4, 2013, Ginger irrevocably disclaimed the \$250,000 in writing,
and, as a result, the property passed instead to Ginger’s sister Gertie. In 2013, Ginger gave
\$100,000 cash to her alma mater, State University. In 1996, Ginger had given ownership
of a life insurance policy on her own life to her daughter, Denise, and in 2013 Ginger paid
the \$22,000 annual premium on the policy. In 2010, Ginger deposited \$45,000 into a
bank account in the name of herself and son Stevie, joint tenants with rights of survivor-
ship. Stevie deposited nothing. Neither party made a withdrawal until 2013, when Stevie
withdrew \$30,000. In 2013, Ginger created a trust with County Bank as trustee and
transferred \$300,000 of stock to the irrevocable trust. She named her husband Greg (age
47) to receive all the trust income semi-annually for life and daughter Drucilla to receive
the remainder. In 2013, she gave a remainder interest in her beach cottage to the
American Red Cross and kept the right to use the cottage rent free for the rest of her life.
The fair market value of the cottage was \$70,000.

Other information: Ginger’s earlier taxable gifts are \$175,000, all made in 1996.
Ginger will make whatever elections are necessary to minimize her current gift tax liabil-
ity. Assume the Sec. 7520 interest rate is 4%.

Get a 30 % discount on an order above \$ 50
Use the following coupon code:
COCONUT
Positive SSL