Finanolal Audit Worksheet FInanolal Audit for aturbucks financial date from Mergent Online Accessed 2019 Industry dets from RMA NAICS 722211 Limited Services Restaurants Starbucks Dollars reported In thousands COMPANY Ratio Decoription Formulas Industry 2011 2010 2008 2008 2007 LIQUIDITY (draw risk conclusion) Current Reto [CR GAICL 0.60 Net working Capital INC CA-CL 1.83 1.85 1.23 0.80 0.79 1.719,100 8977 300 8454 800 -8435,700 -$459,079 Quick Roto (OR 0140 1.38 1.24 087 0.47 CAPITAL STRUCTURE (draw rick and cost of capital bonolusions) Debt-to-Equity (DIE) Tot. Lgb /BQ. [TCL + LTD] BB)" (or)(Totell Lab./Total Equity) 15 40 0.74 1.23 1.34 Debt-to-Assets [DIA) Tot. LIBb./A [TCL - LTD]/ TA] (or) (Totel Lieb./Totell Assets) 0.80 D.40 D.42 Current Debt-to-Total Debt (CD/TO) O 4E DEE 0.57 PERFORMANCE (look at all Ingredients Bun. Debt/Tot.Deb: ( CD/TO 0.70 0.70 Gross Profit Merg T(GPM] 51.709: 56.739: 54.0098 Cost of Goods Bold (0038) 38.309: 46 5294 43.279: 45.729% BellIng. General & Admin. Exp. (3GLA 46.009: 44.31% BAE : Boles (Ad Ex./Bel23) 56.0098 40 4393 39.99 9: 41.259: 42.25% 41.05%% Net Profit (NF] Rote-0"-Return on Asses (ROAD RR AS585 9: INF/TAY 2.0598 11.7139 4.108: 9.1893 4.169: 7.01 5: 3.179% 7.459 5.5698 Rote-of-Return on Equity (ROB] RR Net Worth $ (NF/BE) 12.59 96 18.409% 23 419% 25.739: 12.83 9: 12.679 29.45 9% ACTIVITY |Drew control conoluclon Inventory Tum 41.80 5.12 8.21 Inventory Days 6 90 5.78 AR Turn In. Days 018 (365Am. Tum) AR Tum. 130 03 AR 9 00 710100 27.Sej 44.48 96.11 :4104 94 70 54.44 AR DAYS AR COIL (DEYE] (385 AR Tum.)] 1.00 5.12 8.21 890 6.71 5.78 Floored Asset Turnover FA Turnover (8::5/NFA (FAX) 4.92 4.25 3.12 Total Asset Tumover TA Turnover (BOSS/TAY TAX 2 20 1.49 LIMITS 1.61 1.69 Deot based on Equity *Ind. OVER :00. Equity - 300. Liabilities 864 561.980.00 Deot Based on Assets Ind. DVA - 300. Assets) - 800. Webillbles 32 927 540.80 Improved Operations (emclancy in AIR CO. A/R days - Ind. AIR dey:]-Co. BAR 5311,078.89 Improved Operations (:Miclancy In Im.) OTHER (Co. Inv. deys - Ind. Inv. de,s)"Co. &Inv. 3843,762.47 "Note: Remember that for Cepitel Structure Calculations, you should use the TOTAL LIABILITIES number if you can calculate it rather than try to tease out the multiple columns that fall Into TOL and LTD. Hint: Remember the besic accounting equation Assets - Liabilities - Owner's Equity. If your given Liabilities + Owner's Equity, and Owner's Equity on a seperate line, cum you calculate " Note: the numerator for this ratio depends on the Industry survey used. For example: (C@ 8/Inv. for RMA & Troy's) (Beles/Inv. For DEB] Comments: Income tax for RMA calculated at 50%% tax rate, Median quartile used (should be upper quartile for this firm based on sales). Note that all figures calculated with "Bales" use the BALBB, not total revenue figures to reflect the core business activity. AMA uses BALBB and this figure does not Include extraordinary Income not associated with the firm's production/service ().:., one-time sale of assets, wind fell from litigation, etc)
