I need help with the attached worksheet. Instructions are on the worksheet. Please use excel and show work so that I can learn from it.

The following income and epense accounts appeared in the gook accounting records of x corporation, an accrual basis taxpayer, for the current calendar year. Accounting Record Additional Information: Account Title Book income Credit $3,450,000 15,000 -1 12,000 -2 Debit Net sales Dividends Interest Gain on sale of stock 25,000 -3 Keyperson life insurance proceeds 1. Dividends were from Venus the Corporation, 30% owned domestic corporation. 2. Interest revenue consists of interest on corporate bonds, $6000; and municipal bonds, $6,000.00 3. The stock is a capital assets held for three years prior to sale. 4. Rodland uses the specific write off method of accounting for bad debts. 10,000 Cost of goods sold Salaries and wages Bad debts Payroll taxes Interest expense 5. Interest expense consists of $23,000 interest incured on funds borrowed for working. 6. Rodland paid all contributions in cash during the current year to State University. 7. Rodland calculated depreciation per books using the straight line method. For income tax purposes, depreciation amounted to $80,000. 8. Other expenses include premiums of $14,000 on the key person Life Insurance policy covering Rodland president, who died in December. 9. Qualified production activities is $330,000. 2,150,000 490,000 8,000 -4 45,000 24,000 -5 Charitable contributions 75,000 -6 Depreciation Other expenses 55,000 -7 70,000 -8 Federal income taxes 10. Rocket has a $14,000 NOL carryover from previous years. 187,782 Net income Total 407,218 $3,512,000 $3,512,000 Requirements a. Complete the worksheet to reconcile Rodland's book income with its taxable income (before special deductions). b. Prepare eight tax provision reconciliation. Assume a 34% corporate tax rate. a. Complete the worksheet to reconcile Rodland's book income with its taxable income (before special deductions). Tax depreciation - Book depreciation = = Reconciling amount $0 Radford Corporation Reconciliation of Book Income to Taxable Income before Special Deductions Book income Account Title Net sales Dividends Interest Gain on sale of stock Keyperson life insurance proceeds Cost of goods sold Salaries and wages Bad debts Payroll taxes Interest expense Charitable contributions Depreciation Other expenses Federal income taxes U.S. production activities deductions Net income/Taxable income before special deductions Total Debit Credit $3,700,000 29,000 25,000 12,000 70,000 $2,100,000 520,000 11,000 45,000 15,000 90,000 90,000 85,000 261,137 618,863 $3,836,000 $3,836,000 b. Prepare eight tax provision reconciliation. Assume a 34% corporate tax rate. Debit Adjustments Credit