pls, help the Industry is Apple Inc.

Purpose: Use resources available to obtain the MOST RECENT four years of financial statements, specifically the income statement. Prepare summarized corporate income statements using trend analysis and common-size statement techniques. Requirements: Obtain financial statements for the most recent four years for the company you selected. . Where do I find the financial statements? You should already have these from part 2a, but if you need to find them, the best place to find the financial statements is on the EDGAR e website. Be sure you use the 10-K report. Complete the financial analysis spreadsheet based on the information in the financial statements you have obtained. Here is a link to the spreadsheet. Income Statement Spreadsheet NOTE: There are 4 tabs; 1 is instructions and remaining 3 are the condensed income statements that you need to complete. Prepare the Financial Statements: Prepare a multi-step income statement. Condensed means some accounts are grouped into one summarized subtotal, but no numbers are left out of the computations. Each financial statement should total properly. How to Create a Condensed Income Statement Prepare common-size statements and trend analyses for both the income statement. NOTE: There are multiple tabs and you will need to complete ALL of them. A link to the original financial statements must be included. You should place this in the Assignment Comments. Download Office 3652 Submission/Format: Each project needs to be in a single document. An Excel spreadsheet is preferred, but I can also accept a pdf file. Links to the original financial statements must be included in the assignment comments. Use the spreadsheet provided. Do no create your own spreadsheet or change the format. If you do this, it will result in a zero for this assignment. The assignment will close exactly at 11:59 pm on the due date. It is your responsibility to submit the paper by that time. Even if it is only 1 minute late, it will not be accepted. Do not wait until the last minute to submit. You never know what could happen. You will have the opportunity to make revisions for a better grade, but that means you need to submit on time so I can grade the paper and provide feedback A o buc Incom. Home Insert Page Layout Formulas Data Review View X View Only Your account jackelinejimenez@student.hartnell.edu doesn't allow editing on a Mac. To learn more, co A15 X fx Trend Analysis Income Statement D E F G 7 Common-Size Statements 8 1. Click on the box for company name and begin typing the name will be underlined 9 9 2 Make sure to changes to the year you are working with in the titles 10 3 Enter all your information from the Condensed Multi-Step Income Statement into the 11 Common-Size Statements sheet as follows 12 Replace the number 1 in the Net sales boxes with your company's total 13 All other information will replace the cells that have a "0" in them 14 When entered all % values will appear 15 Trend Analysis Income Statement 16 1. Click on the box for company name and begin typing the name will be underlined 17 2 Make sure to changes to the year you are working with in the titles 18 3 Enter all your information from the Condensed Multi-Stem Income Statement into the 19 Trend Analysis Sheet as follows 20 Replace the number 1 in the far right column with your company's figures for that year 21 All other information will replace the cells that have a "0" in them 22 When entered all % values will appear 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 Instructions Condensed Multi-Step IS Common-Size IS Trend Analysis IS + A14 x fx fx Cost of revenues /Cost of goods sold DE F G H I J A B 1 Financial Accounting - ACTG 1-A 2 Financial Analysis Project 3 Financial Analysis Project 4 Condensed Multi-Step Income Statement 5 Company Name: 6 7 7 8 Fiscal year ended: (Most recent year) 9 $ in 000s) 10 11 Revenues / Net Sales Ils S S $ 12 13 $ S S $ S S $ $ $ Cost of revenues /Cost of 14 goods sold 15 16 17 Gross margin IS 18 19 20 Operating expenses IS 21 22 23 Income from operations ls 24 25 Other revenues and 26 expenses IS 27 28 29 Income before income taxls 30 $ S S S S $ $ $ $ 31 32 Income tax expense S S S $ 33 34 Income before 35 nonrecurring items ||S S S $ IS $ S S $ IS $ S $ $ 36 37 38 Nonrecurring items 39 40 41 Net income 42 43 44 45 Earnings per share 46 47 48 49 50 51 IS $ $ $ Purpose: Use resources available to obtain the MOST RECENT four years of financial statements, specifically the income statement. Prepare summarized corporate income statements using trend analysis and common-size statement techniques. Requirements: Obtain financial statements for the most recent four years for the company you selected. . Where do I find the financial statements? You should already have these from part 2a, but if you need to find them, the best place to find the financial statements is on the EDGAR e website. Be sure you use the 10-K report. Complete the financial analysis spreadsheet based on the information in the financial statements you have obtained. Here is a link to the spreadsheet. Income Statement Spreadsheet NOTE: There are 4 tabs; 1 is instructions and remaining 3 are the condensed income statements that you need to complete. Prepare the Financial Statements: Prepare a multi-step income statement. Condensed means some accounts are grouped into one summarized subtotal, but no numbers are left out of the computations. Each financial statement should total properly. How to Create a Condensed Income Statement Prepare common-size statements and trend analyses for both the income statement. NOTE: There are multiple tabs and you will need to complete ALL of them. A link to the original financial statements must be included. You should place this in the Assignment Comments. Download Office 3652 Submission/Format: Each project needs to be in a single document. An Excel spreadsheet is preferred, but I can also accept a pdf file. Links to the original financial statements must be included in the assignment comments. Use the spreadsheet provided. Do no create your own spreadsheet or change the format. If you do this, it will result in a zero for this assignment. The assignment will close exactly at 11:59 pm on the due date. It is your responsibility to submit the paper by that time. Even if it is only 1 minute late, it will not be accepted. Do not wait until the last minute to submit. You never know what could happen. You will have the opportunity to make revisions for a better grade, but that means you need to submit on time so I can grade the paper and provide feedback A o buc Incom. Home Insert Page Layout Formulas Data Review View X View Only Your account jackelinejimenez@student.hartnell.edu doesn't allow editing on a Mac. To learn more, co A15 X fx Trend Analysis Income Statement D E F G 7 Common-Size Statements 8 1. Click on the box for company name and begin typing the name will be underlined 9 9 2 Make sure to changes to the year you are working with in the titles 10 3 Enter all your information from the Condensed Multi-Step Income Statement into the 11 Common-Size Statements sheet as follows 12 Replace the number 1 in the Net sales boxes with your company's total 13 All other information will replace the cells that have a "0" in them 14 When entered all % values will appear 15 Trend Analysis Income Statement 16 1. Click on the box for company name and begin typing the name will be underlined 17 2 Make sure to changes to the year you are working with in the titles 18 3 Enter all your information from the Condensed Multi-Stem Income Statement into the 19 Trend Analysis Sheet as follows 20 Replace the number 1 in the far right column with your company's figures for that year 21 All other information will replace the cells that have a "0" in them 22 When entered all % values will appear 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 Instructions Condensed Multi-Step IS Common-Size IS Trend Analysis IS + A14 x fx fx Cost of revenues /Cost of goods sold DE F G H I J A B 1 Financial Accounting - ACTG 1-A 2 Financial Analysis Project 3 Financial Analysis Project 4 Condensed Multi-Step Income Statement 5 Company Name: 6 7 7 8 Fiscal year ended: (Most recent year) 9 $ in 000s) 10 11 Revenues / Net Sales Ils S S $ 12 13 $ S S $ S S $ $ $ Cost of revenues /Cost of 14 goods sold 15 16 17 Gross margin IS 18 19 20 Operating expenses IS 21 22 23 Income from operations ls 24 25 Other revenues and 26 expenses IS 27 28 29 Income before income taxls 30 $ S S S S $ $ $ $ 31 32 Income tax expense S S S $ 33 34 Income before 35 nonrecurring items ||S S S $ IS $ S S $ IS $ S $ $ 36 37 38 Nonrecurring items 39 40 41 Net income 42 43 44 45 Earnings per share 46 47 48 49 50 51 IS $ $ $