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%.