Question
Compute the following 13 ratios. (Use a 360-day year. Do not round intermediate calculations. Input your profit margin, return on assets, return on equity, and
Compute the following 13 ratios. (Use a 360-day year. Do not round intermediate calculations. Input your profit margin, return on assets, return on equity, and debt to total assets answers as a percent rounded to 2 decimal places. Round all other answers to 2 decimal places.) b. Provide what each ratio represents to the company. | ||||||
|
|
|
|
|
|
|
Input variables: | ||||||
JJ's Jammers: | ||||||
Cash | $20,000 | |||||
Accounts receivable | $80,000 | |||||
Inventory | $50,000 | |||||
Total current assets | $150,000 | |||||
Gross plant and equipment | $500,000 | |||||
Accumulated depreciation | $150,000 | (input as positive) | ||||
Net plant and equipment | $350,000 | |||||
Total assets | $2,515,000 | |||||
Accounts payable | $100,000 | |||||
Bonds payable (long-term) | $80,000 | |||||
Total liabilities | $180,000 | |||||
Common stock | $150,000 | |||||
Capital paid in excess of par | $70,000 | |||||
Retained earnings | $100,000 | |||||
Total stockholders' equity | $320,000 | |||||
Total liabilities and stockholders' equity | $1,000,000 | |||||
Credit sales | $1,250,000 | |||||
Cost of goods sold | $750,000 | |||||
Gross profit | $500,000 | |||||
Selling and administrative expense | $257,000 | |||||
Depreciation | $50,000 | |||||
Operating profit (EBIT) | $193,000 | |||||
Interest expense | $8,000 | |||||
Earnings before taxes (EBT) | $185,000 | |||||
Taxes | $92,500 | |||||
Earnings after taxes (EAT) | $100,500 | |||||
Lease payments included in S&A exp | $7,000 | |||||
Number of days in year | 360 |
Profit margin | ||
Return on assets | ||
Return on equity | ||
Receivables turnover | ||
Average collection period | ||
Inventory turnover | ||
Fixed asset turnover | ||
Total asset turnover | ||
Current ratio | ||
Quick ratio | ||
Debt to total assets | ||
Times interest earned | ||
Fixed charge coverage |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started