All Matches

Solution Library

Expert Answer

Textbooks

Search Textbook questions, tutors and Books

Oops, something went wrong!

Change your search query and then try again

Result Not Found

Books FREE
Tutors
Study Help
Hire a Tutor
AI Study Help New

Search
Sign In
Register

study help
business
data analytics accounting

Questions and Answers of Data Analytics Accounting

Click the filters to compare S&P100 companies listed on the NYSE to those listed on NASDAQ. Which exchange has the most positive companies in the data?
In the top 10 companies with the most to say, which companies have a positive-negative ratio higher than 0.7?
What is the value of the positive-negative ratio at its highest point?
In what year does the positive-negative ratio reach its highest point?
How many NYSE companies have a positive-negative ratio above 0.7 from 2016 to 2019?
Look at the companies with the highest word counts.Do they tend to have a higher or lower PNR? Would you expect companies that with high word counts in their financial statements to include more
Given the benchmark for PNR, do you expect financial statements to include more positive or negative words overall? Why?
What does the PNR represent?
What is the benchmark value for PNR used to identify companies with the most positive word counts?
If one company has a significantly higher debt-toequity ratio than the other two, what might be driving this? How might the DuPont ratios help explain this?
What impact (if any) does missing data have on the ratios?
Analyze liquidity, profitability, financing (leverage), and activity for your company. Where is it strong?
Why is it useful to compare multiple companies at once?
How does XBRL fulfill the need for real-time, accurate financial data?
How well has your Company 1 managed short-term liabilities over the last three years?
Which of the three companies is most liquid in 2020, according to the quick ratio?
For your Company 1, which ratio has seen the biggest change from 2018 to 2020? Use sparklines or calculate the percentage change.
Which industry did you analyze?
Look at the values that return a 0.Is it likely that the 0 represents the company’s actual standing? What else might explain the 0 value?
Look at the different companies’ ratios. Which ones stand out to you as being atypical?
Which company’s ratios match Column J?
Which company’s ratios match Column I?
Which company’s ratios match Column H?
Which company’s ratios match Column G?
Which company’s ratios match Column F?
Which company’s ratios match Column E?
Which company’s ratios match Column D?
Which company’s ratios match Column page 441 C?
Which company’s ratios match Column B?
Which company’s ratios match Column A?
If analysts expect MMM to attain a gross profit margin above 47 percent, does the company exceed the expectations in all three years analyzed?
In which of the three years analyzed is operating expense highest as a percentage of revenue for PG?
What direction is cost of revenue trending for GE?
How could you expand this table you built in Part 2 to include multiple competitors’ data on the same sheet for quick analysis?
Replace the company ticker with a competitor of your company (e.g., MSFT vs. AAPL). How do their trends compare with your initial company?
How did the actual results compare with your hypothesis in Part 1 AQ3?
Enter the ticker for Apple Inc. (AAPL) or Nike(NKE). Look at the trends and composition of the income statement, then answer your three questions from Part 1 AQ2.
Change the values in your test formula. What is the value of [Current Assets] or AssetsCurrent for PG in 2020? (Round to the nearest million dollars.)
Change the values in your test formula. What is the Net Income for NKE in 2020? (Round to the nearest million dollars.)
What was the Net Income value for AAPL in 2020?(Round to the nearest million dollars.)
Form a hypothesis for each of your questions. For example, “I expect Nike’s operating costs have gone up.”
Select either Apple Inc. (AAPL) or Nike (NKE), and identify three questions you might want to know about that company’s financial performance over the past three years. For example, “What is the
iXBRLAnalyst in Google Sheets uses “normalized”tags for common financial statement elements. What is the purpose of “normalized” XBRL tags?
(LO 8-3) Go to Loughran and McDonald’s sentiment word lists at https://sraf.nd.edu/textual-analysis/resources/ and download the Master Dictionary. These lists are what they’ve used to assess
(LO 8-3) Go to Loughran and McDonald’s sentiment word lists at https://sraf.nd.edu/textual-analysis/resources/ and download the Master Dictionary.These lists are what they’ve used to assess
What impact did the Whole Foods announcement have on Amazon trading volume?b. Do the same analysis for Walmart (WMT) over the same dates. What impact did the Whole Foods announcement have on Walmart
(LO 8-1) The preceding question asked you to figure out how the stock market responded to Amazon’s announcement that it would purchase Whole Foods. The question now is if the stock market for
(LO 8-1) You’re asked to figure out how the stock market responded to Amazon’s announcement on June 16, 2017, that it would purchase Whole Foods—arguably a transformational change for Amazon,
(LO 8-3) Analysis: We noted in the text that negative words in the financial dictionary include words such as loss, claims, impairment, adverse, restructuring, and litigation. What other negative
(LO 8-3) Analysis: Can you think of situations where sentiment analysis might be helpful to analyze press releases or earnings announcements? What additional information might it provide that is not
(LO 8-2) Match the following descriptions to one of the following visualization types:Heat map Sparklines Sunburst diagram Illustrates Description 1. Illustrates trends in sales 2. Illustrates
(LO 8-1) Match the following descriptions or equations to one of the following components of the DuPont ratio:Return on stockholders’ equity Profit margin Asset turnover Equity multiplier Return on
(LO 8-1) Match the description of the financial statement analysis technique to the data analytics type:Descriptive analytics Diagnostic analytics Predictive analytics Prescriptive analytics
(LO 8-1) Match the description of the financial statement analysis question to the data analytics type:Descriptive analytics Diagnostic analytics Predictive analytics Prescriptive analytics Financial
(LO 8-3) Can you think of how sentiment analysis might be used in a marketing setting? How could it be used in a hospital setting? Or at your university? When would it be especially good to measure
(LO 8-4) Can you think of any other settings, besides financial reports, where tagged data might be useful for fast, accurate analysis generally completed by computers? How could it be used in a
(LO 8-1) Go to finance.yahoo.com and type in the ticker symbol for Apple (AAPL)and click on the statistics tab. Which of those variables would be useful in assessing profitability?
(LO 8-4) Go to https://xbrl.us/data-rule/dqc_0015-lepr/ and find the XBRL element name for Other Nonoperating Income and indicate whether XBRL says that should normally be a debit or credit entry.
(LO 8-4) Go to https://xbrl.us/data-rule/dqc_0015-lepr/ and find the XBRL element name for Interest Expense and Sales, General, and Administrative Expense.
(LO 8-1) Why do audit firms perform analytical procedures to identify risk? Which type of ratios (liquidity, solvency, activity, and profitability ratios) would you use to evaluate the company’s
(LO 8-2) Would you recommend the Securities and Exchange Commission require the use of sparklines on the face of the financial statements? Why or why not?
(LO 8-3) Which would you predict would have more positive sentiment in a 10-K, the financial statements or the MD&A (management discussion and analysis) of the financial statements? More positive
(LO 8-4) What is the name of the output from data vendors to help compare companies using different XBRL tags for revenue?a. XBRL taxonomyb. Data assimilationc. Consonant taggingd. Standardized
(LO 8-4) What is the term used to describe the process of assigning XBRL tags internally within a financial reporting/enterprise system?a. XBRL taggingb. XBRL taxonomyc. XBRL-GLd. XBRL dictionary
(LO 8-4) Which term defines and describes each XBRL financial element?a. Data dictionaryb. Descriptive statisticsc. XBRL-GLd. Taxonomy
(LO 8-4) XBRL stands for:a. Extensible Business Reporting Language.b. Extensive Business Reporting Language.c. XML Business Reporting Language.d. Excel Business Reporting Language.
(LO 8-2) Determining how sensitive a stock’s intrinsic value to assumptions and estimates made would be an example of _____ analytics.a. diagnosticb. predictivec. descriptived. prescriptive
(LO 8-3) What computerized technique would be used to perform sentiment analysis on an annual accounting report?a. Text miningb. Sentiment miningc. Textual analysisd. Decision trees
(LO 8-2) In which stage of the IMPACT model (introduced in Chapter 1) would the use of sparklines fit?a. Track outcomesb. Communicate insightsc. Address and refine resultsd. Perform test plan
(LO 8-1) Performance comparisons to a company’s own past or to its competition would be considered _____ analytics.a. prescriptiveb. descriptivec. predictived. diagnostic
(LO 8-1) What type of ratios measure a firm’s operating efficiency?a. DuPont ratiosb. Liquidity ratiosc. Activity ratiosd. Solvency ratios
(LO 8-1) The DuPont analysis of return on equity (ROE) includes all of the following component ratios except:a. asset turnover.b. inventory turnover.c. financial leverage.d. profit margin.
Using Exhibit 8-14 as the source of data and using the raw accounts, show the components of profit margin, operating leverage, and financial leverage and how they are combined to equal ROE for Q1
Assuming XBRL-GL is able to disseminate real-time financial reports, which real-time financial elements (account names) might be most useful to decision makers? And which information might not be
How might standardized XBRL metrics be useful in comparing the financial statements of General Motors, Alphabet, and Alibaba?
How does XBRL facilitate Data Analytics by analysts?
Why would you guess the results between the proportion of negative words and the stock market reaction to the 10-K issuance differ between the Fin-Neg and the H4N-Inf dictionary?
Which do you predict would have more positive sentiment in a 10-K, the footnotes to the financial statements or the MD&A (management discussion and analysis) of the financial statements?
How might sparklines be used to enhance the DuPont analysis? Would you show the sparklines for each component of the DuPont ROE disaggregation, or would you propose it be shown only for the total?
What would a horizontal trend tell you about a firm’s performance?
Which ratios would a financial institution be most interested in when determining whether to grant a loan to a business?
Describe how XBRL tags financial reporting data and how it facilitates financial statement analysis.
Describe the value of text mining and sentiment analysis of financial reporting.
Explain how to create and read visualizations of financial statement data.
Understand different types of financial statement analysis that are performed.
Compare and contrast the treemap produced by Tableau Desktop with the one produced by Power BI Desktop. Which one is easier to interpret?
Compare and contrast the stacked bar chart produced by Tableau Desktop with the one produced by Power BI Desktop. Which one is easier to interact with?
Compare and contrast the cluster model produced by Tableau Desktop with the one produced by Power BI Desktop. What do you notice about the clusters?
If you exclude the city from the previous question from analysis, what sales rank does Arkansas fall to?
Which city has the highest volume of sales for the two weeks of analysis?
Which three states had the lowest sales volume for the two weeks of analysis?
Which three states had the top sales volume for the two weeks of analysis?
How would you collect those additional data?
What additional data would you want to gather to help explain why sales transactions decrease on the days with the lowest sales?
Given this pattern, would you expect the next day after this analysis to be higher or lower than the last day?
Look up these dates on a calendar. What do you notice about the days with higher transaction amounts?
Which two days appear to have the lowest transaction amounts?
Which two days appear to have the highest transaction amounts?
Look at the cluster of low-performing stores. What do you think are some of the drivers for their poor performance?
Look at the cluster of high-performing stores. What do you think are some of the drivers for their good performance?

Showing 200 - 300 of 1547

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Last

Services

Sitemap
Fun
Definitions
Become Tutor
Study Help Categories
Recent Questions
Expert Questions

Company Info

Security
Copyrights
Privacy Policy
Terms & Conditions
SolutionInn Fee
Scholarship

Get In Touch

About Us
Contact Us
Career
Jobs
FAQ
Campus Ambassador

Secure Payment

Download Our App

© 2024 SolutionInn. All Rights Reserved