Question
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.
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started