Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

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 $ 218,000,000 Cost of goods sold 124,000,000 Administrative expenses 25,000,000 Operating income $ 69,000,000 Interest expense 6,000,000 Taxes 200,000 Net income $ 62,800,000 Red Brick Balance Sheet as of 12/31/20X2 Assets Liabilities and Stockholders Equity Cash $ 800,000 Accounts payable $ 45,000,000 Accounts receivable 32,000,000 * Notes payable 11,000,000 Inventory 79,600,000 Long-term debt 51,000,000 Plant and equipment 129,000,000 Stockholders equity 134,400,000 $ 241,400,000 $ 241,400,000 *90% of sales are on credit. Previous years inventory was $58,000,000. Companys Ratios Industry (Previous Year) Average Current ratio 1.8:1 2.2:1 Quick ratio 0.6:1 0.7:1 Inventory turnover 5.2x 4.7x Average collection period 37 days 45 days Debt ratio (debt/total assets) 30% 48% Times-interest-earned 11.5 3.8 Return on equity 58.9% 14.3% Return on assets 30.7% 10.0% Operating profit margin 24.3% 15.2% Net profit margin 22.2% 8.7% 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 the industry average and the ratio in the previous year. Quick ratio of times is the industry average and the ratio in the previous year. Inventory turnover ratio of is the industry average and the ratio in the previous year. Average collection period of days is the industry average and the ratio in the previous year. Debt ratio of % is the industry average and the ratio in the previous year. Times-interest-earned ratio of is the industry average and the ratio in the previous year. Return on equity ratio of % is the industry average and the ratio in the previous year. Return on assets ratio of % is the industry average and the ratio in the previous year. Operating profit margin ratio of % is the industry average and the ratio in the previous year. Net profit margin ratio of % is the industry average and the ratio in the previous year.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions