Accounting -Determine Mr. J’s filing status in each of the following independent cases

Please solve the following 4 answers in excel using formulas(not just typing in the answers) when applicable.1.Determine Mr. J’s filing status in each of the following independent cases:a. Mr, J and Mrs. J were divorced on November 18th. Mr. J has not remarried and has no dependent childrenb.Mr.J and the first Mrs. J were divorced on April 2nd. MR. J married the second Mrs. J on December 15th and he has no dependent children.c.Mrs. J died on july 23rd. Mr. J has not remarried and has no dependent children.d.Mrs. J died on October 1, 2013. Mr. J has not remarried and maintains a home for one dependent child.e. Mrs. J died on May 30th, 2014. Mr. J has not remarried and has no dependent children.f. Mr. and Mrs. J were divorced on May 30, 2012. Mr. J has not remarried and maintains a home for his 2 dependent children.2.Mrs. W is an unmarried individual. Determine if each of the following unmarried unmarried individuals is either a qualifying hold or qualifying relative for whom Ms. W can claim an exemption.a.Daughter dee, age 20 who is a student at state university but lists ms. w’s home as her permanent residence. Mrs. W provides 80 percent of of Dee’s financial support. Dee earned $6,320 from her summer internship with a bank.b.Sister Lulu, who is 39 years old and mentally handicapped. lulu lives in a privately operated group home, and mrs. W provides 100 percent of her financial support. lulu has no gross incomec. Son Bryan, age 13, who lives in Mrs. W’s home but receives 65% of his financial support from his father.d. niece betsy, age 25, who lives in Mrs. W’s home Ms. W provides 60 percent of Betsy’s financial support. Betsy is a part time student and holds a part time joint which she earned $10,450 this year.3.Mr and Mrs. S have the following income items:Ms. S’s schedule C net profit: $91,320Mrs. S’s Scjedule c net loss: (7,480)Mrs. S’s taxable pension: $12,300Mr. S’s seld employment tax was $12,903. The couple had $13,050 itemized deductions. They provide 100 percent of the financial support for mrs. S’s 82 year old mother, Who resides in their home. Compute the couple’s income tax on a joint return.4. Mr. RG, and unmarried individual, had the following income items.salary: $512,100Interest income: $19,700dividend eligible for 20% rate: $31,000He had $34,000 itemized deductions (none of which were medical expense, investment interest expense, or casualty, theft, or gambling loss) and four dependent children (ages 5 through 15) plus two dependent parents who live in his home. Compute Mr. RG’s income tax.