Question
Empire Labs Inc. was organized several years ago to produce and market several new miracle drugs. The following data on the company are available for
Empire Labs Inc. was organized several years ago to produce and market several new miracle drugs. The following data on the company are available for the past two years:
EMPIRE LABS INC. Comparative Income Statement For the Years Ended December 31 | ||
This Year | Last Year | |
Sales | $20,000,000 | $15,000,000 |
Less: Cost of goods sold | 13,000,000 | 9,000,000 |
Gross margin | 7,000,000 | 6,000,000 |
Less: Operating expenses | 5,260,000 | 4,560,000 |
Net operating income | 1,740,000 | 1,440,000 |
Less: Interest expense | 240,000 | 240,000 |
Net income before taxes | 1,500,000 | 1,200,000 |
Less: Income taxes (30%) | 450,000 | 360,000 |
Net income | $ 1,050,000 | $ 840,000 |
EMPIRE LABS INC. Comparative Retained Earnings Statement For the Years Ended December 31 | ||
This Year | Last Year | |
Retained earnings, January 1 | $2,400,000 | $1,960,000 |
Add: Net income (above) | 1,050,000 | 840,000 |
Total | 3,450,000 | 2,800,000 |
Deduct: Cash dividends paid: | ||
Preferred dividends | 120,000 | 120,000 |
Common dividends | 360,000 | 280,000 |
Total dividends paid | 480,000 | 400,000 |
Retained earnings, December 31 | $2,970,000 | $2,400,000 |
EMPIRE LABS INC. Comparative Balance Sheet December 31 | ||
This Year | Last Year | |
Assets | ||
Current assets: | ||
Cash | $ 200,000 | $ 400,000 |
Accounts receivable, net | 1,500,000 | 800,000 |
Inventory | 3,000,000 | 1,200,000 |
Prepaid expenses | 100,000 | 100,000 |
Total current assets | 4,800,000 | 2,500,000 |
Plant and equipment, net | 5,170,000 | 5,400,000 |
Total assets | $9,970,000 | $7,900,000 |
Liabilities and Shareholders Equity | ||
Liabilities: | ||
Current liabilities | $2,500,000 | $1,000,000 |
Bonds payable, 12% | 2,000,000 | 2,000,000 |
Total liabilities | 4,500,000 | 3,000,000 |
Shareholders equity: | ||
Preferred shares, 8%, $10 par | 1,500,000 | 1,500,000 |
Common shares, no par (200,000 @ $5) | 1,000,000 | 1,000,000 |
Retained earnings | 2,970,000 | 2,400,000 |
Total shareholders equity | 5,470,000 | 4,900,000 |
Total liabilities and shareholders equity | $9,970,000 | $7,900,000 |
Although Empire Labs Inc. has been profitable since it was organized several years ago, the company is beginning to experience some difficulty in paying its bills as they come due. Management has approached Security National Bank requesting a two-year, $500,000 loan to bolster the cash account.
Security National Bank has assigned you to evaluate the loan request. You have gathered the following data relating to firms in the pharmaceutical industry:
Current ratio | 2.4 to 1 |
Acid-test (quick) ratio | 1.2 to 1 |
Average age of receivables | 16 days |
Inventory turnover in days | 40 days |
Times interest earned | 7 times |
Debt-to-equity ratio | 0.70 to 1 |
The following additional information is available on Empire Labs Inc.:
- All sales are on account.
- At the beginning of last year, the accounts receivable balance was $600,000 and the inventory balance was $1,000,000.
Required:
- Compute the following amounts and ratios for both last year and this year:
- The working capital.
- The current ratio.
- The acid-test ratio.
- The accounts receivable turnover in days.
- The inventory turnover in days.
- The times interest earned.
- The debt-to-equity ratio.
- Comment on the results of your analysis in part (1).
- Would you recommend that the loan be approved? Explain.
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