company is amazon
Excel Project Historical Financial State... D Switch To Light Mode Ove Company Information (Tab 1), and Historical Income Statements, Balance Sheets, and Cash Flows (Tabs 2-4) Instructions - Choose one of the 3 companies listed in you Instructar's. Module I: Week I Excel Projoct Announcement. * Go to the Securities and Exchange Commission's EDGAR database and aceess your chosea coanpany's most recent Form 10-K (annual report). (For help wish this process, sec the Afodile 1: Week \& presentarion, Downloading. Financial Siatements fromit the SEC EDGAR Defabase. ") - Create an Excel workbookn including data for your cbonen company as follows: . The 1s tab (workaheet) in your Financial Statement Analysis Template must be labeled Company Information. The following information mast be included: - Company Name and ticker symbol - Industry - Products or services offered - Major competitors * An ckample of this tab is provided in Exhabit A. o The 2attab in your Financial Statement Analysis Template must be labeled Historical Inceme Statements. - Include the latest thre vequr based on SEC filings. - Enstire that the wotkshect inclades a header with: * Company Name - Financial Statement Name (tncome Statements) * Financial Statement Dates - Denomination level (Ss in millions or. thousands, cte.) 0. The 2ra tab ia your Fiaancial Statement Analysis Template must be labeled Historieal Balance Sheets. - Include the lates threeverre based on SEC (10-K) flings. (Notes Some 1O N s andy provided 2 years of balance sheer data. You mary need to donnlowd the second mand receret 10K for jour: (D) Switch To Light Mode Template must be labeled Historical Balance Shects. - Include the latest direc vear based on SEC(10K) filings. (Nates Some 10-K's anly prosided 2 yours of balance sheet data Yow may merd to donmland the stcond most recent 10K for your compans in orter ro obtain 3 jears of balance sheer data-) - Ensure that the workshcet includes a header with: - Company Name - Financial Statemenir Name - Financial Statement Dates. - Denomination level (\$s in millions of thousands, cte.) - A partial balance shect cxample is provided in Exhibit B. o. The 4a tab in your Financial Statement Analysis Template must be labeled Historical Statement of Cash Flevs., - Include the latest tiree vears based on SEC (10-K) filings. - Make sure that the Income Staterncnt, Balance Sheet, and Cash Flows Statement tie in as follows: - Net Income from Income Statement agroes with Net Iacorme on the Statement of Cash Flows. - Ending Casa Balance from Statement of Cash Flows agrees with Cash in the Balance. Shest. - Enstire that the workshect includes a header with: - Company Name. - Financial Statement Name - Financial Statement Dates - Denomination level (5s in millions or thousands, cte.) ( Oher instructions: - The Exeel workbook should be professionally formatted. Professional formatting includes: - All numbers are formatied similarly. The tise of decimals. commas for thousands, and Excel Project Historical Financial State... (D) Switch To Light Mode , ) - Other instructions: - The Excel workbook should be professionally formatted. Professioal formatting includes: * All numbers are formated similarly, The use of decimals, commas for thousands, and other formatting is consistent. - Dollar signs are included in the firs and last numbers of each column. - Subtotals and totals are preceded by a single underline. Totals are followed by a dowble underline. - All extrancous information is removed from the spreadsheet. Sometimes, files downloeded from the SEC website contains extra characters or other things that need io be deleted. - Line deseriptions are indented bolded in a manner that makes the spreadshect easy to read. - All totals and subtotals sbould be calculated using formulas. For an example of which cells may noed formulas, please see Exhibit B. Notes Your assignment will be checked for origirality via the Turnitin plagiarism tool. Ex A: Example Compavy I F TAB Eximatr B: Example Histokical. Balavce Surtis Tab AMPORTANT NOTE: Over Pernut B Atavce Smert shoun. Yock Bat vere Simer sunotio vectete Liasermes avd Stoexwotbers 'Eotm' As wrich) Excel Project Historical Financial State... D Switch To Light Mode Ove Company Information (Tab 1), and Historical Income Statements, Balance Sheets, and Cash Flows (Tabs 2-4) Instructions - Choose one of the 3 companies listed in you Instructar's. Module I: Week I Excel Projoct Announcement. * Go to the Securities and Exchange Commission's EDGAR database and aceess your chosea coanpany's most recent Form 10-K (annual report). (For help wish this process, sec the Afodile 1: Week \& presentarion, Downloading. Financial Siatements fromit the SEC EDGAR Defabase. ") - Create an Excel workbookn including data for your cbonen company as follows: . The 1s tab (workaheet) in your Financial Statement Analysis Template must be labeled Company Information. The following information mast be included: - Company Name and ticker symbol - Industry - Products or services offered - Major competitors * An ckample of this tab is provided in Exhabit A. o The 2attab in your Financial Statement Analysis Template must be labeled Historical Inceme Statements. - Include the latest thre vequr based on SEC filings. - Enstire that the wotkshect inclades a header with: * Company Name - Financial Statement Name (tncome Statements) * Financial Statement Dates - Denomination level (Ss in millions or. thousands, cte.) 0. The 2ra tab ia your Fiaancial Statement Analysis Template must be labeled Historieal Balance Sheets. - Include the lates threeverre based on SEC (10-K) flings. (Notes Some 1O N s andy provided 2 years of balance sheer data. You mary need to donnlowd the second mand receret 10K for jour: (D) Switch To Light Mode Template must be labeled Historical Balance Shects. - Include the latest direc vear based on SEC(10K) filings. (Nates Some 10-K's anly prosided 2 yours of balance sheet data Yow may merd to donmland the stcond most recent 10K for your compans in orter ro obtain 3 jears of balance sheer data-) - Ensure that the workshcet includes a header with: - Company Name - Financial Statemenir Name - Financial Statement Dates. - Denomination level (\$s in millions of thousands, cte.) - A partial balance shect cxample is provided in Exhibit B. o. The 4a tab in your Financial Statement Analysis Template must be labeled Historical Statement of Cash Flevs., - Include the latest tiree vears based on SEC (10-K) filings. - Make sure that the Income Staterncnt, Balance Sheet, and Cash Flows Statement tie in as follows: - Net Income from Income Statement agroes with Net Iacorme on the Statement of Cash Flows. - Ending Casa Balance from Statement of Cash Flows agrees with Cash in the Balance. Shest. - Enstire that the workshect includes a header with: - Company Name. - Financial Statement Name - Financial Statement Dates - Denomination level (5s in millions or thousands, cte.) ( Oher instructions: - The Exeel workbook should be professionally formatted. Professional formatting includes: - All numbers are formatied similarly. The tise of decimals. commas for thousands, and Excel Project Historical Financial State... (D) Switch To Light Mode , ) - Other instructions: - The Excel workbook should be professionally formatted. Professioal formatting includes: * All numbers are formated similarly, The use of decimals, commas for thousands, and other formatting is consistent. - Dollar signs are included in the firs and last numbers of each column. - Subtotals and totals are preceded by a single underline. Totals are followed by a dowble underline. - All extrancous information is removed from the spreadsheet. Sometimes, files downloeded from the SEC website contains extra characters or other things that need io be deleted. - Line deseriptions are indented bolded in a manner that makes the spreadshect easy to read. - All totals and subtotals sbould be calculated using formulas. For an example of which cells may noed formulas, please see Exhibit B. Notes Your assignment will be checked for origirality via the Turnitin plagiarism tool. Ex A: Example Compavy I F TAB Eximatr B: Example Histokical. Balavce Surtis Tab AMPORTANT NOTE: Over Pernut B Atavce Smert shoun. Yock Bat vere Simer sunotio vectete Liasermes avd Stoexwotbers 'Eotm' As wrich)
