LO.8Under Rowena's will, Mandy (Rowena's sister) inherits her property. One year later, Mandy dies. Based on the following independent assumptions, what is Mandy's credit for the tax on prior transfers?

A. The estate tax attributable to the inclusion of the property in Rowena's gross estate is $700,000, and the estate tax attributable to the inclusion of the property in Mandy's gross estate is $800,000.

B. The estate tax attributable to the inclusion of the property in Rowena's gross estate is $1,200,000, and the estate tax attributable to the inclusion of the property in Mandy's gross estate is $1,100,000.

C. Express your computations forparts (a)and(b)asMicrosoftExcelcommands.

D. Would your answers toparts (a)and(b)change if Mandy died seven years (rather than one year) after Rowena?

I am conflicted in part A and B as the deaths are within 2 years so it should be 100% however, should it be the difference of the total estates?

I do not understand how to compute a Microsoft excel command to support my answers in part A and B.