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 2006 2008 2007 LIQUIDITY (draw rick conclusion) Current Ruto (OR CA/CL 0.80 1.55 1.23 Net working Capital INVIC) CA-CLI 1.83 0.80 0.79 31.719,100 :977 300 8454 800 -8441,700 -6459,079] Quick Rodo (OR] 0.40 1.28 1.24 CAPITAL STRUCTURE (draw rick and cost of capital ponolusions] Debt-to-EQUty (DIE Tot. Llab./Bq. [TCL + LTD]7 88) (or)[(Totel Llab.Total Equity]] 15 40 0.63 0.74 0.83 Debt-to-Assets (DIA) 1.23 1.34 Tot. LIeb /A D(TCL - LTD)/ TA]" for)]Totel Llab./Tote Ass:3) 0.80 0.40 0.42 0.57 Current Debt-to-Total Debt (CO.TO) Cum. Debt/Tot.Debt (CD/TD) DEE PERFORMANCE (look at all Ingredients 0.70 0.62 0.70 Gross Profit Meng (OFMJ Boles-00081 80es 51.709: 56. 739: 54.009: 53.289% Cost of Goods Bold (0038) 36.309: 46 52% 13.279: 46.0098 Belling General & Admin. Exp. (3GLA] 45.7296 44.31 56 56.009: 40 43%% 39.989: 41.2598 Net Profit (NP) 42.2586 41.0898 11.71% RR ASSES : INPITA) 2.0598 9.1893 4.169: 3.17% 16 92% 7.459 7.019: Rote-of-Return on Equity (ROB] RR Net Worth 9: (NF/38) 12.59 9 18.409: 28 41%% 25.739: 12.835: 12.6798 ACTIVITY (Drew control conclusion) 29.459% Inventory Tum Im. Tum+ 1.80 5. 12 8.21 8.71 Inventory Days n. Days OF8 (385Am. Tum) 5.78 71.23 AVR Turn 9.00 44.48 AVR Turn. 130 03 AR 96.11 54.44 710.00 27.58 347047 34.70 AR DAYS AR COIL (DAYS) (385 AR Tum.)] 1.00 5.12 8.21 Fored Asset Turnover E.71 5.78 FA Turnover (8::5/NFA] (FAX) 4.60 4.52 4.25 3.71 3 36 3.12 Total Asset Tumover TA Turnover (BOSS/TA ITAX 2 20 LIMIT 1.49 1.61 1.83 1.75 1.69 Debt based on Equity (Ind. ONE - :00. Equity) - 300. Loo he: :64 851.980.00 Deot Based on Assets Ind. OVA - 300. Assets) - 800. Webliber :2 927.540.80 Improved Operations (eciency MARK Co. A/R days - Ind. AIR deys]"Co. SAR 9311,078.89 Improved Operations fellclancy In Im) Co. Inv. deys - Ind. Inv. deys "Co. AInv. OTHER :843,762.47 "Note: Remember that for Capital 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 : seperate line, can you calculate Note: the numerator for this ratio depends on the Industry survey used. For example: (C@ B/Inv. for RMA & Troy's) (Beles/Inv. For DBE] Comments: Income tax for RMA calculated at 80%% tax rate, Median quartile used (should be upper quartile for this firm based on sales). Note that all figures calculated with "Bales" us: the BALBB, not total revenue figures to reflect the core business activity. AMA uses SALES and this figure does not Include extraordinary Income not associated with the firm's production/service (1.e., one-time sale of assets, windfell from litigation, etc)
