Ay 1. Using your financial analysis of Gap Clothing company, Refer to the Annual Reports located in the Class Resources. You will use information in the Form 10-K to complete this assignment. Using the correct formulas and a separate tab for each analysis, calculate the following ratios using Microsoft Excel: Three liquidity ratios for the past 2 years Three solvency ratios for the past 2 years Three profitability ratios for the past 2 years

Ay 1. Using your financial analysis of Gap Clothing company, Refer to the Annual Reports located in the Class Resources. You will use information in the Form 10-K to complete this assignment. Using the correct formulas and a separate tab for each analysis, calculate the following ratios using Microsoft Excel: Three liquidity ratios for the past 2 years Three solvency ratios for the past 2 years Three profitability ratios for the past 2 years

Financial Accounting: The Impact on Decision Makers

10th Edition

ISBN:9781305654174

Author:Gary A. Porter, Curtis L. Norton

Publisher:Gary A. Porter, Curtis L. Norton

Chapter13: Financial Statement Analysis

Section: Chapter Questions

Problem 13.1DC

See similar textbooks

Similar questions

Assignment 1 : Select a company. It is advised to choose the organization ( if it is listed ) where you are employed for this assignment. If your organization is not listed you may choose any other listed company from your industry or related industry. · Download last 3 years annual report. · Compute the financial ratios for last 3 years and see the trend [ Profitability ratios, Liquidity ratios, Activity Ratios, Financing Ratios, and Market Ratios ] . You need to do this exercise on an excel file. · Provide explanation on the strategic implications of these ratios on your company ’ s financial standing and strategy. You may explain in 2 - 3 lines for each category of ratios. [ Profitability ratios, Liquidity ratios, Activity Ratios, Financing Ratios, and Market Ratios ] . Use the same company as the one mentioned in Assignment 1 . • Part A: Strategic Analysis • Conduct a strategic analysis using PESTLE and Porter ’ s 5 forces tools for understanding the…
The following are financial ratios for the company. You are required to answer the following questions. Year 5 Year 6 Year 7 ROA 2.87% 2.60% 4.13% Profit Margin 3.2% 2.9% 3.1% Assets Turnover 0.90 0.88 0.99 Accounts receivable Turnover 6.2 11.5 118.4 Inventory Turnover 6.1 6.0 5.8 Fixed Assets Turnover 1.3 1.4 1.5 collection period 58.6 31.7 3.1 inventory period 59.6 60.9 62.5 %change in sales 7.66% 9.68% 1. Explain the decrease in ROA between year 5 and year 6? And the increase between year 5 and 6?
The following are financial ratios for the company. You are required to answer the following questions. Year 5 Year 6 Year 7 ROA 2.87% 2.60% 4.13% Profit Margin 3.2% 2.9% 3.1% Assets Turnover 0.90 0.88 0.99 Accounts receivable Turnover 6.2 11.5 118.4 Inventory Turnover 6.1 6.0 5.8 Fixed Assets Turnover 1.3 1.4 1.5 collection period 58.6 31.7 3.1 59.6 60.9 62.5 inventory period %change in sales 7.66% 9.68% Between year 5 and 6, the increase in cost of goods sold and the decrease in inventory turnover is an indication of what? Provide evidence to your answer.
Use the following selected data from Business Solutions's income statement for the three months ended March 31, 2022, and from its Complete this question by entering your answers in the tabs below. March 31, 2022, balance sheet to complete the requirements. Computer services revenue Net sales (of goods) Total sales and revenue Cost of goods sold. Net income Quick assets Current assets Total assets Current liabilities Total liabilities. Total equity Required 1 Required: 1. Compute the gross margin ratio (both with and without services revenue) and net profit margin ratio. 2. Compute the current ratio and acid-test ratio. 3. Compute the debt ratio and equity ratio. 4. What percent of its assets are current? What percent are long term? Required 2 Complete this question by entering your answers in the tabs below. $ 25,307 18,693 44,000 Required 3 Gross margin ratio Net profit margin ratio 14,052 18,833 90,924 95,568 120,268 875 875 119,393 % Compute the gross margin ratio (both with and…
Question 1 Mabel is a potter and sells her pottery at stalls that she rents in four tourist information centres across the south of England. Extracts from her financial statements for the years ended 31 December 2021 and 2020 are shown below. Statement of profit or loss for the year ended 31 December: 2021 28,900 |(16,500) 12,400 (3,800) 8,600 |(4,000) 4,600 2020 Revenue 27,200 (14,000) 13,200 (3,600) 9,600 Cost of sales Gross profit Operating expenses Operating profit Non-operating expenses Net profit 9,600 Statement of financial position as at 31 December: 2021 Non-current assets Current assets Total assets 22,660 4,360 27,020 2020 20,920 3,750 24,670 Equity Non-current liabilities Current liabilities Equity and liabilities 20,940 3,000 3,080 27,020 16,340 3,500 4,830 24,670 The following information is also relevant: In July 2021 the rent on one of Mabel's stalls was increased significantly for the third time in three years so she decided not to renew the annual contract. She sold…
The financial statements for Royale and Cavalier companies are summarized here: Cavalier Royale Company Company Balance Sheet $ 31,000 61,000 122,000 562,000 146,000 $ 51,000 22,000 37,000 172,000 52,000 Cash Accounts Receivable, Net Inventory Equipment, Net Other Assets $ 922,000 $ 334,000 $ 27,000 67,000 216,000 10,000 14,000 $ 334,000 Total Assets $ 132,000 202,000 486,000 56,000 Current Liabilities Notes Payable (long-term) Common Stock (par $20) Additional Paid-In Capital Retained Earnings 46,000 Total Liabilities and Stockholders' Equity $ 922,000 Income Statement $ 818,000 $ 298,000 156,000 101,000 Sales Revenue Cost of Goods Sold 486,000 246,000 Other Expenses $ 86,000 $ 41,000 Net Income Other Data $ 18.00 $ 15.00 Per share price at end of year Selected Data from Previous Year Accounts Receivable, Net Notes Payable (long-term) Equipment, Net Inventory Total Stockholders' Equity $ 53,000 202,000 562,000 101,000 588,000 $ 20,000 67,000 172,000 44,000 240,000 These two companies…
The financial statements of Dandy Distributors Ltd. are shown on the "Fcl. Stmts." page. 1 Based on Dandy's financial statements, calculate ratios for the year ended December 31, 2020. Assume all sales are on credit. Show your work. 2 From these ratios, analyze the financial performance of Dandy.
In the provided income statement image, can you plz calculate the profitability ratios: Gross Profit Margin for the 3 years (2021, 2020, 2019) and Profit Margin for 3 years) and could you discuss and explain the gross profit margin and profit margin and overall the company's profitability (or lack thereof). also please can you show your calculations for the 3 years for each ratio
Alex is currently considering to invest his money in one of the companies betweenCompany A and Company B. The summarized final accounts of the companies for theirlast completed financial year are as follows: (refer to the images) Required:a. Calculate the following ratios for Company A and Company B. State clearly theformulae used for each ratio:i. Gross Profit Marginii. Net Profit Marginiii. Inventory Turnover Period (days)iv. Receivables Collection Period (days)v. Payables Payment Period (days)vi. Current Ratiovii. Quick Ratiob. Comment on each of the ratios calculated in part (a) above.
Rick's Travel Service has asked you to help piece together financial information on the firm for the most current year. Managers give you the following information: sales are $7.4 million, total debt is $2.00 million, debt ratio is 35 percent, and ROE is 17.1 percent. Using the above information, calculate Rick's ROA. Note: Round your answer to 2 decimal places. ROA %
Required: Compute the following: (For Requirements 1 to 4, enter your percentage answers rounded to 2 decimal places (i.e., 0.1234 should be entered as 12.34).) 1. Gross margin percentage. 2. Net profit margin percentage. 3. Return on total assets. 4. Return on equity. 5. Was financial leverage positive or negative for the year? 1. Gross margin percentage % 2. Net profit margin percentage % 3. Return on total assets % 4. Return on equity % 5. Financial Leverage
SPREADSHEET DIRECTIONS: Apple Inc. wants to conduct a comparative Ratio Analysis of their last 2 years to reveal insight into their profitability, liquidity, solvency, and operational efficiency. Utilize the provided Ratios to complete the Analysis. Utilize the APPLE Income Statement, APPLE Balance Sheet, APPLE Cash Flow Statement Spreadsheets and the Ratio Equations to complete the missing colored cells. spreadsheet https://docs.google.com/spreadsheets/d/1PMxi_-pVCN3FvbeCZTQ7q9caeDtA1x1x/edit?usp=sharing&ouid=103368527338324517598&rtpof=true&sd=true