Accounting

profileizzy0531
ratio_hw_acc_305.docx

he current ratio of a company is 5:1 and its acid-test ratio is 1:1. If the inventories and prepaid items amount to $421,600, what is the amount of current liabilities?

Current Liabilities

$

Entry field with incorrect answer now contains modified data

(b) A company had an average inventory last year of $254,000 and its inventory turnover was 6. If sales volume and unit cost remain the same this year as last and inventory turnover is 8 this year, what will average inventory have to be during the current year?  (Round answer to 0 decimal places, e.g. 125.)

Average Inventory

$

Entry field with incorrect answer now contains modified data

(c) A company has current assets of $89,580 (of which $35,300 is inventory and prepaid items) and current liabilities of $35,300. What is the current ratio? What is the acid-test ratio? If the company borrows $14,800 cash from a bank on a 120-day loan, what will its current ratio be? What will the acid-test ratio be?  (Round answers to 2 decimal places, e.g. 2.50.)

Current Ratio

Entry field with incorrect answer

 :1

Acid Test Ratio

Entry field with incorrect answer

 :1

New Current Ratio

Entry field with incorrect answer

 :1

New Acid Test Ratio

Entry field with incorrect answer

 :1

(d) A company has current assets of $600,700 and current liabilities of $205,300. The board of directors declares a cash dividend of $194,000. What is the current ratio after the declaration but before payment? What is the current ratio after the payment of the dividend?  (Round answers to 2 decimal places, e.g. 2.50.)

Current ratio after the declaration but before payment

Entry field with incorrect answer

 :1

Current ratio after the payment of the dividend

Entry field with incorrect answer now contains modified data

 :1

Heartland Company’s budgeted sales and budgeted cost of goods sold for the coming year are $146,340,000 and $91,710,000, respectively. Short-term interest rates are expected to average 10%. If Heartland can increase inventory turnover from its present level of 9 times a year to a level of 10 times per year. Compute its expected cost savings for the coming year.

Expected Cost Savings

$

Entry field with incorrect answer now contains modified data

The following information pertains to Wamser Company:

Cash

$22,000

Accounts receivable

125,000

Inventory

75,000

Plant assets (net)

381,000

Total assets

$603,000

Accounts payable

$75,000

Accrued taxes and expenses payable

24,500

Long-term debt

48,500

Common stock ($10 par)

155,000

Paid-in capital in excess of par

89,000

Retained earnings

211,000

Total equities

$603,000

Net sales (all on credit)

$805,000

Cost of goods sold

604,000

Net income

80,500

Compute the following:  (Round answers to 2 decimal places e.g. 15.25.)

(a)

Current ratio

http://edugen.wiley.com/edugen/art2/common/pixel.gif

: 1

(b)

Inventory turnover

http://edugen.wiley.com/edugen/art2/common/pixel.gif

times

(c)

Accounts receivable turnover

http://edugen.wiley.com/edugen/art2/common/pixel.gif

times

(d)

Book value per share

$

http://edugen.wiley.com/edugen/art2/common/pixel.gif

(e)

Earnings per share

$

http://edugen.wiley.com/edugen/art2/common/pixel.gif

(f)

Debt to assets

http://edugen.wiley.com/edugen/art2/common/pixel.gif

%

(g)

Profit margin on sales

http://edugen.wiley.com/edugen/art2/common/pixel.gif

%

(h)

Return on common stock equity

http://edugen.wiley.com/edugen/art2/common/pixel.gif

%

The following data is given:

December 31,

2015

2014

Cash

$65,500

$48,500

Accounts receivable (net)

91,000

61,000

Inventories

91,000

118,000

Plant assets (net)

383,500

323,000

Accounts payable

55,500

39,000

Salaries and wages payable

11,500

5,500

Bonds payable

71,500

68,000

8% Preferred stock, $40 par

100,000

100,000

Common stock, $10 par

120,000

90,000

Paid-in capital in excess of par

80,000

65,000

Retained earnings

192,500

183,000

Net credit sales

1,000,000

Cost of goods sold

740,000

Net income

82,000

Compute the following ratios:  (Round answers to 2 decimal places e.g. 15.25.)

(a)

Acid-test ratio at 12/31/15

http://edugen.wiley.com/edugen/art2/common/pixel.gif

: 1

(b)

Accounts receivable turnover in 2015

http://edugen.wiley.com/edugen/art2/common/pixel.gif

times

(c)

Inventory turnover in 2015

http://edugen.wiley.com/edugen/art2/common/pixel.gif

times

(d)

Profit margin on sales in 2015

http://edugen.wiley.com/edugen/art2/common/pixel.gif

%

(e)

Return on common stock equity in 2015

http://edugen.wiley.com/edugen/art2/common/pixel.gif

%

(f)

Book value per share of common stock at 12/31/15

$

http://edugen.wiley.com/edugen/art2/common/pixel.gif

As loan analyst for Utrillo Bank, you have been presented the following information.

Toulouse Co.

Lautrec Co.

Assets

Cash

$129,900

$329,700

Receivables

211,400

305,700

Inventories

570,200

 

515,300

 

   Total current assets

911,500

1,150,700

Other assets

495,000

 

616,100

 

   Total assets

$1,406,500

 

$1,766,800

 

 

Liabilities and Stockholders’ Equity

Current liabilities

$294,100

$350,800

Long-term liabilities

405,900

495,000

Capital stock and retained earnings

706,500

 

921,000

 

   Total liabilities and stockholders’ equity

$1,406,500

 

$1,766,800

 

Annual sales

$935,000

$1,492,100

Rate of gross profit on sales

25

%

35

%

Each of these companies has requested a loan of $49,060 for 6 months with no collateral offered. Because your bank has reached its quota for loans of this type, only one of these requests is to be granted. Compute the various ratios for each company.  (Round answer to 2 decimal places, e.g. 2.25.)

Toulouse Co.

Lautrec Co.

Current ratio

http://edugen.wiley.com/edugen/art2/common/pixel.gif

 : 1

http://edugen.wiley.com/edugen/art2/common/pixel.gif

 : 1

Acid-test ratio

http://edugen.wiley.com/edugen/art2/common/pixel.gif

 : 1

http://edugen.wiley.com/edugen/art2/common/pixel.gif

 : 1

Accounts receivable turnover

http://edugen.wiley.com/edugen/art2/common/pixel.gif

 times

http://edugen.wiley.com/edugen/art2/common/pixel.gif

 times

Inventory turnover

http://edugen.wiley.com/edugen/art2/common/pixel.gif

 times

http://edugen.wiley.com/edugen/art2/common/pixel.gif

 times

Cash to current liabilities

http://edugen.wiley.com/edugen/art2/common/pixel.gif

 : 1

http://edugen.wiley.com/edugen/art2/common/pixel.gif

 : 1

Bradburn Corporation was formed 5 years ago through a public subscription of common stock. Daniel Brown, who owns 15% of the common stock, was one of the organizers of Bradburn and is its current president. The company has been successful, but it currently is experiencing a shortage of funds. On June 10, 2015, Daniel Brown approached the Topeka National Bank, asking for a 24-month extension on two $35,420 notes, which are due on June 30, 2015, and September 30, 2015. Another note of $6,100 is due on March 31, 2016, but he expects no difficulty in paying this note on its due date. Brown explained that Bradburn’s cash flow problems are due primarily to the company’s desire to finance a $306,100 plant expansion over the next 2 fiscal years through internally generated funds. The commercial loan officer of Topeka National Bank requested financial reports for the last 2 fiscal years.

BRADBURN CORPORATION BALANCE SHEET MARCH 31

Assets

2015

2014

Cash

$18,410

$13,090

Notes receivable

148,200

132,100

Accounts receivable (net)

133,240

126,870

Inventories (at cost)

106,440

50,120

Plant & equipment (net of depreciation)

1,469,300

1,427,000

    Total assets

$1,875,590

$1,749,180

 

Liabilities and Owners’ Equity

Accounts payable

$79,790

$91,700

Notes payable

76,940

63,250

Accrued liabilities

29,480

11,360

Common stock (130,000 shares, $10 par)

1,300,000

1,300,000

Retained earningsa

389,380

282,870

    Total liabilities and stockholders’ equity

$1,875,590

$1,749,180

 

aCash dividends were paid at the rate of $1 per share in fiscal year 2014 and $2 per share in fiscal year 2015.

BRADBURN CORPORATION INCOME STATEMENT FOR THE FISCAL YEARS ENDED MARCH 31

2015

2014

Sales revenue

$3,014,200

$2,712,500

Cost of goods solda

1,539,500

1,428,900

Gross margin

1,474,700

1,283,600

Operating expenses

863,850

784,500

Income before income taxes

610,850

499,100

Income taxes (40%)

244,340

199,640

Net income

$366,510

$299,460

 

aDepreciation charges on the plant and equipment of $109,500 and $112,200 for fiscal years ended March 31, 2014 and 2015, respectively, are included in cost of goods sold.

(a) Compute the following items for Bradburn Corporation.  (Round answer to 2 decimal places, e.g. 2.25.)

(1)

Current ratio for fiscal years 2014 and 2015.

(2)

Acid-test (quick) ratio for fiscal years 2014 and 2015.

(3)

Inventory turnover for fiscal year 2015.

(4)

Return on assets for fiscal years 2014 and 2015. (Assume total assets were $1,694,200 at 3/31/13.)

(5)

Percentage change in sales, cost of goods sold, gross margin, and net income after taxes from fiscal year 2014 to 2015.

2014

2015

(1)

Current ratio

http://edugen.wiley.com/edugen/art2/common/pixel.gif

 :1

http://edugen.wiley.com/edugen/art2/common/pixel.gif

 :1

(2)

Acid-test (quick) ratio

http://edugen.wiley.com/edugen/art2/common/pixel.gif

 :1

http://edugen.wiley.com/edugen/art2/common/pixel.gif

 :1

(3)

Inventory turnover

http://edugen.wiley.com/edugen/art2/common/pixel.gif

 times

(4)

Return on assets

http://edugen.wiley.com/edugen/art2/common/pixel.gif

%

http://edugen.wiley.com/edugen/art2/common/pixel.gif

%

(5)

Percent Changes

Percent Increase

Sales revenue

http://edugen.wiley.com/edugen/art2/common/pixel.gif

%

Cost of goods sold

http://edugen.wiley.com/edugen/art2/common/pixel.gif

%

Gross margin

http://edugen.wiley.com/edugen/art2/common/pixel.gif

%

Net income after taxes

http://edugen.wiley.com/edugen/art2/common/pixel.gif

%

1.75

254750

50000

125000