I am having a difficult time especially with finding the correct numbers for Ford's financial statements, cash flows etc.. Please help!

ACCT 212 INDIVIDUAL LEARNING PROJECT QUESTIONS Name: William B. Ferrell Answers are in red for your conveince in grading General Information: 1. What is the name of your corporation? a. Ford motor company 2. Where are the corporate headquarters? a. Dearborn, Michigan, a suburb of Detroit 3. What is the corporation's fiscal year end? a. December 31st 4. What are the primary products or services of the corporation? a. This corportation manufactures a variety of automobiles for transportation and work vehichles/trucks 5. Graph the high and low price of the company's stock for each quarter of the last two years. What was the high and what was the low? a. 6. Who is the company's transfer agent and where are they located? a. Computershare Trust Company, N.A 7. Who are your company's competitors? a. There are many car companies that compete with Ford. The easily recognized competitors are General Motors, and Dodge. Market Information: 8. On which stock exchange is your corporation's stock traded? a. NYSE 9. What is the current market price of their stock? a. 11.14 USD per share 10. What is the ticker symbol used to identify your corporation on the stock exchange? a. (FORD) or simply (F) Internet Information: 11. What is the Internet address of your corporation? Be sure it appears as a hyperlink. a. www.ford.com 12. Is the corporation's Annual Report online? a. yes 13. Are its financial statements on-line? a. yes 14. Is your company listed on Annualreports.com? a. yes Page 1 of 4 ACCT 212 15. How long is your company's 10-K report at the Securities and Exchange Commission website (Edgar Database)? a. 59 pages long b. https://www.sec.gov/Archives/edgar/data/37996/000003799617000013/f123 1201610-k.htm Cash Flow and Retained Earnings: 16. List the amount of cash flows from each of the 3 activities: Operating, Investing, and Financing for the 2 most recent years. What was the increase or decrease in cash for each of these years? a. Operating i. 2016 (19.79 Billion) ii. 2017 b. Investing i. 2016 (25.35 Billion) ii. 2017 (Billion) c. Financing i. 2016 (7.46 Billon) ii. 2017 (Billion) 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. Were there any Non-Cash Investing/Financing Transactions? Describe the type and amount. a. No What is the dollar difference between accrual net income and Cash provided by Operations? a. 5,868 What investing activity provided the largest inflow of cash in the current year? a. Sale of maturity investments 2016 - (29.35 Billion) What investing activity used the largest amount of cash in the current year? a. Capital expenditures (Fixed Assets) 2016 - (6.99 Billion) What financing activity provided the largest inflow of cash in the current year? a. Issuance of Long term Debt 2016 - (45.96 Billion) What financing activity used the largest amount of cash in the current year? a. Reduction in long term debt 2016 - ( Does the company have sufficient cash inflows from the appropriate category? Describe any problems the company many experience with cash flow from your analysis of the cash flow statement. a. Show the change in Retained Earnings for the 2 most recent years. What was net income for each year? How much was paid out in dividends each year? a. Were the dividends on common stock and/or preferred stock? What was the amount of each? a. Did Retained Earnings change for any reasons other than net income or dividends? Explain. Page 2 of 4 ACCT 212 27. 28. 29. 30. a. What classes of stock does your company have? a. How many shares of each class of stock are authorized, how many are issued, and how many are outstanding? a. Does your company have any treasury stock? How many shares and what dollar amount? a. What is the par or stated value of each of your company's stocks? a. Footnote Disclosures: 31. How many footnote disclosures does your company have? a. 32. How many significant accounting policies are listed under its Summary of Significant Accounting Policies? a. 33. What does it include as Cash and Cash Equivalents? a. 34. What method does it use to value Inventory? a. 35. What method(s) does it use to depreciate its assets? a. 36. Does it have any leased assets? If yes, describe them. a. 37. What policies does it have in regard to Foreign Currency Translations? a. 38. Describe any pending lawsuits in which it is involved. a. 39. Provide its Earnings per Share for the 2 most recent years? a. Report of the Independent Auditor(s): 40. Who is/are your company's auditor(s)? a. 41. Where are they located? a. 42. Does the auditor(s) give a qualified opinion, an unqualified opinion, a disclaimer of opinion, or an adverse opinion? What does that opinion mean? Is it good? 43. 44. 45. 46. What is the auditor's responsibility in regard to the financial statements? What is management's responsibility in regard to the financial statements? What financial statements were included in the auditor's opinion? Did the auditor believe that the statements were presented fairly? Page 3 of 4 ACCT 212 Management's Report: 47. Who bears the responsibility for the integrity and the objectivity of the financial statements? 48. What does management say they are doing to assure the public that the financial information is reliable? 49. What is the responsibility of the Audit Committee of the Board of Directors? Analysis: (use Excel to complete this section) 50. Provide common-size analysis of your company's income statement and balance sheet for the 2 most recent years (must be done using Excel with formulas). 51. Provide horizontal analysis of your company's income statement and balance sheet, showing the dollar amount and percent of change using the 2 most recent years (you must use an Excel spreadsheet with formulas). 52. Perform ratio analysis on your company using the ratios listed in Exhibit 13.16 on page 529 of your text (these must be in an Excel spreadsheet, using formulas to calculate the ratios). You should present them in a similar format as the text: group by category, list name of ratio, formula in words, and the ratio calculation. Give a short explanation of your conclusions about your company after each category of ratios (i.e. How liquid is your company? How efficiently is it using its assets? etc.). Conclusions: 53. Are you optimistic or pessimistic regarding the future of your chosen corporation? Explain. 54. Would you invest in the stock of the company? Explain. 55. Would you invest in the bonds of the company? Explain. Page 4 of 4 ACCT 212 INDIVIDUAL LEARNING PROJECT GRADING RUBRIC Questions Questions 1-49 except 5, 16, 23, 24, 28, 39, 42, and 45 Question 5 Questions 16, 23, 24, 28, 39, 42, and 45 Question 50 Question 51 Question 52 Questions 53-55 Criteria Questions answered correctly are awarded 1 point each. Points Possible 0 to 41 points Questions answered correctly are awarded 5 points each. Questions answered correctly are awarded 2 points each. 0 to 5 points Points are awarded based on the quality of the answers given, including the use of formulas. Points are awarded based on the quality of the answers given, including the use of formulas. Ratios calculated correctly, including the use of formulas, are awarded 2 points each; quality conclusions are awarded 1 point each Questions answered correctly, with explicit explanation, are awarded 5 points each. 0 to 15 points Points Earned 0 to 14 points 0 to 15 points 0 to 23 points 0 to 12 points Total Instructor's Comments: /125 ACCT 212 INDIVIDUAL LEARNING PROJECT INSTRUCTIONS This project will allow you the opportunity to explore a company's annual report and become familiar with the items it contains. Choose a company from Standard & Poor's Net Advantage whose company's name begins with the same letter as your last name. Locate the most recent annual report, either from the Liberty University library's access to Standard & Poor's website, the EDGAR database (http://www.sec.gov/), or the company's website. Once located, open Individual Learning Project Questions document and add your answers underneath each question. Do not delete the questions. Questions 1-49 must be answered with Microsoft Word. Your answers for these do not need to be in complete sentences. Questions 50-52 must be answered in Microsoft Excel and your answers must include formulas. Questions 53-55 must be answered with complete sentences and justification within the Word document. Both documents (Word and Excel) must be uploaded into the Assignment link. To access the Liberty University Library online resources from off campus: From the Blackboard log-in page, right-hand side \"Quicklinks\" pull-down menu -choose \"Library.\" Click log-in button. Off-site access cannot be gained unless the user successfully completes the log-in. This must take you to the \"Library Research Portal\"; if not, click on \"Portal.\" Click on the \"databases\" tab. Click on the \"Databases by Letter,\" and select the letter \"S.\" Scroll down until you see \"Standard & Poor's NetAdvantage.\" Click on the link and then you may begin your search. This assignment is due by 11:59 p.m. (ET) on Monday of Module/Week 7. Individual Learning Project (ILP) You know seven weeks in advance that the project is due. Begin working on it early as I will not accept late projects- no excuses! If you decide to begin it the last week before it is due and something extreme happens, then that is your choice. This is worth 125 points and will destroy your grade if it is not finished on time or at all. Please understand that these take a great amount of time to grade and with the due date being in the last week of class and grades being due, I must be firm with the due date. This assignment is due by 11:59 p.m. (ET) on Monday of Module/Week 7. Please note that no project will be allowed after this point and the submission area will disappear so that you cannot submit a project after this time The grading rubric for this item is located in the course content area- read carefully as this is what I will be using as my grading tool. Read This Carefully! Instructions for the ILP: 1.Choose a company whose company name begins with the same 1st letter of your last name on your Liberty records from the SEC website http://www.sec.gov/edgar/searchedgar/companysearch.html. Locate the most recent 10-K from ACCT 212 the EDGAR database (http://www.sec.gov/edgar/searchedgar/companysearch.html). The company must have a current 10-K on the SEC site (typically this means American companies only) and should be either a retail or manufacturing company, as these are the easiest. If you are having problems finding a company, then I recommend this website http://www.makingafortune.biz/ MUST 2. You then email me the name of your company to get my OK. Failure to do so can only cause you misery- I recommend the EDGAR (SEC) Database only- I have students every semester that pick very difficult companies some are foreign (These often are not listed on the EDGAR site and thus they may not match up to GAAP and American Auditing requirements and will get a grade of Zero) and some are no longer in business. This class is difficult enough as is, and so do not make it more difficult by choosing a company for this assignment that will cause you problems. Pick an easy high profile American company e.g. if you last name begins with M then Microsoft would be a good choice. You must contact me with the name of your company so that I can approve it. If you do not contact me and the company is not acceptable, then you will earn a zero on this assignment. I further recommend that you choose a retailer or manufacturer instead of a service business or a financial business as this will make for a much easier project. 3. Once located, open Individual Learning Project 55 Question Form document and add your answer underneath each question; do not delete the questions. Questions 1-49 must be answered within Microsoft Word. Your answers for these must be in complete sentences where required. Questions 50-52 must be answered in Microsoft Excel and your answers must include formulas (if the formulas are not included and I cannot follow them, then you will get a zero as there are many places on the net where financial analysis can be cut and pasted without formulas) the required ratios are in Exhibit 13.16 on page 529 of your text. Questions 53-55 must be answered with complete sentences and justification (this justification must be from the financial analysis that you have completed and must be objective in nature) within the Word document. Both documents (Word and Excel) must be uploaded into the Assignment link. I want only one excel and one word document. Before loading your Word document- make sure that you have 55 questions and not some other number like 50 or 52- if you do this it makes my task much more difficult as I try to determine what questions you did or did not answer and it becomes an issue for you as it can affect your score