Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can anyone help me with this? I'm not sure how its suppose to look in excel. The company I chose was Adobe EXCEL PROJECT: HISTORICAL

can anyone help me with this? I'm not sure how its suppose to look in excel. The company I chose was Adobe
image text in transcribed
EXCEL PROJECT: HISTORICAL FINANCIAL STATEMENTS ASSIGNMENT INSTRUCTIONS OVERVIEW 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 your Instructor's Module 1: Week 1 Excel Project Announcement. . Go to the Securities and Exchange Commission's EDGAR database and access your chosen company's most recent Form 10-K (annual report). (For help with this process, see the Module 1: Week I presentation, "Downloading Financial Statements from the SEC EDGAR Database.") Create an Excel workbook, including data for your chosen company as follows: o The 1 tab (worksheet) in your Financial Statement Analysis Template must be labeled Company Information. The following information must be included: * Company Name and ticker symbol Industry . Products or services offered . . Major competitors An example of this tab is provided in Exhibit A. o The 2nd tab in your Financial Statement Analysis Template must be labeled Historical Income Statements. M Include the latest three years based on SEC filings. Ensure that the worksheet includes a header with: Company Name . Financial Statement Name (Income Statements) Financial Statement Dates . . . . Denomination level (Ss in millions or thousands, etc.). o The 3rd tab in your Financial Statement Analysis Template must be labeled Historical Balance Sheets. Include the latest three years based on SEC (10-K) filings. (Note: Some 10- Ks only provided 2 years of balance sheet data. You may need to download the second most recent 10-K for your company in order to obtain 3 years of balance sheet data) Ensure that the worksheet includes a header with MacBook Air EXCEL PROJECT: HISTORICAL FINANCIAL STATEMENTS ASSIGNMENT INSTRUCTIONS OVERVIEW 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 your Instructor's Module 1: Week 1 Excel Project Announcement. . Go to the Securities and Exchange Commission's EDGAR database and access your chosen company's most recent Form 10-K (annual report). (For help with this process, see the Module 1: Week I presentation, "Downloading Financial Statements from the SEC EDGAR Database.") Create an Excel workbook, including data for your chosen company as follows: o The 1 tab (worksheet) in your Financial Statement Analysis Template must be labeled Company Information. The following information must be included: * Company Name and ticker symbol Industry . Products or services offered . . Major competitors An example of this tab is provided in Exhibit A. o The 2nd tab in your Financial Statement Analysis Template must be labeled Historical Income Statements. M Include the latest three years based on SEC filings. Ensure that the worksheet includes a header with: Company Name . Financial Statement Name (Income Statements) Financial Statement Dates . . . . Denomination level (Ss in millions or thousands, etc.). o The 3rd tab in your Financial Statement Analysis Template must be labeled Historical Balance Sheets. Include the latest three years based on SEC (10-K) filings. (Note: Some 10- Ks only provided 2 years of balance sheet data. You may need to download the second most recent 10-K for your company in order to obtain 3 years of balance sheet data) Ensure that the worksheet includes a header with MacBook Air

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Principles

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

9th Edition

978-0470317549, 9780470387085, 047031754X, 470387084, 978-0470533475

More Books

Students also viewed these Accounting questions