Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help in ratio analysis. Please do it correctly, my figures are wrong, i did but its wrong, please fix them, i have only
I need help in ratio analysis. Please do it correctly, my figures are wrong, i did but its wrong, please fix them, i have only 30 minutes
E82 fax =SUM(E77:E81) B (Unaudited - in thousands, except per share amounts) D E F G H | J 3 4 2004 2003 2002 2001 $ 201,600 $ 66,194 $ 32,235 $ 16,462 $ 99,275 $ 16,837 $ 8,963 $ 4,525 $ 102,325 $ 49,357 $ 23,272 $ 11,937 $ $ $ 24,249 $ 14,664 $ 28,626 $ 14,929 $ 16,564 $ 6,716 $ 8,504 $ 6,118 7,341 $ 5,061 3,852 $ 2,203 5 6 REVENUES 7 Total revenues 8 COST OF REVENUES 9 Total cost of revenues 10 GROSS PROFIT 11 OPERATING EXPENSES 12 Research and development expenses 13 Sales and marketing expenses 14 General and administrative expenses Write-off of acquired in-process 15 research and development costs 16 Restructuring charges Costs of integration of acquired 17 companies Amortization of unearned 18 compensation Amortization of acquired intangible 19 assets 20 Total operating expenses 21 OPERATING INCOME (LOSS) $ 9,681 $ 3,375 $ 1,300 $ 15,908 $ 3,934 $ 256 $ 5,925 $ 8,676 $ 4,710 $ 1,488 $ $ 101,248 $ 54,634 $ 24,816 $ 13,382 $ 1,077 $ (5,277) $ (1,544) $ (1,445) Tables Illustrations Add-ins Charts Tours Sparklines E82 fac =SUM(E77:E81) B F G H | B D E 1,077 $ (5,277) $ (1,544) $ (1,445) 2,687 $ 807 $ 669 $ 1,336 (109) 3,764 $ (4,470) $ 1,581 $ 1,618 $ (875) $ (90) $ 2,183 $ (6,088) $ (785) $ (109) 21 OPERATING INCOME (LOSS) $ 22 Interest and other income, net $ INCOME (LOSS) FROM CONTINUING 23 OPERATIONS BEFORE INCOME TAXES $ 24 Income tax expense (benefit) $ INCOME (LOSS) FROM CONTINUING 25 OPERATIONS 26 Income (loss) from continuing operation: $ Loss from operations of discontinued GDS business (including loss on disposal 27 of $3,506 in 2002) $ 28 NET INCOME (LOSS) $ 29 30 Basic income (loss) per common share: Income (loss) from continuing 31 operations $ 32 Loss from discontinued GDS business $ 33 34 Net income (loss) per share $ 0 $ $ (3,954) 2,183 $ (6,088) $ (4,739) $ (109) 0.10 $ $ (0.54) $ $ (0.10) (0.51) 0.10 $ (0.54) $ (0.61) 35 $ 0.10 $ (0.54) $ (0.61) 33 34 Net income (loss) per share 35 Diluted income (loss) per common 36 share: Income (loss) from continuing 37 operations 38 Loss from discontinued GDS business $ $ 0.10 $ $ (0.54) $ $ (0.10) (0.51) 39 40 Net income (loss) per share $ $ 0.10 $ (0.54) $ (0.61) 41 42 E F G I 44 A B D SCIAT INC and SUBSIDIARIES CONSOLIDATED STATEMENTS BALANCE SHEETS (Unaudited - in thousands, except per share amounts) 45 46 47 48 December 31, 49 2004 2003 2002 2001 50 ASSETS 51 Current assets: 52 Cash and cash equivalents $ 74,901 $ 24,451 $ 3,399 $ 14,819 53 Short-term investments $ 93,310 $ 92,280 $ 28,763 $ 15,865 Accounts receivable, net of allowance for doubtful accounts of $2,264, $940, $244, and $150 in 2004, 2003, 2002, and 54 2001, respectively $ 56,224 $ 13,191 $ 4,534 $ 3,225 Inventories, net of reserve of $726, $1,275, $958, and $482 in 2004, 2003, 55 2002, and 2001, respectively $ 18,168 $ 3,123 $ 1,008 $ 1,260 56 Prepaid expenses and other current asse $ 3,252 $ 1,405 $ 1,002 $ 850 57 Other current assets $ 10,944 $ $ 93 $ 784 58 Total Current Assets $ 256,808 $ 134,459 $ 38,808 $ 36,812 59 Property and equipment, net $ 18,313 $ 3,809 $ 1,246 $ 969 Computer software development costs, net of accumulated amortization of F G H | J A B D E 57 Other current assets $ 10,944 $ $ 93 $ 784 58 Total Current Assets $ 256,808 $ 134,459 $ 38,808 $ 36,812 59 Property and equipment, net $ 18,313 $ 3,809 $ 1,246 $ 969 Computer software development costs, net of accumulated amortization of $2,619, $1,696, $1,513, and $3,113 in 60 2004, 2003, 2002, and 2001, respectively $ 2,349 $ 1,982 $ 479 $ 727 61 Goodwill $ 305,311 $ 42,407 $ 12,826 Other intangible assets, net of accumulated amortization of $28,223 in 62 2004 and $8,483 in 2003 $ 139,192 $ 23,599 $ 595 63 Other assets $ 2,005 $ 1,900 $ 1,374 $ 1,378 64 TOTAL ASSETS $ 723,978 $ 208,156 $ 55,328 $ 39,886 65 Pivot Tables Charts Loss Pictures + Illustrations Tours Tables Add-ins Charts Sparklines E82 for =SUM(E77:E81) F G H 1 J A B D E 65 66 LIABILITIES AND STOCKHOLDERS' EQUITY 67 Current liabilities: 68 Accounts payable $ 11,615 $ 3,799 $ 1,456 $ 988 69 Accrued compensation and related costs $ 13,046 $ 3,770 $ 2,162 $ 713 70 Advance payments and deferred revenue $ 11,319 $ 4,791 $ 1,393 $ 1,918 71 Other accrued expenses $ 7,060 $ 1,774 $ 1,424 $ 577 72 Other current liabilities $ 11,109 $ 8,695 $ 377 $ 222 73 Total current liabilities $ 54,149 $ 22,829 $ 6,812 $ 4,418 74 Other liabilities $ 57,243 $ 6,330 $ 129 75 Total liabilities $ 111,392 $ 29,159 $ 6,941 $ 4,418 76 STOCKHOLDERS' EQUITY Common stock, $.01 par value per share, authorized 50,000 shares, issued and outstanding shares of 24,401 in 2004 and 77 13,286 in 2003 $ 244 $ 133 $ 79 $ 80 78 Additional paid-in capital $ 633,882 $ 199,783 $ 65,665 $ 52,400 79 Unearned compensation $ (6,719) 80 Accumulated other comprehensive incon $ 9,309 $ 5,394 $ 2,859 $ (1,526) 81 Accumulated deficit $ (24,130) $ (26,313) $ (20,225) $ (15,486) 82 Total stockholders' equity $ 612,586 $ 178,997 $ 48,378 $ 35,468 83 Total liabilities and stockholders' equity $ 723,978 $ 208,156 $ 55,319 $ 39,886 A F B D E 1 Ratio 2001 2002 2003 2004 2 Current Ratio 8.332277 5.697005 5.889833 4.742618 3 4 Quick Ratio 36811.71 38808.15 134459.1 256807.7 5 2001 2002 2003 2004 6 Inventory Turnover' 3.59127 8.891865' 5.39129 '5.464278 7 8 Receivables Turnov 5.104496 7.109616 5.018118 3.585657 9 2001 2002 2003 2004 10 Gross Margin 0.725125 0.721948 0.745642 0.507564 11 12 Operating Margin 0.08778' -0.0479 -0.07972' 0.005342 13 14 Return on Assets-0.00273 -0.08565 -0.02925 0.003015 15 16 Return on Equity -0.00307 -0.09796 -0.03401 0.003564 17
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started