I need help on the third sheet of the excel. I can't seem match the figures with the check figures. I need this done by tomorrow. Thanks in advanced!

Facts, Issues, & Authorities Facts Justin is a single taxpayer with no dependents, who owns IMC, Inc. (a C corporation). Both entities use the calendar year and cash basis for tax reporting purposes. Based on year-end tax planning for 2014, the corporation expects to earn taxable income (before paying Justin's salary) of $300,000. The corporation plans to pay 60% of that amount as compensation to Justin, in some combination of salary and dividend. Justin has ordinary taxable income from other sources of $50,000. Issue How should Justin's compensation package be allocated between salary and dividend? Use only three alternatives in your analysis: Salary Dividends #1 0% 100% #2 50% 50% #3 100% 0% Authorities IRC 1 imposes a tax on an individual's taxable income while IRC 11 imposes a tax on a corporation's taxable income. In addition, 3101 and 3111 impose taxes under the Federal Insurance Contributions Act on employees and employers, respectively. For both individuals and corporations, IRC 63 defines taxable income to mean gross income (which generally includes all income from whatever source derived, per 61) minus allowable deductions and excluding items specifically identified in 101-140. Section 162 authorizes deductions for the ordinary and necessary expenditures incurred in the conduct of a trade or business. More specifically, 162(a)(1) allows a deduction for "reasonable allowance for salaries or other compensation." 5. Based on your analysis of the alternatives, which alternative should the taxpayer select? 6. Briefly explain why the taxpayers should select that alternative. 7. Briefly explain which tax planning strategy that alternative relies on. 8. Briefly explain whether the alternative that you selected would change if the provisions under 1(h)(11) expired. 9. Briefly explain why the alternative that you selected would or would not change if 1(h)(11) expired. 10. Assume that the spreadsheet analysis indicated that the taxpayer should take the compensation package as salary. However, you know that the compensation would be unreasonable. Which feasibility constraint is preventing the taxpayers from implementing the conclusion supported by the spreadsheet analysis? Links to Worksheets in File Introduction Questions Analysis ASSUMPTIONS: Corporate Taxable Income before Officer Compensation $ Percentage of Corporate TI for Officer Compensation Tax Year 300,000 60% 2014 1(h)(11) In Effect 1(h)(11) Expired Alternative #1 Alternative #2 Alternative #3 Alternative #1 Alternative #2 Alternative #3 Percentage of Payment to be Paid as Salary CORPORATION 0% 50% 100% 0% 50% 100% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Corporate Income before Deducting Officer's Salary Officer's Salary FICA Tax on Officer's Salary Corporate Taxable Income Corporate Income Tax Corporate Dividends Paid Corporation's After Tax Wealth OWNER/OFFICER Officer'sTaxable Income before Corporate Compensation Officer's Salary Officer's Dividends Officer's Taxable Income Officer's Income Tax (ordinary) Officer's Income Tax (dividends) FICA Tax on Corporate Salary Officer's After Tax Wealth Total After Tax Wealth $ Check Figures $ - $ 214,394 $ - $ 227,889 $ 239,426 $ - $ $ 185,108 $ - $ 209,123 $ 239,426