Federal income tax allows a deduction for any state tax paid during the year. In addition, the state of Alabama allows a deduction from its state income tax for any federal tax paid during the year. The federal corporate income tax is equivalent to a flat rate of 34% and the Alabama state tax rate is a flat 5%. Both the Alabama and the federal taxable income for a corporation is $1,000,000 before either tax is paid. Because each tax is deductible on the other return, the taxable income will differ for the state and federal taxes (assume for this problem that the company has no other deductions to consider). One procedure often used by tax accountants to find the tax due in this and similar situations is called iteration and it's described by the following steps: 1. Make an estimate of the federal taxes due by assuming no state tax is due, deduct this estimated federal tax due from the state taxable income and calculate an estimate of the state taxes due on the basis of this assumption. 2. Deduct the estimated state tax as computed in (1) from the federal taxable income and calculate a new estimate of the federal tax due under this assumption. 3. Deduct the new federal tax due as computed in (2) from the state taxable income and calculate a new estimate of the state taxes due on the basis of these calculations. 4. Repeat the process in (2) and (3) until the federal tax changes from one repetition to another by less than $1. QUESTION 1 Use Excel (or your favorite spreadsheet application) to model the above iteration process. Then complete the table, using as many rows as needed (until the change in federal tax is less than $1). Please include a print out of your table rather than filling in the one below (this is just the sample) Federal Taxable income Federal Tax State Taxable income Table Income State T4%) Table Income - Fede peduction) Deductie lietti 1,000,000 340,000 660,000 33.000 P" let Hi |, 400,000 - 33,000 967,000 3 het (Hint: this process will not take a lot of iterations - be careful how you apply the deductions at each step, and keep in mind that the taxable income is always $1,000,000.)