Please use the following statements to answer the excel formulas, assistance as soon as possible is much needed. Thanks!

Aura 0 Financial Statements Search - Caira N Lewis Fle Home Insert Draw Page Layou: Formulas Data Review View Hep Share Comments 10A General Bad 27 O X Cut Copy Pute 3 Format Panter Clipboard == - Wrap Test === 45 E Merge Carter Auringum F Clear Normal Condo formats Calculation Fuum.lling to Tile- Good Neutral Explanatory... put ON Anstre 1 -A- 5 % 913 Check Cell Insert Delme met Sort find File - S Fant Alannen Number Shytes Cels Eden Analys K20 n F G . V N 9 R 5 0110320 USD Net Guilled Yes Mure 1014 7231 193 235 - 1945 -111 -1941 83 224 -255 121251201 wa USD Not Qualne Yes Midhura 1511 2009 977 1296 CES 1140 A 7 Forte nedsatt the Year Infrasorted date 2 10 AS Reported Annual Cash Flow 11 Report that 12 currency Audit Status 13 14 Consolidated 15 Soal 16 ore 17 largos 11 DAILER & ul properly arugi 1n exato mancatan 19 Asus wieder 20 Contraten reveal 21 Nessa 1991) of 59 ruan 22 Detax per 23 Credit losses accounts recevable conces 24 A 25 hvers As payable 27 Oner current current assets 22 Ore 29 Netcash out from SU A pily Preces from the passer EAST S2 Acqualas, ne faqed Purchan tractante S4 Baesar acesta 25 respetarie acuty,nat 58 Oher investing videa, primarily licenses nestones se Safarvested 58 Dividends to strenes Rechers maak 40 Proceeds from short-ermdebt 41 sayesisha 42 Process from longiomet, nance costs 43 Huseymunluk-bermdett Procesde from the verse of stock options or oplyse wholding tax on stock wards, 45 Dredd place 16 Other Trang 47 Netic in Ma-ferrate changes on parh Chi siete, 49 ccaacccrease in cean & shquare 0 Cash Latina 51 Cash & conquesta end of year : Dash said during the year far til 53 Cash Belluring the year for interest ret of amount ceptekad 34 Chargt ywer for 55 2154 -2475 -20 -280 277 4380 1922 1425 2010 -3458 2794 2355 34 -7323 2100 12:37 -521 -5810 1920 3287 330 44 -1 -9911 -674 30 -900 3 -10411 -37221 3391 2003 7431 -1084 1914 -35 394 95% SP -3220 17.335 13985 934 341 21 19 -12315 P -302 101T 17205 998 985 4111 ST 32 59 Insome Statement Balance Sheet Cash Flow Statement + ol Ready Type here to search O . D1 o' 11:00 AM 13/17/2001 Auto H Financial statements Search - Caira N Lewis Fle Draw Page Layout Formulas Data Review View Help Share Comments 10 AA Guntal Bad Neutral Good 47 Home Insert X Cut In Copy 3 Format Pante Clipboard == - 2 Wrap Test == = = = = = Meige & Carter F Paste Normal Condona Tomatx Calculation Formatting Table ON Anstie BI -A 5% Check Cell Insert Delme met Exploratory... input Clear Sort & Tind File - S Fant Alat Number Shytes Cels Eden Salus 112 D F B L N N N o P R S 94 4 Pornedb.Cleath 5 Johnson & Johnson (NYS: JNJ) 7 Exchange sedis alal the Year End reported ale 32444 01/03/202 USD Not Guarded Yes Millions 1395 11200 1381 . an 203 13575 1410 2040 5804 9344 3132 21 Ramen 34434 1799 32835 792 7214 5761 2220 3078 SEN 250 11310 547 10771 16 11944 4042 111616 3120 -893 4 121291201 USU Not Qualified Yes Milicas We 1 Da 14707 226 14481 1117 123 an 6071 9020 2992 94 45774 884 11877 26064 DES 3537 33 43232 25574 28 17568 47543 2010 33539 7819 cenc 5595 157728 1202 8544 9715 10 3254 2266 35084 51 2532 24999 18 27594 1100 25494 FACE 5958 SER 2297 3004 20 ... 338 11177 -314 es 7444 11734 479 98257 490 3120 -8705 20 Note Other long-term dat Total long-term debt Les current porton Long-term debit - Deferred as an income Pansion bantis Pastrarementant Poshamplament heeft for Deferred compensation Total employer obligations Les current benets payabia withe Employee related obligations Long-term payable Other Tota labilities Common stock Feral Foreign currenyans Caindoss) un Employee benet plans Gainda) ondershed Accumulated other comprehensanooma osa) Ratained earningsmand defd Total Douby before reasury stock Les common stock held in treasury cost Total shareholders' eguny (fic) y 10 As Keported Annual Wulance Shen 11 Report Date 12 Currency Audit Status 13 14 Consolidated 15 Scale 16 Cash Rath walents 17 Nabbi se 1a laccus recebe trades 10 19 LAS Blowancas do Accounts ure 20 Accouns cabaran a raw materials & Supplies 22 Goods in process ... 23 Finished goods 24 Inventories 25 Prepaid expenses & other relate Bald 26 Assets held for cate her sale 27 Total current 2a Land and improvements 29 Alings & bulding quement 30 Machinery & apment 31 Construction in progress 2 Total property plant & equipment ress 33 LARS med depreciation 34 Property blant & aqupment, net 35 Inangible in 36 Goodwi CA 37 Petani 37 Deferred as an income rassets 39 Total assets 40 Loans notes parate 41 Account 42 Acordes 43 Accedebant.ms & promotions 44 Accrued compensation & amor dabigations 45 Acordes on income 46 Tol 46 Total current liabiles 47 Zara coupon converble subordinated debentures 4 Cables 49 Income Statemen Balance Sheet Ready E Type here to search .4 13 51237 BRO 12502 29-04 47 4316 46804 COM 28038 18756 53402 36301 ac 8534 6562 174804 2631 9505 100 11513 3414 1302 42403 -1991 20 -295 -15191 - 2057 SC 652 -15242 113890 101768 33490 63278 Shar 110659 9788 38417 50471 X 1983 Dropbo Screenshot Added A screenshot was added to your A Dropbox Cash How Statement + LA O DI 10:39 AM 13/17/2001 Archer BP Financial Statements Search (10) - Caira N Lewis Draw Page Layout Formulas Data Review View Help Share Comments 10 A A General Bad Goud Neutral Fle Home Insert FX X Cut Copy Paste 3 Format Painter Clipboard 27 O === - Wrap Test = = = = Meige & Center Es F BI Normal Condon Tomates Calculation Formatting Table ON Anstre 11 5 % 911 Incert De Form 0-A- Check Cell Exploratory input Clear Sort Find File su Fant Alannen Number Cels Feng Salus A28 Net carnings (los) D T 1 1 M N D P R II w X 94 Powys Chute Johnson & Johnson (NYS: JNJ) 7 Carrerate raden the Year Indrasented 10 As Reported Annual Income Statement 11 Reportate 12 Currency Audit Status 19 14 Consolidated 15 Seal 16 forelcumentation du 17 Dual uludattaa 10 mes piste) 19 Sub capenas 20 Racer Ada ATESTATA 21-process caearch & devchan 0212121 USO Net Quained Yes Mithuna 62584 2842) 1920 USD Nort Qualified Yes M 32069 2255 54500 22178 11360 890 2384 12 " 31 23 rest expense of portion capital 231 S18 der (enne -2100 -20 25 Restructuring 247 260 26 Emile biten Te-U.S 3540 27 Eemings loss before wes on romerne 12:36 13785 28 Bara bore prevenir lesen 184 1792 29 Current states provision (benefit 104 1941 SU DU.SE 31 9) Current inter altres prolone 1390 S2 Total CCI BARS PRU 2124 Datera UAE heart -76 M S4 Deerd U.S. ea interduperelons 23 Ferra instalace prisen haalt 1055 1 Se Total de contexea provision (re) -141 -2478 JT Pikanter one 175 771a Neseemines ikea 14714 15119 sa Winter geen 40 Weigned averege shares outstardino-dised 2670.7 25701 26843 41 Yanduarding 2212312 20 SOT 42 Net een koper stare 672 45 Neaming parhare- 5.51 KY 44 Cash Mats per a 3.96 375 3 45 Tilkyusa 198430 1992 46 Number of contentcodes 15237 135 47 Free calley klerenta -233 184 an 49 PO 51 ! 59 Income Statement Balance sheet Cash Flow Statement Ready Type here to search O + ol OF o' 10:58 AM 13/17/2001 Acer 0 HN 320 Project we Franca Formulastutulisher Search - Caira N Lewis Fle Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Arinum Gibi II AA General Bad F X Cut Copy arte 3 Format Panter Clipboard 2 Wrap Test === & 45 E Merge Cartier Goud Neutral Explanatory... put Normal Condtional Formates Calculation Furmaling talu 47 0 Sort find File - S B1- 5 % 913 Check Cell Insert Delene Format Clear ON Anste Delal Analys Fant Alqen Nunc Eden 131 A B B C D E M N 0 P RS G ACCOUNTING & FINANCIAL RATIOS CURRENT RATIO (Current Assets / Current liabilities) TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets) 5 Current Assets Current abilities 51,237,000 42,493,000 Total Revenue Total Assets 82,584,000 174,894,000 1.205775069 0.472194586 6 7 8 9 10 WORKING CAPITAI (Current Assets - Current liabilities) FINANCIAL I FVFRAGF (Total Assets / Shareholder's Fquity) Current Assets 51,737,000 42,493,000 Total Assets Shareholder's Equity 174,894,000 63,278,000 Current Liabilities 8/44000 2./63898985 12 13 14 DEBT RATIO (Total Debl/Total Assets) NET PROFIT MARGIN (Net Income / Total Revenue) Neting Total Deut Total Assets 111,616,000 171,891,000 0.638192276 Total Revenus #DIV/0! 15 16 17 18 19 20 21 22 23 24 25 26 27 EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding) RETURN ON ASSETS (Net Income / Total Assets) Nel Inc Nel come Shares Outstanding 14,714 2,632.51 5.589342491 14,714,000 174,894,000 Total Assets 0.084130959 PRICF FARNINGS RATIO (Share Price (end of quarter / FPS) RETURN ON FQUITY Net Income - Preferred Dividends /Shareholder's Fquity) 26 Stock Price Jers 159.2 2.32 INI - Pref. Di Shareholder's Equity 12081.2 63278 68.62068966 0.190922596 29 30 31 32 33 34 RATIOS Monthly Annual PV FV PV Lump Sum FV-Lumo Sum NPV + Ready 1 100% Type here to search O O S OF o' 10:57 AM 13/17/2001 Archer BP HN 320 Project we Franca Formulastutulisher Search - Caira N Lewis Fle Home Insert Draw Page Layout Formulas Data REYCH View Help Share Comments Caibi 12 AA Auringum - 2 Wrap Test Gunara Normal Bad Goud Neutral F X Cut Copy 3 format Panter Clipboard 47 0 Sort & Find File su (@ ON Anstre Paste B1- Incert De Form === 45 E Merge Cartier 5 % 91 Condtional Formates Calculation Fumetting Table Check Cell Exploratory input Clear Fant Alanen Number Cels Eden Analys All Je 0 F 3 T U V W Y z He AC HD AE AF 1 2 Rate of Return 3 til Investment 4 5 7 A 9 10 11 12 13 14 15 16 17 D F C OH I J K L L M N O N P Time Value of Money Monthly Compoundink Year Month 1 2 3 4 5 6 7 8 9 10 11 12 8 narest su $ $0 SO Sa Su $0 $0 so Sa su $0 Investment Valud 30 salsal $0 30 Year 2 Martha Su 12 7 9 11 Interest 50 50 50 50 50 $ 30 50 50 50 sn sn 50 LAVA 50 50 50 60 9030 so so so 50 sal sal sal 50 Years Month 2 3 4 5 6 7 8 9 10 11 12 7 interest so - SO 50 50 sol SO SC 50 Investment Value SO 50! $ SO! sol sol SC 501 sol $0 sol 50 sol SO sol SC Year Month 1 S 4 5 6 7 9 10 11 12 Interest so 090 90 90 sol so $0 FO Larven. Vulus 900 so SO su sol 90 sul su su 901 sal so SC su $ Years Month 1 2 3 4; 920 1 12 13 Interest $0 50 50 so Sa $0 $0 50 $0 Sa $u $0 Investment Value sa 50 50 $ sal $n 50 50 $0 Sn 30 Year 6 Manith T2S 0 11 12 1 5 6 7 10 Interest 50 50 50 50 50 50 50 50 50 50 50 50 Laaman SO 5050505050 SO sal 50 so so so so 10 50 Year 7 Month 1 2 3 4 5 6 7 8 1 4 9 10 11 12 interest $0 $0 50 501 sol SO $o 50 501 SD so solo $0 Investment Value sol sc sel 50 501 sol SO sol 50 sol so so Year Month 2 5 7 9 10 11 12 In cual sol 0 0 S SO SO so se SU SO 30 Invest Value su su SOS sol so su u SU sal su SU su su SU Year Month 1 2 3 4 5 6 7 9 10 11 12 M 9 interest $50 0 50 so so $n 50 SD $ sa $ SO Inveemer ud Valu 50 50 50 $ sal sn 50 30 $ san sol $ 50 Year 10 Math 1 2 3 5 7 9 10 1 12 Interest SO O 30 SO SOI SO SO 50 50 50 SO O Investment Valu SO sol 90 sol 50 so 90 sol SO SO 50 "TIT LI 10 44 45 RATIOS Monthly Anual PV FV PY PV Lump Sum FV - LUT Sum NPV + Ready 1 Type here to search O O 10:57 AM E. s . D1 o' 13/17/2001 Archer BP HN 320 Project we Franca Formulastutulisher D Search (10) - Caira N Lewis Fle Home Insert Draw Page Layout Formulas Data Review View Share Comments Auringum Calibri 12 A - 2 Wrap Test Gunara Bad 27 0 F X Cut Copy 3 format Panter Clipboard Goud Neutral Exploratory input Paste Normal Condtional Tommates Calculation Funneling - == BI- 5 - % 912 45 Merge Cartier Insert Dele om Check Cell Clear Sort & linda File su (@ ON Anstyne Dalai Analys Fant Alq Number Shymes Cels Feng C17 for D Q R 8 T U V W X Y Z NA PE AC AD NE AF 7 F C H I J K L H Time Value of Money - Annual Compounding 1 2 3 4 5 6 7 8 4 G SO SO $ 50 50 50 SO 50 O 50 su $u $0 $0 sal su $0 $0 2 Fate of Return Este 3 Initial Investment 9 Yes Interest resimari Valud 50 SO $0 4 A 9 10 11 12 14 15 16 17 a 10 44 15 RATIOS Monthly Annual PV FV PV Lumpsum FV - Luna Sum NPV + Ready Type here to search O ET AF 10:56 AM 13/17/2001 Audio 9 HN 320 Project we Franca Formulastutulisher Search - Caira N Lewis Fle Home Insert Draw Page Layout Formulas Data REVIC View Share Comments Calibri Auringum 14 A Gunun FX X Cut Copy 3 rammet anter Clipboard - 2 Wrap Test = = Merge Carter & F Bad Goud Neutral Check CellEtory, Exploratory input Normal Cendon Tomates Calculation Furmulting - Table 47 0 Sort find File su BTW -A 5 - % 9 21-2 Inzert Delarom Clear ON Anstre Dalai Analys Fant Alignment Number deng G H K 1 MN OP R R S T U V W X Y Z A4 Al f Time Value of Money Present Value Annuity B G D F Timre Value of Money - Present Value Anruily 2 Number of Years 3. Rate of Return $0.00 $ 4 Payment 5 8 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 20 29 30 31 32 33 34 35 36 RATIOS Monthly Arnul PV py FV PV - Lumpsum FV - Luna Sum NPV + Ready 100% Type here to search o . D1 o' 10:58 AM 13/17/2001 Archer BP HN 320 Project we Franca Formulastutulisher Search - Caira N Lewis Fle Home Insert Draw Page Layout Formulas Data REYCH View Share Comments Calibri 12 AA Auringum Gunud Bad Goud Neutral F FX X Cut Copy Paste format Clipboard = - 2 Wrap Test ==== 45 Meige & Carter Alqen 47 Sort find File - S -A- Normal Condo format calculation Furmulting - Table BIL- 5 - % 9 21-2 Check Cell Inzert Delarom Exploratory input Clear ON Anstre Dalai Araus Fant Nu Cels deng E F H K KL M N P Q R S T T U VW X Y Z AA G37 Jo B C D Time Value of Murey - Future Value Annuity 2 Number of Years 3 Rate of Return S0.00 4 Payment 5 8 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 20 29 30 31 32 33 34 35 36 Dropbox Screenshot Added A screenshot was added to your Dropbox RATIOS Monthly Arnul PY FV PV-lump Sum FV - Lum Sum NPV + Ready LA TU Type here to search O S DI 10:58 AM 13/17/2001 Archer BP HN 320 Project Iwe Hardal Formulas tutuisher Search - Caira N Lewis Fle Home Insert Draw Page Layout Formulas Data REVIC View Share Comments General Bad Goud Neutral - Normal Condone format calculation Furmaling - Table 5 - % 912 Check Cell Exploratory input ON Analyse Inzert Delarom Auringum 47 0 F Sort Find Clear File - Su deng . Nu Cels Analys . K LM N NO P Q RS S T UV W X Y Z Z AA AB - 3 FX X Cut Calibri 14 A - 2 Wrap Test Copy Paste BTW -A === Morge Care 3 Format Panter Clipboard Fant Alignet A1 f Time Value of Money - Present Value of Lump Sum D F G H Time Value of Money - Present Value of Lump Sum 2 2 Rate 3 Years $0.00 4 Initial Investment 5 8 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 22 24 25 26 27 20 29 30 31 32 33 34 35 36 X Dropbox Screenshot Added A screenshot was added to your Dropbox RATIOS Monthly Annual PV FV PV - Lump Sum FV - Lum Sum NPV + Ready LA TU Type here to search o E. S DI 10:55 AM 13/17/2001 Auto PE- HN 320 Project Iwe Hardal Formulas tutuisher Search - Caira N Lewis Fle Home Insert Draw Page Layout Formulas Data REVIC View Share Comments Ganuel Bad Goud Neutral Normal Condon Format Calculation Formatting Table 5 - % 912 Check Cell Insert Palmy Exploratory input Auringum 47 0 F Sort & Find Clear File - Su deng (@ ON Analyse Dalai Seals Number Cels J K LM N o P Q R S T U V W X Y Z $ X Cut Calibri 14 AA - 2 Wrap Test Copy BTW -A = = + Merge Cartier 3 Format Panter 45 & Clipboard Fant Alg Al A f Time Value of Money - Future Value of Lump Sum B F H Time Value of Money - Future Value of Lumip Surn 2 Rate 3 Years $0.00 4 Initial Investment 5 8 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 22 24 25 26 27 20 29 30 31 32 33 34 35 36 Dropbox Screenshot Added A screenshot was added to your Dropbox RATIOS Monthly Arnual PV FV PV - Lump Sum FV Lump Sum - NPV (+) Ready TU Type here to search O S DI 10:56 AM 13/17/2001 Archer BP HN 320 Project we Franca Formulastutulisher D Search (10) - Caira N Lewis Fle Home Insert Draw Page Layout Formulas Data Review View Share Comments Gibi 12 AA Auringum - 2 Wrap Test Percentage Bad Goud Neutral 47 0 X Cut Copy Format Panter F BTW- -A- Normal Condone formats Calculation Fuumaling - ==== Mage & Carter 45 5 - % 912 Check Cell Exploratory... input Insert Delme me Clear Sort & Tind File - S ON Anatyre Dale Analys Clipboard Fant Alignment Number Styles Cels deng BG C D E F L M N N OP R S U V W X 1 H J Net Present Value (NPV) Calculator Building Year 2 2 5 9 10 so SO $0 so 1 $0 11 sol 3 $o 13 So Cash Flows Year Cashflows 4 so 14 90 7 so 17 SU sol 15 NPV = $0 12 16 $0 $ 18 $ 19 20 SO SU so 30 2 3 4 Initial Investment 5 Annual Cash Inflows 6 Discount Rate 7 Number of Years B Salvage Value 9 10 11 12 13 14 initial investment 15 Annual Cash Inflows 16 Discount Rate 17 Number of Years 18 Salvage Value 19 20 21 22 Equipment 3 4 7 8 so O Year Cash Flows Year Cash Flows SO 1 so 11 90 5 sol 15 2 $0 12 50 6 so 16 $0 9 $o 19 50 10 so 20 $0 NPV = $0 13 14 17 18 90 $0 sol Bonds 23 NPV = $0 1 3 4 5 7 8 9 10 Year Cash Flows sal 6 sol $ 90 90 90 $0 $0 $a 90 90 24 Initial Investment 25 Annual Cash Inflows 26 Discount Rate 27 Number of Years 28 Principal Returned 29 30 31 32 33 34 35 RATIOS Dropbox Screenshot Added ** A screenshot was adoed to your Dropbox Monthly Arnus P PV PV - Lumpsum FV - Lum Sum NPV + Ready TU Type here to search O E: S g DI 10:56 AM 13/17/2001 Aura 0 Financial Statements Search - Caira N Lewis Fle Home Insert Draw Page Layou: Formulas Data Review View Hep Share Comments 10A General Bad 27 O X Cut Copy Pute 3 Format Panter Clipboard == - Wrap Test === 45 E Merge Carter Auringum F Clear Normal Condo formats Calculation Fuum.lling to Tile- Good Neutral Explanatory... put ON Anstre 1 -A- 5 % 913 Check Cell Insert Delme met Sort find File - S Fant Alannen Number Shytes Cels Eden Analys K20 n F G . V N 9 R 5 0110320 USD Net Guilled Yes Mure 1014 7231 193 235 - 1945 -111 -1941 83 224 -255 121251201 wa USD Not Qualne Yes Midhura 1511 2009 977 1296 CES 1140 A 7 Forte nedsatt the Year Infrasorted date 2 10 AS Reported Annual Cash Flow 11 Report that 12 currency Audit Status 13 14 Consolidated 15 Soal 16 ore 17 largos 11 DAILER & ul properly arugi 1n exato mancatan 19 Asus wieder 20 Contraten reveal 21 Nessa 1991) of 59 ruan 22 Detax per 23 Credit losses accounts recevable conces 24 A 25 hvers As payable 27 Oner current current assets 22 Ore 29 Netcash out from SU A pily Preces from the passer EAST S2 Acqualas, ne faqed Purchan tractante S4 Baesar acesta 25 respetarie acuty,nat 58 Oher investing videa, primarily licenses nestones se Safarvested 58 Dividends to strenes Rechers maak 40 Proceeds from short-ermdebt 41 sayesisha 42 Process from longiomet, nance costs 43 Huseymunluk-bermdett Procesde from the verse of stock options or oplyse wholding tax on stock wards, 45 Dredd place 16 Other Trang 47 Netic in Ma-ferrate changes on parh Chi siete, 49 ccaacccrease in cean & shquare 0 Cash Latina 51 Cash & conquesta end of year : Dash said during the year far til 53 Cash Belluring the year for interest ret of amount ceptekad 34 Chargt ywer for 55 2154 -2475 -20 -280 277 4380 1922 1425 2010 -3458 2794 2355 34 -7323 2100 12:37 -521 -5810 1920 3287 330 44 -1 -9911 -674 30 -900 3 -10411 -37221 3391 2003 7431 -1084 1914 -35 394 95% SP -3220 17.335 13985 934 341 21 19 -12315 P -302 101T 17205 998 985 4111 ST 32 59 Insome Statement Balance Sheet Cash Flow Statement + ol Ready Type here to search O . D1 o' 11:00 AM 13/17/2001 Auto H Financial statements Search - Caira N Lewis Fle Draw Page Layout Formulas Data Review View Help Share Comments 10 AA Guntal Bad Neutral Good 47 Home Insert X Cut In Copy 3 Format Pante Clipboard == - 2 Wrap Test == = = = = = Meige & Carter F Paste Normal Condona Tomatx Calculation Formatting Table ON Anstie BI -A 5% Check Cell Insert Delme met Exploratory... input Clear Sort & Tind File - S Fant Alat Number Shytes Cels Eden Salus 112 D F B L N N N o P R S 94 4 Pornedb.Cleath 5 Johnson & Johnson (NYS: JNJ) 7 Exchange sedis alal the Year End reported ale 32444 01/03/202 USD Not Guarded Yes Millions 1395 11200 1381 . an 203 13575 1410 2040 5804 9344 3132 21 Ramen 34434 1799 32835 792 7214 5761 2220 3078 SEN 250 11310 547 10771 16 11944 4042 111616 3120 -893 4 121291201 USU Not Qualified Yes Milicas We 1 Da 14707 226 14481 1117 123 an 6071 9020 2992 94 45774 884 11877 26064 DES 3537 33 43232 25574 28 17568 47543 2010 33539 7819 cenc 5595 157728 1202 8544 9715 10 3254 2266 35084 51 2532 24999 18 27594 1100 25494 FACE 5958 SER 2297 3004 20 ... 338 11177 -314 es 7444 11734 479 98257 490 3120 -8705 20 Note Other long-term dat Total long-term debt Les current porton Long-term debit - Deferred as an income Pansion bantis Pastrarementant Poshamplament heeft for Deferred compensation Total employer obligations Les current benets payabia withe Employee related obligations Long-term payable Other Tota labilities Common stock Feral Foreign currenyans Caindoss) un Employee benet plans Gainda) ondershed Accumulated other comprehensanooma osa) Ratained earningsmand defd Total Douby before reasury stock Les common stock held in treasury cost Total shareholders' eguny (fic) y 10 As Keported Annual Wulance Shen 11 Report Date 12 Currency Audit Status 13 14 Consolidated 15 Scale 16 Cash Rath walents 17 Nabbi se 1a laccus recebe trades 10 19 LAS Blowancas do Accounts ure 20 Accouns cabaran a raw materials & Supplies 22 Goods in process ... 23 Finished goods 24 Inventories 25 Prepaid expenses & other relate Bald 26 Assets held for cate her sale 27 Total current 2a Land and improvements 29 Alings & bulding quement 30 Machinery & apment 31 Construction in progress 2 Total property plant & equipment ress 33 LARS med depreciation 34 Property blant & aqupment, net 35 Inangible in 36 Goodwi CA 37 Petani 37 Deferred as an income rassets 39 Total assets 40 Loans notes parate 41 Account 42 Acordes 43 Accedebant.ms & promotions 44 Accrued compensation & amor dabigations 45 Acordes on income 46 Tol 46 Total current liabiles 47 Zara coupon converble subordinated debentures 4 Cables 49 Income Statemen Balance Sheet Ready E Type here to search .4 13 51237 BRO 12502 29-04 47 4316 46804 COM 28038 18756 53402 36301 ac 8534 6562 174804 2631 9505 100 11513 3414 1302 42403 -1991 20 -295 -15191 - 2057 SC 652 -15242 113890 101768 33490 63278 Shar 110659 9788 38417 50471 X 1983 Dropbo Screenshot Added A screenshot was added to your A Dropbox Cash How Statement + LA O DI 10:39 AM 13/17/2001 Archer BP Financial Statements Search (10) - Caira N Lewis Draw Page Layout Formulas Data Review View Help Share Comments 10 A A General Bad Goud Neutral Fle Home Insert FX X Cut Copy Paste 3 Format Painter Clipboard 27 O === - Wrap Test = = = = Meige & Center Es F BI Normal Condon Tomates Calculation Formatting Table ON Anstre 11 5 % 911 Incert De Form 0-A- Check Cell Exploratory input Clear Sort Find File su Fant Alannen Number Cels Feng Salus A28 Net carnings (los) D T 1 1 M N D P R II w X 94 Powys Chute Johnson & Johnson (NYS: JNJ) 7 Carrerate raden the Year Indrasented 10 As Reported Annual Income Statement 11 Reportate 12 Currency Audit Status 19 14 Consolidated 15 Seal 16 forelcumentation du 17 Dual uludattaa 10 mes piste) 19 Sub capenas 20 Racer Ada ATESTATA 21-process caearch & devchan 0212121 USO Net Quained Yes Mithuna 62584 2842) 1920 USD Nort Qualified Yes M 32069 2255 54500 22178 11360 890 2384 12 " 31 23 rest expense of portion capital 231 S18 der (enne -2100 -20 25 Restructuring 247 260 26 Emile biten Te-U.S 3540 27 Eemings loss before wes on romerne 12:36 13785 28 Bara bore prevenir lesen 184 1792 29 Current states provision (benefit 104 1941 SU DU.SE 31 9) Current inter altres prolone 1390 S2 Total CCI BARS PRU 2124 Datera UAE heart -76 M S4 Deerd U.S. ea interduperelons 23 Ferra instalace prisen haalt 1055 1 Se Total de contexea provision (re) -141 -2478 JT Pikanter one 175 771a Neseemines ikea 14714 15119 sa Winter geen 40 Weigned averege shares outstardino-dised 2670.7 25701 26843 41 Yanduarding 2212312 20 SOT 42 Net een koper stare 672 45 Neaming parhare- 5.51 KY 44 Cash Mats per a 3.96 375 3 45 Tilkyusa 198430 1992 46 Number of contentcodes 15237 135 47 Free calley klerenta -233 184 an 49 PO 51 ! 59 Income Statement Balance sheet Cash Flow Statement Ready Type here to search O + ol OF o' 10:58 AM 13/17/2001 Acer 0 HN 320 Project we Franca Formulastutulisher Search - Caira N Lewis Fle Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Arinum Gibi II AA General Bad F X Cut Copy arte 3 Format Panter Clipboard 2 Wrap Test === & 45 E Merge Cartier Goud Neutral Explanatory... put Normal Condtional Formates Calculation Furmaling talu 47 0 Sort find File - S B1- 5 % 913 Check Cell Insert Delene Format Clear ON Anste Delal Analys Fant Alqen Nunc Eden 131 A B B C D E M N 0 P RS G ACCOUNTING & FINANCIAL RATIOS CURRENT RATIO (Current Assets / Current liabilities) TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets) 5 Current Assets Current abilities 51,237,000 42,493,000 Total Revenue Total Assets 82,584,000 174,894,000 1.205775069 0.472194586 6 7 8 9 10 WORKING CAPITAI (Current Assets - Current liabilities) FINANCIAL I FVFRAGF (Total Assets / Shareholder's Fquity) Current Assets 51,737,000 42,493,000 Total Assets Shareholder's Equity 174,894,000 63,278,000 Current Liabilities 8/44000 2./63898985 12 13 14 DEBT RATIO (Total Debl/Total Assets) NET PROFIT MARGIN (Net Income / Total Revenue) Neting Total Deut Total Assets 111,616,000 171,891,000 0.638192276 Total Revenus #DIV/0! 15 16 17 18 19 20 21 22 23 24 25 26 27 EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding) RETURN ON ASSETS (Net Income / Total Assets) Nel Inc Nel come Shares Outstanding 14,714 2,632.51 5.589342491 14,714,000 174,894,000 Total Assets 0.084130959 PRICF FARNINGS RATIO (Share Price (end of quarter / FPS) RETURN ON FQUITY Net Income - Preferred Dividends /Shareholder's Fquity) 26 Stock Price Jers 159.2 2.32 INI - Pref. Di Shareholder's Equity 12081.2 63278 68.62068966 0.190922596 29 30 31 32 33 34 RATIOS Monthly Annual PV FV PV Lump Sum FV-Lumo Sum NPV + Ready 1 100% Type here to search O O S OF o' 10:57 AM 13/17/2001 Archer BP HN 320 Project we Franca Formulastutulisher Search - Caira N Lewis Fle Home Insert Draw Page Layout Formulas Data REYCH View Help Share Comments Caibi 12 AA Auringum - 2 Wrap Test Gunara Normal Bad Goud Neutral F X Cut Copy 3 format Panter Clipboard 47 0 Sort & Find File su (@ ON Anstre Paste B1- Incert De Form === 45 E Merge Cartier 5 % 91 Condtional Formates Calculation Fumetting Table Check Cell Exploratory input Clear Fant Alanen Number Cels Eden Analys All Je 0 F 3 T U V W Y z He AC HD AE AF 1 2 Rate of Return 3 til Investment 4 5 7 A 9 10 11 12 13 14 15 16 17 D F C OH I J K L L M N O N P Time Value of Money Monthly Compoundink Year Month 1 2 3 4 5 6 7 8 9 10 11 12 8 narest su $ $0 SO Sa Su $0 $0 so Sa su $0 Investment Valud 30 salsal $0 30 Year 2 Martha Su 12 7 9 11 Interest 50 50 50 50 50 $ 30 50 50 50 sn sn 50 LAVA 50 50 50 60 9030 so so so 50 sal sal sal 50 Years Month 2 3 4 5 6 7 8 9 10 11 12 7 interest so - SO 50 50 sol SO SC 50 Investment Value SO 50! $ SO! sol sol SC 501 sol $0 sol 50 sol SO sol SC Year Month 1 S 4 5 6 7 9 10 11 12 Interest so 090 90 90 sol so $0 FO Larven. Vulus 900 so SO su sol 90 sul su su 901 sal so SC su $ Years Month 1 2 3 4; 920 1 12 13 Interest $0 50 50 so Sa $0 $0 50 $0 Sa $u $0 Investment Value sa 50 50 $ sal $n 50 50 $0 Sn 30 Year 6 Manith T2S 0 11 12 1 5 6 7 10 Interest 50 50 50 50 50 50 50 50 50 50 50 50 Laaman SO 5050505050 SO sal 50 so so so so 10 50 Year 7 Month 1 2 3 4 5 6 7 8 1 4 9 10 11 12 interest $0 $0 50 501 sol SO $o 50 501 SD so solo $0 Investment Value sol sc sel 50 501 sol SO sol 50 sol so so Year Month 2 5 7 9 10 11 12 In cual sol 0 0 S SO SO so se SU SO 30 Invest Value su su SOS sol so su u SU sal su SU su su SU Year Month 1 2 3 4 5 6 7 9 10 11 12 M 9 interest $50 0 50 so so $n 50 SD $ sa $ SO Inveemer ud Valu 50 50 50 $ sal sn 50 30 $ san sol $ 50 Year 10 Math 1 2 3 5 7 9 10 1 12 Interest SO O 30 SO SOI SO SO 50 50 50 SO O Investment Valu SO sol 90 sol 50 so 90 sol SO SO 50 "TIT LI 10 44 45 RATIOS Monthly Anual PV FV PY PV Lump Sum FV - LUT Sum NPV + Ready 1 Type here to search O O 10:57 AM E. s . D1 o' 13/17/2001 Archer BP HN 320 Project we Franca Formulastutulisher D Search (10) - Caira N Lewis Fle Home Insert Draw Page Layout Formulas Data Review View Share Comments Auringum Calibri 12 A - 2 Wrap Test Gunara Bad 27 0 F X Cut Copy 3 format Panter Clipboard Goud Neutral Exploratory input Paste Normal Condtional Tommates Calculation Funneling - == BI- 5 - % 912 45 Merge Cartier Insert Dele om Check Cell Clear Sort & linda File su (@ ON Anstyne Dalai Analys Fant Alq Number Shymes Cels Feng C17 for D Q R 8 T U V W X Y Z NA PE AC AD NE AF 7 F C H I J K L H Time Value of Money - Annual Compounding 1 2 3 4 5 6 7 8 4 G SO SO $ 50 50 50 SO 50 O 50 su $u $0 $0 sal su $0 $0 2 Fate of Return Este 3 Initial Investment 9 Yes Interest resimari Valud 50 SO $0 4 A 9 10 11 12 14 15 16 17 a 10 44 15 RATIOS Monthly Annual PV FV PV Lumpsum FV - Luna Sum NPV + Ready Type here to search O ET AF 10:56 AM 13/17/2001 Audio 9 HN 320 Project we Franca Formulastutulisher Search - Caira N Lewis Fle Home Insert Draw Page Layout Formulas Data REVIC View Share Comments Calibri Auringum 14 A Gunun FX X Cut Copy 3 rammet anter Clipboard - 2 Wrap Test = = Merge Carter & F Bad Goud Neutral Check CellEtory, Exploratory input Normal Cendon Tomates Calculation Furmulting - Table 47 0 Sort find File su BTW -A 5 - % 9 21-2 Inzert Delarom Clear ON Anstre Dalai Analys Fant Alignment Number deng G H K 1 MN OP R R S T U V W X Y Z A4 Al f Time Value of Money Present Value Annuity B G D F Timre Value of Money - Present Value Anruily 2 Number of Years 3. Rate of Return $0.00 $ 4 Payment 5 8 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 20 29 30 31 32 33 34 35 36 RATIOS Monthly Arnul PV py FV PV - Lumpsum FV - Luna Sum NPV + Ready 100% Type here to search o . D1 o' 10:58 AM 13/17/2001 Archer BP HN 320 Project we Franca Formulastutulisher Search - Caira N Lewis Fle Home Insert Draw Page Layout Formulas Data REYCH View Share Comments Calibri 12 AA Auringum Gunud Bad Goud Neutral F FX X Cut Copy Paste format Clipboard = - 2 Wrap Test ==== 45 Meige & Carter Alqen 47 Sort find File - S -A- Normal Condo format calculation Furmulting - Table BIL- 5 - % 9 21-2 Check Cell Inzert Delarom Exploratory input Clear ON Anstre Dalai Araus Fant Nu Cels deng E F H K KL M N P Q R S T T U VW X Y Z AA G37 Jo B C D Time Value of Murey - Future Value Annuity 2 Number of Years 3 Rate of Return S0.00 4 Payment 5 8 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 20 29 30 31 32 33 34 35 36 Dropbox Screenshot Added A screenshot was added to your Dropbox RATIOS Monthly Arnul PY FV PV-lump Sum FV - Lum Sum NPV + Ready LA TU Type here to search O S DI 10:58 AM 13/17/2001 Archer BP HN 320 Project Iwe Hardal Formulas tutuisher Search - Caira N Lewis Fle Home Insert Draw Page Layout Formulas Data REVIC View Share Comments General Bad Goud Neutral - Normal Condone format calculation Furmaling - Table 5 - % 912 Check Cell Exploratory input ON Analyse Inzert Delarom Auringum 47 0 F Sort Find Clear File - Su deng . Nu Cels Analys . K LM N NO P Q RS S T UV W X Y Z Z AA AB - 3 FX X Cut Calibri 14 A - 2 Wrap Test Copy Paste BTW -A === Morge Care 3 Format Panter Clipboard Fant Alignet A1 f Time Value of Money - Present Value of Lump Sum D F G H Time Value of Money - Present Value of Lump Sum 2 2 Rate 3 Years $0.00 4 Initial Investment 5 8 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 22 24 25 26 27 20 29 30 31 32 33 34 35 36 X Dropbox Screenshot Added A screenshot was added to your Dropbox RATIOS Monthly Annual PV FV PV - Lump Sum FV - Lum Sum NPV + Ready LA TU Type here to search o E. S DI 10:55 AM 13/17/2001 Auto PE- HN 320 Project Iwe Hardal Formulas tutuisher Search - Caira N Lewis Fle Home Insert Draw Page Layout Formulas Data REVIC View Share Comments Ganuel Bad Goud Neutral Normal Condon Format Calculation Formatting Table 5 - % 912 Check Cell Insert Palmy Exploratory input Auringum 47 0 F Sort & Find Clear File - Su deng (@ ON Analyse Dalai Seals Number Cels J K LM N o P Q R S T U V W X Y Z $ X Cut Calibri 14 AA - 2 Wrap Test Copy BTW -A = = + Merge Cartier 3 Format Panter 45 & Clipboard Fant Alg Al A f Time Value of Money - Future Value of Lump Sum B F H Time Value of Money - Future Value of Lumip Surn 2 Rate 3 Years $0.00 4 Initial Investment 5 8 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 22 24 25 26 27 20 29 30 31 32 33 34 35 36 Dropbox Screenshot Added A screenshot was added to your Dropbox RATIOS Monthly Arnual PV FV PV - Lump Sum FV Lump Sum - NPV (+) Ready TU Type here to search O S DI 10:56 AM 13/17/2001 Archer BP HN 320 Project we Franca Formulastutulisher D Search (10) - Caira N Lewis Fle Home Insert Draw Page Layout Formulas Data Review View Share Comments Gibi 12 AA Auringum - 2 Wrap Test Percentage Bad Goud Neutral 47 0 X Cut Copy Format Panter F BTW- -A- Normal Condone formats Calculation Fuumaling - ==== Mage & Carter 45 5 - % 912 Check Cell Exploratory... input Insert Delme me Clear Sort & Tind File - S ON Anatyre Dale Analys Clipboard Fant Alignment Number Styles Cels deng BG C D E F L M N N OP R S U V W X 1 H J Net Present Value (NPV) Calculator Building Year 2 2 5 9 10 so SO $0 so 1 $0 11 sol 3 $o 13 So Cash Flows Year Cashflows 4 so 14 90 7 so 17 SU sol 15 NPV = $0 12 16 $0 $ 18 $ 19 20 SO SU so 30 2 3 4 Initial Investment 5 Annual Cash Inflows 6 Discount Rate 7 Number of Years B Salvage Value 9 10 11 12 13 14 initial investment 15 Annual Cash Inflows 16 Discount Rate 17 Number of Years 18 Salvage Value 19 20 21 22 Equipment 3 4 7 8 so O Year Cash Flows Year Cash Flows SO 1 so 11 90 5 sol 15 2 $0 12 50 6 so 16 $0 9 $o 19 50 10 so 20 $0 NPV = $0 13 14 17 18 90 $0 sol Bonds 23 NPV = $0 1 3 4 5 7 8 9 10 Year Cash Flows sal 6 sol $ 90 90 90 $0 $0 $a 90 90 24 Initial Investment 25 Annual Cash Inflows 26 Discount Rate 27 Number of Years 28 Principal Returned 29 30 31 32 33 34 35 RATIOS Dropbox Screenshot Added ** A screenshot was adoed to your Dropbox Monthly Arnus P PV PV - Lumpsum FV - Lum Sum NPV + Ready TU Type here to search O E: S g DI 10:56 AM 13/17/2001