1. Upon your saved szcel worxooox you submitted to Lanvas for Part I or this prolect. Make sure you have the nal version that includes fully completed PINK tabs. 2. 0n the \"Trial Balance\" tab, make sure each of the accuracy checks calculated in red throughout the worksheet still show a result of zero. 3. You will m be working with the ORANGE tabs for Part II of this project. 4. Click on the worksheet titled I'Current Provision\". a. In column B, select the Permanent and Temporary book-tax differences you previously calculated on the \"Book-to-tax Rec\" tab (green cells). b. In column C, manually input the applicable book-tax differences you calculated in Part I (yellow cells). i. Hint - Favorable differences should be shown as negative amounts (since they reduce book income), and vice-versa for Unfavorable differences. ii. Hint to avoid unintended typos, you should use an Excel formula to link the answers directly to the applicable cell in the \"Book-to-tax Rec\" tab. 5. Click on the worksheet titled "State Adjustments\". a. The state only allows 50% bonus depreciation on xed asset additions, as opposed to the 100% Federal bonus depreciation allowance. i. Select the appropriate bonus depreciation allowances for state tax purposes (green cells). ii. Input the Federal tax depreciation that you calculated in Part I (yellow cell). Try and use an Excel formula link to reduce inadvertent errors associated with manual data input. iii. Indicate whether the adjustment should increase or decrease Federal taxable income to arrive at the allowable depreciation expense under the state's income tax rules (green cells)