Ratio Analysis
myguksddieBy Wednesday, March 11, 2015 solve the problem below, calculate the ratios, interpret the results against the industry average, and fill in the table on the worksheet. Then, provide an analysis of how those results can be used by the business to improve its performance. Turn in your completed work to the M1: Assignment 3 Dropbox by Wednesday, March 11, 2015.
Balance Sheet as of December 31, 2010 | ||||
Gary and Company | ||||
Cash | $45 |
| Accounts payables | $45 |
Receivables | 66 |
| Notes payables | 45 |
Inventory | 159 |
| Other current liabilities | 21 |
Marketable securities | 33 |
| Total current liabilities | $111 |
Total current assets | $303 |
|
|
|
Net fixed assets | 147 |
| Long Term Liabilities |
|
Total Assets | $450 |
| Long-term debt | 24 |
|
| Total Liabilities | $135 | |
|
|
|
| |
|
| Owners Equity |
| |
|
| Common stock | $114 | |
|
| Retained earnings | 201 | |
|
| Total stockholders’ equity | 315 | |
|
|
| Total liabilities and equity | $450 |
Income Statement Year 2010 | |
|
|
Net sales | $795 |
Cost of goods sold | 660 |
Gross profit | 135 |
Selling expenses | 73.5 |
Depreciation | 12 |
EBIT | 49.5 |
Interest expense | 4.5 |
EBT | 45 |
Taxes (40%) | 18 |
Net income | 27 |
1. Calculate the following ratios AND interpret the result against the industry average:
Ratio | Your Answer | Industry Average | Your Interpretation |
Profit margin on sales |
| 3% |
|
Return on assets |
| 9% |
|
Receivable turnover |
| 16X |
|
Inventory turnover |
| 10X |
|
Fixed asset turnover |
| 2X |
|
Total asset turnover |
| 3X |
|
Current ratio |
| 2X |
|
Quick ratio |
| 1.5X |
|
Times interest earned |
| 7X |
|
2. Analysis:
Give your interpretation of what the ratios calculations show and how the business can use this information to improve its performance. Justify all answers.
- 9 years ago
- 25
Purchase the answer to view it
- ratio_analysis_answers.docx
Purchase the answer to view it
- gary_and_co..xls
Purchase the answer to view it
- 2012-09-12_050015_gary.xls
Purchase the answer to view it
- solution_1449453702.xlsx
Purchase the answer to view it
- assignment_3_ratio_analysis.zip
Purchase the answer to view it
- answer.zip
Purchase the answer to view it
- financial_management_-_ratio_analysis.docx
Purchase the answer to view it
- financial_statement_analysis.docx
Purchase the answer to view it
- gary_and_company_solution.xls
- one page summ
- [Print](https://devry.equella.ecollege.com/file/8e6240b8-64f0-4071-b943-2be06a994209/1/BUSN380_W5_YouDecide.html#) Scenario Scenario Summary After a number of years of planning, you have made the decision to evaluate the potential purchase of a...
- MHR 6551 Unit 8 Test
- c++ exercise 5 Solution
- Project5- Palindrome And Telephone lookup Solution
- "For A-Z Answers only"
- Essay Assignment #1
- Prof Xavier - Definition Paper Wk1
- presentation help
- COM 172 Rough Draft