2.99 See Answer

Question: In the Chapter 11 Data Analytics Case,


In the Chapter 11 Data Analytics Case, you used Tableau to examine a data set and create calculations to compare the relative age of two companies’ assets. In this case you continue in your role as an analyst conducting introductory research into the relative merits of investing in one or both of these companies. This time assess the extent to which the companies invest in equity securities on a long-term basis. To do so, you evaluate the percentage of noncurrent assets invested in equity securities. The investments in equity to assets formula is total equity investments/total noncurrent assets.
Required:
Use Tableau to calculate each company’s annual percentage of noncurrent assets invested in equity securities in each year from 2018 to 2021. Based upon what you find, answer the following questions:
1. What is the percentage of noncurrent assets invested in equity securities for (a) Big Store and for (b) Discount Goods in 2021?
2. Comparing the percentage of noncurrent assets invested in equity securities ratios over the most recent four-year period, is Discount Good’s equity investment (a) generally increasing, (b) roughly the same, or (c) generally decreasing from year to year?
3. In general, which company invests the higher amount in equity securities as a percentage of its noncurrent asset during the most recent four-year period?


> On September 30, 2021, Ferguson Imports leased a warehouse. Terms of the lease require Ferguson to make 10 annual lease payments of $55,000 with the first payment due immediately. Accounting standards require the company to record a lease liability when

> Horizon Corporation manufactures personal computers. The company began operations in 2016 and reported profits for the years 2016 through 2019. Due primarily to increased competition and price slashing in the industry, 2020’s income statement reported a

> The birth of the Internet in the 1990s led to the creation of a new industry of online retailers such as Amazon, Overstock.com, and PCM, Inc. Many of these companies often act as intermediaries between the manufacturer and the customer without ever takin

> EDGAR, the Electronic Data Gathering, Analysis, and Retrieval system, performs automated collection, validation, indexing, and forwarding of submissions by companies and others who are required by law to file forms with the U.S. Securities and Exchange C

> An article published in Accounting Horizons describes various techniques that companies use to manage their earnings. Required: In your library, on the Internet, or from some other source, locate the article “How Are Earnings Managed? Evidence from Audit

> Southwest Airlines provides scheduled air transportation services in the United States. Like many airlines, Southwest leases many of its planes from Boeing Company. In its long-term debt disclosure note included in the financial statements for the year e

> Johnson & Johnson is one of the world’s largest manufacturers of health care products. The company’s July 2, 2017, financial statements included the following information in the long-term debt disclosure note: The

> Harvey Alexander, an all-league professional football player, has just declared free agency. Two teams, the San Francisco 49ers and the Dallas Cowboys, have made Harvey the following offers to obtain his services: 49ers: $1 million signing bonus payable

> GlaxoSmithKline Plc. (GSK) is a global pharmaceutical and consumer health-related products company located in the United Kingdom. The company prepares its financial statements in accordance with International Financial Reporting Standards. Below is a por

> The following events occurred during 2021 for various audit clients of your firm. Consider each event to be independent and the effect of each event to be material. 1. A manufacturing company recognized a loss on the sale of investments. 2. An automobile

> Each of the following situations occurred during 2021 for one of your audit clients: 1. An inventory write-down due to obsolescence. 2. Discovery that depreciation expenses were omitted by accident from 2020’s income statement. 3. The u

> On December 31, 2021, Interlink Communications issued 6% stated rate bonds with a face amount of $100 million. The bonds mature on December 31, 2051. Interest is payable annually on each December 31, beginning in 2022. Determine the price of the bonds on

> Access the FASB Accounting Standards Codification at the FASB website (www.fasb.org). Determine each of the following: 1. The topic number (Topic XXX) that addresses exit or disposal cost obligations. 2. The specific eight-digit Codification citation (XX

> Ralph Lauren Corporation is a global leader in the design, marketing, and distribution of premium lifestyle products, including men’s, women’s and children’s apparel. Below are selected financial statements taken from a recent 10-K filing. Required: Use

> Refer to the income statement of The Home Depot, Inc., in Illustration 4–2 of this chapter. Required: 1. Is this income statement presented in the single-step or multiple-step format? 2. What is the company’s approxima

> Rice Corporation is negotiating a loan for expansion purposes and the bank requires financial statements. Before closing the accounting records for the year ended December 31, 2021, Rice’s controller prepared the following financial sta

> The fiscal year-end for the Northwest Distribution Corporation is December 31. The company’s 2021 financial statements were issued on March 15, 2022. The following events occurred between December 31, 2021, and March 15, 2022. 1. On January 22, 2022, the

> The balance sheet and disclosure of significant accounting policies taken from the 2017 annual report of Walmart Stores Inc. appear below. Use this information to answer the following questions: 1. Does Walmart separately report current assets versus lon

> You recently joined the auditing staff of Best, Best, and Krug, CPAs. You have been assigned to the audit of Clearview, Inc., and have been asked by the audit senior to examine the balance sheet prepared by Clearview’s account. Required

> You recently joined the internal auditing department of Marcus Clothing Corporation. As one of your first assignments, you are examining a balance sheet prepared by a staff accountant. In the course of your examination you uncover the following informati

> EDGAR, the Electronic Data Gathering, Analysis, and Retrieval system, performs automated collection, validation, indexing, and forwarding of submissions by companies and others who are required by law to file forms with the SEC. All publicly traded domes

> Refer to Case 2–1 above. Mr. Pitt has relented and agrees to provide you with the information necessary to convert his cash basis financial statements to accrual basis statements. He provides you with the following transaction information for the fiscal

> Refer to the situation described in BE 5–8. What amount did Canliss borrow assuming that the first of the five annual $10,000 payments was not due for three years? Data from BE 5-8: Canliss Mining Company borrowed money from a local bank. The note the c

> You have recently been hired by Davis & Company, a small public accounting firm. One of the firm’s partners, Alice Davis, has asked you to deal with a disgruntled client, Mr. Sean Pitt, owner of the city’s largest hardware store. Mr. Pitt is applying to

> Consider the question of whether the United States should converge accounting standards with IFRS. Required: 1. Make a list of arguments that favor convergence. 2. Make a list of arguments that favor nonconvergence. 3. Indicate your own conclusion regard

> Access the financial statements for the year ended January 28, 2017, for Gap Inc. by downloading them from www.gapinc.com, and use them to answer the following questions. Required: 1. What amounts did Gap Inc. report for the following items for the fisca

> A new client, the Wolf Company, asks your advice concerning the point in time that the company should recognize revenue from the rental of its office buildings under generally accepted accounting principles. Renters usually pay rent on a quarterly basis

> Assume that the FASB is considering revising an important accounting standard. Required: 1. What constraint applies to the FASB’s consideration of whether to require companies to provide new information? 2. In what Concepts Statement is that constraint d

> A friend asks you about whether GAAP requires companies to disclose forecasts of financial variables to external users. She thinks that information could be very useful to investors. Required: 1. What are the two primary qualitative characteristics of ac

> Auditors often earn considerable fees from a company for examining (auditing) its financial statements. In addition, it’s not uncommon for auditors to earn additional fees from the company by providing consulting, tax, and other advisory services. Requir

> One of your friends is a financial analyst for a major stock brokerage firm. Recently she indicated to you that she had read an article in a weekly business magazine that alluded to the political process of establishing accounting standards. She had alwa

> The purpose of this case is to introduce you to the information available on the website of the Securities and Exchange Commission (SEC) and its EDGAR database. Required: Access the SEC home page on the Internet. The web address is www.sec.gov. Answer th

> The purpose of this case is to introduce you to the information available on the website of the International Accounting Standards Board (IASB). Required: Answer the following questions. 1. The IASB has how many board members? 2. In what city is the IASB

> Refer to the situation described in BE 4–8. Assume instead that the estimated fair value of the segment’s assets, less costs to sell, on December 31 was $7 million rather than $10 million. Prepare the lower portion of the 2021 income statement beginning

> In prior chapters, you applied Tableau to examine a data set and create calculations to compare two companies’ financial information. In this case, you continue in your role as an analyst conducting introductory research into the relative merits of inves

> In prior chapters, you applied Tableau to examine a data set and create calculations to compare two companies’ financial information. In this case, you continue in your role as an analyst conducting introductory research into the relative merits of inves

> To prepare for this case, you will need to download Tableau to your computer. If you have not completed any of the prior data analytics cases, follow the instructions listed in the Chapter 1 Data Analytics case to get set up. You will need to watch the v

> In the Chapter 1 and Chapter 2 Data Analytics Cases, you applied Tableau to examine a data set and create charts to compare our two (hypothetical) publicly traded companies: Discount Goods and Big Store. In this case, you continue in your role as an anal

> In the Chapter 1 Data Analytics Case, you applied Tableau to examine a data set and create bar charts to compare ten-year trends in operating cash flows and net income for our two (hypothetical) publicly traded companies: Discount Goods and Big Store. In

> This case introduces you to data analysis in a very basic way by allowing you to quickly extract, visualize, and compare financial data over a span of ten years for two (hypothetical) publicly traded companies: Discount Goods and Big Store. For this case

> In the Data Analytics Cases in previous chapters, we applied Tableau to examine two (hypothetical) publicly traded companies: GPS Corporation and Tru, Inc. regarding various aspects of their earnings performance and financial position. In this case, you

> In the Data Analytics Cases in the previous chapter, you used Tableau to examine two (hypothetical) publicly traded companies: GPS Corporation and Tru, Inc. regarding the return on stockholders’ equity. This time, you investigate two aspects of the relat

> In the Data Analytics Cases in the previous chapter, you used Tableau to examine two (hypothetical) publicly traded companies: GPS Corporation and Tru, Inc. regarding changes in the funded status of their pension plans during the previous ten years as we

> In the Data Analytics Cases in the previous chapter, you used Tableau to examine a data set and create charts to examine two (hypothetical) publicly traded companies: GPS Corporation and Tru, Inc., to examine the effect of the Tax Cuts and Jobs Act of 20

> Refer to the situation described in BE 4–7. Assume that the semiconductor segment was not sold during 2021 but was held for sale at year-end. The estimated fair value of the segment’s assets, less costs to sell, on December 31 was $10 million. Prepare th

> In the Data Analytics Cases in the previous chapter, you used Tableau to examine a data set and create charts to examine two (hypothetical) publicly traded companies: GPS Corporation and Tru, Inc. as to their pattern of leasing facilities, their transiti

> In the Data Analytics Cases in prior chapters, you used Tableau to examine a data set and create charts to compare two (hypothetical) publicly traded companies, Big Store and Discount Goods. In this chapter, you will examine GPS Corporation and Tru, Inc.

> In the Chapter 13 Data Analytics Cases, you used Tableau to examine a data set and create charts to compare our two (hypothetical) publicly traded companies: Discount Goods and Big Store as to their liquidity - their ability to pay short-term debts as th

> In the Chapter 3 Data Analytics Cases, you used Tableau to examine a data set and create charts to compare our two (hypothetical) publicly traded companies, Discount Goods and Big Store, as to their liquidity - their ability to pay short-term debts as th

> In the Chapter 10 Data Analytics Case, you used Tableau to examine a data set and create calculations to compare two companies’ fixed-asset turnover. In this case you continue in your role as an analyst conducting introductory research into the relative

> In the Chapter 3 Data Analytics Case, you applied Tableau to examine a data set and create calculations to compare two companies’ profitability. For the case in this chapter, you continue in your role as an analyst conducting introductory research into t

> In this case you are seeking to gain insight into the relative demand for the company’s products in various regions of the country and various states in which it sells. Your focus is on assessing the company’s inventory management relative to regional an

> In prior chapters, you used Tableau to examine a data set and create calculations to compare two companies’ financial information. In this case you are seeking to gain insight into the relative profitability of a company in various regions of the country

> Air France-KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are provided in Connect. This ma

> On December 31, 2021, the end of the fiscal year, California Microtech Corporation completed the sale of its semiconductor business for $10 million. The semiconductor business segment qualifies as a component of the entity according to GAAP. The book val

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material also is available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are available in Connect. This m

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material also is available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are provided in Connect. This ma

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material is also available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are available in Connect. This m

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material is also available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are available in Connect. This m

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material is also available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are available in Connect. This m

> On December 31, 2021, the end of the fiscal year, Revolutionary Industries completed the sale of its robotics business for $9 million. The robotics business segment qualifies as a component of the entity according to GAAP. The book value of the assets of

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material also is available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are available in Connect. This m

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material also is available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are available in Connect. This m

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material also is available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are available in Connect. This m

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material is also available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are available in Connect. This m

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material is also available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are available in Connect. This m

> The following are partial income statement account balances taken from the December 31, 2021, year-end trial balance of White and Sons, Inc.: restructuring costs, $300,000; interest revenue, $40,000; before-tax loss on discontinued operations, $400,000;

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material also is available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF‘s financial statements and disclosure notes for the year ended December 31, 2017, are available in Connect. This m

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material also is available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are available in Connect. This m

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material is also available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are available in Connect. This m

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material is also available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are available in Connect. This m

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material is also available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are available in Connect. This m

> Refer to the facts described in BE 4–16. Show the DuPont framework’s calculation of the three components of the 2021 return on equity for Anderson TV and Appliance. Data from BE 4-16: The 2021 income statement for Anderson TV and Appliance reported net

> On July 1, 2021, Apache Company, a real estate developer, sold a parcel of land to a construction company for $3,000,000. The book value of the land on Apache’s books was $1,200,000. Terms of the sale required a down payment of $150,000 and 19 annual pay

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material is also available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are available in Connect. This m

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material also is available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are available in Connect. This m

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material also is available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are available in Connect. This m

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material is also available under the Investor Relations li

> Air France–KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are provided in Connect. This ma

> Target Corporation prepares its financial statements according to U.S. GAAP. Target’s financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This material is also available under the Investor Relations li

> Air France-KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF’s financial statements and disclosure notes for the year ended December 31, 2017, are provided in Connect. This ma

> The 2021 income statement for Anderson TV and Appliance reported net sales of $420,000 and net income of $65,000. Average total assets for 2021 was $800,000. Shareholders’ equity at the beginning of the year was $500,000, and $20,000 was paid to sharehol

2.99

See Answer