Given the following information, calculate the earning after tax as well as the equity capital and explain what excel function could be useful in problem solving. T$1$ T$2$

Sales Units $20000020000$

Sales Price $$0\mathrm{.}45$ $$0\mathrm{.}45$

Variable Cost $$0\mathrm{.}25$ $$0\mathrm{.}25$

Contribution $$0\mathrm{.}20$ $$0\mathrm{.}20$

Sales Revenue $$90,000\mathrm{.}00$ $$9,000\mathrm{.}00$

Variable Cost $$50,000\mathrm{.}00$ $$5,000\mathrm{.}00$

Contribution $$40,000\mathrm{.}00$ $$4,000\mathrm{.}00$

Fixed Operating Cost $$40,000$ $$40,000$

EBIT $$0\mathrm{.}00($$$36,000\mathrm{.}00)$

Interest $$0$ $$10,000$

EBT $$0\mathrm{.}00($$$46,000\mathrm{.}00)$

Tax $$0\mathrm{.}00($$$11,500\mathrm{.}00)$