Question: Instructions:[1] Create an Excel spreadsheet to compute the taxpayers [a] book income, [b] taxable income,and [c] book/tax differences. Format your spreadsheet to print on a

Instructions:[1] Create an Excel spreadsheet to compute the taxpayers [a] book income, [b] taxable income,and [c] book/tax differences. Format your spreadsheet to print on a single page in a font large enough for easy reading. Be sure to label the information on your spreadsheet.[2] Using your Excel spreadsheet, prepare a 2022 Form 1120 [thru line 37] and Schedule M-1[p.6]. Find Form 1120 at www.irs.gov. Do not attach other forms as required by certain lines of Form 1120.Taxpayer Information:Buttler, Inc. is an accrual-basis, calendar-year wholesaler which was incorporated on May 13,2018. Its employer identification number is 31-4957632. Buttlers main office is located at15151 Exchange Street, Sycamore, IL 60178. Total assets as of December 31, 2022, sum to$9,642,900. Buttlers 2022 GAAP income statement reports the following: $3,326,000 of total sales for the year. Returns and allowances of $64,000 were subsequently granted to customers who received goods that was damaged. $8,600 of interest income was received during the year from investments in corporate bonds. $4,200 was earned on OHare Airport District bonds. These bonds are considered municipal bonds. ($22,700) loss on the sale of investment securities $14,000 gain on the sale of investment land $1,078,900 cost of goods sold $380,000 officers compensation $812,000 other salaries and wages $147,300 federal income tax expense $147,400 depreciation expense $15,000 state income taxes $55,200 payroll taxes $6,900 interest expense $12,800 repairs $68,400 rent expense $21,500 advertising expense $38,300 bad debt expense $14,300 property insurance premiums $6,100 key-person life insurance premiums $17,500 business meals from restaurants $6,300 business meals not from restaurants Additional information is as follows: Buttlers financial reporting already reflects the capitalization of certain indirect costs to GAAP inventory this year (i.e., DR to Inventory, CR to certain period expenses). Tax law requires the following additional costs to be capitalized to tax-basis inventory:o $94,000 of other salaries and wages o $27,000 of rent expense NOTE combine and label these differences as UNICAP in Schedule M-1 Cost of goods sold for tax purposes is $1,212,400. MACRS depreciation totaled $185,900 for the year. C-suite bonuses of $38,000 are included in the accrued officers compensation. These bonuses will be paid out on April 1, 2023. For tax purposes, Buttler capitalized organizational costs of $11,250 incurred to incorporate the business in 2018. These costs were expensed in 2018 for GAAP purposes. Accounts receivable totaling $47,600 were written off as uncollectible this year. Buttler received $22,500 of prepaid rent in late December 2022 from a company that will lease excess space in its largest warehouse from February 1 through October 30, 2023. The tax workpapers show a net operating loss carryforward of $114,600. Buttler made the following estimated income tax payments to the IRS for 2022:o 1st quarter $33,000o 2nd quarter 33,000o 3rd quarter 31,000o 4th quarter 30,000 Buttler does not qualify for any other tax credits in 2022. Any overpayment of 2022 tax should be credited to its 2023 estimated taxes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!