Question 4 True or False - your worksheet tab is named Income Statement? O True O False 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. Use what you learned 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. When asked for a figure, enter exactly what is in the cells on your file COMPANY AND SUBSIDIARIES IDATED BALANCE SHEET (in millions) December 31. 2010 ASSETS Cash and cash 14.805 equivalent December 31. 2009 20,894 Marketable securities (Note 6) 20,765 20,765 21,387 70,070 75.892 7.388 7.194 Finance receivable: net (Note 7) Other receivable: net Net investment in operating leases (Note 8) Inventories (Note 10) 11.675 17.270 5.917 5,061 Equity in nel assets of affiliated companies (Note 11) 2.569 2.367 23.179 22.637 Net property (Note 14) Deferred income taxes 2,003 3,479 Net 102 165 intangible assets (Note 16) - 7,618 Assets of held for sale operations (Note 24) Other assets Total assets 6.214 8,096 164,687 192.040 LIABILITI 16,362 14,301 Payables Accrued liabilities and 43.844 46,144 deferred revenge (Note 17) 103.988 131.635 1.135 2.421 Debit (Note 19) Deferred income taxes Liabilities of held for-sale operations (Note 24) 5,321 Total 165.329 199,822 liabilitic EQUITY Capital stock (Note 25) Commo Stock par value 30.01 por share (3,707 million shares issued of 6 billion authoriz 37 33 Class B Stock. par value S0.01 per share (71 million shares issued of 530 million authoria of 6 billion authori Class Stock, par value S0.01 per share (71 million shares issued of $30 million authoria Capital in excess of 20,803 16,786 par value of stock Accumula other comprches income (14,313) (10.864) Treasury stock (163) (177) Retained earning deficit) (7,038 (13,5991) Total equity attributa to Ford (673) (7.820) Motor Compat Equity (D attributabb to noncontrol interests 38 Total equity (642) (7.7821) Total liabiliti and equity 164,687 192,040