Answered step by step
Verified Expert Solution
Question
1 Approved Answer
DA 1 8 - 1 Analyzing Visualizations of Deferred Tax Accounts The Excel file associated with this exercise includes balance sheet tax account data for
DA Analyzing Visualizations of Deferred Tax Accounts
The Excel file associated with this exercise includes balance sheet tax account data for two years for fourteen large companies in the Consumer Discretionary segment. In this exercise, we analyze trends in the deferred tax allowance as a percentage of the gross deferred tax asset balance. An increase in the percentage means that management expects a larger portion of the deferred tax asset to not be realized.
Required
Save this Excel file DA found in myBusinessCourse.
Create a schedule in Excel showing each company's deferred tax allowance balance divided by the gross deferred tax asset balance.
Sort the balances for each year in the order from largest to smallest. Hint: Copy and Paste Special the calculations as Values before sorting in order to save your calculations after sorting.
Create a bar chart visualization showing a bar for and for each company. Hint: Highlight the data, click Insert, Bar.
List the companies in which the ratio did not increase from year to
List the company that visually showed the largest change in the ratio from to
Select the best answer below that is the most likely reason for the common trend in the ratios from to
a The increasing trend in the ratio was generally due to foreign legislative changes.
b The increasing trend in the ratio was generally due to changes in the accounting for leases.
c The increasing trend in the ratio was generally due to the uncertainties surrounding future earnings due to the COVID pandemic.
d The decreasing trend in the ratio was generally due to domestic legislative changes.
Create a separate schedule in Excel with a column for each company's net deferred tax asset balance and a column for each company's deferred tax liability balance as of
Create a stacked bar chart for each company's net deferred tax asset balance and deferred tax liability balance as of Hint: Select the Insert tab, Recommended charts, and choose the stacked bar chart.
Indicate which company has the highest percentage of net deferred tax assets to deferred tax liabilities.
Indicate which company has the lowest percentage of net deferred tax assets to deferred tax liabilities.
Indicate a factor that could have had a significant impact on the relation of net deferred tax assets to deferred tax liabilities described in part Choose the best answer.
a Property and equipment balances were greater for financial reporting than for tax.
b Accruals for selfinsurance benefits were greater for financial reporting than for tax.
c Inventory balances were less for financial reporting than for tax.
d Accrued and deferred compensation balances were greater for financial reporting than for tax.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started