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. Question 1 What do you have in cell G39 of your file? LIDATED BALANCE SHEET da millions December 31, 2010 December 31, 30 ASSETS Cash and cash equivo 14.05 20,894 Marketabl sunt (Note 20745 21.347 00 75.392 Finance recevable et (Note 7) Other recevable net Net investen 73 7.194 11.699 17,170 operating les (Note Inventor (Note 10 591 5.041 Fupuity in net 256 216 ailed companies (Note 11) 23.17 22.637 Ne property (No. 1) Deferred 2.00 1.470 es Net intangihle 100 106 (Note 761 Auto hablar sale opers (Note 24) Other 30 Total 14 193.040 14.301 LIABILITHI Payables And lates and deferred revent (Note 17) 43.844 101 131.635 Date Note 19) Deferred income tores 3,421 Liabilities of held For sale peration (Note 24) 5321 Total liabile 165.12 1992 EQUITY Capital wack (Note 25) Com Steck, par value 50.01 17 11 share 13.707 million where issued of 6 billi utte Class Stack, par value $0.01 shar (71 million shares issued 510 th Capital in acesso palu odstock 20,800 16,76 other comprehet (14313 (10.864 Treasury stock (163) ) Retail camins deficit) (704 (13.3901 Total quity attribute to Feed Motor Curga 67.820) Com Stock po Value 30.01 pov where (207 milies shares issued of 6 Nice 37 33 Cou Stock value $0.01 471 milli shares issued 530 million th Capital in ence of por sale 20.03 16.76 of stick Accumula other crepeche comerk 10.64 Treasury stock (10) (177) 031 (3.590 canti deficio Total prity attribute so Feed MO Com (673) (7.820 Equity attributabl to 38 Total quity 1642 Total liabilit and equity 161,587 192.000 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. Question 1 What do you have in cell G39 of your file? LIDATED BALANCE SHEET da millions December 31, 2010 December 31, 30 ASSETS Cash and cash equivo 14.05 20,894 Marketabl sunt (Note 20745 21.347 00 75.392 Finance recevable et (Note 7) Other recevable net Net investen 73 7.194 11.699 17,170 operating les (Note Inventor (Note 10 591 5.041 Fupuity in net 256 216 ailed companies (Note 11) 23.17 22.637 Ne property (No. 1) Deferred 2.00 1.470 es Net intangihle 100 106 (Note 761 Auto hablar sale opers (Note 24) Other 30 Total 14 193.040 14.301 LIABILITHI Payables And lates and deferred revent (Note 17) 43.844 101 131.635 Date Note 19) Deferred income tores 3,421 Liabilities of held For sale peration (Note 24) 5321 Total liabile 165.12 1992 EQUITY Capital wack (Note 25) Com Steck, par value 50.01 17 11 share 13.707 million where issued of 6 billi utte Class Stack, par value $0.01 shar (71 million shares issued 510 th Capital in acesso palu odstock 20,800 16,76 other comprehet (14313 (10.864 Treasury stock (163) ) Retail camins deficit) (704 (13.3901 Total quity attribute to Feed Motor Curga 67.820) Com Stock po Value 30.01 pov where (207 milies shares issued of 6 Nice 37 33 Cou Stock value $0.01 471 milli shares issued 530 million th Capital in ence of por sale 20.03 16.76 of stick Accumula other crepeche comerk 10.64 Treasury stock (10) (177) 031 (3.590 canti deficio Total prity attribute so Feed MO Com (673) (7.820 Equity attributabl to 38 Total quity 1642 Total liabilit and equity 161,587 192.000