70.2K

Verified Solution

Link Copied!

Using Excel Visualizations to Analyze the Impact of an Accounting Change

$$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

$1.$ Download the following Excel file: Companies in the Consumer Discretionary segment

$2.$ Create a schedule in Excel showing each company$$s deferred tax allowance balance divided by the gross deferred tax asset balance.

Note: Enter the percent rounded to one digit after the decimal; for example, enter $8\mathrm{.}4$ for $8\mathrm{.}44\%,$ or $8\mathrm{.}5$ for $8\mathrm{.}45\%.$

$20202019$DTA Allow.$/$DTADTA Allow.$/$DTAUnder Armour Inc.Answer $1$Answer $2$Yum Brands Inc.Answer $3$Answer $4$Marriott Intl. Inc.Answer $5$Answer $6$Amazon.com Inc.Answer $7$Answer $8$General Motors Inc.Answer $9$Answer $10$Ralph Lauren Corp.Answer $11$Answer $12$Gap Inc.Answer $13$Answer $14$Harley$-$Davidson Inc.Answer $15$Answer $16$Best Buy Co$.$ Inc.Answer $17$Answer $18$Starbucks Corp.Answer $19$Answer $20$Ebay Inc.Answer $21$Answer $22$Chipotle Mexican Grill, Inc.Answer $23$Answer $24$Home Depot Inc.Answer $25$Answer $26$Target Corp.Answer $27$Answer $28$

Answer & Explanation Solved by verified expert

See Answer