Under 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.2 million, and the estate tax attributable to the inclusion of the property in Mandy’s gross estate is $1.1 million.

c. Express your computations for parts (a) and (b) as Excel commands.

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