| FOR THIS ASSIGNMENT PLEASE PROVIDE A MAJOR PUBICLY TRADED CORPORATION, THAN ACCESS THE CORPORATION'S WEBSITE TO RETRIEVE INFORMATION. PROVIDE INFORMATION ABOUT THE HISTORY OF THE COMPANY AND ITS CURRENT PRODUCT OFFERING. THAN RETRIEVE THE LATEST ANNUAL INCOME STATEMENT AND INCLUDE A SCREEN SHOT OF THE STATEMENT. THAN ORGANIZE THE INCOME STATEMENT IN AN EXCEL FILE AND INCLUDE THE COPY OF THE EXCEL FILE IN YOUR SUBMISSION DOCUMENT. DO NOT USE YAHOO FINANCE AS A SOURCE OF DATA, SINCE SOME INFORMATION IN THIS SITE IS INACCURATE. VERIFY THE ARITMETIC IN THE INCOME STATEMENT AND EXPLAIN. ALSO, EXPLAIN THE NATURE OF EACH ITEM IN THE INCOME STATEMENT. INCLUDE IN LINE CITATIONS, MINIMUM OF 6 REFERENCES REQUIRED AMONG WHICH ONE IS THE SOURCE OF THE DATA - THE CORPORATE SITE, AND AT LEAST 5 OTHER SCHOLARLY REFERENCES. |
| THE STATEMENT BELOW IS FOR FORD MOTOR COMPANY TO BE USED BY SOARES ONLY. YOU CHOOSE YOUR OWN COMPANY AND THE RETRIEVED DATA AS DONE IN CLASS |
| | | | | | | | | | REVENUES |
| | | | | | | | | | AUTOMOTIVE | $ 148,294,000,000 |
| | | | | | | | | | CREDIT | $ 12,018,000,000 |
| | | | | | | | | | MOBILITY | $ 26,000,000 |
| | | | | | | | | | TOTAL REVENUES | $ 160,338,000,000 | | REVENUES = AUTOMOTIVE REVENUES + CREDIT REVENUES + MOBILITY REVENUES |
| | | | | | | | | | COSTS AND EXPENSES |
| | | | | | | | | | COSTS OF SALES | $ 136,269,000,000 | | TOTAL COSTS AND EXPENSES = COST OF SALES + SELLING, ADM AND OTHER EXPENSES + CREDIT INTEREST, OPERATING AND OTHER EXPENSES |
| | | | | | | | | | SELLING, ADMINISTRATIVE AND OTHER EXPENSES | $ 11,403,000,000 |
| | | | | | | | | | CREDIT INTEREST, OPERATING AND OTHER EXPENSES | $ 9,463,000,000 | | TOTAL INTEREST EXPENSE = INTEREST EXP. ON AUTOMOTIVE DEBY + INTEREST EXPENSE ON OTHER DEBT |
| | | | | | | | | | TOTAL COSTS AND EXPENSES | $ 157,135,000,000 |
| | | | | | | | | | INTEREST EXPENSE ON AUTOMOTIVE DEBT | $ 1,171,000,000 |
| | | | | | | | | | INTEREST EXPENSE ON OTHER DEBT | $ 57,000,000 |
| | | | | | | | | | TOTAL INTEREST EXPENSE | $ 1,228,000,000 |
| | | | | | | | | | OTHER INCOME (LOSS) | $ 2,247,000,000 |
| | | | | | | | | | EQUITY IN NET INCOME OF AFFILIATED COMPANIES | $ 123,000,000 |
| | | | | | | | | | INCOME BEFORE TAXES | $ 4,345,000,000 | | INCOME BEFORE TAX = TOTAL REVENUES - TOTAL COST AND EXPENSES - TOTAL INTEREST EXPENSE + OTHER INCOME + EQUITY IN NET INCOME OF AFFILIATED COMPANIES |
| | | | | | | | | | PROVISION FOR INCOME TAXES | $ 650,000,000 |
| | | | | | | | | | NET INCOME | $ 3,695,000,000 |
| | | | | | | | | | COMPREHENSIVE INCOME ATTRIBUTABLE TO NONCONTROLLING INTERESTS | $ 18,000,000 |
| | | | | | | | | | NET INCOME ATTRIBUTABLE TO FORD MOTORS COMPANY | $ 3,677,000,000 | | NET INCOME ATTRIBUTABLE TO FORD MOTORS COMPANY = NET INCOME - COMPREHENSIVE INCOME ATTRIBUTABLE |
| | | | | | | | | | AUTOMOTIVE REVENUES ARE THE REVENUES GENERATED THROUGH SALES OF AUTOMOTIVES |
| FULL REPRESENTATION OF THE NUMBERS |
Randy19
Sampleformatexcelsheetforford.xlsx
