Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

AC312 - Tax Compliance and Provision - Part I Instructions Your tax senior has e-mailed you Oh Gnome You Didn't, Inc.'s GAAP-basis trial balance and

AC312 - Tax Compliance and Provision - Part I Instructions

Your tax senior has e-mailed you Oh Gnome You Didn't, Inc.'s GAAP-basis trial balance and financial statements for the 2018 calendar year, prepared using Microsoft Excel, and has asked you to convert Gnome's book income into taxable income within the same Excel workbook.The Excel workbook contains pre-formatted tabs you'll need to complete to properly calculate taxable income.

Your tax senior has also asked you to prepare Form 1120, Schedule M-3 for Gnome once you have finished computing taxable income.

Please read each of the below instructions carefully as you complete this part of the project:

Step 1 - Taxable Income Calculation using Microsoft Excel

1.Open the file titled "Tax Compliance and Provision Project - Parts I and II.xlsx".

2.The Financial Statements and Trial Balance can be found in the last 2 worksheets of the Excel workbook.

a.On the "Trial Balance" tab, make sure each of the accuracy checks calculated in red throughout the worksheet shows a result of zero.

3.You will ONLY be working with the PINK tabs for Part I of this project.

4.Click on the worksheet titled "Perm Book-Tax Differences".

a.For each type of permanent difference, select the appropriate answer in the drop-down boxes within each of the cells shaded in GREEN (16 in total).

b.Hint - you will need to use the "Trial Balance" tab to help you determine the correct "Acct. Number" for the applicable cells.

5.Click on the worksheet titled "Temp Book-Tax Differences".

a.Select the appropriate answer in the drop-down boxes within each of the cells shaded in GREEN (31 in total).

b.Hint - you will need to use the "Trial Balance" tab to help you determine the correct "Acct. Number" for the applicable cells.

c.There are also YELLOW cells (3 in total) that require manual numerical inputs.Enter 0 if applicable.

6.Once you've fully completed the Perm and Temp Book-Tax Differences tabs, select the "Book-to-tax Rec" worksheet.

a.The accuracy checkpoint should show a variance within +/- 1.0 (cell C30).

7.Save the completed Excel workbook (only the PINK tabs should be completed) and upload into the applicable Canvas assignment.

Continued...

Step 2 - Preparation of Schedule M-3 (Form 1120)

Your tax senior has also asked you to prepare Form 1120, Schedule M-3 for Gnome once you have finished computing taxable income.

Option 1

1.Print the file titled "Schedule M-3 - partially completed.pdf".

2.Complete Parts II and III of Schedule M-3 by hand:

a.Locate the rows with book-tax differences and input the book-tax adjustment you calculated in Step 1, making sure you properly input the adjustment in the Temporary or Permanent columns on the Schedule M-3.

i.Compute the resulting taxable income/deduction and input your answer in column (d) of the applicable row.

b.Hint - in Part III, expense amounts are shown as positive amounts.Therefore, if a book-tax difference reduces book expense, you will show a negative number in the Temporary or Permanent columns.

c.The book-tax differences associated with capital losses and income tax expense have already been completed for you.

d.In Part III, total each column in Row 38 - column (a) has already been totaled for you.

e.in Part II, subtotal each column in Row 26 as instructed on the form - column (a) has already been subtotaled for you.

f.In Part II Line 27, fill in the amounts you totaled for each column in (d) above.

g.In Part II, input the total for each column in Row 30, following the specific instructions on the form.

3.Checkpoint - Schedule M-3 Part II Row 30 column (d) should equal the taxable income you calculated in Step 1 (on the "Book-to-tax Rec" Excel worksheet).

4.Scan the completed Schedule M-3 and upload into the applicable Canvas assignment.

Option 2

1.Access a fill-able version of Schedule M-3 at the following site:https://www.irs.gov/pub/irs-pdf/f1120sm3.pdf

2.Download the form to your hard drive.

3.Open the file titled "Schedule M-3 - partially completed.pdf" and input all information found in that form into your fill-able version of Schedule M-3.

4.Follow the instructions covered in Option 1, #2 above.

5.Checkpoint - Schedule M-3 Part II Row 30 column (d) should equal the taxable income you calculated in Step 1 (on the "Book-to-tax Rec" Excel worksheet).

6.Save the completed Schedule M-3 and upload into the applicable Canvas assignment.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial And Managerial Accounting

Authors: Jerry J Weygandt, Paul D Kimmel, Jill E Mitchell

4th Edition

1119752620, 978-1119752622

More Books

Students also viewed these Accounting questions

Question

What are some of the topics they study?

Answered: 1 week ago