Assignment1.docx

Assignment 1

Question 1

1. Prepare an income statement for Franklin Kite Co. Take your calculations all the way to computing earnings per share. (Round EPS answer to 2 decimal places.)   

 

 

Sales

$

1,380,000

Shares outstanding

 

115,000

Cost of goods sold

 

600,000

Interest expense

 

28,000

Selling and administrative expense

 

49,000

Depreciation expense

 

31,000

Preferred stock dividends

 

85,000

Taxes

 

117,000

 

Franklin Kite Company

Income Statement

0

0

0

0

0

0

0

0

0

0

0

Earnings available to common stockholders

0

Shares outstanding

0

Earnings per share

0

Question 2

The Rogers Corporation has a gross profit of $792,000 and $277,000 in depreciation expense. The Evans Corporation also has $792,000 in gross profit, with $43,300 in depreciation expense. Selling and administrative expense is $188,000 for each company.  

a. Given that the tax rate is 40 percent, compute the cash flow for both companies.

Rogers

Evans

CashFlow

$

$

b. Calculate the difference in cash flow between the two firms.

Difference in Cash Flow

$

Question 3

The Holtzman Corporation has assets of $441,000, current liabilities of $105,000, and long-term liabilities of $147,000. There is $31,500 in preferred stock outstanding; 20,000 shares of common stock have been issued.  

a. Compute book value (net worth) per share. (Round your answer to 2 decimal places.)

Book Value per share

b. If there is $32,700 in earnings available to common stockholders, and Holtzman’s stock has a P/E of 24 times earnings per share, what is the current price of the stock? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)  

Current Price

c. What is the ratio of market value per share to book value per share? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)

Market value to book Value

Times

Question 4

Refer to the following financial statements for Crosby Corporation:      

CROSBY CORPORATION Income Statement For the Year Ended December 31, 20X2

Sales

 

$

4,240,000

Cost of goods sold

 

 

2,640,000

Gross profit

 

$

1,600,000

Selling and administrative expense

 

 

700,000

Depreciation expense

 

 

300,000

Operating income

 

$

600,000

Interest expense

 

 

89,000

Earnings before taxes

 

$

511,000

Taxes

 

 

211,000

Earnings after taxes

 

$

300,000

Preferred stock dividends

 

 

10,000

Earnings available to common stockholders

 

$

290,000

Shares outstanding

 

 

150,000

Earnings per share

 

$

1.93

  

Statement of Retained Earnings For the Year Ended December 31, 20X2

Retained earnings, balance, January 1, 20X2

$

80,300

Add: Earnings available to common stockholders, 20X2

 

290,000

Deduct: Cash dividends declared and paid in 20X2

 

150,000

Retained earnings, balance, December 31, 20X2

$

220,300

  

Comparative Balance Sheets For 20X1 and 20X2

 

Year-End 20X1

 

Year-End 20X2

Assets

 

 

 

 

 

 

 

Current assets:

 

 

 

 

 

 

 

Cash

 

$

112,000

 

 

$

185,900

Accounts receivable (net)

 

 

556,000

 

 

 

602,000

Inventory

 

 

633,000

 

 

 

641,000

Prepaid expenses

 

 

64,900

 

 

 

32,000

Total current assets

 

$

1,365,900

 

 

$

1,460,900

Investments (long-term securities)

 

 

92,300

 

 

 

85,000

Gross plant and equipment

$ 2,120,000

 

 

 

$ 2,870,000

 

 

Less: Accumulated depreciation

1,870,000

 

 

 

2,170,000

 

 

Net plant and equipment

 

 

250,000

 

 

 

700,000

Total assets

 

$

1,708,200

 

 

$

2,245,900

Liabilities and Stockholders’ Equity

 

 

 

 

 

 

 

Current liabilities:

 

 

 

 

 

 

 

Accounts payable

 

$

304,000

 

 

$

635,000

Notes payable

 

 

536,000

 

 

 

536,000

Accrued expenses

 

 

74,900

 

 

 

56,600

Total current liabilities

 

$

914,900

 

 

$

1,227,600

Long-term liabilities:

 

 

 

 

 

 

 

Bonds payable, 20X2

 

 

123,000

 

 

 

208,000

Total liabilities

 

$

1,037,900

 

 

$

1,435,600

Stockholders’ equity:

 

 

 

 

 

 

 

Preferred stock, $100 par value

 

$

90,000

 

 

$

90,000

Common stock, $1 par value

 

 

150,000

 

 

 

150,000

Capital paid in excess of par

 

 

350,000

 

 

 

350,000

Retained earnings

 

 

80,300

 

 

 

220,300

Total stockholders’ equity

 

$

670,300

 

 

$

810,300

Total liabilities and stockholders’ equity

 

$

1,708,200

 

 

$

2,245,900

a. Prepare a statement of cash flows for the Crosby Corporation: (Amounts to be deducted should be indicated with parentheses or a minus sign.)

CROSBY CORPORATION

Statement of Cash Flows

For the Year Ended December 31, 20X2

Cash flows from operating activities:

Adjustments to determine cashflow from operating activities:

Total adjustments

Net cash flows from operating activities

Cash flows from investing activities:

Net cash flows from investing activities

Cash flows from financing activities:

Net cash flows from financing activities

b. Compute the book value per common share for both 20X1 and 20X2 for the Crosby Corporation. (Round your answers to 2 decimals places.)

Book value

20X1

20X2

Question 5

Jim Short’s Company makes clothing for schools. Sales in 20X1 were $4,490,000. Assets were as follows:

  

 

Cash

$

110,000

 

Accounts receivable

 

864,000

 

Inventory

 

493,000

 

Net plant and equipment

 

504,000

 

Total assets

$

1,971,000

 

a. Compute the following: (Round your answers to 2 decimal places.)

Turn over Ratio

1

Account receivable turnover

Times

2

Inventory Turnover

Times

3

Fix Asset Turnerover

Times

4

Total Asset turnover

Times

c. Is there an improvement or a decline in the total asset turnover?

  

·

Decline

·

Improvement

Question 6

The balance sheet for Stud Clothiers is shown next. Sales for the year were $3,490,000, with 75 percent of sales sold on credit.

STUD CLOTHIERS Balance Sheet 20X1

Assets

Liabilities and Equity

Cash

$

38,000

Accounts payable

$

262,000

Accounts receivable

 

292,000

Accrued taxes

 

148,000

Inventory

 

248,000

Bonds payable (long-term)

 

178,000

Plant and equipment

 

500,000

Common stock

 

100,000

 

 

 

Paid-in capital

 

150,000

 

 

 

Retained earnings

 

240,000

Total assets

$

1,078,000

Total liabilities and equity

$

1,078,000

Compute the following ratios: (Use a 360-day year. Do not round intermediate calculations. Round your answers to 2 decimal places. Input your debt-to-total assets answer as a percent rounded to 2 decimal places.)

a

Current ratio

Times

b

Quick Ratio

times

c

Debt-to-total-asset ratio

%

d

Asset turnover

times

e

Average collection period

days

Question 7

Jolie Foster Care Homes Inc. shows the following data:

  

Years Net income Total Assets Stockholders' Equity Total Debt’s

20X1

138,000

2,650,000

796,000

1,854,000

20X2

140,000

2,300,000

1,280,000

1,016,000

20X3

160,000

2,280,000

1,500,000

780,000

20X4

255,000

2,640,000

2,510,000

130,000

a-1. Compute the ratio of net income to total assets for each year. (Input your answers as a percent rounded to 2 decimal places.)

Year

Return on Assets

20X1

%

20X2

%

20X3

%

20X4

%

a-2. What is the trend in the net income to total assets ratio?   

·

Strong downward movement

·

Strong upward movement

 

b-1. Compute the ratio of net income to stockholders' equity for each year. (Input your answers as a percent rounded to 2 decimal places.)   

Year

Return Stockholder’s Equity

20X1

%

20X2

%

20X3

%

20X4

%

b-2. What is the trend in the net income to stockholders' equity ratio?   

·

Strong downward movement

·

Strong upward movement