I need some help with this practice problem, I have to create an excel worksheet in which I have to show the pre-tax earnings, the taxes paid, the earnings after taxes for both corporate and proprietor.

MGMT 640 Excel Practice Problem Homework 1 Question: You want to compare the earnings from two different legal forms for a firm: Corporate and Proprietor. Your pre-tax income is $500,000 in both. However there is a difference in the taxes you pay. 1) Corporate pays corporate tax rate of 30%. After paying corporate taxes the rest is distributed as dividends to owners. They pay personal tax on these dividends at the rate 18%. 2) Proprietor pays personal tax on 36% only. Create an Excel worksheet in which you show the pre-tax earnings, the taxes paid, the earnings after taxes for both corporate and proprietor