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 ExcelOpen the file titled “Tax Compliance and Provision Project – Parts I and II.xlsx”.The Financial Statements and Trial Balance can be found in the last 2 worksheets of the Excel workbook.On the “Trial Balance” tab, make sure each of the accuracy checks calculated in red throughout the worksheet shows a result of zero.You will ONLY be working with the PINK tabs for Part I of this project.Click on the worksheet titled “Perm Book-Tax Differences”.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).Hint – you will need to use the “Trial Balance” tab to help you determine the correct “Acct. Number” for the applicable cells.Click on the worksheet titled “Temp Book-Tax Differences”.Select the appropriate answer in the drop-down boxes within each of the cells shaded in GREEN (31 in total).Hint – you will need to use the “Trial Balance” tab to help you determine the correct “Acct. Number” for the applicable cells.There are also YELLOW cells (3 in total) that require manual numerical inputs. Enter 0 if applicable.Also, note the following:Assume that the goodwill and intangibles were purchased on May 1, 2018.Assume that the organizational costs were incurred on March 1, 2018.Once you’ve fully completed the Perm and Temp Book-Tax Differences tabs, select the “Book-to-tax Rec” worksheet.The accuracy checkpoint should show a variance within +/- 1.0 (cell C30).Save the completed Excel workbook (only the PINK tabs should be completed) and upload into the applicable Canvas assignment.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 1Print the file titled “Schedule M-3 – partially completed.pdf”.Complete Parts II and III of Schedule M-3 by hand: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.Compute the resulting taxable income/deduction and input your answer in column (d) of the applicable row.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.The book-tax differences associated with capital losses and income tax expense have already been completed for you.In Part III, total each column in Row 38 – column (a) has already been totaled for you.in Part II, subtotal each column in Row 26 as instructed on the form – column (a) has already been subtotaled for you.In Part II Line 27, fill in the amounts you totaled for each column in (d) above.In Part II, input the total for each column in Row 30, following the specific instructions on the form.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).

Scenario: You currently work as the marketing manager of your favorite company/organization and manage the success of one of its products or services. Your responsibility is to monitor the stages of the Product Life Cycle (PLC) and adjust the marketing strategies as needed for your product so that it can thrive for as long as possible. At each stage, you assess changes in the target market, determine changes that you need to make to the product or price strategy, and review the competition and profitability.Create a 10- to 15-slide (not counting cover slide or reference slide) Microsoft PowerPoint, presentation with speaker's notes that covers the following criteria:Develop a slide that establishes the theme and goals of the presentation.Define and discuss the PLC concept and its importance to marketing managers.Discuss why the PLC is important to marketing managers, and provide examples of the possible implications if the PLC is not monitored.Describe the selected company/organization, product/service, the target market for this product, and how the product/service is presented to the selected target market.Describe how brand equity can be used to create a positive customer image of your product.Describe each stage of the PLC, and analyze the implications that each stage may have on pricing, product definition, competition, and profitability for your selected product/service.