You have just been hired as a loan officer at fairfield

Reference no: EM13570507

You have just been hired as a loan officer at Fairfield State Bank. Your supervisor has given you a file containing a request from Hedrick Company, a manufacturer of auto components, for a $1,000,000 five-year loan. Financial statement data on the company for the last two years are given below:

Hedrick Company Comparative Balance Sheet
	This Year		Last Year
Assets
Current assets:
Cash	$	339,000	$	413,000
Marketable securities		0		94,000
Accounts receivable, net		893,000		604,000
Inventory		1,340,000		880,000
Prepaid expenses		71,000		67,000

Total current assets		2,643,000		2,058,000
Plant and equipment, net		3,335,900		2,823,200

Total assets	$	5,978,900	$	4,881,200

Liabilities and Stockholders' Equity
Liabilities:
Current liabilities	$	1,310,000	$	730,000
Bonds payable, 10%		1,190,000		1,040,000

Total liabilities		2,500,000		1,770,000

Stockholders' equity:
Preferred stock, 8%, $30 par value		600,000		600,000
Common stock, $40 par value		2,000,000		2,000,000
Retained earnings		878,900		511,200

Total stockholders' equity		3,478,900		3,111,200

Total liabilities and stockholders' equity	$	5,978,900	$	4,881,200

Hedrick Company Comparative Income Statement and Reconciliation
	This Year		Last Year
Sales (all on account)	$	5,410,000	$	4,210,000
Cost of goods sold		4,080,000		3,260,000

Gross margin		1,330,000		950,000
Selling and administrative expenses		520,000		500,000

Net operating income		810,000		450,000
Interest expense		119,000		104,000

Net income before taxes		691,000		346,000
Income taxes (30%)		207,300		103,800

Net income		483,700		242,200

Dividends paid:
Preferred stock		48,000		48,000
Common stock		68,000		34,000

Total dividends paid		116,000		82,000

Net income retained		367,700		160,200
Retained earnings, beginning of year		511,200		351,000

Retained earnings, end of year	$	878,900	$	511,200

Marva Rossen, who just two years ago was appointed president of Hedrick Company, admits that the company has been "inconsistent" in its performance over the past several years. But Rossen argues that the company has its costs under control and is now experiencing strong sales growth, as evidenced by the more than 28% increase in sales over the last year. Rossen also argues that investors have recognized the improving situation at Hedrick Company, as shown by the jump in the price of its common stock from $64 per share last year to $48 per share this year. Rossen believes that with strong leadership and with the modernized equipment that the $1,000,000 loan will enable the company to buy, profits will be even stronger in the future.

Anxious to impress your supervisor, you decide to generate all the information you can about the company. You determine that the following ratios are typical of companies in Hedrick's industry:


Current ratio	2.3
Acid-test ratio	1.2
Average collection period	31	days
Average sale period	60	days
Return on assets	9.5	%
Debt-to-equity ratio	0.65
Times interest earned ratio	5.7
Price-earnings ratio	10

Required:
1.	Present the balance sheet in common-size format. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 1 decimal place. Due to rounding, figures may not fully reconcile down a column. Omit the "%" sign in your response.)

Hedrick Company Comparative Balance Sheet
	This Year		Last Year
Assets
Current assets:
Cash		%		%
Marketable securities
Accounts receivable, net
Inventory
Prepaid expenses

Total current assets
Plant and equipment, net

Total assets		%		%

Liabilities and Stockholders' Equity
Liabilities:
Current liabilities		%		%
Bonds payable, 10%

Total liabilities

Stockholders' equity:
Preferred stock, 8%, $30 par value
Common stock, $40 par value
Retained earnings

Total stockholders' equity

Total liabilities and stockholders' equity		%		%

2.	Present the income statement in common-size format down through net income. (Input all amounts as positive values. Round your answers to 1 decimal place. Due to rounding, figures may not fully reconcile down a column. Omit the "%" sign in your response.)

Hedrick Company Comparative Income Statements
	This Year	Last Year
Sales	%	%
Cost of goods sold

Gross margin
Selling and administrative expenses

Net operating income
Interest expense

Net income before taxes
Income taxes (30%)

Net income	%	%

Reference no: EM13570507

Questions Cloud

Jefferson is a small ski resort they have experienced 2 : jefferson is a small ski resort. they have experienced 2 problems unusually low snowfalls and long lift lines. they

Baron corporation has two sequential processing departments : baron corporation has two sequential processing departments assembly then shaping the shaping department reports the

Assume that all direct material used is only recorded at : 1. hpc inc. has developed a standard pricing system for its products.nbspnbspthe variable cost standards based on

These cash flows will grow at an annual rate of 4 forever : assume an investment will provide you with a cash flow of 2000 at the end of the first year. these cash flows will

You have just been hired as a loan officer at fairfield : you have just been hired as a loan officer at fairfield state bank. your supervisor has given you a file containing a

Jackalope company makes attachments such as backhoes and : jackalope company makes attachments such as backhoes and grader and bulldozer blades for construction equipment. the

The stock price of jenkins co is 5370 investors require a : the stock price of jenkins co. is 53.70. investors require a 15 percent rate of return on similar stocks. required if

My aunt is about to retire and she wants to buy an annuity : my aunt is about to retire and she wants to buy an annuity that will supplement her income by 65000 per for 25 years

During the year 235 bicycles were sold at a price of 1500 : cyclone co. uses the periodic inventory system. the following information about their inventory of model xx mountain

User Account

All Pages