Horngren's Financial & Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780133866292
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 15, Problem 15.28AP
1)
To determine
Vertical analysis: Vertical analysis is prepared to analyze the relationship among various financial statements with a particular base amount. Use the following formula to calculate vertical analysis percentage:
This analysis is otherwise called as common-size statement.
To prepare: A common-size income statement and
Given info: Income statement and balance sheet.
2)
To determine
Company performance and Industry average:
To compare: The company’s profit percentage and financial position with the average for the industry.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Specialty Department Stores chief executive officer (CEO) has asked you to compare the company's profit performance and financial position with the
average for the industry. The CEO has given you the company's income statement and balance sheet, as well as the industry average data for retailers. Assets
\table[[Current assets, %,.71.1%
Indicate in the following chart the most likely source of information for each business decision. Use M for managerial accounting information and F for financial accounting information. Business Decision 1. Determine whether to lend to a company 2. Evaluate a purchasing department’s performance 3. Report financial performance to board of directors . 4. Estimate product cost for a new line of shoes 5. Plan the budget for next quarter . 6. Measure profitability of an individual store 7. Prepare financial reports according to GAAP . 8. Determine location and size for a new plant
Your Task…
Using your assigned financial statements calculate the required ratios below
Indicate if the change from year to year is favorable or unfavorable.
All values should be accurate to at least two decimal places.
The expectation is to submit a professional report free of grammar and spelling errors and easy to read. Think of this as a menu you would be handing to a customer.
All calculations are to be represented.
Analysis of Profitability
Gross Profit Ratio
Operating Profit Ratio
Net Profit Ratio
Sales to Total Assets Ratio
Return on Total Assets
Return on Equity
Earnings Per Share
Chapter 15 Solutions
Horngren's Financial & Managerial Accounting (5th Edition)
Ch. 15 - What part of the Libertys annual report is written...Ch. 15 - Horizontal analysis of Liberty's balance sheet for...Ch. 15 - Vertical analysis of Liberty's balance sheet for...Ch. 15 - Which statement best describes Liberty's acid-test...Ch. 15 - Liberty's inventory turnover during 2017 was...Ch. 15 - Prob. 6QCCh. 15 - Prob. 7QCCh. 15 - Liberty's rate of return on common stockholders'...Ch. 15 - The company has 2,500 shares of common stock...Ch. 15 - Prob. 10AQC
Ch. 15 - What ate the three main ways to analyze financial...Ch. 15 - What is an annual report? Briefly describe the key...Ch. 15 - Prob. 3RQCh. 15 - What is trend analysis, and how does it differ...Ch. 15 - Prob. 5RQCh. 15 - Prob. 6RQCh. 15 - Prob. 7RQCh. 15 - Briefly describe the ratios that can be used to...Ch. 15 - Prob. 9RQCh. 15 - Briefly describe the ratios that can be used to...Ch. 15 - Briefly describe the ratios that can be used to...Ch. 15 - Prob. 12RQCh. 15 - Prob. 13RQCh. 15 - Prob. 14RQCh. 15 - Prob. 15RQCh. 15 - Prob. 15.1SECh. 15 - Performing horizontal analysis McDonald Corp....Ch. 15 - Calculating trend analysis Variline Corp. reported...Ch. 15 - Performing vertical analysis Hoosier Optical...Ch. 15 - Preparing common-size income statement Data for...Ch. 15 - Shine's Companies, a home improvement store chain,...Ch. 15 - Shine's Companies, a home improvement store chain,...Ch. 15 - Shine's Companies, a home improvement store chain,...Ch. 15 - Prob. 15.9SECh. 15 - Prob. 15.10SECh. 15 - Prob. 15.11SECh. 15 - Using ratios to reconstruct a balance sheet...Ch. 15 - Prob. 15.13SECh. 15 - Prob. 15.14SECh. 15 - Prob. 15.15ECh. 15 - Computing trend analysis Grand Oaks Realty's net...Ch. 15 - Prob. 15.17ECh. 15 - Prob. 15.18ECh. 15 - Prob. 15.19ECh. 15 - Prob. 15.20ECh. 15 - Analyzing the ability to pay liabilities Big Bend...Ch. 15 - Analyzing profitability Varsity, Inc.s comparative...Ch. 15 - Prob. 15.23ECh. 15 - Using ratios to reconstruct a balance sheet The...Ch. 15 - Prob. 15.25ECh. 15 - Computing earnings per share Falconi Academy...Ch. 15 - Prob. 15.27APCh. 15 - Prob. 15.28APCh. 15 - Prob. 15.29APCh. 15 - Prob. 15.30APCh. 15 - Using ratios to evaluate a stock investment...Ch. 15 - Prob. 15.32APCh. 15 - Preparing an income statement The following...Ch. 15 - Computing trend analysis and return on common...Ch. 15 - Prob. 15.35BPCh. 15 - Prob. 15.36BPCh. 15 - Determining the effects of business transactions...Ch. 15 - Prob. 15.38BPCh. 15 - Prob. 15.39BPCh. 15 - Prob. 15.40BPCh. 15 - Prob. 15.41CPCh. 15 - Lance Berkman is the controller of Saturn, a dance...Ch. 15 - Prob. 15.1CTEI
Knowledge Booster
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_forwardFinancial information for Lighthizer Trading Company for the fiscal year-ended September 30, 20xx, was collected. As part of a management training session, you have been asked to prepare an income statement format that will be used to distribute to management. Subtotals and totals are included in the information, but you will need to calculate the values. A. In the correct format, prepare the income statement using this information: B. Calculate the profit margin, return on investment, and residual income. Assume an investment base of $42,000 and 8% cost of capital. C. Prepare a short response to accompany the income statement that explains why uncontrollable costs are included in the income statement.arrow_forwardFinancial information for BDS Enterprises for the year-ended December 31, 20xx, was gathered from an accounting intern, who has asked for your guidance on how to prepare an income statement format that will be distributed to management. Subtotals and totals are included in the information, but you will need to calculate the values. A. In the correct format, prepare the income statement using the following information: B. Calculate the profit margin, return on investment, and residual income. Assume an investment base of $100,000 and 6% cost of capital. C. Prepare a short response to accompany the income statement that explains why uncontrollable costs are included in the income statement.arrow_forward
- Choose a company and explain how a specific issue, policy, or procedure (for example, granting merchandise returns, establishing sales prices) might look if the business is structured as a decentralized business.arrow_forwardChoose a company and describe how a specific issue, policy, or procedure (for example, granting merchandise returns, establishing sales prices) might look if the business is structured as a centralized business.arrow_forwardUsing the information provided below from Ben Company prepare two income statements: A normal GAAP Income Statement A CVP Income Statement These Income Statements should be done in good form and in Excel. Include formulas.arrow_forward
- Read and understand the financial statements of Green Valley Merchandising, Compute for the following ratios of the said business entity: 1. Profitability Ratios a) Gross Profit Margin b) Return on Equity c) Return on Assets 2. Leverage Ratio a) Debt-to-Equity 3. Liquidity Ratios a) Current Ratio b) Quick-Asset Ratioarrow_forwardTRUE OR FALSE: Read each sentence carefully and determine whether the statement True or False. Write your answers in the space provided before the number. 1. Financial statement analysis uses computational and analytical techniques to evaluate the company's risks, performance, financial health, and future prospects with the objective of making economic decisions. 2. Return on asset is an operational efficiency ratio. 3. Profitability ratios measure the ability of the company's assets to generate sales. 4. Gross profit margin provides an indication of the company's average pricing policy 5. Given equal gross profit margin, the company with the lower operating income margin has higher operating expenses as a percentage of sales and has leaner operations. Written Works Below are the comparative Statement of Comprehensive Income & Statement of Financial Position of Ellane Company & Lanie Company: Statement of Comprehensive Income Ellane Company 2013 Melanie Company 2014 2013 2014 Net Sales…arrow_forwardIndustry standards for financial statement onalysis: Multiple Choice Are used to compare a company's performance to industry performance. Are based on rules of thumb. Are set by the government. Compare a company's income with its prior year's income. Are based on a single competitor's financial performance.arrow_forward
- For each individual ratio for each company, Your comments for each ratio should include more than just a definition or increase or decrease of the ratio. You should focus on interpreting each ratio numberfor the company and support your comments. Use the ratio results by category to form and support conclusion by Liquidity, Solvency and Profitability. Then use to complete the Overall Conclusion as to the financial results of the company (ratios described in the chapters covered and summarized in Chapter 14 of your textbook). Conclude by stating whether the company is the better employment /investment opportunity and why. Stargel Inc. Comparative Balance Sheet December 31, 20Y2 and 20Y1 20Y2 20Y1 Assets Current assets: Cash $500,000 $400,000 Marketable securities 1,010,000 1,000,000 Accounts receivable (net) 740,000 510,000 Inventories 1,190,000 950,000 Prepaid expenses 250,000 229,000 Total current assets…arrow_forwardHow you can assess the company’s performance with financial ratios? Select any company and analyzes the current situation of financial statements with the help of rations.arrow_forwardHere you will find some income statements and balance sheets for Sears Holdings (SHLD) and Taget Corp (TGT). Assume that you are a financial manager at Sear and want to compare your firm’s situation with that of Target. Calculate represenatative ratios for liquidity, asset management efficiency, financial leverage (capital structure), and profitability for both Sears and Target. How would you summarize the financial performance of Sears compared to target (its benchmark firm)? Include Sears and Targets current ratio, acid-test ratio, average collection period, accounts receivable turnover, inventory turnover, debt ratio, timed interest earned, total asset turnover, fixed asset turnover, gross profit margin, operating profit margin, net profit margin, operating return on assets, and return on equity.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College