Lauren_Johnson_SEC_Excel_Apple

Other comprehensive income t o ta l s to c kh o l d

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ome T o ta l s to c kh o l d er' s eq u i ty o ta l l i a b i l i ti es & s to c kh o l d er' s eq u i ty 21,175 11,4 14 5,9 53 38 ,54 2 2,6 4 8 16 ,6 6 4 57,8 54 12.03% 6 .4 8 % 3.38 % 21.8 9 % 1.50% 9 .4 6 % 32.8 6 % 14 ,6 32 9 ,24 7 4 ,09 1 27,9 70 1,6 8 6 10,100 39 ,756 I n teres ti n g P o i n ts Nu mbers need ed for r atio s Apple had a little over 2% more cash & cash equiv. in 2012 Receiva bles increa sed by a lmost 2% Inventories weirdly only increased by less than 1% , even though the sales increased by 45% 8 ,14 9 .50 Avera ge Receiva bles 78 3.5 Avera ge I nventory 14 6 217.5 Avera ge tota l a ssets 1,8 6 8 ,8 4 5 T ota l ousta nding sha res 12.57% 7.9 5% 3.52% 24 .04 % 1.4 5% 8 .6 8 % 34 .16 % 16 ,4 22 9 .33% 13,331 11.4 6 % 101,28 9 499 118 ,210 176 ,06 4 57.53% 0.28 % 6 7.14 % 100.00% 6 2,8 4 1 443 76 ,6 15 116 ,371 54 .00% 0.38 % 6 5.8 4 % 100.00% 9 39 ,208 + 9 29 ,277= Ratio Formula Computed Ratio Current Assets / Current Liabilities 1.50 Cost of Goods Sold / Average Inventory 112...
View Full Document

Ask a homework question - tutors are online