Question is based on a excel sheet

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.

What do you have in cell D32 of your file?

B C D E F G . 1 3 CONSOLIDATED BALANCE SHEET (in millions) 4 5 December 31, 2010 December 31, 2009 6 8 $ 9 14,805 20,765 70,070 7,388 11,675 5,917 2,569 23,179 2,003 102 20,894 21,387 75,892 7,194 17,270 5,041 2,367 22,637 3,479 165 7,618 8,096 192,040 6,214 164,687 $ 7 ASSETS Cash and cash equivalents $ Marketable securities (Note 6) 10 Finance receivables, net (Note 7) 11 Other receivables, net 12 Net investment in operating leases (Note 8) 13 Inventories (Note 10) 14 Equity in net assets of affiliated companies (Note 11) 15 Net property (Note 14) 16 Deferred income taxes 17 Net intangible assets (Note 16) 18 Assets of held-for-sale operations (Note 24) 19 Other assets 20 Total assets S 21 22 LIABILITIES 23 Payables S 24 Accrued liabilities and deferred revenue (Note 17) 25 Debt (Note 19) 26 Deferred income taxes 27 Liabilities of held-for-sale operations (Note 24) 28 Total liabilities 29 30 EQUITY 31 Capital stock (Note 25) 32 Common Stock, par value $0.01 per share (3,707 million shares issued of 6 billion authorized) 33 Class B Stock, par value $0.01 per share (71 million shares issued of 530 million authorized) 34 Capital in excess of par value of stock 35 Accumulated other comprehensive income/loss) 36 Treasury stock 37 Retained earnings (Accumulated deficit) 38 Total equity/(deficit) attributable to Ford Motor Company 39 Equity/(Deficit) attributable to noncontrolling interests 40 Total equity/(deficit) 41 Total liabilities and equity $ 16,362 43,844 103,988 1,135 14,301 46,144 131,635 2,421 5,321 199,822 165,329 37 1 20,803 (14,313 ) (163) (7,038 ) (673) 31 (642 ) 164,687 33 1 16,786 (10,864 ) (177) (13,599 ) (7,820 ) 38 (7,782 192,040 $ 42