MGMT 640 Week 1 Excel Practice Problem Solution
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →MGMT 640 Excel Practice Problem 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.
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds