Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The financial statements for Castile Products, Inc., are given below: Castile Products, Inc. Balance Sheet December 31 Assets Current assets: Cash $ 21,000 Accounts receivable,

The financial statements for Castile Products, Inc., are given below:

Castile Products, Inc. Balance Sheet December 31
Assets
Current assets:
Cash $ 21,000
Accounts receivable, net 250,000
Merchandise inventory 390,000
Prepaid expenses 10,000
Total current assets 671,000
Property and equipment, net 820,000
Total assets $ 1,491,000
Liabilities and Stockholders' Equity
Liabilities:
Current liabilities $ 270,000
Bonds payable, 12% 310,000
Total liabilities 580,000
Stockholders equity:
Common stock, $5 per value $ 190,000
Retained earnings 721,000
Total stockholders equity 911,000
Total liabilities and stockholders equity $ 1,491,000

Castile Products, Inc. Income Statement For the Year Ended December 31
Sales $ 3,800,000
Cost of goods sold 1,292,000
Gross margin 2,508,000
Selling and administrative expenses 640,000
Net operating income 1,868,000
Interest expense 37,200
Net income before taxes 1,830,800
Income taxes (30%) 549,240
Net income $ 1,281,560

Account balances at the beginning of the year were: accounts receivable, $150,000; and inventory, $290,000. All sales were on account.

Required:

Compute the following financial data and ratios:

1. Working capital.

2. Current ratio. (Round your answer to 1 decimal place.)

3. Acid-test ratio. (Round your answer to 2 decimal places.)

4. Debt-to-equity ratio. (Round your answer to 2 decimal places.)

5. Times interest earned ratio. (Round your answer to 2 decimal places.)

6. Average collection period. (Use 365 days in a year. Round your intermediate calculations and final answer to 1 decimal place.)

7. Average sale period. (Use 365 days in a year. Round your intermediate calculations and final answer to 1 decimal place.)

8. Operating cycle. (Round your intermediate calculations and final answer to 1 decimal place.)

Answers:

1. Calculation of working capital: Current assets $ 671,000 Current liabilities 270,000 Working capital $ 401,000

2. Current ratio: Current ratio = Current assets = $671,000 = 2.5 Current liabilities $270,000

3. Acid-test ratio: Acid-test ratio = Cash + Marketable securities + Accounts receivable + Short-term notes receivable Current liabilities = $21,000 + $0 + $250,000 + 0 $270,000 = 1.00

4. Debt-to-equity ratio: = Total liabilities Stockholders' equity = $580,000 $911,000 = 0.64 (rounded)

5. Times interest earned: Times interest earned = Earnings before interest and income taxes Interest expense = $1,868,000 $37,200 = 50.22

6. Average collection period: Accounts receivable turnover = Sales on account Average accounts receivable = $3,800,000 ($250,000 + $150,000)/2 = 19 Average collection period = 365 days Accounts receivable turnover = 365 days 19 = 19.2 days (rounded)

7. Average sale period: Inventory turnover = Cost of goods sold Average inventory = $1,292,000 ($390,000 + $290,000)/2 = 3.8 Average sale period = 365 days 3.8 = 96.1 days (rounded)

8.

The operating cycle is computed as follows:

Operating cycle = Average sales period + Average collection period
= 96.1 days + 19.2 days = 115.3 days

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

International Accounting Standards Regulations Financial Reporting

Authors: Greg N. Gregoriou, Mohamed Gaber

1st Edition

0750669837, 978-0750669832

More Books

Students also viewed these Accounting questions

Question

Know how to use reservations systems to inventory demand.

Answered: 1 week ago

Question

Be familiar with the integrative servicescape model.

Answered: 1 week ago