Financial Reporting, Financial Statement Analysis and Valuation
8th Edition
ISBN: 9781285190907
Author: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 10, Problem 9PC
The Home Depot is a leading specialty retailer of hardware and home improvement products and is the second-largest retail store chain in the United States. It operates large warehouse-style stores. Despite declining sales and difficult economic conditions in 20X1 and 20X2, The Home Depot continued to invest in new stores. The following table provides summary hypothetical data for The Home Depot.
REQUIRED
- a. Use the preceding data for The Home Depot to compute average revenues per store, capital spending per new store, and ending inventory per store in 20X2.
- b. Assume that The Home Depot will add 100 new stores by the end of Year +1. Use the data from 20X2 to project Year +1 sales revenues, capital spending, and ending inventory. Assume that each new store will be open for business for an average of one-half year in Year +1. For simplicity, assume that in Year +1, Home Depot’s sales revenues will grow, but only because it will open new stores.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Kate is considering expanding and bringing in several employees. To do this she will need a larger facility and to purchase more equipment. Which means additional financing. Answer this: look at the financial statements as if you were a banker considering her for a loan comment on your findings and use calculations to support your answer.
Identify the activity ratio of a computer shop is its Cost of Goods Sold is P12 million and the Average Inventory is P24 million. Analyze and interpret your answer.
Compute the return on investment of AR Grocery Store if the net profit after taxes is P10 million and its total assets is P100 million. Analyze and interpret your answer.
A growing chain is trying to decide which store location to open. The first location (A) requires a $500,000 investment in average
assets and is expected to yield annual income of $70,000. The second location (B) requires a $200,000 investment in average assets
and is expected to yield annual income of $46,000.
(1) Compute the expected return on investment for each location.
(2) Using return on investment, which location (A or B) should the company open?
Complete this question by entering your answers in the tabs below.
Required 1
Required 2
Compute the expected return on investment for each location.
Location A
Location B
Numerator
Return on Investment
Denominator
ROI
Required 2 >
Chapter 10 Solutions
Financial Reporting, Financial Statement Analysis and Valuation
Ch. 10 - Prob. 1QECh. 10 - The chapter encourages analysts to develop...Ch. 10 - Prob. 3QECh. 10 - Suppose you are analyzing a firm that is...Ch. 10 - Use the following hypothetical data for Walgreens...Ch. 10 - Prob. 6QECh. 10 - Prob. 7QECh. 10 - Prob. 8QECh. 10 - The Home Depot is a leading specialty retailer of...Ch. 10 - Prob. 10PC
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- Use the following information to answer the questions that follow. A. Calculate the operating income percentage for each of the stores. Comment on how your analysis has changed for each store. B. Perform a vertical analysis for each store. Based on your analysis, what accounts would you want to investigate further? How might management utilize this information? C. Which method of analysis (using a dollar value or percentage) is most relevant and/or useful? Explain.arrow_forwardAnswer this without using Excel format please.arrow_forwardThe new chief executive officer (CEO) of Richard Manufacturing has asked for a variety of information about the operations of the firm from last year. The CEO is given the following information, but with some data missing: (Click the icon to view the variety of operations information.) Read the requirements, Requirement 1. Find (a) total sales revenue, (b) selling price, (c) rate of return on investment, and (d) markup percentage on full cost for this product. (a) The total sales revenue is (Round your answer to the nearest cent.) (b) The selling price per unit is (Round the retum on investment to the nearest whole percent, X%.) (c) The rate of return on investment is (d) Calculate the markup percentage on full cost for this product. (Round your intermediary calculations to the nearest cent and the markup to the nearest hundredth percent XXX%) The markup percentage on full cost for this product is Requirement 2. The new CEO has a plan to reduce fixed costs by $200,000 and variable…arrow_forward
- A growing chain is trying to decide which store location to open. The first location (A) requires a $500,000 investment in average assets and is expected to yield annual income of $70,000. The second location (B) requires a $200,000 investment in average assets and is expected to yield annual income of $40,000. (1) Compute the expected return on investment for each location. (2) Using return on investment, which location (A or B) should the company open? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compute the expected return on investment for each location. Location A Location B Return on Investment Numerator Denominator ROIarrow_forwardSuppose that you have been given a summer job as an intern at Issac Aircams, a company that manufactures sophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which is privately owned, has approached a bank for a loan to help finance its growth. The bank requires financial statements before approving the loan. Required: Classify each cost listed below as either a product cost or a period cost for the purpose of preparing financial statements for the bank. Costs 1. Depreciation on salespersons' cars. 2. Rent on equipment used in the factory. 3. Lubricants used for machine maintenance. 4. Salaries of personnel who work in the finished goods warehouse. 5. Soap and paper towels used by factory workers at the end of a shift. 6. Factory supervisors' salaries. 7. Heat, water, and power consumed in the factory. 8. Materials used for boxing products for shipment overseas. (Units are not normally boxed.) 9. Advertising costs. 10. Workers' compensation…arrow_forwardSuppose that Demont has been given a summer job as an intern at Isaac Aircams, a company that manufactures sophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which is privately owned, has approached a bank for a loan to help it finance its growth. The bank requires financial statements before approving such a loan. Classify each cost listed below as either product costs or period costs for the purpose of preparing the financial statements for the bank. Costs Product Cost/Period Cost 1. Depreciated on salesperson's cars 2. Rent on equipment used in the factory 3. Lubricants used for machine maintenance 4. Salaries of personnel who work in the finished goods warehouse 5. Soap and paper towels used by factory workers at the end of a shiftarrow_forward
- Can you help me with this question? Thank you for your help and time :)arrow_forwardFitness Fanatics is a regional chain of health clubs. The managers of the clubs, who have authority to make investments as needed, are evaluated based largely on return on investment (ROI). The company's Springfield Club reported the following results for the past year: Sales Net operating income Average operating assets 720,000 $ 12,240 $ 100,000 The following questions are to be considered independently. Assume that the manager of the club is able to increase sales by $72,000 and that, as a result, net operating income increases by $5.184. Further assume that this is possible without any increase in average operating assets. What would be the club's return on investment (ROI)?arrow_forwardZNet 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,000arrow_forward
- Suppose that you have been given a summer job as an intern at Issac Aircams, a company that manufactures sophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which is privately owned, has approached a bank for a loan to help finance its growth. The bank requires financial statements before approving the loan. Required: Classify each cost listed below as either a product cost or a period cost for the purpose of preparing financial statements for the bank. × Answer is complete but not entirely correct. Costs Product Cost / Period Cost Period Cost Product Cost 1. Depreciation on salespersons' cars. 2. Rent on equipment used in the factory. 3. Lubricants used for machine maintenance. 4. Salaries of personnel who work in the finished goods warehouse. 5. Soap and paper towels used by factory workers at the end of a shift. 6. Factory supervisors' salaries. 7. Heat, water, and power consumed in the factory. 8. Materials used for boxing products for…arrow_forwardFitness Fanatics is a regional chain of health clubs. The managers of the clubs, who have authority to make investments as needed, are evaluated based largely on return on investment (ROI). The company's Springfield Club reported the following results for the past year: Sales $ 780,000 Net operating income $ 17,940 Average operating assets $ 100,000 The following questions are to be considered independently. 2. Assume that the manager of the club is able to increase sales by $78,000 and that, as a result, net operating income increases by $6,084. Further assume that this is possible without any increase in average operating assets. What would be the club's return on investment (ROI)? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Return on investment (ROI) %arrow_forwardPlease 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…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License