Data Analytics For Accounting
19th Edition
ISBN: 9781260375190
Author: RICHARDSON, Vernon J., Teeter, Ryan, Terrell, Katie
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 7, Problem 5P
If ROA is considered a key KPI for a company, what would be an appropriate benchmark? The industry’s ROA? The average ROA for the company for the past five years? The competitors’ ROA?
- a. How will you know if the company is making progress?
- b. How might Data Analytics help with this?
- c. How often would you need a measure of ROA? Monthly? Quarterly? Annually?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Choose an industry and identify the factors that will determine its performance in the next three years. What is your forecast for performance in that time period?
The financial manager of Company X has just received the sales forecast for next year and it indicates that the year's sales are expected to double in the second half. What are the challenges that Company X might face in increasing its production to meet the sales projections and how can these challenges be overcome? What risks does Company X face by ramping-up production to meet the sales forecast?
Choose an industry and identify the factors that will determine its performance in the next 3 years. What is your forecast for performance in that time period? Support with calculations where necessary.
Chapter 7 Solutions
Data Analytics For Accounting
Ch. 7 - What would you consider to be Financial...Ch. 7 - Prob. 2MCQCh. 7 - What does KPI stand for? a. Key performance index...Ch. 7 - Prob. 4MCQCh. 7 - Prob. 5MCQCh. 7 - On a Balanced Scorecard, which is not included as...Ch. 7 - Prob. 7MCQCh. 7 - Prob. 8MCQCh. 7 - Prob. 9MCQCh. 7 - Prob. 10MCQ
Ch. 7 - We know that a Balanced Scorecard is comprised of...Ch. 7 - Prob. 2DQCh. 7 - Amazon, in the authors opinion, has cared less...Ch. 7 - For an accounting firm like PwC, how would the...Ch. 7 - For a company like Walmart, how would the Balanced...Ch. 7 - Prob. 6DQCh. 7 - If the data underlying your digital dashboard are...Ch. 7 - In which of the four components of a Balanced...Ch. 7 - From Exhibit 7-5, choose 5 Financial Performance...Ch. 7 - From Exhibit 7-5, choose 10 Employee Performance...Ch. 7 - From Exhibit 7-5, choose 10 Marketing KPIs to...Ch. 7 - Prob. 4PCh. 7 - If ROA is considered a key KPI for a company, what...Ch. 7 - If Time to Market is considered a key KPI for a...Ch. 7 - Prob. 7P
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. Construct a time series plot. What type of pattern exists in the data? Compare a three-month moving average forecast with an exponential smoothing forecast for α = 0.2. Which provides the better forecasts using MSE as the measure of model accuracy? What is the forecast for next month?arrow_forwardWith the 2013 data still on the screen, click the Chart sheet tab. The chart presented shows the rates of return for Global Technology for the last five years. Answer the following questions: a. In 2009, the rate of return on assets exceeded the rate of return on common stockholders equity. Why might this have occurred? Be as specific as possible. b. Is the company better off in 2013 than it was in 2009? Why or why not? When the assignment is complete, close the file without saving it again. Worksheet. Modify the RATIOA4 worksheet to have it compute two additional activity ratios: number of days sales in receivables and number of days sales in merchandise inventory. Use the 2012 and 2013 data and assume a 365-day year. Write out the formulas for your ratios in the spaces provided. Days sales in receivables (average collection period) ________________ Days sales in inventory (average sales period) ________________ Preview the printout to make sure that the worksheet will print neatly, and then print the worksheet. Save the completed file as RATIOAT. Chart. Using the RATIOA4 file, prepare a column chart that compares the acid test and current ratios for Global Technology for 2012 and 2013. Complete the Chart Tickler Data Table and use it as a basis for preparing the chart. Enter all appropriate titles, legends, and formats. Enter your name somewhere on the chart. Save the file again as RATIOA4. Print the chart.arrow_forwardBlake McKenzie Tax Services is a company serving 72 clients (as of the beginning of last month) that is working on reorganizing its balanced scorecard. Currently, the company has the following performance metrics: online client satisfaction rating, client growth percentage (the number of total clients at the beginning of the current month compared to the number of total clients at the beginning of the prior month), market share, and profit margin. The company tracks these metrics from month to month. The companys target client growth percentage is 4% per month. Its target average online client satisfaction rating is 4.8 stars. Last month, the company noted the following data related to these metrics: a. Working together in teams, create strategic objectives that each of the companys four performance metrics might represent. b. Determine whether the company achieved its client growth percentage target last month. c. Suppose that last month, the company received 55 five-star reviews, 10 four-star reviews, 3 three-star reviews, 1 two-star review, and 1 one-star review (some clients did not submit a review). Determine whether the company met its average online client satisfaction rating target. d. Come up with at least one strategic initiative for the strategic objective of any performance metric target that you know the company did not meet last month.arrow_forward
- The president of a small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the cost per unit for the firms leading product over the past eight years: a. Construct a time series plot. What type of pattern exists in the data? b. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. c. What is the average cost increase that the firm has been realizing per year? d. Compute an estimate of the cost/unit for next year.arrow_forwardEvaluate the two departments for Moxie Products. Compare the years performance of the two departments in terms of ROI and RI. Which department has created the most wealth for Moxie shareholders in the past year?arrow_forwardTowson Industries is considering an investment of $496,800 that is expected to generate returns of $150,000 per year for each of the next four years. What is the investment’s internal rate of return? https://openstax.org/books/principles-managerial-accounting/pages/time-value-of-money _________%arrow_forward
- The Martins know that setting up some projected Income Statements are important. They need to look at what the first year of operations might look like and if possible they will need to look at the years thereafter to get an impression of what the long term might look like. RM Purchases: $132,000* (Raw Material Purchases is a part of COGS) Sales Salaries: 80,000 Advertising: 3,000 Travel: 2,000 Revenue: 360,000 Financing Costs: 10,000 Office Lease: 13,000 Depreciation: 38,000 Income Taxes: 22,000 Admin Salary: 40,000 A second financial statement that is key to understanding a business is the Balance Sheet. The Martins have estimated the following accounts to be a part of their initial Balance Sheet. Trade Receivables: $35,000 Cash: 15,000 Short Term Loan: 30,000 Share Capital: 100,000 Long Term Liabilities: 60,000 Property, Plant:…arrow_forwardSuppose the government announces that, based on a just-completed survey, the growth rate in the economy is likely to be 2 percent in the coming year, as compared to 5 percent for the past year. Will securityprices increase, decrease, or stay the same following this announcement? Does it make any difference whether the 2 percent figure was anticipated by the market? Explain.arrow_forwardThe corporate you work for has asked for a summary and report of the future projections for the next 5 years. With the help of the CFO, you have put together the following preliminary figures based on the last year's numbers for a planned production and sales level of 4,000 units per year. Building depreciation $200,000 per year Machine operator $100,000 per year Management staff. $400,000 per year Direct materials $4,000,000/year. Other expenses that seem to vary based on production levels. $3,000,000/year. Other expenses that doesn't seem vary. $1,300,000/year. Selling price per unit. $5,0000/ unit. Utilities. You have the following data to which you pay for the high-low method. .when there is no production, utility costs are $20,000/month. . When production levels reached 4,000 units, unit cost totalled $40,000 per month. 1.calculate the contribution margin per unit. 2. Calculate…arrow_forward
- As an analyst in the valuation team your job is to perform significant financial modeling and analysis. Your company is seeing a new sales strategy that require your input. The strategy will be effective for the upcoming 4 Years. If the company adopts the new strategy, sales will grow at the rate of 15% per year for three years. Other ratios such as: Asset turnover, gross margin, the capital structure and income tax will remain unchanged. However, depreciation would be applicable at 8% of net fixed assets at the starting of the year. Moreover, the target rate of return for the company is 12%. Additional financial information for current year is mentioned below: Income Statement Sales 50,000 Gross Margin (15%) 7,500 Admin., selling and Distribution expenses (7%) 3,500 Profit before tax 10,000 Tax (35%) 3,500 Profit After Taxes 6,500 Balance Sheet Fixed Assets 17,000 Current Assets 12,000 Equity 25,000 Determine…arrow_forwardAs an analyst in the valuation team your job is to perform significant financial modeling and analysis. Your company is seeing a new sales strategy that require your input. The strategy will be effective for the upcoming 4 Years. If the company adopts the new strategy, sales will grow at the rate of 15% per year for three years. Other ratios such as: Asset turnover, gross margin, the capital structure and income tax will remain unchanged. However, depreciation would be applicable at 8% of net fixed assets at the starting of the year. Moreover, the target rate of return for the company is 12%. Additional financial information for current year is mentioned below: Income Statement Sales -50,000 Gross Margin (15%) -7,500 Admin., selling and Distribution expenses (7%) -3,500 Profit before tax -10,000 Tax (35%) -3,500 Profit After Taxes -6,500 Balance Sheet Fixed Assets -17,000 Current Assets -12,000 Equity-25,000 Determine value of business before adoption of new strategy?…arrow_forwardAs an analyst in the valuation team your job is to perform significant financial modeling and analysis. Your company is seeing a new sales strategy that require your input. The strategy will be effective for the upcoming 4 Years. If the company adopts the new strategy, sales will grow at the rate of 15% per year for three years. Other ratios such as: Asset turnover, gross margin, the capital structure and income tax will remain unchanged. However, depreciation would be applicable at 8% of net fixed assets at the starting of the year. Moreover, the target rate of return for the company is 12%. Additional financial information for current year is mentioned below: Income Statement Sales 50,000 Gross Margin (15%) 7,500 Admin., selling and Distribution expenses (7%) 3,500 Profit before tax 10,000 Tax (35%) 3,500 Profit After Taxes 6,500 Balance Sheet Fixed Assets 17,000 Current Assets 12,000 Equity 25,000 Determine…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Financial Projections for Startups Basic Walkthrough; Author: Mike Lingle;https://www.youtube.com/watch?v=7avegQF4dxI;License: Standard youtube license