Compare financial ratios between Wicked Good Cupcakes and the company you chose to blog about. Instructions: Using
Question:
Compare financial ratios between Wicked Good Cupcakes and the company you chose to blog about.
Instructions:
Using the attached Excel spreadsheet for Wicked Good Cupcakes (WGC) calculate the listed ratios.
What do these ratios suggest about the company's performance during the period presented?
In Table 2 list the 5 ratios from your 'blog company' and corresponding ratios for WGC.
Are these ratios 'comparable' for these two companies? Explain? Why you think they are/not comparable.
Which ratios would a senior operational manager for WGC be most interested in following?
ANNUAL BALANCE SHEET | | ||||||
| ($ Thousands) | | | | | | |
| | | | | | 31-Dec-15 | 31-Dec-16 |
| | | 31-Dec-15 | 31-Dec-16 | | | |
| ASSETS | | | | Profitability Ratios (in %) | | |
| Cash & Short-Term Investments | | $17.11 | $25.05 | Return on equity | | |
| Net Receivables | | $1.62 | $1.84 | Return on assets | | |
| Inventories | | $42.72 | $39.68 | Return on invested capital | | |
| Prepaid Expenses | | $0.00 | $0.00 | Profit margin | | |
| Other Current Assets | | $3.38 | $2.93 | Gross margin | | |
| | | | | | | |
| Total Current Assets | | $64.84 | $69.49 | Turnover-Control Ratios | | |
| | | | | Asset turnover | | |
| Gross Plant, Property & Equipment | | $63.75 | $58.28 | Fixed-asset turnover | | |
| Accumulated Depreciation | | $36.16 | $32.61 | Inventory turnover | | |
| | | | | Collection period (days) | | |
| Net Plant, Property & Equipment | | $27.58 | $25.67 | Days' sales in cash | | |
| Intangibles | | $5.88 | $6.01 | Payables period | | |
| Other Assets | | $6.16 | $5.81 | | | |
| | | | | Leverage and Liquidity Ratios | | |
| TOTAL ASSETS | | $104.47 | $106.98 | Assets to equity | | |
| | | | | Debt to assets | | |
| LIABILITIES | | | | Debt to equity | | |
| Long Term Debt Due In One Year | | $0.00 | $0.00 | Times interest earned | | |
| Accounts Payable | | $10.59 | $11.91 | Current ratio | | |
| Taxes Payable | | $1.87 | $2.01 | Acid test | | |
| Accrued Expenses | | $7.19 | $6.91 | | | |
| Other Current Liabilities | | $1.88 | $1.85 | | | |
| | | | | | | |
| Total Current Liabilities | | $21.54 | $22.67 | | | |
| | | | | | | |
| Long Term Debt | | $6.95 | $19.79 | | | |
| Deferred Taxes | | $1.16 | $2.32 | | | |
| Other Liabilities | | $3.04 | $2.43 | | | |
| | | | | | | |
| TOTAL LIABILITIES | | $32.68 | $47.21 | | | |
| | | | | | | |
| EQUITY | | | | | |
Related Book For
Fundamentals of InvestingISBN: 978-0133075359 12th edition Authors: Scott B. Smart, Lawrence J. Gitman, Michael D. Joehnk
Posted Date:
|