Answered step by step
Verified Expert Solution
Link Copied!

Question

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$236,000,000Cost of goods sold149,000,000Administrative expenses21,000,000Operating income$66,000,000Interest expense15,000,000Taxes500,000Net income$50,500,000Red Brick Balance Sheet as of 12/31/20X2AssetsLiabilities and Stockholders EquityCash$600,000Accounts payable$40,000,000Accounts receivable28,000,000*Notes payable11,000,000Inventory79,300,000Long-term debt45,000,000Plant and equipment132,000,000Stockholders equity143,900,000$239,900,000$239,900,000*80% of sales are on credit. Previous years inventory was $62,400,000.Companys RatiosIndustry(Previous Year)AverageCurrent ratio2.0:12.0:1Quick ratio0.5:10.8:1Inventory turnover5.1x4.7xAverage collection period33 days46 daysDebt ratio (debt/total assets)30%41%Times-interest-earned4.43.9Return on equity39.1%14.2%Return on assets23.2%10.1%Operating profit margin21.5%15.2%Net profit margin16.5%9.0%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 to Expert-Tailored 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

Recommended Textbook for

Financial Accounting A Focus On Interpretation And Analysis

Authors: Richard F Kochanek, A Douglas Hillman

7th Edition

1111061750, 9781111061753

More Books

Students also viewed these Finance questions