Question
Joseph Berio is a loan officer with the First Bank of Tennessee. Red Brick, Inc., a major producer of masonry products, has applied for a
Joseph Berio is a loan officer with the First Bank of Tennessee. Red Brick, Inc., a major producer of masonry products, has applied for a short-term loan. Red Brick supplies building material throughout the southern states, with brick plants located in Tennessee, Alabama, Georgia, and Indiana. The firms income statement and balance sheet are given below. The third table presents both a ratio analysis of Red Bricks previous years financial statements and the industry averages of the ratios.
Red Brick Income Statement | ||
(for the period ending December 12/31/20X1) | ||
Sales | $ | 153,000,000 |
Cost of goods sold | 106,000,000 | |
Administrative expenses | 31,000,000 | |
Operating income | $ | 16,000,000 |
Interest expense | 9,000,000 | |
Taxes | 700,000 | |
Net income | $ | 6,300,000 |
Red Brick Balance Sheet as of 12/31/20X2 | ||||||
Assets | Liabilities and Stockholders Equity | |||||
Cash | $ | 400,000 | Accounts payable | $ | 44,000,000 | |
Accounts receivable | 32,000,000 | * | Notes payable | 11,000,000 | ||
Inventory | 74,700,000 | Long-term debt | 44,000,000 | |||
Plant and equipment | 139,000,000 | Stockholders equity | 147,100,000 | |||
$ | 246,100,000 | $ | 246,100,000 | |||
*50% of sales are on credit. | ||||||
Previous years inventory was $51,300,000. |
Companys Ratios | Industry | |
(Previous Year) | Average | |
Current ratio | 1.7:1 | 2.1:1 |
Quick ratio | 0.6:1 | 0.8:1 |
Inventory turnover | 4.2x | 4.5x |
Average collection period | 94 days | 49 days |
Debt ratio (debt/total assets) | 29% | 41% |
Times-interest-earned | 1.8 | 3.9 |
Return on equity | 4.8% | 13.9% |
Return on assets | 2.8% | 10.0% |
Operating profit margin | 8.0% | 15.1% |
Net profit margin | 3.2% | 8.6% |
To help decide whether to grant the loan, compute the following ratios and compare the results with the company's previous year ratios and industry averages. Assume there are 365 days in a year. Do not round intermediate calculations. Round your answers to two decimal places.
Current ratio of times is -Select-higher thanlower thanequal toItem 2 the industry average and -Select-higher thanlower thanequal toItem 3 the ratio in the previous year.
Quick ratio of times is -Select-higher thanlower thanequal toItem 5 the industry average and -Select-higher thanlower thanequal toItem 6 the ratio in the previous year.
Inventory turnover ratio of is -Select-higher thanlower thanequal toItem 8 the industry average and -Select-higher thanlower thanequal toItem 9 the ratio in the previous year.
Average collection period of days is -Select-higher thanlower thanequal toItem 11 the industry average and -Select-higher thanlower thanequal toItem 12 the ratio in the previous year.
Debt ratio of % is -Select-higher thanlower thanequal toItem 14 the industry average and -Select-higher thanlower thanequal toItem 15 the ratio in the previous year.
Times-interest-earned ratio of is -Select-higher thanlower thanequal toItem 17 the industry average and -Select-higher thanlower thanequal toItem 18 the ratio in the previous year.
Return on equity ratio of % is -Select-higher thanlower thanequal toItem 20 the industry average and -Select-higher thanlower thanequal toItem 21 the ratio in the previous year.
Return on assets ratio of % is -Select-higher thanlower thanequal toItem 23 the industry average and -Select-higher thanlower thanequal toItem 24 the ratio in the previous year.
Operating profit margin ratio of % is -Select-higher thanlower thanequal toItem 26 the industry average and -Select-higher thanlower thanequal toItem 27 the ratio in the previous year.
Net profit margin ratio of % is -Select-higher thanlower thanequal toItem 29 the industry average and -Select-higher thanlower thanequal toItem 30 the ratio in the previous year.
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