You are reviewing major competitors' net income over the last 5 year period, with a view to understanding and predicting trends in graphic design companies. Company 1 and company 4 are closest geographically to your graphic design company. You want to know if there is a trend over the past five years in the total net income. By dragging and dropping, please RANK the 5 years from LOWEST total net income of companies 1 and 4 combined, to HIGHEST total net income. 1 2 3 4 5 A B 2016 2017 C 2018 E D 2019 2020 ⠀ : ⠀ ⠀

You are reviewing major competitors' net income over the last 5 year period, with a view to understanding and predicting trends in graphic design companies. Company 1 and company 4 are closest geographically to your graphic design company. You want to know if there is a trend over the past five years in the total net income. By dragging and dropping, please RANK the 5 years from LOWEST total net income of companies 1 and 4 combined, to HIGHEST total net income. 1 2 3 4 5 A B 2016 2017 C 2018 E D 2019 2020 ⠀ : ⠀ ⠀

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter3: Data Visualization

Section: Chapter Questions

Problem 20P: The following table shows monthly revenue for six different web development companies. a. Use Excel...

See similar textbooks

Similar questions

The following table shows monthly revenue for six different web development companies. a. Use Excel to create sparklines for sales at each company. b. Which companies have generally decreasing revenues over the six months? Which company has exhibited the most consistent growth over the six months? Which companies have revenues that are both increasing and decreasing over the six months? c. Use Excel to create a heat map for the revenue of the six companies. Do you find the heat map or the sparklines to be better at communicating the trend of revenues over the six months for each company? Why?
Blake 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.
Alpha Milk Corp is considering taking over their competitor, Dana Dairy Products, and asked your consultancy firm to perform financial statement analysis to assess feasibility of this strategic initiative. You are given the following key financial ratios, the firm’s income statement and the balance sheet. You can assume that there are 365 days in a year. a) Using the information provided for 31 Dec 2005, calculate the following: net working capital, current ratio, quick ratio, inventory turnover, average collection period, total debt ratio, gross profit margin, net profit margin, return on total assets, return on equity. b) Evaluate the company’s performance against industry average ratios and compare with last year’s results. To answer, please refer to pictures attached
A five-year earnings summary for Motors, Inc. is presented in the following table. Using this data, construct a single graph of the three earnings measures, and then prepare a memo addressing the following items. What type of graph did you create and why? Present your graphs in your memo. Does there appear to be a relationship among the earnings measures? Explain why or why not. Assess your chart's design in terms of presentation bias. If you feel your chart is free from bias, explain why this is so. Then develop a second chart with the data presented in a manner that might be misleading to a viewer. MOTORS: Earnings Measures, 2008-2012 \table[[Year,2012,2011,2010,2009,200],[\table[[Income],[from],[operations]],5,785,6,450,7,250,6,250,5,975,],[\table[[Net],[income]],4,385,5,300,5,325,4,737,4,529,],[\table[[Net cash],[flow from],[operations]],5,050,8,300,7,700,7,530,5,700,]]
ZNet Co. is a web-based retail company. The company reports the following for the past year. The company’s CEO believes that sales for next year will increase by 20% and both profit margin (%) and the level of average invested assets will be the same as for the past year. 1. Compute return on investment for the past year. 2. Compute profit margin for the past year. 3. If the CEO’s forecast is correct, what will return on investment equal for next year? 4. If the CEO’s forecast is correct, what will investment turnover equal for next year? Sales . $5,000,000 Operating income . $1,000,000 Average invested assets . $12,500,000
The Clothes Clutch, a retail clothier, has had average sales of $400,000 for the last five years, 2018-2022. The firm's total assets at the end of 2020 were $400,000. An internal staff cost analyst has prepared the following financial data from the annual reports. You have been hired as a consultant to help analyze the financial position. 2022 2021 2020 2019 2018 Current Ratio 2.80 2.43 2.36 2.10 2.00 Acid Test Ratio 2.03 1.93 1.82 1.61 1.47 Days' Sales in Receivables 61 58 54 42 35 Merchandise Inventory Turnover 4.20 4.10 4.10 3.90 3.70 Debt Ratio 0.48 0.50 0.49 0.47 0.47 Times Interest Earned 4.60 4.80 5.90 5.70 6.00 Sales as a Percent of 1996 Sales 1.46 1.23 1.12 1.06 1.00 Net Income as a Percent of 1998 Income 1.31 1.20 1.10 1.06 1.00 Gross Profit Margin 38.5% 38.8% 38.9% 40.0% 39.7% Operating Expenses to Net Sales 11.4% 11.3% 11.5% 11.4% 11.7% Net Profit Margin 7.6% 8.6% 8.9% 9.4% 9.3% Return on Total Assets…
Please answer in detail CarniTrin is a manufacturer of Carnival costumes in a highly competitive market. The company's management team is seeking guidance on the use of financial performance measures to identify the key drivers of the company's financial performance and develop a strategy to improve it. The following data relate to the company for the year 2022: In its clothing division, the company has $6,000,000 invested in assets. After-tax operating income from sales of clothing in 2022 is $900,000. Income for the clothing division has grown steadily over the last few years. The cosmetics division has $14,000,000 invested in assets and an after-tax operating income in 2022 of $1,900,000. The weighted-average cost of capital for CarniTrin is 10% and the 2021’s after-tax return on investment for each division was 15%. The general manager of CarniTrin has asserted that in the future, managers should have their compensation structure aligned with their performance measures…
You are analyzing two companies that manufacture electronic toys—Like Games Inc. and Our Play Inc. Like Games was launched eight years ago, whereas Our Play is a relatively new company that has been in operation for only the past two years. However, both companies have an equal market share with sales of $800,000 each. You’ve collected company data to compare Like Games and Our Play. Last year, the average sales for all industry competitors was $2,040,000. As an analyst, you want to make comments on the expected performance of these two companies in the coming year. You’ve collected data from the companies’ financial statements. This information is listed as follows: (Note: Assume there are 365 days in a year.) Data Collected (in dollars) Like Games Our Play Industry Average Accounts receivable 21,600 31,200 30,800 Net fixed assets 440,000 640,000 1,734,000 Total assets 760,000 1,000,000 1,876,800 Using this information, complete the following statements to include in…
You are analyzing two companies that manufacture electronic toys—Like Games Inc. and Our Play Inc. Like Games was launched eight years ago, whereas Our Play is a relatively new company that has been in operation for only the past two years. However, both companies have an equal market share with sales of $200,000 each. You’ve collected company data to compare Like Games and Our Play. Last year, the average sales for all industry competitors was $510,000. As an analyst, you want to make comments on the expected performance of these two companies in the coming year. You’ve collected data from the companies’ financial statements. This information is listed as follows: (Note: Assume there are 365 days in a year.) Data Collected (in dollars) Like Games Our Play Industry Average Accounts receivable 5,400 7,800 7,700 Net fixed assets 110,000 160,000 433,500 Total assets 190,000 250,000 469,200 Using this information, complete the following statements to include in your…
Starborn Company has just been established as a new company to manufacture furniture. The company expects to earn $1 million after-taxes during its first year. The company president has asked for a projected balance sheet based on ratios similar to the industry average. Assuming all sales are made on credit, calculations utilize a 365-day year, and final numbers are rounded to the nearest thousand, prepare a projected balance sheet for Starborn based on the following industry ratios: Current Ratio: 2:1 Quick Ratio: 1:1 Net Profit Margin: 10% Average Collection Period: 20 days Debt Ratio: 40% Total Asset Turnover Ratio: 2 times Current Liabilities/Stockholder's Equity: 20% Create your balance sheet based on the following format: Cash Total Current Liabilities Accounts Receivable Long-term Debt Inventory Total Debt Total Current Assets Stockholder's Equity Net Fixed Assets Total Liabilities and…
Nancy Tercek, the financial vice president, and Margaret Lilly, the controller, of Romine Manufacturing Company are reviewing the financial ratios of the company for the years 2020 and 2021. The financial vice president notes that the profit margin on sales ratio has increased from 6% to 12%, a hefty gain for the 2-year period. Tercek is in the process of issuing a media release that emphasizes the efficiency of Romine Manufacturing in controlling cost. Margaret Lilly knows that the difference in ratios is due primarily to an earlier company decision to reduce the estimates of warranty and bad debt expense for 2021. The controller, not sure of her supervisor's motives, hesitates to suggest to Tercek that the company's improvement is unrelated to efficiency in controlling cost. To complicate matters, the media release is scheduled in a few days. Instructions What, if any, is the ethical dilemma in this situation? Should Lilly, the controller, remain silent? Give reasons. What…
Performance Aid, Inc. has two divisions: Test Preparation and Language Arts. Results (in millions) for the past three years are partially displayed here: Q.Use the DuPont method of profitability analysis to explain changes in the operating-income-to-totalassets ratios over the 2015–2017 period for each division and for Performance Aid as a whole. Comment on the results.