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

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 06, 2024

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.