Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please answer the questions below: Data: You are an accounting analyst at Sunrise Ventures, Limited. Sunrise Ventures has goodwill on its balance sheet and has
Please answer the questions below:Data:
You are an accounting analyst at Sunrise Ventures, Limited. Sunrise Ventures has goodwill on its balance sheet and has to test for goodwill impairment in the next reporting period. You see the Wall Street Journal headline, "Goodwill Impairments Continue to Climb Despite Strong Economy". Your manager has asked you to understand goodwill and goodwill impairment at other companies so that goodwill impairment can be properly tested at Sunrise Ventures. She created a dashboard visualization using financial data from Dow Jones companies in 2017 (since the data is publicly available). She asks you to interpret the dashboard and answer the questions below. Click here to view the data in Tableau, and here to view it in Power BI. (The Tableau and Power BI files contain the same data; you can use either to answer the questions in this assignment. Your instructor may specify which program they prefer you to use!) How to Access Tableau: You can open the Tableau file in this problem statement with Tableau Desktop software. If you don't have Tableau Desktop, you can download Tableau Reader, a free program that allows you to open Tableau visualizations. To get it, search for "Tableau Reader" in your internet browser, or click here. How to Access Power BI: You can open the Power BI file in this problem statement with Power BI Desktop. If you don't have it already, search for "Power BI download" in your internet browser, or click here for a free download. Which company had the greatest percentage increase in goodwill from 2016 to 2017 ? What factors may have contributed to this change? Comment on the accuracy of the goodwill value and how goodwill impairment is tested? Which sectors show the greatest goodwill to total asset ratios? With large amounts of goodwill, there is risk of large impairment losses. How does impairment loss impact the balance sheet and income statement? Which companies, according to the dashboard, have the greatest ratios of Goodwill to total assets? If you are unfamiliar with these companies do a quick internet search about them. What might explain why they have such high ratios while a company like Nike is very low? Dow Jones Goodwill Dashboard Figure 1: Average Goodwill/Total Assets By Sector Figure 2: Average Goodwill/Total Equity by Sector Figure 3: ROA vs Goodwill/Total Assets ROA Goodwill/Total Assets Figure 4: Total 2017 Goodwill vs Goodwill \% Change from Prior Year 100% $80K $60K $40K $20K SOK .. . . or Goodwill Goodwill % ChangeStep 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