Calculate the current-period financial statement items expressed as a percentage of the base amount for the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Calculate the current-period financial statement items expressed as a percentage of the base amount for the last two years. In other words, use this relationship: Common-Size Percentage = (comparison amount/base amount) NOTE: these fields are formatted as percentages, there is no need to multiply the percent change by 100 to convert the figure to a percentage. 3) For asset accounts, use total assets as the base amount. For liability or equity accounts, use total liabilities and stockholders' equity as the base amount. For income statement accounts, use net sales as the base amount. 4) Reference the raw financial numbers tab and use excel equations to complete this section. NO numbers should be directly typed in. 5) Do NOT google the answer and type it in the box! Doing so will earn ZERO points. Students are being graded both on their ability to use excel as well as their ability to use what they've learned in class to complete this assignment. Table C: Vertical Analysis Autozone, Inc. Income Statement Items Net Income Cost of goods sold Balance Sheet Items Current Assets Property, Plant, and Equipment (net) Current Liabilities Long-term Liabilities Stockholders' Equity 2021 2020 31.40% 13.72% 47.25% 46.40% Company Name Financial Statement Year: Scaler for values 2021 no scaler Autozone, Inc. Table A: Raw Inputs Autozone, Inc. 2021 2020 2019 Balance Sheet Items Cash Short-term Investments* Accounts Receivable Inventory Current Assets 1,171,335 225,763 1,750,815 223,001 378,392 364,774 308,995 4,639,813 4,473,282 4,319,113 6,415,303 6,811,872 Property, Plant, and Equipment (net) 4,856,891 4,509,221 Total Assets Current Liabilities 14,516,199 14,423,872 9,895,913 7,369,754 6,283,091 Long-term Liabilities 8,943,981 9,018,758 Total Liabilities 16,313,735 15,301,849 Stockholders' Equity (1,797,536) (877,977) (1,713,851) Total Liabilities and Stockholders' Equity 14,516,199 14,423,872 Weighted Average Shares Outstanding** 22,799 24,093 25,498 Income Statement Items Net Sales Cost of Goods Sold Gross Profit *** Other Operating Expenses* Net Income Interest Expense 14,629,585 12,631,967 11,863,743 6,911,800 5,861,214 5,498,742 7,717,785 6,770,753 4,773,258 4,353,074 4,148,864 2,170,314 1,732,972 195,337 201,165 578,876 483,542 Income Tax Expense Statement of Retained Earnings Total Cash Dividends Preferred Stock Cash Dividends Common Stock Cash Dividends 0 0 0 0 0 0 Cash Flow Statement Net Cash Provided by Operating Activities 3,518,543 Capital Expenditures (621,767) 2,720,108 (457,736) Other Market Price Per Share 0.01 0.01 * Short term investments are assets that can be readily converted into cash. Examples of these instruments are money market funds and marketable securities. In the current asset section of the balance sheet, these items are usually listed directly after cash if the company has them. ** Weighted average shares outstanding is disclosed at the bottom of the income statement. Be sure to use the "basic" figure rather than the "diluted" figure. *** Other operating expenses refers to the total of all operating expenses, excluding cost of goods sold. Calculate the current-period financial statement items expressed as a percentage of the base amount for the last two years. In other words, use this relationship: Common-Size Percentage = (comparison amount/base amount) NOTE: these fields are formatted as percentages, there is no need to multiply the percent change by 100 to convert the figure to a percentage. 3) For asset accounts, use total assets as the base amount. For liability or equity accounts, use total liabilities and stockholders' equity as the base amount. For income statement accounts, use net sales as the base amount. 4) Reference the raw financial numbers tab and use excel equations to complete this section. NO numbers should be directly typed in. 5) Do NOT google the answer and type it in the box! Doing so will earn ZERO points. Students are being graded both on their ability to use excel as well as their ability to use what they've learned in class to complete this assignment. Table C: Vertical Analysis Autozone, Inc. Income Statement Items Net Income Cost of goods sold Balance Sheet Items Current Assets Property, Plant, and Equipment (net) Current Liabilities Long-term Liabilities Stockholders' Equity 2021 2020 31.40% 13.72% 47.25% 46.40% Company Name Financial Statement Year: Scaler for values 2021 no scaler Autozone, Inc. Table A: Raw Inputs Autozone, Inc. 2021 2020 2019 Balance Sheet Items Cash Short-term Investments* Accounts Receivable Inventory Current Assets 1,171,335 225,763 1,750,815 223,001 378,392 364,774 308,995 4,639,813 4,473,282 4,319,113 6,415,303 6,811,872 Property, Plant, and Equipment (net) 4,856,891 4,509,221 Total Assets Current Liabilities 14,516,199 14,423,872 9,895,913 7,369,754 6,283,091 Long-term Liabilities 8,943,981 9,018,758 Total Liabilities 16,313,735 15,301,849 Stockholders' Equity (1,797,536) (877,977) (1,713,851) Total Liabilities and Stockholders' Equity 14,516,199 14,423,872 Weighted Average Shares Outstanding** 22,799 24,093 25,498 Income Statement Items Net Sales Cost of Goods Sold Gross Profit *** Other Operating Expenses* Net Income Interest Expense 14,629,585 12,631,967 11,863,743 6,911,800 5,861,214 5,498,742 7,717,785 6,770,753 4,773,258 4,353,074 4,148,864 2,170,314 1,732,972 195,337 201,165 578,876 483,542 Income Tax Expense Statement of Retained Earnings Total Cash Dividends Preferred Stock Cash Dividends Common Stock Cash Dividends 0 0 0 0 0 0 Cash Flow Statement Net Cash Provided by Operating Activities 3,518,543 Capital Expenditures (621,767) 2,720,108 (457,736) Other Market Price Per Share 0.01 0.01 * Short term investments are assets that can be readily converted into cash. Examples of these instruments are money market funds and marketable securities. In the current asset section of the balance sheet, these items are usually listed directly after cash if the company has them. ** Weighted average shares outstanding is disclosed at the bottom of the income statement. Be sure to use the "basic" figure rather than the "diluted" figure. *** Other operating expenses refers to the total of all operating expenses, excluding cost of goods sold.
Expert Answer:
Answer rating: 100% (QA)
Income Statement Items Net Income 2021 RAWB30 Net Income for 2021 RAWB29 Net Sales for 2021 1160 370... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation
ISBN: 978-0324302950
6th edition
Authors: Clyde P. Stickney
Posted Date:
Students also viewed these finance questions
-
You have found several items relating to revenue: 1. You see a deposit was made into the company bank account December 15, year1 for $50,000 from Accolades Inc. The amount was a purchase of office...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
1. Can you explain why business majors apparently study less, on average, than students in other majors? 2. Can you explain why business students writing and reasoning skills apparently increase less...
-
Verify that C3 = 11/12A + 11/12B C 5/6D is orthogonal to the C1 and C2 of Case Study 12.4.1. Find SSC3 and illustrate the statement of Theorem 12.4.1.
-
The data set agsrs.dat also contains information on the number of farms in 1987 for the SRS of n = 300 counties from the population of the N = 3078 counties in the United States (see Example 2.5). In...
-
Elsies Muffins makes two types of muffin that are sold to grocery stores: the standard muffin (which comes in various flavours such as carrot, chocolate chip, bran, and apple spice) and the gourmet...
-
Let A be an event that a persons primary method of transportation to and from work is an automobile and B be an event that a persons primary method of transportation to and from work is a bus....
-
Time Limit: 1:00:00 Time Left:0:40:45 Shateria Quince: Attempt 1 Page 1: 1 2 3 5 6 7 8 9 10 11 12 13 14 15 Question 4 (1 point) In an activity-based costing system A) Cost drivers can only be labor...
-
Resolve with excel In determining automobile mileage ratings, it was found that the mpg in the city for a certain model is normally distributed, with a mean of 30 mpg and a standard deviation of 1.0...
-
Calculate the product cost for each of the four tests in accordance with: a . ?The existing costing system b . ?The costing system proposed by Crest, the accountant c . ?The costing system proposed...
-
Refer to the above Table 1. According to the information provided in the table, the 6-month yen is selling at a forward of approximately per annum. (Use the "mid rates" to make your calculations.)
-
Certain genetic mutations have been linked to an increased risk of developing Alzheimer's disease. With the development of CRISPR gene editing technology, could we ethically edit the genes of healthy...
-
(TCOS 1, 2, and 6) What error, if any, is in the following code? public class Test private int num; private void setNum(int n) num = n;
-
Describe the impact of biological factors, aversive events, and learning experiences on aggressive behavior. Describe and explain the bystander effect, and explain altruistic behavior in terms of...
-
Sheryl Company operates a factory in which pickled olives are prepared and packaged. Of course, in making her product, Sheryl must purchase a lot of olives. Sheryl has purchased her olives from the...
-
Distinguish among total-moisture content, free-moisture content, equilibrium-moisture content, unbound moisture, and bound moisture.
-
A Portuguese company imports maize from Mexico, which it in turn exports to Canada. The company pays and is paid at 3 months (the maize is in fact shipped direct from Mexico to Canada). Should it buy...
-
What is a future?
-
What are the differences between OTC forward transactions and futures?
Study smarter with the SolutionInn App