exclude #5 from the questions and # 4

AutoSave OFF EU- Insert Home Draw Page Layout Formulas Data Review View Tell me Times New Roman V 10 A A ab Wrap Text Paste BI VE V Merge & C H28 . fx 199822 E F G H December 31, 20,894 C D 1 MPANY AND SUBSIDIARIES 2 3 TED BALANCE SHEET 4 fin millions) 5 December 31, 6 2010 7 ASSETS Cash and cash equivalent 14 ROS Marketabl e securities 9 (Note 6) 20,765 Finance receivable 5, ne 10 (Note7 70,070 Other Toeivable 11 7,388 Net investmen 21,387 75,892 7.194 12 11,675 operating les (Note 8) Inventore s (Note 10) 17,270 13 5,917 5.041 Equity in affiliated companies (Note 11) 14 2,569 2,367 15 Net property Note 14) Deferred income 23.179 22,637 16 2,003 3,479 Net intangible Sheett AutoSave OFF BE SU: Home Insert Draw Page Layout Formulas Data Review View Tell me Times New Roman v 10 A = = Wrap Tex y Paste BI UB > A Merge & H28 fx 199822 A C D E F G H 1 2,003 3,479 Deferred income 16 Net intangible assets 17 (Note 16) 102 165 7,618 6,214 8,096 $ 164,687 192,040 Assets of held for sale operations (Note 24) 18 Other 19 Total 20 21 LIABILIT 22 IES 23 Payables Accrued liabilities and deferred revenue 24 (Note 17) Debt 25 (Note 19) Deferred income 26 16,362 14,301 43,844 46,144 103,988 131,635 1,135 2,421 Liabilities of held for sale operations (Note 24) 27 5,321 Total liabilitie 165,329 199,8221 28 29 30 EQUITY Capital stock (Note 25) 31 AutoSave OFF BESU: Home Insert Draw Page Layout Formulas Data Review View Tell me Times New Roman 10 A Wrap Text Paste BIU Av Merge & Center H28 fx 199822 A B D E G H 1 J K 30 EQUITY Capital stock 31 (Note 25) Commo n Stock par value $0.01 per share 03.707 million shares issued of 6 billion wthorne d) 32 37 33 Class B Stock per value $0.0 per share 71 million shares issued of 530 authorize d) 33 34 20.03 16,786 Capital in Cof per value of stock Accumula to other comprehe mive income oss) Tury stock 35 (14313) (10,864) 36 Sheet1 Paste BIU V Av H28 fx 199822 C D A B E F G H ted other comprehe nsive income oss) Treasury stock 35 (14,313 ) (10,864 ) 36 (163) (177) Retained eurings/ Accumula ted deficit) 37 (7,038 ) (13,599 Total equity/(d eficit) attributa ble to Ford Motor Compan 38 (673) (7.820) Equity (D eficit) attributabl e to noncontro lling interests Total equity/(d 39 31 38 40 eficit) (642 (7.782 Total liabilitie sand equity 41 $ 164,687 $ 192,040 42 43 44 45 46 47 48 49 50 Module 1 Assessment Xisx The file is a Balance Sheet for The Ford Motor Company. You need to format the file for the CEO to read, using the following guidelines: 1. All the data needs to remain within the rows that it exists in now. 2. Your 2010 numbers need to end up in column D, and your 2009 figures in column G. 3. Replace the figures in rows 20, 28, 38, 40 and 41 with formulas to insure that if the data is changed then the figures will calculate the correct totals. 4. Follow the steps from the practice file to format the Assessment file. Use critical thinking skills to create a professional document. 5. Answer the assessment questions based on the file you create - the first question is your file upload, followed by four other questions based on the file. When asked for a figure, enter exactly what is in the cells on your file