Please Assist me on doing the Excel files Required for Ford Company. The Attached files are the procedures and requirement and samples.

Company Name Ticker Symbol Stock Market Head Quarters IRS Employer ID Link to 10-K GM is currently ranked eighth on the Fobes 500 listing. General Motors builds automobiles and car parts worldwide for their assortment of brands. GM's automobile brands include Buick, Cadillac, Chevrolet and GMC brands. General Motors includes both an Automotive and Financial section. GM's automotive segments: GM North America (GMNA), GM Europe (GME), GM International Operations (GMIO) and GM South America (GMSA). General Motors Company GM NYSE Detroit, MI 27-0756180 https://www.gm.com/content/dam/gm/en_us/english/Group4/InvestorsPDFDocuments/10-K.pdf ts/10-K.pdf GENERAL MOTORS COMPANY AND S CONSOLIDATED INCOME STATE (in thousands, except per share a For the year ended Dec. 31, Net sales and revenue Automotive GM Financial Total net sales and revenue Cost and expenses Automotive cost of sales GM Financial interest, operating and other expenses Automotive selling, general and administrative expense Goodwill impairment charges Total costs and expenses Operating Income Automotive interest expense Interest income and other non-operating income, net Gain on extinguishment of debt Equity income Income before income taxes Income tax expense Net Income Net (income) loss attributable to noncontrolling interests Net income attributable to stockholders Net income attributable to common stockholders Earnings per share Basic Basic earnings per common share Weighted-average common shares outstanding Diluted Diluted earnings per common share Weighted-average common shares outstanding CONSOLIDATED STATEMENTS OF COMPREHENSIVE (In millions) For the year ended December 31, Net income Other comprehensive income (loss), net of tax Foreign currency translation adjustments and other Defined benefit plans Other comprehensive income (loss), net of tax Comprehensive income (loss) Comprehensive income (loss) attributable to noncontrolling interests Comprehensive income (loss) attributable to stockholders MOTORS COMPANY AND SUBSIDIARIES NSOLIDATED INCOME STATEMENTS ousands, except per share amounts) 2016 $ 156,849 2015 $ 145,922 2014 $ 151,092 9,531 6,434 4,837 166,380 152,356 155,929 136,333 128,321 138,082 8,792 5,733 4,039 11,710 13,405 12,158 - - 120 156,835 147,459 154,399 9,545 4,897 1,530 572 443 403 429 621 823 - 449 202 2,282 2,194 2,094 11,684 7,718 4,246 2,416 (1,897) 228 9,268 9,615 4,018 159 72 (69) $ 9,427 $ 9,687 $ 3,949 $ 9,427 $ 9,687 $ 2,804 $ 6.12 $ 6.11 $ 1.75 1,540 $ 1,586 6.00 1,570 $ 1,605 5.91 $ 1.65 1,640 1,687 2015 2014 ENTS OF COMPREHENSIVE INCOME (In millions) 2016 $ $ 9,268 $ 9,615 $ 4,018 (384) (955) (478) (969) 1,011 (4,505) (1,353) 56 (4,983) 7,915 9,671 (965) 218 53 (46) 8,133 $ 9,724 $ (1,011) GENERAL MOTORS COMPANY AND SUBSIDIAR CONSOLIDATED BALANCE SHEETS (In millions, except per share amounts) December 31, 2016 ASSETS Current Assets: Cash and cash equivalents $ 12,960 Marketable securities 11,841 Accounts and notes receivable 9,638 GM Financial receivables, net 22,065 Inventories 13,788 Equipment on operating leases, net 1,896 Other current assets 4,015 Total current assets 76,203 Non-current Assets GM Financial receivables, net 20,724 Equity in net assets of nonconsolidated affiliates 8,996 Property, net 35,820 Goodwill and intangible assets, net 6,259 GM Financial equipment on operating leases, net 34,526 Deferred income taxes 35,092 Other assets 4,070 Total non-current assets 145,487 Total Assets $ 221,690 LIABILITIES AND EQUITY Current Liabilities Accounts Payable $ 26,961 Short-term debt and current portion of long-term debt Automotive 1,167 GM Financial 27,861 Accrued liabilities 29,192 Total current liabilities 85,181 Non-current Liabilities Long-term debt Automotive 9,585 GM Financial 46,015 Postretirement benefits other than pensions 5,803 Pensions 17,951 Other liabilities 13,080 Total non-current liabilities 92,434 Total Liabilities 177,615 Commitments and contingencies Equity Common stock, $0.01 par value 15 Additional paid-in capital 26,983 Retained earnings 26,168 Accumulated other comprehensive loss (9,330) Total Stockholders' equity 43,836 Noncontrolling interests 239 Total Equity 44,075 Total Liabilities and Equity $ 221,690 COMPANY AND SUBSIDIARIES TED BALANCE SHEETS cept per share amounts) 2015 $ 15,238 8,163 8,337 18,051 13,764 2,783 3,072 69,408 18,500 9,201 31,229 5,947 20,172 36,860 3,021 124,930 $ 194,338 $ 24,062 817 18,745 27,593 71,217 7,948 35,601 5,685 20,911 12,653 82,798 154,015 15 27,607 20,285 (8,036) 39,871 452 40,323 $ 194,338 2016 2015 Current Ratio 0.89 0.97 Profit Margin Ratio 0.056 0.063 Debt to Equity Ratio 4.05 3.86 Gross Profit (Automotive) 30,047 24,035 Gross Profit Ratio (Automotive) as % 18.06% 15.78% Automotive Sales as a % of Net Sales 94.27% 95.78% GM Financial as a % of Net Sales 5.73% 4.22% Automotive as a % of Total Liabilities 6.05% 5.69% GM Financial as a % of Total Liabilities 41.59% 35.29% SEC 10K: Peer Review - an initial posting for discussion Post a draft of your SEC 10K Excel file (analysis) as a response to this discussion topic, so that your peers may provide any feedback and/or suggestions. You are required to post (at a minimum) the Excel file and post a substantive response to a peer's file(s). The Peer Review process serves four purposes: 1) Each student has an opportunity to learn about another corporation. 2) Providing detailed and constructive feedback results in higher grades for all students. 3) Seeing how other students approached the project may provide insight for your to improve your project. 4) At your discretion, you have an opportunity to edit your project before submitting it for a grade. Ask for and volunteer to provide detailed and constructive to one or more of your classmates. 1. Ford Motor Company; NYSE: F 2. Ford Motors is one of the oldest automobile company of United States. The company has a high brand loyalty and a rich customer base. The vehicles of company are always in demand. The reputation and the name of company have made me curious to explore its financial report to find out its profitability, valuation, assets, etc. 3. https://www.sec.gov/Archives/edgar/data/37996/000003799616000092/f1231201510k.htm 4. Position in Fortune 500 List: 500 5. a) Income Statement: FS2 b) Balance Sheet: FS4 c) Statement of Stockholders Equity: FS8 d) Statement of Cash Flows: FS6 Public Company Incorporated in 1919 Employees: 327,531 Sales: $164.1, billion (2003) Stock Exchanges: ,New York Pacific Euronext Paris Swiss London. Sticker Symbol, FORD NAIC: 336111 car Manufacturing; 336112 light truck couch and utility vehicle Manufacturing; 33612 overwhelming obligation truck couch Manufacturing; 33621 engine vehicle figure Manufacturing; 532112 traveler Leasing; 524126 immediate Property What's more setback protection operator transporters. Concerning illustration those second-biggest car particular organization in the world, portage engine agency speaks to a $164 billion multinational benefits of the business realm. Referred to essential Likewise a maker from claiming automobiles, portage additionally works portage Credit, which generates more than $3 billion over income, and claims the hertz Corporation, the biggest auto rental accumulation shares of the organization in the planet. The organization produces vehicles under the names Ford, Lincoln, Mercury, Jaguar, Volvo, land Rover, What's more Aston Martian. Portage also supports controlling investment clinched alongside Mazda engine Cor. Ford's fiscal solidness might have been shaken in initial a considerable length of time of the new thousand years as an aftereffect for abating sales, caliber issues, Also a catastrophe directing, including firestone tires. Explanation: Substance definition: substances are bookkeeping units that take part in exactly sort bookkeeping activity, or need monetary advantages that must a chance to be accounted to. Substance Example: there are an amount for possibilities for diverse substances inside an association. To example, an organization with separate divisions of the business may define each division as a substance. Also, each Branch or cooperation inside an association may a chance to be its own substance. An item might make an entity, and also an organization's ventures alternately possessions. Other characteristic's from claiming Entity: substances clinched alongside accounting impact monetary resources; the more substances an association has, those that's only the tip of the iceberg workers the association necessities will track every last bit budgetary records from claiming each substance. Substances likewise must a chance to be differentiate from the personal money related exercises from claiming agency owners, gurus alternately representatives. It is a best act that substance subtle elements not progress habitually or whatsoever. Motivation behind entities: diverse organizations alternately divisions inside an association must be accounted for separately, in this way bookkeepers make distinctive substances on a greater amount faultlessly report card monetary records for every angle of an association. Aside from lawful What's more duty purposes, substances would likewise utilized to assistance bookkeepers a association's monetary records and transactions. Also, bookkeepers What's more back executives could use records starting with Different substances should foresee future money related Growth alternately loss, What's more aggravate additional educated choices over what heading should make an organization. For example, if one specific substance will be performing well, for example, such that An division On a company, that point shares of the organization pioneers might utilization that entity's fiscal records on aggravate an instance should table parts to dispense All the more plan Furthermore workers will those well-performing division. Similarly, though a division or entity's budgetary records show steady loss, shares of the organization pioneers could decide on stop that angle of the business, alternately detract movement will make it gainful. Reference: https://www.sec.gov/Archives/edgar/data/37996/000003799616000092/f123 1201510-k.htm Inventory comments: costing information. What do you see? WIP? From the 2015 annual report of Ford, in the inventory comments state that all inventory are stated at the lower of cost and the net realizable value. The work in process is combined with the raw materials and supplies. Its value is $4005 million. Inventory: How is inventory described for your SEC 10-K company? LIFO, FIFO, and / or average cost? Relate your answer to topics in our course. The cost of substantial US inventories is described in LIFO (Last in First Out basis) while cost of other inventories approximate FIFO basis. The cost is used to value inventor. Cost and sources for production materials: notice how cost is used in the SEC 10-K Ford uses significant amount of raw materials in the manufacture of vehicles. The suppliers are from all over the world. Ford mainly uses raw materials such as base metals e.g. steel, aluminums, iron castings, precious metals e.g. palladium, natural gas energy and plastics like polypropylene. The availability of the raw material is at times low but Ford has made sure it has a number of suppliers to cater for the deficits. There are always uncertainties and risks which plague the company forcing it adjust its prices. Freight costs such as warranty, product recall, material and commodity costs are contribution costs which vary with the production volume. The annual production volume is affected by external factors such as cost of fuel and availability of consumer credit Challenges and opportunities you see as you relate our current textbook topics to your company. Details are high level in the SEC 10-K but organizations rely on Cost Accounting. Ford material costs and contribution costs vary greatly with production volume while elements within structural costs are impacted to differing degrees by production volume changes. Cost accounting techniques should be used to allocate the costs according to the production volumes. Another challenge is the excess capacity of motor vehicles caused wastage of raw materials and consequent loses due to unused inventory. The excess capacity, coupled with the proliferation of new products being introduced in key segments, will keep pressure on the manufacturers' ability to its increase prices. Reference: https://www.sec.gov/Archives/edgar/data/37996/000003799616000092/f1231201510k.htm SEC 10-K: Management Discussion and Analysis The reported figures on the financial statements explain the operations of the FORD Company. The new divisions created in the preceding year are discussed of opening and expanding production to a new product of fuel consuming cars. FORD has incorporated the latest technology in producing cars that consume less fuel and are more effective and efficient in performance. Soon, the project of flying cars will be implemented after the completion of research and collection of the necessary information and requirements. However, FORD faces the challenge of discussing with other airline companies on the idea of coming up with flying cars. As we all know, the movement through air is restricted by various territories to secure the air space territory of a state and ensure that there is no interference to aircraft or other entities at both domestic and overseas operations. The major cost accounting issue that might arise to FORD could be the allocation of funds to the projected areas of operations. The maintenance and production of new items will require funds that have no specific figure but estimates. This is due to the complete new effort required for a new transportation method. FORD would require the knowledge of other experts who have tried implementing the similar ideas to help in preparing the budget and ensure that all the factors have been included so as to allocate enough funds for the project. FORD will benefit more from the release of the new cars into the market. The idea of having cars that can be able to overcome traffic jam and use the air to navigate and reach the desired destinations will help people to save a lot of time and avoid delays. The structure that FORD is taking will help to reduce the substantial costs that have been a headache to the internal control managers for a long period. The economic status of the region and the market at large is a consideration in the production of new products. The new strategy will consider the ability of the customers and ensure satisfaction of the client needs. Reference: HuangFu, J. B., & Ford Motor Company. (2014). Organizational communication and the natural environment: A case study of the Ford Motor Company This is based on analysis of FORD company MD&A, CSR, Contingencies and liabilities 1. My analysis of MD&A are that the costs are devoted to develop, manufacture, distribute and service vehicles parts and accessories and these costs are included in the cost of sales. Certain costs are affected by changes in the mix of production and volume, hence fluctuations in costs occur every quarter as production volume varies quarterly. Also, external factors like cost of fuel and pace of economic growth do cause fluctuations on costs incurred by the company. 2. On the pricing decisions of FORD, I learn that pricing decisions as per the MD&A are affected by manufacturing costs, emerging market segments and competition. There are many competitors in the market that can directly impact FORD's pricing decisions. Excess demand and introduction of new products in FORD's key segments puts the company at pressure of increasing prices. Again, commodity and energy price changes pose a long term effect on prices trending them higher because of global demand growth expectations. 3. On CSR for FORD, I have learned that the company is sensitive about corporate social responsibility. Protection of the environment and people are very high on their corporate social ladder. FORD wants to ensure safety and prevent hazard that might negatively impact their operational markets or their products and seek to mitigate the present or potential hazards that can impact products and markets. 4. Contingencies for this company consist of guarantees, indemnifications, warranty and litigation and claims. Extent of financial exposure to litigation and claims may be difficult to estimate. These are revalued if they occur and they may affect liquidity of the company because they are obligations. Cost and profitability may be affected on occurrence of any liabilities to the company. Reference: https://www.sec.gov/Archives/edgar/data/37996/000003799616000092/f1231201510k.htm ______________________________________________________________________ I've seen a few questions related to the SEC 10K project. Here are a few additional comments. 1. Read the SEC 10K Requirements/Overview (ACCT 321) in its entirety. (See https://learn.umuc.edu/d2l/le/content/200480/viewContent/8219766/View). This breaks the project down... 2. Week 6: The first deliverable due is in Week 6 this is the DRAFT of your Excel file...you can find the specific guidance in the above document (see link above). Basic requirement = 4 worksheets. I've included some screenshots of past projects (see attached) - these are not "the" way but "a" way to illustrate the topics. If you need help with Excel, there is also a tutorial in the requirements document above (see link). The Zebra Corporation Fact sheet I posted in Week 5 is an example of type - just to give you ideas for the Information Tab. I've included some screenshots of Company Information tabs - there is not really to include a list of corporate officers, but you might include the Fortune 500 position, the mission, brief description of the business, etc. 2 of the 4 worksheets are financial statements - you can copy and paste or re-create the financial statements - I've included a screenshot (see attached) that shows you how to isolate the financial statements. Do your vertical/horizontal analysis on these tabs... 3. Week 7: Finalize your Excel File (based on feedback in Week 6) and turn it into the Assignment Folder. Also turn in your written paper - again, there is some additional guidance in the Requirements/Overview link (see link above). Basic Requirement = 5-7 pages, single spaced, but APA format. You should layout some background of the company, talk about what you learned about the company, contrast it to a nonmanufacturing company's financial statements, talk about opportunities for cost control, talk changes in sales, net income, gross profit, talk about your vertical analysis (year to year), look at the segment information, which ones are doing well and which ones are not, what did you gather about the financial health of the company from the SEC 10K? talk about your ratios you prepared in the Excel document. The requirements ask for you to include the key financial statement (put these at the end) - they do not count as part of the 5-7 pages. I would consider using excerpts (graphics) from the SEC 10K in your report to illustrate the topics. Ensure you use parenthetical references - and use your OWN words. You can cite portions of the 10K report, and use some of your analysis you've done in the weekly 10K discussions. End with some conclusions...look at the grading rubric I posted in the Week 3 discussion. In Week 7, you will also post a DRAFT power point presentation - in the above Requirements/Overview link you will find a list of 10 slides that you should prepare. You can add an additional reference slide as #11 or include the reference somewhere in the slide deck. There are a list of specific topics for each slide that you must cover...ensure you cover them...you should have like hit on these in your written analysis. In Week 8, as indicated in the Requirements/Overview (see link above) you will turn in the FINAL power point document (based on the feedback in Week 7). Again, use the Grading Rubric provided in the Week 3 discussion and ensure that you've hit at least the basic requirements detailed in the Requirements/Overview document. Below is a link to an online article "Steps to a Basic Company Financial Analysis" - take a look at this if you'd like. http://faculty.philau.edu/lermackh/financial_analysis.htm I hope the above and the attached help answer any questions. Thanks, Professor Montano o IncomeStatement.PNG(99.05 KB) o InformationTab.PNG(54.02 KB) o FinancialAnalysis.PNG(89.53 KB) o InformationTab2.PNG(54.01 KB) o BalanceSheet.PNG(121.84 KB) o EDGAR_IncomeStatement.PNG(73.82 KB) I've seen a few questions related to the SEC 10K project. Here are a few additional comments. 1. Read the SEC 10K Requirements/Overview (ACCT 321) in its entirety. (See https://learn.umuc.edu/d2l/le/content/200480/viewContent/8219766/View). This breaks the project down... 2. Week 6: The first deliverable due is in Week 6 this is the DRAFT of your Excel file...you can find the specific guidance in the above document (see link above). Basic requirement = 4 worksheets. I've included some screenshots of past projects (see attached) - these are not "the" way but "a" way to illustrate the topics. If you need help with Excel, there is also a tutorial in the requirements document above (see link). The Zebra Corporation Fact sheet I posted in Week 5 is an example of type - just to give you ideas for the Information Tab. I've included some screenshots of Company Information tabs - there is not really to include a list of corporate officers, but you might include the Fortune 500 position, the mission, brief description of the business, etc. 2 of the 4 worksheets are financial statements - you can copy and paste or re-create the financial statements - I've included a screenshot (see attached) that shows you how to isolate the financial statements. Do your vertical/horizontal analysis on these tabs... 3. Week 7: Finalize your Excel File (based on feedback in Week 6) and turn it into the Assignment Folder. Also turn in your written paper - again, there is some additional guidance in the Requirements/Overview link (see link above). Basic Requirement = 5-7 pages, single spaced, but APA format. You should layout some background of the company, talk about what you learned about the company, contrast it to a nonmanufacturing company's financial statements, talk about opportunities for cost control, talk changes in sales, net income, gross profit, talk about your vertical analysis (year to year), look at the segment information, which ones are doing well and which ones are not, what did you gather about the financial health of the company from the SEC 10K? talk about your ratios you prepared in the Excel document. The requirements ask for you to include the key financial statement (put these at the end) - they do not count as part of the 5-7 pages. I would consider using excerpts (graphics) from the SEC 10K in your report to illustrate the topics. Ensure you use parenthetical references - and use your OWN words. You can cite portions of the 10K report, and use some of your analysis you've done in the weekly 10K discussions. End with some conclusions...look at the grading rubric I posted in the Week 3 discussion. In Week 7, you will also post a DRAFT power point presentation - in the above Requirements/Overview link you will find a list of 10 slides that you should prepare. You can add an additional reference slide as #11 or include the reference somewhere in the slide deck. There are a list of specific topics for each slide that you must cover...ensure you cover them...you should have like hit on these in your written analysis. In Week 8, as indicated in the Requirements/Overview (see link above) you will turn in the FINAL power point document (based on the feedback in Week 7). Again, use the Grading Rubric provided in the Week 3 discussion and ensure that you've hit at least the basic requirements detailed in the Requirements/Overview document. Below is a link to an online article "Steps to a Basic Company Financial Analysis" - take a look at this if you'd like. http://faculty.philau.edu/lermackh/financial_analysis.htm I hope the above and the attached help answer any questions. Thanks, Professor Montano o IncomeStatement.PNG(99.05 KB) o InformationTab.PNG(54.02 KB) o FinancialAnalysis.PNG(89.53 KB) o InformationTab2.PNG(54.01 KB) o BalanceSheet.PNG(121.84 KB) o EDGAR_IncomeStatement.PNG(73.82 KB) Financial Analysis of Ford Motor Company's 10K Report By: Lourdes L. Owens By: Lourdes L. Owens Acct 321 6381 Acct 321 6381 Prof. Montano Prof. Montano Overview Company Overview Ford's brief history Management Mission & Vision Financial Assessment Revenue and Net Income Comprehensive Income Assets, Equity and Liabilities Working Capital Treasury Stock Margins Gross Profit Margin Net Profit Margin Gross Profit and Net Income Changing, as a Dollar Value? Operating Activities Net Income Versus Total for Operating Activities Investing and Financing Activities Long Term Assets Overall cashflow analysis Conclusion References About the Company Manufactures and distributes automobiles on six continents, strong presence in all 50 states. Employs approximately 327,531 people and operates 90 plants worldwide. Brands include Ford, Lincoln, Mercury, Volvo, Mazda and Ford Motor Credit Company (financial service). Ford's Brief History 1903 - Ford Motor Company founded in Michigan 1908 - Model T introduced 1913 - first moving automobile assembly line in the world created in Detroit 1956 - Ford's stocks go on sale (10.2 million shares sold the first day) 1987 - Beginning of the acquisitions of other brands 1988 - Ford Motor Company reached the peek Management William Clay Ford, Jr. Executive Chairman Mark Fields President and Chief Executive Officer Robert Shanks Chief Financial Officer & Executive Vice President Marcy Klevorn Chief Information Officer & Vice President Raj Nair Chief Technical Officer Paul Ballew Global Chief Data & Analytics Officer Mission & Vision Statement - Both mission and vision are one statement \"Our vision is to become the world's leading consumer manufacturing company for automotive products and services. To achieve this, we the company and all our employees are dedicated to provide all our customers and the community with safe innovative products and services of world class standards. Through our engineering excellence, high quality and the use of our constantly upgrading technology, we limit the harm that we cause to the environment while delivering superior value to our customers. Our close knit working environment allows our employees, community and business partner to share in our success, while achieving a substantial return on our shareholders investment.'' Financial Assessment Ford's Revenue and Net Income Ford's Net Sales - 164,100 Billion Cost of Goods Sold - 124.04 Billion Gross Profit - 25.52 Billion Corporate tax rate - 28.1% Comprehensive Income Comprehensive income attributable to Ford Motor Company was $6,381,000. Ford's other comprehensive income was (6,257) million in 2015 and it is (5,265) million in 2014. Ford's other comprehensive income has increased by $992,000 from 2014 to 2015. The value for Other Comprehensive Net Income (or net loss) for Ford Motor Co was: 2015 = 7,371 2014 = 1,230. In 2014 the Other Comprehensive Net Income was 1,230 (million) and has increased by 6,141 (million) in 2015. Assets, Equity and Liabilities Total current assets for 2015 were 42.6 Billion Total current liabilities for 2015 were 39.6 Billion Total assets (deficit) for 2015 were 227.9 Billion Total stockholder's equity (deficit) are 28.7 Billion Working Capital Ford's Working Capital for 2015 was (42,574 - 39,646 = 2,928) (millions) Ford's Working Capital for 2014 was (38,758 - 40,086 = (1,328)) (Millions) Note: The working capital last year changed significantly. Ford Motor Companies' working capital increased by $4,256 (Millions) from Dec. 2014 to Dec. 2015 Treasury Stock Treasury Stock Dec06 Dec07 Dec08 Dec09 Dec10 Dec11 Dec12 Dec13 Dec14 Dec15 -183 -185 -181 -177 -163 -166 -292 -506 -848 -977 Treasury Stock in 2015 was (977) and 2014 (848) (Millions) Ford Motor Company had an increase in Treasury stock of $129 million. Gross Profit Margin Fords Gross Profit Margin Gross profit calculations for Ford Motor Company 2015. Gross profit = revenue - COGS 149.56B - 124.04B = 25.52B Gross profit for 2014 Gross profit = revenue - COGS 144.08B - 125.03B = 19.05B Gross Profit Margin for Ford Motor Company 2015 Gross profit / Net sales x 100 25.52B / 149.56B x 100 = 17.06% Gross profit margin for 2014. Gross profit / Net sales x 100 19.05B / 144.08B x 100 = 13.22% Net Profit Margins Ford Motor Company's Net Profit Margin 2015 Net profit margin = Net income / Net sales x 100 7.37B / 149.56B x 100 = 4.9% Ford Motor Company's Net Profit Margin 2014 Net profit margin = Net income / Net sales x 100 1.23B / 144.08B x 100 = .85% Gross Profit and Net Income Changing, as a Dollar Value? Sales are increasingly profitable for Ford Motor Company from 2014 to 2015. Ford's gross profit has increased by 6.47 billion from 2014 to 2015. Fords gross profit margin has increased by 3.84%. Fords net profit has also increased from 2014 to 2015 by 4.05%. Sales have increased in profitability by 3.8 cents on the dollar. Operating Activities Net Income versus total for operating activities Net income 2014: 1.2 Billion 2015: 7.3 Billion Operating activity cash flow: 2014: 14.5 Billion 2015: 16.1 Billion This shows that Ford Motor Company has been providing cash flow form operations. You can see a positive value. Investing and Financing Activities Ford Motor Company's Long Term Assets Fords capital spending for 2014 was 7.5 Billion Fords capital spending for 2015 was 7.2 Billion Overall Cash Flow Analysis This year and last years overall cash flow. 2014: 10.7 Billion 2015: 14.2 Billion Fords overall cash flow has increased from 2014 to 2015 by 3.5 Billion. References Ford Motor Company 10K Report. (2015, December 31). Retrieved February 10, 2017 from https://www.sec.gov/Archives/edgar/data/37996/000003799616000092/f12312 01510-k.htm Company, F. M. (2015). Ford motor company Timeline. Retrieved February10, 2017, from https://corporate.ford.com/company/history.html Financial Analysis of Ford Motor Company's 10K Report By: Lourdes L. Owens By: Lourdes L. Owens Acct 321 6381 Acct 321 6381 Prof. Montano Prof. Montano Overview Company Overview Ford's brief history Management Mission & Vision Financial Assessment Revenue and Net Income Comprehensive Income Assets, Equity and Liabilities Working Capital Treasury Stock Margins Gross Profit Margin Net Profit Margin Gross Profit and Net Income Changing, as a Dollar Value? Operating Activities Net Income Versus Total for Operating Activities Investing and Financing Activities Long Term Assets Overall cashflow analysis Conclusion References About the Company Manufactures and distributes automobiles on six continents, strong presence in all 50 states. Employs approximately 327,531 people and operates 90 plants worldwide. Brands include Ford, Lincoln, Mercury, Volvo, Mazda and Ford Motor Credit Company (financial service). Ford's Brief History 1903 - Ford Motor Company founded in Michigan 1908 - Model T introduced 1913 - first moving automobile assembly line in the world created in Detroit 1956 - Ford's stocks go on sale (10.2 million shares sold the first day) 1987 - Beginning of the acquisitions of other brands 1988 - Ford Motor Company reached the peek Management William Clay Ford, Jr. Executive Chairman Mark Fields President and Chief Executive Officer Robert Shanks Chief Financial Officer & Executive Vice President Marcy Klevorn Chief Information Officer & Vice President Raj Nair Chief Technical Officer Paul Ballew Global Chief Data & Analytics Officer Mission & Vision Statement - Both mission and vision are one statement \"Our vision is to become the world's leading consumer manufacturing company for automotive products and services. To achieve this, we the company and all our employees are dedicated to provide all our customers and the community with safe innovative products and services of world class standards. Through our engineering excellence, high quality and the use of our constantly upgrading technology, we limit the harm that we cause to the environment while delivering superior value to our customers. Our close knit working environment allows our employees, community and business partner to share in our success, while achieving a substantial return on our shareholders investment.'' Financial Assessment Ford's Revenue and Net Income Ford's Net Sales - 164,100 Billion Cost of Goods Sold - 124.04 Billion Gross Profit - 25.52 Billion Corporate tax rate - 28.1% Comprehensive Income Comprehensive income attributable to Ford Motor Company was $6,381,000. Ford's other comprehensive income was (6,257) million in 2015 and it is (5,265) million in 2014. Ford's other comprehensive income has increased by $992,000 from 2014 to 2015. The value for Other Comprehensive Net Income (or net loss) for Ford Motor Co was: 2015 = 7,371 2014 = 1,230. In 2014 the Other Comprehensive Net Income was 1,230 (million) and has increased by 6,141 (million) in 2015. Assets, Equity and Liabilities Total current assets for 2015 were 42.6 Billion Total current liabilities for 2015 were 39.6 Billion Total assets (deficit) for 2015 were 227.9 Billion Total stockholder's equity (deficit) are 28.7 Billion Working Capital Ford's Working Capital for 2015 was (42,574 - 39,646 = 2,928) (millions) Ford's Working Capital for 2014 was (38,758 - 40,086 = (1,328)) (Millions) Note: The working capital last year changed significantly. Ford Motor Companies' working capital increased by $4,256 (Millions) from Dec. 2014 to Dec. 2015 Treasury Stock Treasury Stock Dec06 Dec07 Dec08 Dec09 Dec10 Dec11 Dec12 Dec13 Dec14 Dec15 -183 -185 -181 -177 -163 -166 -292 -506 -848 -977 Treasury Stock in 2015 was (977) and 2014 (848) (Millions) Ford Motor Company had an increase in Treasury stock of $129 million. Gross Profit Margin Fords Gross Profit Margin Gross profit calculations for Ford Motor Company 2015. Gross profit = revenue - COGS 149.56B - 124.04B = 25.52B Gross profit for 2014 Gross profit = revenue - COGS 144.08B - 125.03B = 19.05B Gross Profit Margin for Ford Motor Company 2015 Gross profit / Net sales x 100 25.52B / 149.56B x 100 = 17.06% Gross profit margin for 2014. Gross profit / Net sales x 100 19.05B / 144.08B x 100 = 13.22% Net Profit Margins Ford Motor Company's Net Profit Margin 2015 Net profit margin = Net income / Net sales x 100 7.37B / 149.56B x 100 = 4.9% Ford Motor Company's Net Profit Margin 2014 Net profit margin = Net income / Net sales x 100 1.23B / 144.08B x 100 = .85% Gross Profit and Net Income Changing, as a Dollar Value? Sales are increasingly profitable for Ford Motor Company from 2014 to 2015. Ford's gross profit has increased by 6.47 billion from 2014 to 2015. Fords gross profit margin has increased by 3.84%. Fords net profit has also increased from 2014 to 2015 by 4.05%. Sales have increased in profitability by 3.8 cents on the dollar. Operating Activities Net Income versus total for operating activities Net income 2014: 1.2 Billion 2015: 7.3 Billion Operating activity cash flow: 2014: 14.5 Billion 2015: 16.1 Billion This shows that Ford Motor Company has been providing cash flow form operations. You can see a positive value. Investing and Financing Activities Ford Motor Company's Long Term Assets Fords capital spending for 2014 was 7.5 Billion Fords capital spending for 2015 was 7.2 Billion Overall Cash Flow Analysis This year and last years overall cash flow. 2014: 10.7 Billion 2015: 14.2 Billion Fords overall cash flow has increased from 2014 to 2015 by 3.5 Billion. References Ford Motor Company 10K Report. (2015, December 31). Retrieved February 10, 2017 from https://www.sec.gov/Archives/edgar/data/37996/000003799616000092/f12312 01510-k.htm Company, F. M. (2015). Ford motor company Timeline. Retrieved February10, 2017, from https://corporate.ford.com/company/history.html Company Name Ticker Symbol Stock Market Head Quarters IRS Employer ID Link to 10-K Ford Motors manufactures and distributes automobiles on six continents,strong presense in all 50 states. General Motors includes both an Automotive and Financial section. Ford motors brands include Ford,Lincoln,Mercury,Volvo,Mazda and Ford Credit Company(Financial service. Ford Motors Company Ford NYSE ` FORD MOTORS COMPANY AND SU CONSOLIDATED INCOME STATE (in thousands, except per share a For the year ended Dec. 31, Net sales and revenue Automotive Financial services Total net sales and revenue Cost and expenses Automotive cost of sales Operating and other expenses Financial services interest expense Financial Services provision for credit and insurance losses Total costs and expenses Operating Income Automotive interest expense Interest income and other non-operating income, net Financial services other income /Loss ,net Equity in net income of affliated companies Income before income taxes Provision for/(Benefit from )Income taxes Net Income Net (income) loss attributable to noncontrolling interests Net income attributable to stockholders Net income attributable to common stockholders Earnings per share Basic Basic earnings per common share CONSOLIDATED STATEMENTS OF COMPREHENSIVE (In millions) For the year ended December 31, Net income Other comprehensive income (loss), net of tax Foreign currency translation adjustments and other Marketable securities Derivative instruments Pension and other postretirement benefits Other comprehensive income (loss), net of tax Comprehensive income (loss) Comprehensive income (loss) attributable to noncontrolling interests Comprehensive income (loss) attributable to stockholders MOTORS COMPANY AND SUBSIDIARIES NSOLIDATED INCOME STATEMENTS ousands, except per share amounts) 2015 $ 140,566 2014 $ 135,782 8,992 8,295 149,558 144,077 124,041 125,025 14,499 15,716 2,454 2,699 417 305 141,411 143,745 8,147 332 773 797 1,188 76 372 348 1,818 1,275 10,752 1,234 2,881 4 7,871 1,230 (2) (1) $ 7,873 $ 1,231 $ 7,873 $ 1,231 $ 1.99 $ 0.31 ENTS OF COMPREHENSIVE INCOME (In millions) 2015 $ 7,371 (1,132) 2014 $ 1,230 (36) (6) 0 227 (182) (81) (23) (992) (241) 6,379 989 (2) $ 6,381 $ 989 FORD MOTORS COMPANY AND SUBSIDIAR CONSOLIDATED BALANCE SHEETS (In millions, except per share amounts) December 31, 2015 ASSETS Current Assets: Cash and cash equivalents 14,272 Marketable securities 20,904 Accounts and notes receivable 11,284 Inventories 8,319 Other current assets Total current assets 54,779 Non-current Assets Financial receivables, net 90,691 Equity in net assets of nonconsolidated affiliates 3,224 Property, net 30,163 Net investment in operating leases, net 27,093 Deferred income taxes 11,509 Other assets 7,466 Total non-current assets 170,146 Total Assets $ 224,925 LIABILITIES AND EQUITY Current Liabilities Accounts Payable $ 20,272 Other liabilities and deffered revenue $ 42,546 Total current liabilities 62,818 Non-current Liabilities Long-term debt Automotive 12,839 Financial services debt 120,015 Deferred income taxes 502 Total non-current liabilities 133,356 Total Liabilities 196,174 Redeemable noncontrolling interest 94 Equity Common stock, $0.01 par value 40 Class B stock ,par values $.01 per share 1 Additional paid-in capital 21,421 Retained earnings 14,414 Accumulated other comprehensive loss (6,257) Treasury stock (977) Total Stockholders' equity Noncontrolling interests Total Equity Total Liabilities and Equity 28,642 15 28,657 $ 224,925 OMPANY AND SUBSIDIARIES TED BALANCE SHEETS cept per share amounts) 2014 10,757 20,393 11,708 7,870 50,728 81,111 3,357 30,126 23,217 14,024 6,052 157,887 $ 208,615 $ 20,035 $ 44,032 64,067 13,824 105,347 570 119,741 183,808 342 39 1 21,089 9,422 (5,265) (848) 24,438 27 24,465 $ 208,615 2015 2014 Current Ratio 0.87 0.79 Profit Margin Ratio 0.053 0.009 Debt to Equity Ratio 6.85 7.51 Gross Profit (Automotive) 17% 13% Company Name Ticker Symbol Stock Market Head Quarters IRS Employer ID Link to 10-K Ford Motors manufactures and distributes automobiles on six continents,strong presense in all 50 states. General Motors includes both an Automotive and Financial section. Ford motors brands include Ford,Lincoln,Mercury,Volvo,Mazda and Ford Credit Company(Financial service. Ford Motors Company Ford NYSE ` FORD MOTORS COMPANY AND SUBSIDIARI CONSOLIDATED INCOME STATEMENTS (in thousands, except per share amounts) For the year ended December 31, 2015 AUTOMOTIVE Revenues 140,566 Costs and expenses Cost of sales 124,041 Selling and adminstrative 10,502 134,543 Interest expense Interest income and other income /loss Equity ii income of affliated companies Income /Loss before income taxes Financial Services Revenues Costs and expenses Interest expense Depreciation on vehicles subject to operating lease Operating and other expenses Provision for credit and insurance losses Total costs and expenses Other income /(loss) Equity in net income of affliated companies Income before taxes financial services TOTAL COMPANY Income before taxes provision for/(Benefit from) income taxes Net income Less:income/(Loss) attributable to noncontrolling interests Net income attributable to Ford motor company 773 1,188 1,786 8,224 8,992 2,454 3,640 857 417 7,368 372 32 2,028 10,252 2,881 7,371 (2) 7,373 CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (In millions) For the year ended December 31, Net income Other comprehensive income (loss), net of tax Foreign currency translation adjustments and other Marketable securities Derivative instruments Pension and other postretirement benefits Other comprehensive income (loss), net of tax Comprehensive income (loss) Comprehensive income (loss) attributable to noncontrolling interests Comprehensive income (loss) attributable to stockholders 2015 $ 7,371 (1,132) (6) 227 (81) (992) 6,379 (2) $ 6,381 MPANY AND SUBSIDIARIES INCOME STATEMENTS cept per share amounts) 2014 135,782 125,025 11,842 136,867 797 76 1,246 (560) 8,295 2,699 3,098 776 305 6,878 348 29 1,794 1,234 4 1,230 (1) 1,231 VE INCOME 2014 1,230 $ (36) (182) (23) (241) 989 989 FORD MOTORS COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENT OF FINANCIAL POSITION (in thousands, except per share amounts) For the year ended December 31, ASSETS Cash and Cash equivalents Marketable securities Receivables ,less allowances Inventories Deferred income taxes Other current assets Total current assets Equity in net assets from affliated companies Net property Net investment in operating leases Deferred income taxes Other assets Non current receivable fromfinancial services Total automotive assets. Financial services. Cash and Cash equivalents Marketable securities Finance receivables Net investment in operating leases Equity in net assets of affliated companies Other assets Receivable from automotive Total financial services assets Intersector ellimination Liabilities Automotive Payables Other liabilities and deferred revenue Deferred income taxes Current payables within one year Current payables to financial services Total current liabilities Long term debt Other liabilities and deferred revenue Deferred income taxes Non current payable to financial services Total Automotive liabilities 2015 2014 5,386 18,181 23,567 5,173 8,319 3,664 1,851 42,574 3,091 30,021 2,014 10,687 3,572 91,959 4,567 17,135 21,702 5,789 7,870 2,050 1,347 38,758 3,216 29,795 1,699 13,705 2,497 497 90,167 8,886 2,723 96,063 25,079 133 3,059 1,083 137,026 (1,083) 227,902 6,190 3,258 86,141 21,518 141 3,613 527 121,388 (1,024) 210,531 19,168 17,992 13 1,779 694 39,646 11,060 22,732 287 389 74,114 18,876 17,912 270 2,501 527 40,086 11,323 24,270 367 76,046 Financial Services Payables Debt Deferred income taxes Other liabilities and deferred revenue Payable to Automotive Total financial liabilities Intersector ellimination Total liabilities Redeemable noncontrolling interest Equity Common stock, $0.01 par value Class B stock ,par values $.01 per share Additional paid-in capital Retained earnings Accumulated other comprehensive loss Treasury stock Total Stockholders' equity Noncontrolling interests Total Equity Total Liabilities and Equity 1,104 120,015 3,179 1,822 126,120 (1,083) 199,151 1,159 105,347 1,849 1,850 497 110,702 (1,024) 185,724 94 342 40 1 21,421 14,414 (6,257) (977) 28,642 15 28,657 $ 227,902 39 1 21,089 9,422 (5,265) (848) 24,438 27 24,465 $ 210,531 Current Ratio Profit Margin Ratio Debt to Equity Ratio Gross Profit (Automotive) Gross Profit Ratio (Automotive) as % Automotive Sales as a % of Net Sales Financial as a % of Net Sales Automotive as a % of Total Liabilities Financial as a % of Total Liabilities 2016 1.07 0.049 6.95 16,525 11.76% 100.00% 100.00% 37.21% 63.33% 2015 0.97 0.009 7.59 10,757 7.92% 100.00% 100.00% 40.95% 59.61%