Show the pre-tax earnings, taxes paid and earnings after tax

Reference no: EM1354631

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.

Reference no: EM1354631

Questions Cloud

Explain how much output is lost as a result of deaths : The average adult produces $75,000 of output per year, Explain how much output is lost as a result of deaths from secondhand smoke, according to the News given below.

Information of bank of america : Using Bank of America, research this international company. Conduct a brief organizational analysis by answering the following questions.

Find when the current in the solenoid increases : A 3.5 m long, 310 kg steel beam extends horizontally from the point where it has been bolted to the framework of a new building under construction. A 70 kg construction worker stands at the far end of the beam.

Iq as a measure of intelligence : Discuss the advantages and disadvantages of using IQ as a measure of intelligence. (Be sure to include specific examples)

Show the pre-tax earnings, taxes paid and earnings after tax : Suppose you want to compare the earnings from two different legal forms for a company, Corporate and Proprietor. Your pre-tax income is $500,000 in both. However there is a difference in the taxes you pay.

Describe about organizational strategy : You stated that in your company when there is a plan for expansion to be implemented, shortage of funds pulls back the implementation. Why do you think that your organization fails in this area?

Compute minimum-maximum possible values for distance : During run, compute the minimum and maximum possible values for the following distance measures (from the center of the track): Manhattan, Euclidean and Chebyshev distance.

Explain what would you say is a top product or service : Explain What would you say is a top product or service today and Explain why you see them as such and also why they are better than the competition

Explain what are revelant details of geert hofstede research : Organizational Behaviour-Geert Hofstede Research Regarding American and Japanese Beliefs

User Account

All Pages