Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi, need help with solving a. and b. below (marked with red xs). Please show excel calculations if you can. Many thanks. Adjustments for Deferred

Hi, need help with solving a. and b. below (marked with red "x"s). Please show excel calculations if you can. Many thanks.

Adjustments for Deferred Tax Asset Valuation Allowance

Consider the following income tax footnote information for Oracle for the fiscal year ended May 31, 2019 (fiscal year 2019). The following is a geographical breakdown of income before the provision for income taxes:

image text in transcribed

The provision for income taxes differed from the amount computed by applying the federal statutory rate to our income before provision for income taxes as follows:

image text in transcribed

The components of our deferred tax assets and liabilities were as follows:

image text in transcribed

Required
a. Use the four-year average valuation allowance to deferred tax assets (20162019) of 22.55% to adjust the income statement for each of the four years 20162019. Follow Analyst Adjustments 10.3 for guidance in the adjustment process.

Note: Use a negative sign to indicate an income statement reversal.
Note: Do not round until your final answer; round your final answers below to the nearest whole dollar.

image text in transcribed

b. Adjust the balance sheet for each of the four years 20162019.

Note: Use a negative sign to indicate a decrease of the balance sheet accounts.
Note: Round your answers to the nearest whole dollar.

image text in transcribed

Year Ended May 31 (in millions) 2019 2018 2017 Domestic $3,774 $3,366 $3,674 Foreign 8,494 9,058 8,006 Income before provision for income taxes $12,268 $12,424 $11,680 The provision for income taxes consisted of the following: Year Ended May 31 ($ in millions) 2019 2018 2017 Current provision: Federal $979 $8,320 $936 State 300 264 257 Foreign 1,097 1,100 1,100 1,475 Total current provision $2,376 $9,684 $2,668 Deferred benefit: Federal $483 $(827) $(158) State (28) (26) (29) Foreign (1,646) 6 (253) Total deferred benefit $(1.191) $(847) $(440) Total provision for income taxes $1,185 $8,837 $2,228 2019 2018 2017 21.096 29.296 35.096 $2,576 $3,629 $4,088 Year Ended May 31 ($ in millions) U.S federal statutory tax rate Tax provision at statutory rate Impact of the Tax Act of 2017: One-time transition tax Deferred tax effects Foreign earnings at other than United States rates State tax expense, net of federal benefit Settlements and releases from judicial decisions and statute expirations, net Domestic production activity deduction Federal research and development credit Stock-based compensation Other, net Total provision for income taxes (529) 7,781 140 (911) (789) (995) (1,312) 197 142 150 (132) (252) (189) (87) (119) (158) (174) (127) (201) (302) (149) 81 6 (114) $1,185 $8,837 $2,228 2019 2018 $541 $567 646 664 322 338 May 31 (in millions) Deferred tax assets: Accruals and allowances Employee compensation and benefits Differences in timing of revenue recognition Basis of property, plant and equipment and intangible assets Tax credit and net operating loss carryforwards Total deferred tax assets Valuation allowance Total deferred tax assets, net Deferred tax liabilities: Unrealized gain on stock Acquired intangible assets GILTI deferred Basis of property, plant and equipment an intangible assets Other Total deferred tax liabilities Net deferred tax assets 1,238 3,717 2,614 6,464 4,183 (1.266) (1,308) 5,198 2,875 (78) (78) (973) (1.254) (1,515) (158) (200) (48) (2.766) (1,538) $2,432 $1,337 $ millions 2016 2017 Total deferred tax asset $6,197 $4,936 Valuation allowance 1,164 1,173 2016 2017 2018 2019 Income Statement Adjustments ($ millions) Income tax expense Net income $ 0 x $ 0 X $ 0X $ OX 0X OX 2016 2017 2018 2019 Ox $ 0X $ 0 Balance Sheet Adjustments ($ millions) Valuation allowance $ Deferred tax assets, net Total assets Retained Earnings 0X $ 0X 0 OX 0 X OX 0 OX OX 0 Year Ended May 31 (in millions) 2019 2018 2017 Domestic $3,774 $3,366 $3,674 Foreign 8,494 9,058 8,006 Income before provision for income taxes $12,268 $12,424 $11,680 The provision for income taxes consisted of the following: Year Ended May 31 ($ in millions) 2019 2018 2017 Current provision: Federal $979 $8,320 $936 State 300 264 257 Foreign 1,097 1,100 1,100 1,475 Total current provision $2,376 $9,684 $2,668 Deferred benefit: Federal $483 $(827) $(158) State (28) (26) (29) Foreign (1,646) 6 (253) Total deferred benefit $(1.191) $(847) $(440) Total provision for income taxes $1,185 $8,837 $2,228 2019 2018 2017 21.096 29.296 35.096 $2,576 $3,629 $4,088 Year Ended May 31 ($ in millions) U.S federal statutory tax rate Tax provision at statutory rate Impact of the Tax Act of 2017: One-time transition tax Deferred tax effects Foreign earnings at other than United States rates State tax expense, net of federal benefit Settlements and releases from judicial decisions and statute expirations, net Domestic production activity deduction Federal research and development credit Stock-based compensation Other, net Total provision for income taxes (529) 7,781 140 (911) (789) (995) (1,312) 197 142 150 (132) (252) (189) (87) (119) (158) (174) (127) (201) (302) (149) 81 6 (114) $1,185 $8,837 $2,228 2019 2018 $541 $567 646 664 322 338 May 31 (in millions) Deferred tax assets: Accruals and allowances Employee compensation and benefits Differences in timing of revenue recognition Basis of property, plant and equipment and intangible assets Tax credit and net operating loss carryforwards Total deferred tax assets Valuation allowance Total deferred tax assets, net Deferred tax liabilities: Unrealized gain on stock Acquired intangible assets GILTI deferred Basis of property, plant and equipment an intangible assets Other Total deferred tax liabilities Net deferred tax assets 1,238 3,717 2,614 6,464 4,183 (1.266) (1,308) 5,198 2,875 (78) (78) (973) (1.254) (1,515) (158) (200) (48) (2.766) (1,538) $2,432 $1,337 $ millions 2016 2017 Total deferred tax asset $6,197 $4,936 Valuation allowance 1,164 1,173 2016 2017 2018 2019 Income Statement Adjustments ($ millions) Income tax expense Net income $ 0 x $ 0 X $ 0X $ OX 0X OX 2016 2017 2018 2019 Ox $ 0X $ 0 Balance Sheet Adjustments ($ millions) Valuation allowance $ Deferred tax assets, net Total assets Retained Earnings 0X $ 0X 0 OX 0 X OX 0 OX OX 0

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

Strategic Business Management From Planning To Performance

Authors: Gary Cokins

1st Edition

1937352358, 978-1937352356

More Books

Students also viewed these Accounting questions

Question

Prove Theorem 1.

Answered: 1 week ago