Analiza Indicatorilor Economico-Financiari Pe Baza de Bilant
Seminar 1 - Analiza Bilant
-
Upload
andreea-avram -
Category
Documents
-
view
90 -
download
4
description
Transcript of Seminar 1 - Analiza Bilant
-
Oct-14
Prof.dr. Laura Obreja Brasoveanu 1
Seminar
analiza pe bazabilantului
Prof.dr. Laura OBREJA BRASOVEANU
ASE- BucurestiMaster FABBV
2014 - 2015 1
Documentele contabile sanatatea companiei
Bilant (balance sheet) pozitia financiara la un moment dat
Cont de profit si pierdere (income statement) venituri si cheltuieli in perioada analizata
Tabloul fluxurilor de trezorerie (cash flow statement) incasari si plati in perioada analizata
2
Tehnici de analiza utilizate Analiza orizontala modificarea anuala din
2 ani consecutivi modificarea fiecarui element, cauze si efecte favorabile sau nefav.
Analiza trendului analiza orizontala pentru mai mult de 3 ani modificare absoluta sau relativa
Analiza verticala ponderea fiecarui element in total; surprinde corelatii intre elemente
Analiza prin rate
3
Analiza financiara pe baza bilantului
Indicatorii de echilibru financiar:fondul de rulment FR = Pasive permanente Active permanente activ curent net (net working capital)ACN= Active curente Pasive curenteNecesar de fond de rulmentNFR = (Active curente Active de trezorerie) (Pasive curente Pasive de
trezorerie) Trezoreria netaTN = FR NFR = Active de trezorerie Pasive de trezoreriecash-flow CF=TNactiv economicAE = Pasive permanente = CPR + DAT termen lung = Active imobilizate + ACN
Active permanente
Pasive permanente
FR=ACN
Active curente
Pasive curente
4
Analiza financiara pe bazabilantului
Indicatorii de echilibru financiar
comparatie cu alte companii:
FR/AE
NFR/FR
TN/FR
CPR/AE; Dat t lg/AE
alte rate ??? 5
Analiza financiara pe baza bilantului -comparatie cu alte companii
Ratios - Key Metrics:
Leverage: Assets/Equity, Debt/Equity; % LT Debt to Total
Capital
Liquidity: Quick Ratio; Current Ratio
Operating: A/R Turnover, Avg. A/R Days, Inv Turnover, Avg.
Inventory Days, Avg. A/P Days, Fixed Asset Turnover, WC /
Sales Growth
Ratios - Profit/Value/Risk:
Profitability/Return: Sales/Receivables, Revenue/Inventory,
Revenue/Wk Cap, Revenue/Tot Assets
Value: Hist Price/Bk, Tot Eqty6
-
Oct-14
Prof.dr. Laura Obreja Brasoveanu 2
Analiza bilantului financiarAlte variante de analiza a bilantului
Prin procent din total activ/pasiv se analizeaza structura bilantului
Prin variatia procentuala a fiecarui element de activ/pasiv
Prin durate de rotatie se analizeaza rotatia prin CA a elementelor din bilant
Prin ponderea in cifra de afaceri se analizeaza ponderea in CA a elementelor din bilant 7
Analiza bilantului financiar -rate
Rate de lichiditatelichiditatea curenta (current ratio)lichiditatea rapida (acid test ratio;
quick ratio)lichiditatea la vedere (cash ratio)
Rata de indatoraregradul de indatorarerata datorii-capital (debt equity
ratio)Rata de solvabilitate
8
Studii de caz Analiza pe baza ratelor studiu de caz Holly
Fashion
Analiza bilant si cont de profit si pierdere studiu de caz APPLE
9
Studii de caz Analiza pe baza ratelor studiu de caz Holly Fashion
10
t t+1 t+2 t+3Sales 985 1040 1236 1305.1Cost of goods 748.6 774.8 928.2 978.8Gross margin 236.4 265.2 307.8 326.3Administrative 169.4 202.8 236.1 249.3Depreciation 10.8 11.4 13.6 14.4EBIT 56.2 51 58.1 62.6Interest 7 6 5 4EBT 49.2 45 53.1 58.6Taxes 19.7 18.0 21.2 23.4Net income 29.5 27.0 31.9 35.2
EXHIBIT 1HOLLY FASHIONS' Income Statement -- t - t+3 (000s)
Studii de caz Analiza pe baza ratelor studiu de caz Holly Fashion
11
t t+1 t+2 t+3ASSETSCash 40.4 51.9 38.6 10.6Receivables 153.2 158.9 175.1 224.8Inventory 117 121.1 193.4 191.9Other current assets 5.9 6.2 7.4 7.8Current assets 316.5 338.1 414.5 435.1Gross fixed 44.8 58.9 78.1 96.4Accumulated depreciation 12 23.4 37 51.4Net fixed 32.8 35.5 41.1 45Total assets 349.3 373.6 455.6 480.1
LIABILITIES & NET WORTHAccounts payable 53.8 54.7 86.2 84.2Debt due 10 10 10 10Accruals 19.7 26 24.7 26.1Current liabilities 83.5 90.7 120.9 120.3Long-term debt 60 50 40 30Common stock 150 150 180 180Retained earnings 55.8 82.8 114.6 149.8Total L&NW 349.3 373.5 455.5 480.1
EXHIBIT 2Balance Sheet of the HOLLY FASHIONS company -- t - t+3
Studii de caz Analiza pe baza ratelor studiu de caz Holly Fashion
12
t t+1 t+2 t+3 Industry average t - t+3*liquidity ratios current 3.8 3.7 3.4 3.6 2.6 1.7 1.3 quick 2.4 2.4 1.8 2.0 1.6 0.8 0.6leverage ratios debt% 41% 38% 35% 31% 41% 57% 71% times interest earned 8.0 8.5 11.6 15.7 7.4 3.9 1.3activity ratios inventory turnover 8.4 8.6 6.4 6.8 8.1 6 3.5 fixed assets turnover 30.0 29.3 30.1 29.0 40 25 12 total assets turnover 2.8 2.8 2.7 2.7 3.5 2.8 2 average collection period 56 55 51 62 41 50 68 day purchases outstanding (average payment period) **26 25 33 31 18 25 32profitability ratios gross margin 24.0% 25.5% 24.9% 25.0% 28% 26% 24% net profit margin 3.0% 2.6% 2.6% 2.7% 4.20% 3.10% 1.20% return on equity 14.3% 11.6% 10.8% 10.7% 27.30% 19.50% 7.80% return on total assets 8.5% 7.2% 7.0% 7.3% 11.80% 8.70% 3.40%operating margin *** 6.8% 6.0% 5.8% 5.9% 9.90% 7.20% 3.10%
EXHIBIT 3FINANCIAL RATIOS FOR THE HOLLY FASHION COMPANY -- t - t+3
-
Oct-14
Prof.dr. Laura Obreja Brasoveanu 3
Diagnostic Holly Fashions
Cerintele 1 9 Vezi pdf cu studiul de caz
13
Studii de caz
Analiza bilant si cont de profit si pierdere studiu de caz APPLE
14
Analiza financiara - APPLE
15
Analiza financiara - APPLE
16
Daily QAAPL.O 3/5/2008 - 10/8/2013 (EST)
BarOHLC, QAAPL.O, Trade Price10/1/2013, 478.45, 489.14, 478.38, 487.96, N/A, N/ASMA, QAAPL.O, Trade Price(Last), 2010/1/2013, 480.15
PriceUSD
.12100
150
200
250
300
350
400
450
500
550
600
487.96480.15
Vol, QAAPL.O, Trade Price10/2/2013, 63,949.00 Volume
.12A M J J A S O N D J F M A M J J A S O N D J F M A M J J A S O N D J F M A M J J A S O N D J F M A M J J A S O N D J F M A M J J A S O
2008 2009 2010 2011 2012 2013
17
Name Last PE EPS DPS Div. Yld (%) ROE (%) P/Book P/Sales Mcap (USD)
Apple Inc 498.68 12.39 40.04 12.20 2.46 42.84 3.81 2.88 450,650,851,880Sector average (Mean) 141.49 2.16 2.22 2.37 -0.17 3.51 2.42 25,121,952,839Sector median 20.11 0.63 0.95 2.39 9.85 2.32 1.70 1,563,766,158EMC Corp 24.65 20.11 1.26 0.40 1.58 13.12 2.36 2.43 52,832,882,679Hewlett-Packard Co 22.79 -- -1.59 0.58 2.54 -41.43 1.96 0.37 44,009,764,722Del l Inc 13.83 18.17 0.76 0.32 2.31 24.21 2.28 0.43 24,344,622,626Western Digi tal Corp 68.32 17.65 3.90 1.00 1.45 12.59 2.06 1.06 16,248,980,039SanDisk Corp 62.69 21.54 2.93 0.90 1.43 5.83 2.09 3.00 15,151,755,7323D Systems Corp 53.90 119.90 0.45 -- -- 10.59 11.36 15.44 5,458,571,821Diebold Inc 29.71 -- -1.71 1.15 3.77 10.09 3.02 0.80 2,389,463,696SYNNEX Corp 59.30 14.87 4.09 -- -- 12.22 1.73 0.22 2,286,524,483Lexmark International Inc 34.76 17.35 2.03 1.20 3.41 7.95 1.72 0.58 2,202,727,516Cardtronics Inc 38.03 35.76 1.07 -- -- 33.65 11.64 2.20 1,716,376,345Synaptics Inc 52.16 17.26 2.86 -- -- 21.54 3.06 2.40 1,595,866,976Electronics For Imaging Inc 33.19 18.36 1.83 -- -- 13.70 2.40 2.40 1,563,766,158Fusion-io Inc 13.71 -- -0.40 -- -- -8.04 2.88 3.27 1,411,999,219ScanSource Inc 34.68 28.66 1.24 -- -- 5.14 1.43 0.35 997,057,980QLogic Corp 10.86 19.51 0.56 -- -- 9.85 1.30 1.97 954,933,210Cray Inc 22.90 1,810.71 0.01 -- -- 63.56 2.73 2.21 931,352,218Super Micro Computer Inc 14.16 29.89 0.48 -- -- 5.98 1.64 0.53 614,063,460Violin Memory Inc 7.24 -- -8.02 -- -- -245.52 13.36 8.09 597,317,813Si li con Graphics International Corp
14.31 -- -0.10 -- -- -2.34 3.86 0.66 502,796,397
Steel Excel Inc 29.50 41.70 0.71 -- -- 5.67 0.86 3.71 371,710,237Quantum Corp 1.47 -- -0.13 -- -- -- -- 0.63 368,902,124Mercury Systems Inc 8.47 -- -0.44 -- -- -3.99 0.91 1.44 299,681,066Ci tadel EFT Inc 10.5 c -- -- -- -- -- -- -- 282,606,492Agi lysys Inc 11.78 161.51 0.07 -- -- -1.14 2.32 1.12 264,246,098
1 - 25 of 25
APPLE sector competitors - TRBC - Computer Hardware, Top 25, United States
18
APPLE peers competitors - economic sector -- technology
market cap (USD Mill)enterprise value (USD Mill) economic sector industry groupApple 483239 457591 technology computers&office equipment
HPQ.N Hewlett-Packard 45893 57765 technology computers&office equipmentDELL.OQ Dell Inc 24353 19336 technology computers&office equipment
CSCO.OQ Cisco System Inc 120475 86084 technology communications equipmentMSI.N Motorola Solutions Inc 16172 15773 technology communications equipment
INTC.OQ Intel Corp 118472 112833 technology semiconductor equipmentNOK1V.HE Nokia Oyj 26737 22331 technology communications equipmentGOOG.OQ Google Inc 342695 291419 technology software&IT services
-
Oct-14
Prof.dr. Laura Obreja Brasoveanu 4
19
Asset s ($ Thousands)
Cash and Short Term Investments
Cash & Equivalent s
Short Term Investments
Accounts Receivable - Trade, Net
Accounts Receivable - T rade, Gross
Provision for Doubt ful Accounts
Total Receivables, Net
Receivables - Other
Total Inventory
Inventories - Finished Goods
Inventories - Work In Progress
Inventories - Other
Prepaid Expense s
Other Current Asse ts, Total
Deferred Income Tax - Current Asset
Other Current Asset s
Total Current Assets
Property/Plant/Equipment, T otal - Gross
Buildings - Gross
Land/Improvements - Gross
Machinery/Equipment - Gross
Prope rty/Plant/Equipment, Total - Net
Accumulated Depreciation, T otal
Goodwill , Net
Intangible s, Net
Intangibles - Gross
Accumulated Intangible Amortization
Long Term Investme nts
LT Investment - Affiliate Companies
LT Investments - Other
Note Receivable - Long Te rm
Other Long Term Assets, Total
Defered Income Tax - Long Term Asset
Other Long Term Assets
long term assets
Total Assets20
Other Current Asset sLiabilities ($ Thousands)
Accounts Payable
Payable/Accrued
Accrued Expenses
Notes Payable/Short Term Debt
Current Port. of LT Debt/Capital Leases
O ther Current liabil ities, Total
Customer Advances
Income Taxes Payable
Other Current Liabilities
Total Current Liabilities
Total Long Term Debt
Long Term Debt
Capital Lease Obligations
Total Debt
Deferred Income Tax
Deferred Income Tax - LT Liability
Minority Interest
Other Liabilities, Total
Other Long Term Liabilities
Total Liabilities
Shareholders Equity ($ Thousands)
Redeemable Preferred Stock, Total
Preferred Stock - Non Redeemable, Net
Preferred Stock - Non Redeemable
Common Stock, Total
Common Stock
Addit ional Paid-In Capital
Retained Earnings (Accumulated Deficit)
Treasury Stock - Common
ESOP Debt Guarantee
Unrealized Gain (Loss)
Other Equity, Total
Translat ion Adjustment
Other Comprehensive Income
Total Equity
21
APPLE peers competitors - economic sector -- technology
balance debt/equitynet
debt/EBITDA
interest
coverage
current
ratioquick ratio
inventory
turnoveraccts rec DSO
sheet latest LTM LTM latest latest latest latestApple 13.70% NA NA 1.90 1.80 60.80 34.50peer median 63.20% 0.90 12.50 2.30 1.90 13.30 60.00peer average 55.10% 0.90 36.10 2.30 2.10 24.10 58.80HPQ.N 100.60% 0.90 12.20 1.10 0.90 13.30 58.90DELL.OQ 63.20% NA 10.70 1.20 1.10 33.20 60.00CSCO.OQ 27.40% NA 14.40 3.00 2.90 13.80 67.20MSI.N 92.00% NA 12.50 2.30 2.00 4.60 77.70INTC.OQ 24.40% NA 163.10 2.30 1.90 4.50 24.30NOK1V.HE 72.20% NA -0.10 1.30 1.20 10.30 72.20GOOG.OQ 6.30% NA 39.80 4.80 4.70 89.20 51.20
22
profitability ROE ROAGross
margin
operating
margin
operating
margin 5Y
pretax
marginnet margin
Apple 32.10% 20.80% 38.30% 29.50% 31.10% 30% 22.30%peer median 15.50% 9.10% 49.30% 13.90% 6.60% 13.40% 12.70%peer average 12.10% 6.60% 42.80% 11.90% 15.90% 11.80% 9.50%HPQ.N -11.20% -2.80% 23% -1.10% 5.10% -1.80% -2.80%DELL.OQ 13% 3% 20.20% 3.20% 5.50% 2.80% 2.40%CSCO.OQ 31.40% 18% 60.60% 23% 35% 23.10% 20.50%MSI.N 33.40% 9.10% 49.30% 13.90% 6.60% 13.40% 12.70%INTC.OQ 18.10% 11.50% 59% 22.60% 27% 23.40% 18.10%NOK1V.HE -15.40% -4.50% 31% -1.50% 2.40% -2.70% -4.90%GOOG.OQ 15.50% 12.10% 56.70% 23.40% 29.90% 24.40% 20.50%
APPLE peers competitors - economic sector -- technology
23
2003 2004 2005 2006 2007 2008 2009 2010 2011 2012Active pe rmanente 928,000 995,000 1,216,000 2,696,000 3,391,000 6,165,000 15,946,000 33,505,000 71,383,000 118,411,000
Property/Plant /Equipment , T otal - Net
Imobilizari corporale 669,000 707,000 817,000 1,281,000 1,832,000 2,455,000 2,954,000 4,768,000 7,777,000 15,452,000Goodwill, Net ; Intangibles, Net
Imobilizari necorporale 109,000 122,000 96,000 177,000 420,000 559,000 559,000 1,083,000 4,432,000 5,359,000Long Term Investments;
Note Receivable - Long TermImobilizari financiare
0 0 0 0 0 2,379,000 10,528,000 25,391,000 55,618,000 92,122,000Other Long T erm Assets, T otal
alte imobilizari150,000 166,000 303,000 1,238,000 1,139,000 772,000 1,905,000 2,263,000 3,556,000 5,478,000
Active curente 5,887,000 7,055,000 10,300,000 14,509,000 21,956,000 30,006,000 31,555,000 41,678,000 44,988,000 57,653,000T otal Inventory stocuri 56,000 101,000 165,000 270,000 346,000 509,000 455,000 1,051,000 776,000 791,000Accounts Receivable - T rade, Net
creante client i 766,000 774,000 895,000 1,252,000 1,637,000 2,422,000 3,361,000 5,510,000 5,369,000 10,930,000Receivables - Other alte creante 0 276,000 0 1,593,000 2,392,000 2,282,000 1,696,000 4,414,000 6,348,000 7,762,000
Other Current Assets, T otal alte active curente 499,000 440,000 979,000 1,076,000 1,778,000 2,207,000 2,270,000 5,083,000 6,543,000 9,041,000
Prepaid Expenses ch avans 0 0 0 208,000 417,000 475,000 309,000 0 0 0Cash and Short Term Investments
Act ive de t rezorerie4,566,000 5,464,000 8,261,000 10,110,000 15,386,000 22,111,000 23,464,000 25,620,000 25,952,000 29,129,000
Activ total 6,815,000 8,050,000 11,516,000 17,205,000 25,347,000 36,171,000 47,501,000 75,183,000 116,371,000 176,064,000Pasive pe rmane nte 4,458,000 5,399,000 8,029,000 10,762,000 16,067,000 24,810,000 35,995,000 54,461,000 88,401,000 137,522,000
Total Equity C apital propriu 4,223,000 5,076,000 7,428,000 9,984,000 14,532,000 22,297,000 31,640,000 47,791,000 76,615,000 118,210,000Total Long Te rm De bt; Defe rre d Income Tax - LT Liabi li ty; O the r Liabi li tie s, Total
Datorii te rme n lung
235,000 323,000 601,000 778,000 1,535,000 2,513,000 4,355,000 6,670,000 11,786,000 19,312,000long term de bt 0 0 0 0 0 0 0 0 0 0Pasive curente 2,357,000 2,651,000 3,487,000 6,443,000 9,280,000 11,361,000 11,506,000 20,722,000 27,970,000 38,542,000
Accounts Payable Furnizori 1,154,000 1,451,000 1,779,000 3,390,000 4,970,000 5,520,000 5,601,000 12,015,000 14,632,000 21,175,000Accrued Expenses Ch amanate 292,000 386,000 576,000 803,000 772,000 1,320,000 1,293,000 1,593,000 2,428,000 3,283,000Notes Payable/Short T erm Debt ; Current Port . of LT Debt /Capital Leases
datorii financiare pe
termen scurt 304,000 0 0 0 0 0 0 0 0 0
Other Current liabilities, Total alte pasive curente607,000 814,000 1,132,000 2,250,000 3,538,000 4,521,000 4,612,000 7,114,000 10,910,000 14,084,000
Datorii totale 2,592,000 2,974,000 4,088,000 7,221,000 10,815,000 13,874,000 15,861,000 27,392,000 39,756,000 57,854,000Pasive totale 6,815,000 8,050,000 11,516,000 17,205,000 25,347,000 36,171,000 47,501,000 75,183,000 116,371,000 176,064,000
APPLE balance sheet analysis --- construirea bilantului financiar
24
2003 2004 2005 2006 2007 2008 2009 2010 2011 2012FR 3,530,000 4,404,000 6,813,000 8,066,000 12,676,000 18,645,000 20,049,000 20,956,000 17,018,000 19,111,000
NFR (1,036,000) (1,060,000) (1,448,000) (2,044,000) (2,710,000) (3,466,000) (3,415,000) (4,664,000) (8,934,000) (10,018,000)
NWC 3,530,000 4,404,000 6,813,000 8,066,000 12,676,000 18,645,000 20,049,000 20,956,000 17,018,000 19,111,000
TN 4,566,000 5,464,000 8,261,000 10,110,000 15,386,000 22,111,000 23,464,000 25,620,000 25,952,000 29,129,000
CF 898,000 2,797,000 1,849,000 5,276,000 6,725,000 1,353,000 2,156,000 332,000 3,177,000AE 4,458,000 5,399,000 8,029,000 10,762,000 16,067,000 24,810,000 35,995,000 54,461,000 88,401,000 137,522,000
NFR/FR -29.35% -24.07% -21.25% -25.34% -21.38% -18.59% -17.03% -22.26% -52.50% -52.42%
lichiditate gen = current ratio 2.50 2.66 2.95 2.25 2.37 2.64 2.74 2.01 1.61 1.50lichiditate partiala = quick rat io 2.47 2.62 2.91 2.21 2.33 2.60 2.70 1.96 1.58 1.48
lichiditate imediata 1.94 2.06 2.37 1.57 1.66 1.95 2.04 1.24 0.93 0.76grad indatorare pe termen scurt 34.59% 32.93% 30.28% 37.45% 36.61% 31.41% 24.22% 27.56% 24.04% 21.89%grad indatorare pe termen lung 3.45% 4.01% 5.22% 4.52% 6.06% 6.95% 9.17% 8.87% 10.13% 10.97%
APPLE balance sheet analysis --- indicatori de echilibru financiar si rate
??? Explicatii ale dinamicii indicatorilor de echilibru financiarRatelor de lichiditate si indatorare
-
Oct-14
Prof.dr. Laura Obreja Brasoveanu 5
25
APPLE balance sheet analysis
??? Explicatii si interpretari ale dinamicii indicatorilor de echilibru financiarRatelor de lichiditate si indatorare
26
APPLE balance sheet analysis --- structura bilantului financiar
Bilant - structura
2003 2004 2005 2006 2007 2008 2009 2010 2011 2012
Active permanente 13.62% 12.36% 10.56% 15.67% 13.38% 17.04% 33.57% 44.56% 61.34% 67.25%
Active cu rente 86.38% 87.64% 89.44% 84.33% 86.62% 82.96% 66.43% 55.44% 38.66% 32.75%stocuri 0.82% 1.25% 1.43% 1.57% 1.37% 1.41% 0.96% 1.40% 0.67% 0.45%creante client i 11.24% 9.61% 7.77% 7.28% 6.46% 6.70% 7.08% 7.33% 4.61% 6.21%Active de trezorerie 67.00% 67.88% 71.73% 58.76% 60.70% 61.13% 49.40% 34.08% 22.30% 16.54%
Activ total 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Pasive permanen te 65.41% 67.07% 69.72% 62.55% 63.39% 68.59% 75.78% 72.44% 75.96% 78.11%
Capital propriu 61.97% 63.06% 64.50% 58.03% 57.33% 61.64% 66.61% 63.57% 65.84% 67.14%
Datorii termen lung 3.45% 4.01% 5.22% 4.52% 6.06% 6.95% 9.17% 8.87% 10.13% 10.97%
Pasive curente 34.59% 32.93% 30.28% 37.45% 36.61% 31.41% 24.22% 27.56% 24.04% 21.89%Furnizori 16.93% 18.02% 15.45% 19.70% 19.61% 15.26% 11.79% 15.98% 12.57% 12.03%
Datorii totale 38.03% 36.94% 35.50% 41.97% 42.67% 38.36% 33.39% 36.43% 34.16% 32.86%
Pasive totale 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
27
APPLE balance sheet analysis --- structura bilantului financiar
28
APPLE balance sheet analysis --- construirea bilantului financiar
Bilant - modificare procentuala
2003 2004 2005 2006 2007 2008 2009 2010 2011 2012
Active permanente 1.98% 7.22% 22.21% 121.71% 25.78% 81.80% 158.65% 110.12% 113.05% 65.88%
Active curente 9.26% 19.84% 46.00% 40.86% 51.33% 36.66% 5.16% 32.08% 7.94% 28.15%stocuri 24.44% 80.36% 63.37% 63.64% 28.15% 47.11% -10.61% 130.99% -26.17% 1.93%creante clienti 35.58% 1.04% 15.63% 39.89% 30.75% 47.95% 38.77% 63.94% -2.56% 103.58%Act ive de t rezorerie 5.28% 19.67% 51.19% 22.38% 52.19% 43.71% 6.12% 9.19% 1.30% 12.24%
Activ total 8.21% 18.12% 43.06% 49.40% 47.32% 42.70% 31.32% 58.28% 54.78% 51.30%
Pasive permanente -3.92% 21.11% 48.71% 34.04% 49.29% 54.42% 45.08% 51.30% 62.32% 55.57%
C api tal propriu 3.13% 20.20% 46.34% 34.41% 45.55% 53.43% 41.90% 51.05% 60.31% 54.29%
Datori i termen lung -56.88% 37.45% 86.07% 29.45% 97.30% 63.71% 73.30% 53.16% 76.70% 63.86%
Pasive cure nte 42.16% 12.47% 31.54% 84.77% 44.03% 22.42% 1.28% 80.10% 34.98% 37.80%Furnizori 26.67% 25.74% 22.61% 90.56% 46.61% 11.07% 1.47% 114.52% 21.78% 44.72%
Datori i totale 17.66% 14.74% 37.46% 76.64% 49.77% 28.28% 14.32% 72.70% 45.14% 45.52%
Pasive totale 8.21% 18.12% 43.06% 49.40% 47.32% 42.70% 31.32% 58.28% 54.78% 51.30%
29
APPLE balance sheet analysis --- construirea bilantului financiar
30
APPLE balance sheet analysis --- bilantului financiar durate de rotatie prin CA
Bilant - durata de rotatie prin CA
2003 2004 2005 2006 2007 2008 2009 2010 2011 2012C A 6 ,207,000 8 ,279,000 13,931,0 00 24 ,006,00 0 3 2,479,000 37,491,000 42,90 5,00 0 65,225,000 108,249 ,000 156,508,000
Active permanen te 54 43 31 40 38 59 134 185 237 272Imobilizari corporale 39 31 21 19 20 24 25 26 26 36
Active curente 341 307 266 218 243 288 265 230 150 133stocuri 3 4 4 4 4 5 4 6 3 2creante clienti 44 34 23 19 18 23 28 30 18 25Active de t rezorerie 265 238 213 152 171 212 197 141 86 67
Activ total 395 350 298 258 281 347 399 415 387 405
Pasive permanente 259 235 207 161 178 238 302 301 294 316
Capital propriu 245 221 192 150 161 214 265 264 255 272
Datori i termen lung 14 14 16 12 17 24 37 37 39 44
Pasive curente 137 115 90 97 103 109 97 114 93 89Furnizori 67 63 46 51 55 53 47 66 49 49
Datori i totale 150 129 106 108 120 133 133 151 132 133
Pasive totale 395 350 298 258 281 347 399 415 387 405
-
Oct-14
Prof.dr. Laura Obreja Brasoveanu 6
31
APPLE balance sheet analysis --- bilantului financiar durate de rotatie
32
APPLE --- comparison
sector competitors concurenti din sectorpeers competitors concurenti similari
clasament = rank()medie = average()mediana = median()quartile = quartile(,1), quartile(,2),
quartile(,3)
33
APPLE balance sheet analysis --- comparison sector competitors
Quick Ratio 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012APPLE (median) 2.47 2.62 2.91 2.21 2.33 2.60 2.70 1.96 1.58 1.48
APPLE(quartile) 2.47 2.62 2.91 2.21 2.33 2.6 2.7 1.96 1.58 1.48
EMC - EMC Corp 1.64 1.46 1.59 1.55 2.08 1.88 1.87 0.95 1.03 1.07HPQ - Hewlett-Packard Co 1.37 1.25 1.16 1.13 1.00 0.83 1.08 0.97 0.86 0.95DELL.O - Dell Inc 0.96 0.95 1.16 1.06 1.08 1.01 1.30 1.22 1.42 1.27WDC.O - Western Digital Corp 1.28 1.21 1.25 1.49 1.57 1.45 1.87 2.06 2.26 1.47SNDK.O - SanDisk Corp 4.64 4.76 3.93 4.18 3.00 1.67 2.66 3.67 3.36 2.05DDD - 3D Systems Corp 1.23 1.53 1.73 0.87 1.42 1.37 1.55 1.32 4.00 3.27DBD - Diebold Inc 1.36 1.23 1.87 1.50 1.51 1.46 1.53 1.57 1.57 1.63SNX - SYNNEX Corp 0.73 0.85 0.78 0.75 0.81 0.91 1.04 0.99 1.07 1.11LXK - Lexmark International Inc 1.70 1.73 1.43 1.04 1.07 1.29 1.50 1.53 1.67 1.14
CAT M.O - Cardtronics Inc 1.19 0.42 0.49 0.63 0.44 0.49 0.49 0.54 0.65 0.87APPLE (rank) 2 2 2 2 2 1 1 3 5 4
average 1.69 1.64 1.66 1.49 1.48 1.36 1.60 1.53 1.77 1.48median 1.36 1.25 1.43 1.13 1.42 1.37 1.53 1.32 1.57 1.27
quartile1.21, 1.36, 1.67
1.08, 1.25, 1.63
1.16, 1.43, 1.8
0.96, 1.13, 1.53
1.04, 1.42, 1.83
0.96, 1.37, 1.57
1.19, 1.53, 1.87
0.98, 1.32, 1.77
1.05, 1.57, 1.97
1.09, 1.27, 1.56
q q4 q4 q4 q4 q4 q4 q4 q4 q3 q3
34
APPLE balance sheet analysis --- comparison sector competitors
Current Ratio 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012APPLE (median) 2.50 2.66 2.95 2.25 2.37 2.64 2.74 2.01 1.61 1.50
APPLE(quartile) 2.5 2.66 2.95 2.25 2.37 2.64 2.74 2.01 1.61 1.5
EMC - EMC Corp 1.84 1.64 1.79 1.78 2.28 2.04 2.05 1.04 1.13 1.18HPQ - Hewlet t -Packard Co 1.61 1.50 1.38 1.35 1.21 0.98 1.22 1.10 1.01 1.09
DELL.O - Dell Inc 1.00 0.98 1.20 1.10 1.12 1.07 1.36 1.28 1.49 1.34WDC.O - Western Digital Corp 1.47 1.46 1.44 1.73 1.80 1.75 2.12 2.33 2.53 1.77
SNDK.O - SanDisk Corp 4.97 5.32 4.51 4.73 3.61 2.15 3.35 4.20 3.98 2.45
DDD - 3D Systems Corp 1.47 1.81 2.10 1.25 1.82 1.90 2.10 1.74 4.43 3.82DBD - Diebold Inc 1.78 1.67 2.55 2.17 2.27 2.19 2.14 2.12 2.10 2.11SNX - SYNNEX Corp 1.41 1.53 1.55 1.58 1.36 1.52 1.71 1.68 1.78 1.73LXK - Lexmark Internat ional Inc 2.07 2.04 1.76 1.38 1.38 1.64 1.80 1.82 1.97 1.33CAT M.O - Cardt ronics Inc 1.34 0.49 0.55 0.71 0.46 0.52 0.52 0.56 0.68 0.90APPLE (rank) 2 2 2 2 2 1 2 4 7 6
average 1.95 1.92 1.98 1.82 1.79 1.67 1.92 1.81 2.06 1.75
median 1.61 1.64 1.76 1.58 1.80 1.75 2.05 1.74 1.78 1.50
quart ile1.44, 1.61, 1.96
1.48, 1.64, 1.93
1.41, 1.76, 2.33
1.3, 1.58, 1.98
1.29, 1.8, 2.28
1.3, 1.75, 2.1
1.54, 2.05, 2.13
1.19, 1.74, 2.07
1.31, 1.78, 2.32
1.26, 1.5, 1.94
q q4 q4 q4 q4 q4 q4 q4 q3 q2 q3
35
APPLE balance sheet analysis --- comparison sector competitors
Assets/Equity 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012APPLE (median) 1.61 1.59 1.55 1.72 1.74 1.62 1.50 1.57 1.52 1.49
APPLE(quartile) 1.61 1.59 1.55 1.72 1.74 1.62 1.5 1.57 1.52 1.49
EMC - EMC Corp 1.29 1.34 1.39 1.80 1.78 1.79 1.72 1.77 1.78 1.70HPQ - Hewlett-Packard Co 1.98 2.03 2.08 2.15 2.30 2.91 2.83 3.08 3.35 4.85DELL.O - Dell Inc 1.30 1.33 1.29 1.34 1.39 1.80 1.78 1.79 1.72 1.77WDC.O - Western Digital Corp 2.65 2.38 2.27 1.80 1.69 1.81 1.66 1.56 1.48 1.85SNDK.O - SanDisk Corp 1.35 1.20 1.24 1.46 1.46 1.72 1.53 1.52 1.44 1.42DDD - 3D Systems Corp 3.58 2.48 2.19 2.39 1.60 1.50 1.44 1.57 1.82 1.41DBD - Diebold Inc 1.67 1.71 2.04 2.60 2.33 2.68 2.44 2.62 3.04 3.28SNX - SYNNEX Corp 3.12 2.70 2.48 2.70 3.12 2.99 2.54 2.52 2.45 2.25LXK - Lexmark International Inc 2.10 1.98 2.33 2.75 2.44 4.02 3.31 2.66 2.61 2.75CATM.O - Cardtronics Inc - - - - 5.52 - - 10.74 6.39 5.21APPLE 5 5 5 4 6 3 3 5 4 4
average 2.07 1.87 1.89 2.07 2.31 2.28 2.08 2.85 2.51 2.54median 1.83 1.85 2.06 1.98 1.78 1.81 1.75 1.79 1.82 1.85
quartile2.51, 1.83, 1.42
2.29, 1.85, 1.4
2.25, 2.06, 1.43
2.55, 1.98, 1.74
2.39, 1.78, 1.65
2.85, 1.81, 1.74
2.52, 1.75, 1.56
2.64, 1.79, 1.57
2.83, 1.82, 1.62
3.02, 1.85, 1.6
q q3 q3 q3 q4 q3 q4 q4 q4 q4 q4
36
APPLE balance sheet analysis --- comparison sector competitors Debt/Equity 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012
APPLE 0.07 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
APPLE(quartile) 0.07 0 0 0 0 0 0 0 0 0
EMC - EMC Corp 0.01 0.01 0.01 0.33 0.28 0.22 0.20 0.20 0.18 0.08
HPQ - Hewlett-Packard Co 0.20 0.19 0.14 0.14 0.21 0.46 0.39 0.55 0.79 1.27
DELL.O - Dell Inc 0.01 0.00 0.01 0.01 0.01 0.33 0.28 0.22 0.20 0.20WDC.O - Western Digital Corp 0.00 0.14 0.08 0.04 0.01 0.19 0.15 0.08 0.05 0.28SNDK.O - SanDisk Corp 0.10 0.00 0.00 0.26 0.25 0.28 0.26 0.30 0.23 0.23
DDD - 3D Systems Corp 1.00 0.50 0.38 0.52 0.12 0.11 0.08 0.06 0.55 0.18
DBD - Diebold Inc 0.18 0.24 0.44 0.68 0.56 0.65 0.54 0.59 0.76 0.83SNX - SYNNEX Corp 0.31 0.24 0.07 0.19 0.64 0.72 0.35 0.39 0.33 0.21LXK - Lexmark Int ernat ional Inc 0.09 0.07 0.10 0.14 0.12 0.81 0.64 0.47 0.47 0.51
CATM.O - Cardtronics Inc - - - - 2.90 - - 6.01 3.32 2.41APPLE (rank) 5 4 3 2 2 2 2 2 2 2
average 0.20 0.14 0.12 0.23 0.46 0.38 0.29 0.81 0.63 0.56
median 0.10 0.11 0.08 0.17 0.21 0.31 0.27 0.30 0.33 0.23
quart ile0.2, 0.1, 0.03
0.23, 0.11, 0
0.13, 0.08, 0.01
0.31, 0.17, 0.07
0.42, 0.21, 0.07
0.6, 0.31, 0.2
0.38, 0.27, 0.16
0.51, 0.3, 0.14
0.66, 0.33, 0.19
0.67, 0.23, 0.19
q q3 q4 q4 q4 q4 q4 q4 q4 q4 q4
-
Oct-14
Prof.dr. Laura Obreja Brasoveanu 7
37
APPLE balance sheet analysis --- comparison sector competitors% LT Debt to Total Capital2003 2004 2005 2006 2007 2008 2009 2010 2011 2012
APPLE 0 0 0 0 0 0 0 0 0 0
APPLE(quartile) 0 0 0 0 0 0 0 0 0 0
EMC - EMC Corp 0.01 0.01 0.01 0.25 0.21 0.18 0.16 0.01 0.01 0.00HPQ - Hewlet t-Packard Co 0.14 0.10 0.08 0.06 0.11 0.14 0.25 0.24 0.32 0.43DELL.O - Dell Inc 0.00 0.00 0.01 0.01 0.01 0.25 0.21 0.18 0.16 0.01WDC.O - West ern Digit al Corp
0.00 0.10 0.04 0.02 0.01 0.15 0.11 0.06 0.03 0.20SNDK.O - SanDisk Corp 0.09 0.00 0.00 0.20 0.20 0.22 0.19 0.23 0.19 0.09DDD - 3D Systems Corp 0.41 0.28 0.23 0.23 0.07 0.07 0.07 0.06 0.35 0.16DBD - Diebold Inc 0.01 0.01 0.28 0.39 0.35 0.38 0.34 0.35 0.41 0.42SNX - SYNNEX Corp 0.02 0.03 0.00 0.08 0.04 0.13 0.12 0.10 0.14 0.05LXK - Lexmark International Inc
0.08 0.07 0.10 0.13 0.00 0.44 0.39 0.32 0.32 0.16CATM.O - Cardtronics Inc 0.69 0.75 0.89 0.86 0.74 1.05 1.00 0.84 0.76 0.70
APPLE 4 4 3 2 3 2 2 2 2 2
average 0.13 0.12 0.15 0.20 0.16 0.27 0.26 0.22 0.24 0.20
median 0.024 0.028 0.043 0.126 0.074 0.180 0.190 0.180 0.185 0.155
quartile0.12, 0.02, 0.01
0.1, 0.03, 0
0.16, 0.04, 0.01
0.24, 0.13, 0.04
0.21, 0.07, 0.01
0.32, 0.18, 0.13
0.29, 0.19, 0.12
0.28, 0.18, 0.06
0.34, 0.19, 0.09
0.31, 0.16, 0.03
q q4 q4 q4 q4 q4 q4 q4 q4 q4 q4
38
APPLE balance sheet analysis --- comparison sector competitorsAPPLE 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992Quick Ratio 2.54 1.66 2.22 2.84 2.26 2.05 2.03 1.99 1.8 2.09Current Ratio 3.64 2.69 2.78 3.17 2.73 2.16 2.56 2.34 2.35 2.5Assets/Equity 1.47 1.7 1.7 1.67 1.77 2.07 1.85 2.06 1.98 1.93Debt/Equity 0 0 0 0 0 0.31 0.04 0.08 0.08 0.08% LT Debt to Total Capital 0.30% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
APPLE 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002Quick Ratio 1.13 1.74 1.48 1.92 1.64 2.38 2.75 2.79 3.38 3.22Current Ratio 1.73 2.3 2.25 2.25 1.88 2.43 2.77 2.81 3.39 3.25Assets/Equity 2.55 2.22 2.15 2.61 4.03 2.87 1.75 1.69 1.54 1.54Debt/Equity 0.41 0.25 0.26 0.55 0.93 0.64 0.1 0.07 0.08 0.08% LT Debt to Total Capital 0.20% 10.20% 8.30% 29.70% 43.70% 36.70% 8.80% 6.80% 7.50% 7.20%
APPLE 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012Quick Ratio 3.22 2.47 2.62 2.91 2.21 2.33 2.6 2.7 1.96 1.58 1.48Current Ratio 3.25 2.5 2.66 2.95 2.25 2.37 2.64 2.74 2.01 1.61 1.5Assets/Equity 1.54 1.61 1.59 1.55 1.72 1.74 1.62 1.5 1.57 1.52 1.49Debt/Equity 0.08 0.07 0 0 0 0 0 0 0 0 0% LT Debt to Total Capital 7.20% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
39
APPLE balance sheet analysis --- comparison peers competitors
Quick Ratio 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012Apple (median) 2.47 2.62 2.91 2.21 2.33 2.60 2.70 1.96 1.58 1.48APPLE(quart ile) 2.47 2.62 2.91 2.21 2.33 2.6 2.7 1.96 1.58 1.48
HPQ - Hewlet t-Packard Co 1.37 1.25 1.16 1.13 1.00 0.83 1.08 0.97 0.86 0.95DELL.O - Dell Inc 0.96 0.95 1.16 1.06 1.08 1.01 1.30 1.22 1.42 1.27CSCO.OQ - Cisco Systems Inc 1.51 1.51 2.18 2.15 2.26 2.49 3.16 2.60 3.18 3.40MSI.N - Motorola Solutions Inc
1.68 1.75 2.03 1.80 1.55 1.38 1.81 1.91 2.08 1.94INTC.OQ - Intel Corp 2.96 2.68 1.96 1.64 2.39 2.06 2.40 2.99 1.81 2.06NOK1V.HE - Nokia Oyj 2.28 2.28 1.79 1.68 1.39 1.08 1.43 1.40 1.33 1.33GOOG.OQ - Google Inc - - - - - - - - 5.92 4.18APPLE 2 2 1 1 2 1 2 3 5 5
average 1.89 1.86 1.88 1.67 1.71 1.64 1.98 1.86 2.27 2.08median 1.68 1.75 1.96 1.68 1.55 1.38 1.81 1.91 1.70 1.71quartile 1.44,
1.68, 2.38
1.38, 1.75, 2.45
1.48, 1.96, 2.11
1.39, 1.68, 1.98
1.24, 1.55, 2.3
1.05, 1.38, 2.28
1.37, 1.81, 2.55
1.31, 1.91, 2.28
1.4, 1.7, 2.36
1.32, 1.71, 2.4
q q4 q4 q4 q4 q4 q4 q4 q3 q2 q240
APPLE balance sheet analysis --- comparison peers competitors
Current Ratio 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012Apple 2.50 2.66 2.95 2.25 2.37 2.64 2.74 2.01 1.61 1.50APPLE(quartile) 2.5 2.66 2.95 2.25 2.37 2.64 2.74 2.01 1.61 1.5
HPQ - Hewlett-Packard Co 1.61 1.50 1.38 1.35 1.21 0.98 1.22 1.10 1.01 1.09DELL.O - Dell Inc 1.00 0.98 1.20 1.10 1.12 1.07 1.36 1.28 1.49 1.34
CSCO.OQ - Cisco Systems Inc 1.62 1.65 2.31 2.27 2.36 2.58 3.24 2.67 3.27 3.49MSI.N - Motorola Solutions Inc 1.90 1.99 2.23 2.01 1.78 1.63 1.94 1.97 2.30 2.22INTC.OQ - Intel Corp 3.33 3.00 2.30 2.15 2.79 2.54 2.79 3.39 2.15 2.43NOK1V.HE - Nokia Oyj 2.43 2.45 1.96 1.83 1.54 1.20 1.55 1.55 1.46 1.43GOOG.OQ - Google Inc 2.38 7.91 12.08 10.00 8.49 8.77 10.62 4.16 5.92 4.22APPLE 2 3 2 3 3 2 4 4 5 5
average 2.10 2.77 3.30 2.87 2.71 2.68 3.18 2.27 2.40 2.22median 2.14 2.22 2.27 2.08 2.07 2.09 2.34 1.99 1.88 1.86
quartile1.62, 2.14, 2.45
1.61, 2.22, 2.75
1.82, 2.27, 2.47
1.71, 2.08, 2.26
1.46, 2.07, 2.48
1.17, 2.09, 2.6
1.5, 2.34, 2.9
1.48, 1.99, 2.85
1.48, 1.88, 2.54
1.41, 1.86, 2.7
q q4 q3 q4 q3 q3 q4 q3 q3 q2 q2
41
APPLE balance sheet analysis --- comparison peers competitors
Assets/Equity 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012Apple 1 .61 1.59 1.55 1.72 1.74 1.62 1.50 1.57 1.52 1.49
APPLE(quartile) 1.61 1.59 1.55 1.72 1.74 1.62 1.5 1.57 1.52 1.49
HPQ - Hewlett-Packard Co 1.98 2.03 2.08 2.15 2.30 2.91 2.83 3.08 3.35 4.85DELL.O - Dell Inc 3 .17 3.08 3.58 5.75 5.77 7.20 6.20 5.97 4.97 4.99
CSCO.OQ - Cisco Systems Inc 1 .32 1.38 1.46 1.81 1.69 1.71 1.76 1.83 1.84 1.79MSI.N - Motorola Solutions Inc 2 .53 2.32 2.15 2.25 2.25 2.93 2.62 2.35 2.67 3.88INT C.OQ - Int el Corp 1.25 1.25 1.34 1.32 1.30 1.28 1.27 1.28 1.55 1.65NOK1V.HE - Nokia Oyj 1 .58 1.59 1.82 1.89 2.55 2.79 2.73 2.72 3.05 3.78GOOG.OQ - Google Inc 1 .60 1.13 1.09 1.08 1.12 1.12 1.12 1.25 1.25 1.31APPLE (rank) 6 6 5 4 5 4 4 4 3 3
average 1 .88 1.80 1.88 2.25 2.34 2.70 2.50 2.51 2.53 2.97median 1.61 1.59 1.69 1.85 2.00 2.25 2.19 2.09 2.26 2.79
quart ile2.12, 1.61, 1.52
2.1, 1.59, 1.35
2.1, 1.69, 1.43
2.18, 1.85, 1.62
2.36, 2, 1.59
2.92, 2.25, 1.54
2.76, 2.19, 1.44
2.81, 2.09, 1.5
3.13, 2.26, 1.54
4.12, 2.79, 1.61
q q2 q3 q3 q3 q3 q3 q3 q3 q4 q4 42
APPLE balance sheet analysis --- comparison peers competitors
Debt/Equity 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012Apple 0.07 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
APPLE(quartile) 0.07 0 0 0 0 0 0 0 0 0
HPQ - Hewlet t-Packard Co 0.20 0.19 0.14 0.14 0.21 0.46 0.39 0.55 0.79 1.27
DELL.O - Dell Inc 0.10 0.08 0.08 0.17 0.17 0.15 0.47 0.72 0.77 1.04
CSCO.OQ - Cisco Systems Inc 0.00 0.00 0.00 0.26 0.20 0.20 0.27 0.35 0.36 0.32MSI.N - Motorola Solutions Inc 0.63 0.40 0.26 0.26 0.28 0.44 0.40 0.25 0.29 0.57INTC.OQ - Intel Corp 0.03 0.02 0.07 0.06 0.05 0.03 0.05 0.04 0.16 0.26
NOK1V.HE - Nokia Oyj 0.03 0.02 0.03 0.03 0.07 0.31 0.40 0.37 0.45 0.70
GOOG.OQ - Google Inc 0.01 0.00 0.00 0.00 0.00 0.00 0.00 0.07 0.07 0.08
APPLE (rank) 6 4 4 3 3 3 3 2 2 2
average 0.13 0.09 0.07 0.12 0.12 0.20 0.25 0.29 0.36 0.53
median 0.05 0.02 0.05 0.10 0.12 0.18 0.33 0.30 0.33 0.45
quartile0.13, 0.05, 0.03
0.11, 0.02, 0
0.1, 0.05, 0
0.19, 0.1, 0.02
0.2, 0.12, 0.04
0.34, 0.18, 0.02
0.4, 0.33,
0.04
0.42, 0.3, 0.06
0.53, 0.33, 0.14
0.79, 0.45, 0.22
q q2 q4 q4 q4 q4 q4 q4 q4 q4 q4
-
Oct-14
Prof.dr. Laura Obreja Brasoveanu 8
43
APPLE balance sheet analysis --- comparison peers competitors % LT Debt to Total Capital2003 2004 2005 2006 2007 2008 2009 2010 2011 2012
Apple 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
APPLE quartile 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
HPQ - Hewlett-Packard Co 0.14 0.10 0.08 0.06 0.11 0.14 0.25 0.24 0.32 0.43
DELL.O - Dell Inc 0.09 0.07 0.07 0.13 0.11 0.08 0.30 0.35 0.37 0.35
CSCO.OQ - Cisco Systems Inc 0.00 0.00 0.00 0.21 0.17 0.16 0.21 0.21 0.25 0.24MSI.N - Mot orola Solutions Inc 0.35 0.25 0.18 0.13 0.20 0.30 0.24 0.15 0.17 0.36
INT C.OQ - Int el Corp 0.02 0.02 0.06 0.05 0.04 0.03 0.05 0.04 0.13 0.20
NOK1V.HE - Nokia Oyj 0.00 0.00 0.00 0.01 0.01 0.04 0.22 0.20 0.21 0.34
GOOG.OQ - Google Inc 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.05 0.04APPLE (rank) 3 4 4 3 3 3 3 3 2 2
average 0.08 0.06 0.05 0.07 0.08 0.09 0.16 0.15 0.19 0.25median 0.01 0.01 0.03 0.05 0.08 0.06 0.22 0.18 0.19 0.29
quartile0.11, 0.01, 0
0.08, 0.01, 0
0.07, 0.03, 0
0.13, 0.05, 0
0.12, 0.08, 0.01
0.14, 0.06, 0.02
0.24, 0.22, 0.04
0.21, 0.18, 0.03
0.27, 0.19, 0.11
0.35, 0.29, 0.16
q q4 q4 q4 q4 q4 q4 q4 q4 q4 q4 44
APPLE balance sheet analysis --- comparison peers competitors
Peers 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992Quick Ratio 2.54 1.66 2.22 2 .84 2 .26 2.05 2.03 1 .99 1.8 2.09Current Ratio 3.64 2.69 2.78 3 .17 2 .73 2.16 2.56 2 .34 2 .35 2.5Assets/Equity 1.47 1.7 1 .7 1 .67 1 .77 2.07 1.85 2 .06 1 .98 1.93Debt/Equity 0 0 0 0 0 0.31 0.04 0 .08 0 .08 0.08% LT Debt to Total Capital 0.00 0.00 0 .00 0.00 0.00 0.00 0 .00 0.00 0.00 0.00
Peers 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012Quick Ratio 2.47 2.62 2.91 2.21 2.33 2.6 2.7 1.96 1.58 1.48Current Ratio 2.5 2.66 2.95 2.25 2.37 2.64 2.74 2.01 1.61 1.5Assets/Equity 1.61 1.59 1.55 1.72 1.74 1.62 1.5 1.57 1.52 1.49Debt/Equity 0.07 0 0 0 0 0 0 0 0 0% LT Debt to Total Capital 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Peers 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002Quick Ratio 1.13 1.74 1 .48 1.92 1.64 2 .38 2.75 2.79 3 .38 3.22Current Ratio 1.73 2 .3 2 .25 2.25 1.88 2 .43 2.77 2.81 3 .39 3.25Assets/Equity 2.55 2.22 2 .15 2.61 4.03 2 .87 1.75 1.69 1 .54 1.54Debt/Equity 0.41 0.25 0 .26 0.55 0.93 0 .64 0.1 0.07 0 .08 0.08% LT Debt to Total Capital 0.00 0 .10 0.08 0.30 0 .44 0.37 0.09 0 .07 0.08 0.07
Recomandari PROIECT analiza pe baza bilantului http://johnmaxwellteam.ro Lebada neagra Nassim Taleb (Black
Swan) O plimbare in parc..
No pressure, no diamonds (Mary Case)
Saptamana frumoasain continuare!