Need FSAP for Amazon based on the MBA 560 notes attached.

Ford Motor Company Statements of Financial Position As of December 31, 2016 2016 CURRENT ASSETS: Cash and cash equivalents Marketable securities Financial Services finance receivables, net Trade and other receivables, less allowances Inventories Other assets Total Current Assets $ LONG-TERM ASSETS: Financial Services finance receivables, net Net investment in operating leases Net property Equity in net assets of affiliated companies Deferred income taxes Other assets Less: Accumulated Depreciation Total Long-Term Assets TOTAL ASSETS LIABILITIES: Payables Other liabilities and deferred revenue Automotive debt payable within one year Financial Services debt payable within one year Total Current Liabilities 2015 15,905 22,922 46,266 11,102 8,898 3,368 108,461 $ 0 $ 108,461 $ 2014 14,272 20,904 45,137 11,042 8,319 2,913 102,587 $ 0 0 $ 102,587 $ 0 0 $ 0 $ 0 0 Other liabilities and deferred revenue Automotive long-term debt Financial Services long-term debt Deferred income taxes TOTAL LIABILITIES Redeemable noncontroling interest EQUITY Capital stock Common Stock, par value $.01 per share Class B Stock, par value $.01 per share Capital in excess of par value of stock Retained earnings Accumulated other comprehensive income/(loss) Treasury stock Total equity attributable to Ford Motor Company Equity attributable o noncontrolling interests Total equity TOTAL LIABILITIES AND MEMBER'S EQUITY $ 0 $ 0 $ 0 Ford Motor Company Statements of Operations For the Year Ended December 31, 2016 2016 Revenues Automotive Financial Services Other Total Revenues Costs and expenses Cost of sales Selling, administrative, and other expenses Financial Services interest, operating, and other expenses Total costs and expenses $ 141,546 10,253 1 151,800 $ 126,584 12,196 8,904 147,684 Interest expense on Automotive debt 894 Non-Financial Services interest income and other income/(loss), net Financial Services other income/(loss), net Equity in net income of affiliated companies Income before income taxes 1,356 438 1,780 6,796 Provision for/(Benefit from) income taxes Net income 2,189 4,607 Less: Income/(Loss) attributable to noncontrolling interests Net income attributable to Ford Motor Company $ 11 4,596 016 2015 2014 $ 140,566 8,992 0 149,558 $ 135,782 8,295 0 144,077 $ 124,041 10,502 7,368 141,911 $ 125,025 11,842 6,878 143,745 $ 773 797 1,188 372 1,818 10,252 76 348 1,275 1,234 2,881 7,371 4 1,230 (2) 7,373 $ (1) 1,231 MBA 560 Instructor Notes Examples of Projects A. Financial Statement Analysis Project (pages 2-3) B. Financial Statement Analysis Presentation (pages 4-5) 1 A MBA 560 Financial Statement Analysis Project As a group of 2 you are to act as a financial advisor to a client interested in investing in a particular industry. Your group of 2 will research 2 separate companies in the same industry (1 person per company) and provide a recommendation to your client which company, if any, he/she should invest in. Some possible industries include: Industry Airline Fast Food Search Engine Pharmaceutical Auto Retail Beverage Companies American/Southwest Airlines/United Wendy's/McDonalds Google/Yahoo Merck/Pfizer/Bristol Myers Squibb Ford/GM Gap/Guess/Abercrombie Coca Cola/Pepsi Or you may select other companies or another industry. Each person in the class must select a different company. Companies must be public companies. PART A: Obtain Financial Statements Obtain 3 years of financial statements (just the Balance Sheet and Income Statement) for your company from SEC.GOV. 3 BALANCE SHEETS AND 3 INCOME STATEMENTS will be submitted. One set per company. PART B: Enter data into FSAP (Financial Statement Analysis Package) Enter the Balance Sheet and Income Statement amounts for 4 years into the Financial Statement Analysis Package Excel file (just the Balance Sheet and Income Statement information, not the Statement of Cash Flows). Make sure your balance sheet BALANCES!!!! Make sure your Net Income matches your Net Income on the Income Statement. Email one FSAP per company. PART C: Company Analysis Focus more on their position within the industry, recent developments, fluctuation in stock prices relative to the market/industry, and other items of significance that would impact your investment decision. Legal issues facing the company. New markets and new products. DO NOT WRITE ABOUT THE HISTORY OF THE COMPANY (1 page - single spaced). Submit 1 paper per company. 2 PART D: Industry Analysis Summarize the economic outlook for your industry. Look at recent market activity, recent indicators impacting your industry. Address recent change in stock prices. Obtain industry averages for your ratio and common size analysis. Identify laws/regulations impacting your industry. Identify market trends and geo/political events impacting your industry. Identify Micro/Macro economic conditions impacting your industry. DO NOTE WRITE ABOUT YOUR INDIVIDUAL COMPANIES. (1 page - single spaced). Submit 1 paper per industry. Data sources: Standard and Poor's Stock Reports or other Industry Surveys, Mergent's Industry Review. Finance.yahoo.com, moneycentral,msn.com, hoovers.com, and other financial websites. Examine recommendations of other investment websites (buy/sell/hold). PART E: FINAL PAPER A. Include Company Analysis (address prior comments) B. Include Industry Analysis (address prior comments) C. Include FSAP summary - Create tables summarizing the analysis tab of your FSAP. Make it look professional. D. Write a summary of the significant findings from the financial statement analysis. (1 single spaced page). Address significant (Focus on the 2-4 items under each) Ratios, Horizontal Analysis, and Common Sized Analysis from the FSAP (look under the Analysis Tab). Do not address all the ratios and every line of vertical and horizontal analysis, just what you feel is important. E. Based on your findings and after reading the other papers in your group, which company, if any, would you invest in? Include specific support for your decision based on your findings in the analysis. Also include support (for or against) investing in the industry you chose. GRADING DO NOT COPY, DO NOT PLAGIARIZE, CITE APPROPRIATELY!! USE APA Final paper will be submitted to turnitin.com Due PART A - Financial Statements PART B - FSAP PART C - Company Analysis PART D - Industry Analysis (2 Companies submit one) PART E FINAL ESSAY - Analysis using Ratio, Common Sized, and Vertical Analysis - Decision % 15% 15% 15% 15% 40% 3 B. Financial Statement Analysis Presentation: For the presentation, you will get into groups of 3 to 5 team members. You will then select two companies from the same industry on which you will perform financial statement analysis. You will then present your findings, including an overview of the companies, on the last day of classes. Presentation Rubric Evaluating Student Presentations Department of Accounting, Business Information Systems, and Marketing Unacceptable Acceptable 0-3 4-7 Exem Criteria 8- 1) Introduction Student does not introduce topic and offers no components for discussion. Student introduces topic and begins presenting but does not clearly state all variables for discussion. Student completely in clearly states 3 to 4 c discussion. 2) Organization Audience cannot understand presentation because there is no sequence of information. Student presents all components but not in a logical sequence (audience has some difficulty following presentation). Student presents info interesting sequence follow. Student was not professionally dressed and properly groomed. Student was professionally dressed but displayed one or more distracting accessories. Student was profess devoid any distractin 3) Dress and Appearance Student is able to answer rudimentary Student does not have grasp of information; questions and appears uncomfortable with student cannot answer questions about subject. the topic of discussion. Student demonstrate (more than required) questions with explan elaboration. 5) Graphics Student uses superfluous graphics or no graphics Student occasionally uses graphics that rarely support text and presentation. Student's graphics e screen text and pres 6) PP Slides and/or other Visual Student's slide presentation (or handout) has four or more spelling errors and/or grammatical errors. Less than half of the slides follow PP rules (1 topic, 4 to 6 bullets slide). Slide presentation (or handout) has three misspellings and/or grammatical errors. More than half of the slides follow PP rules. Slide presentation (o misspellings or gram slides follow PP rules 7) Eye Contact Student reads all of report with no eye contact. Student occasionally uses eye contact, but still reads most of report. Student maintains ey audience, seldom ret Student does not effectively articulate, incorrectly pronounces terms, and uses slang and/or idiosyncrasies. Student's voice is low. Student incorrectly pronounces terms. Audience members have difficulty hearing presentation. Student uses a clear precise pronunciation audience members c presentation. 4) Subject Knowledge 8) Voice Production and Grammar Usage 4 9) Conclusion Student offered no conclusion and ended presentation without appropriate closing. Student offered a presentation summary but did not reiterate variables that were discussed and/or brought in new information. Student clearly summ by briefly reiterating a discussedwithout b information. 10) Overall Deliverance Student uses some gestures, doesn't show Student uses no gestures, no examples, and complete confidence and presents with little displays poor voice characteristics and a lack of enthusiasm. Examples were used but some confidence. did not relate to presentation topic. Student presents wit confidence and uses gestures, posture, vo and stimulating exam the topic. Total P LEDGER FOR TOTAL POINTS SCORED 0-39 points = Unacceptable 40-79 points = Acceptable 80-100 points = Exemplary 5