Question

1. 3. Selected year-end data for the Melbourne Company are presented below:              Acid-test ratio 2.5...

1.

3. Selected year-end data for the Melbourne Company are presented below:

            

Acid-test ratio

2.5 to 1

Cost of goods sold

$1,500,000

Current liabilities

$1,800,000

Current ratio

3.0 to 1

The company has no prepaid expenses and inventories remained unchanged during the year. Based on these data, what was the company's inventory turnover ratio for the year?

2. Meryl Company had $540,000 in sales on account last year. The beginning accounts receivable balance was $30,000 and the ending accounts receivable balance was $54,000. What was the company's average collection period (age of receivables)?

3. The Southern Division of Schuler Enterprises recorded operating data as follows for the past year:

Sales

$600,000

Net operating income

75,000

Average operating assets

300,000

Stockholders’ equity

240,000

Residual income

39,000

            What was the margin for the past year?

             

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Part 1

Acid test ratio=(cash & cash equivalents+marketable securities+accounts receivable)/ current liabilities

Therefore assets other than inventory (cash & cash equivalents+marketable securities+accounts receivable) = 2.5 x current liabilities

= 2.5 x 1,800,000 = 4,500,000

Current ratio= Current assets / Current liabilities

Current assets = 3 x current liabilities = 3 x 1,800,000= 5,400,000

Therefore inventory = 5,400,000-4,500,000 = 900,000

Inventory turnover ratio= cost of goods sold/ inventory = 1,500,000/900,000 = 1.667

Part 2

Average collection period= (Average receivables/ Sales) x 365

Average receivables= (30,000+54000)/2 =42000

Average collection period= (42000/ 540000) * 365 = 28 days

Part 3

Margin = Net operating income / sales = (75000/ 600,000) * 100 = 12.5%

Add a comment
Know the answer?
Add Answer to:
1. 3. Selected year-end data for the Melbourne Company are presented below:              Acid-test ratio 2.5...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 1. The following data are available for the Northern Division of Comet Products and the single...

    1. The following data are available for the Northern Division of Comet Products and the single product it makes: Unit selling price $60 Variable cost per unit $36 Annual fixed costs $840,000 Average operating assets $4,500,000 How many units must the Northern Division sell each year to have an ROI of 16%? 2. The Southern Division of Schuler Enterprises recorded operating data as follows for the past year: Sales $600,000 Net operating income 75,000 Average operating assets 300,000 Stockholders’ equity...

  • Ratio Question The selected financial data for Sand N Companies are presented at the end of...

    Ratio Question The selected financial data for Sand N Companies are presented at the end of December 2011 Net credit sales Cost of goods sold Cash Accounts receivable, et Inventory Current liabilities SRMO 675,000 504,000 51.000 75,000 34,000 105,000 NEMO 560,000 480,000 20,000 70,000 160,000 100,000 proximate the Assume that the year-end balance shown for accounts receivable and for inventory average balances of the items through the year Required: 1. For each of the companies, compute the following 1. Working...

  • Question The selected financial data for Sand N Companies are presented at the end of December...

    Question The selected financial data for Sand N Companies are presented at the end of December 2011 Net credit sales Cost of goods sold Cash Accounts receivable, net Inventory Current liabilities SRM 675.000 504,000 51,000 75,000 34,000 105,000 NEMO 560,000 450,000 20,000 70,000 160,000 100,000 CA Assume that the year-end balance shown for accounts receivable and for inventory approximate the average balances of these items through the year Required: . For each of the 2 companies, compute the following 1....

  • Question 1 Shown below are selected financial data for AB and XY Limited at the end...

    Question 1 Shown below are selected financial data for AB and XY Limited at the end of the current year AB Ltd XY Ltd Net credit sales $675,000 $560,000 Cost of goods sold 504,000 480,000 Cash 51,000 20,000 Accounts receivable 75,000 70,000 Inventory 84,000 160,000 Current liabilities 105,000 100,000 Required: a) For each of the two companies, compute the following 1. Working capital 2. Current ratio 3. Quick ratio 4. Inventory turnover ratio and average number of days required to...

  • 1) earninggs per share for this year and last year 2) dividend yield ratio in %...

    1) earninggs per share for this year and last year 2) dividend yield ratio in % this and last year 3) dividend payout ratio in % this and last year 4) price earning ratio this and last year 5) book value per share of common stock this and last year Comparative Balance Sheet This Year Last Year $ 960,000 2,700,000 3,600,000 • 260,000 7,520,000 9,520,000 $17,040,000 $ 1,200,000 300,000 1,800,000 2,000,000 200,000 5,500,000 9 ,050,000 $14,550,000 Assets Current assets: Cash...

  • i Data Table - X Selected income statement data for the current year Net Sales Revenue...

    i Data Table - X Selected income statement data for the current year Net Sales Revenue (all on credit) Cost of Goods Sold Interest Expense Net Income Best Digital 416,830 $ 210,000 Very Network 493,115 258,000 19,000 66,000 49,000 Print Done Clear All Data Table Selected balance sheet and market price data at the end of the current year Best Digital Very Network Current Assets Cash Short-term Investments Accounts Receivables, Net Merchandise Inventory 28,000 $ 39,000 39,000 66,000 19,000 191,000...

  • Dube from the 4 1. Kirsten Company presented the following data at the end of 2019...

    Dube from the 4 1. Kirsten Company presented the following data at the end of 2019 A Cash $1,800 000 Accounts receivable 3.200.000 Merchandise inventory 2.800,000 A Prepaid insurance 300.000 Property & equipment 8.000.000 Accounts payable 750.000 L- Unearned revenue 800.000 Wages payable 1,800,000 NC Bonds payable 4,000,000 Determine the current ratio for Kirsten Company (rounded) A) 4.41 C) 2.57 Dj 238 tables 2. Data from the financial statements of Dils Brothers Co and J. Cox, Inc. are presented below...

  • Barco Company Data from the current year-end balance sheets Kyan Company kyan Company Cash Accounts receivable,...

    Barco Company Data from the current year-end balance sheets Kyan Company kyan Company Cash Accounts receivable, net Current notes receivable (trade) Merchandise Inventory Prepaid expenses Plant assets, net Total assets $ 21,000 $31.000 37,400 54,40 9,800 54,840 134,500 6,200 1,050 290.000 100.400 9443,2405542,350 Barco Company Data from the current year's Income statement Sales 600,000 Cost of goods sold 507,100 Interest expense ,300 Income tax expense 15,373 Net Income 139,223 Basic earnings per share Cash dividends per share 3.50 $920,200 63450...

  • 1/ Given the following data: sales $1,500,000; gross profit $640,000; net income after tax $40,000 and income tax expens...

    1/ Given the following data: sales $1,500,000; gross profit $640,000; net income after tax $40,000 and income tax expense $35,000. What is the common-size percentage for operating expenses? 37.7% 42.7% 95.0% 97.3% 2/ To best interpret the accounts receivable turnover ratio, the days in accounts receivable should be compared to the company's inventory turnover. sales revenue. credit terms. accounts receivable balance. 3/ The quick ratio will be negatively impacted by tying up cash in inventory. increasing accounts receivable. decreasing the...

  • every question requires this year and last year 1) working capital (this and last year) 2)...

    every question requires this year and last year 1) working capital (this and last year) 2) the current ratio 3) average collection period (use 365 days in a year) (accounts recievable at the beginning if kast year totaled 1,670,000) 4) average sale period (365 days in a year, inventory of beginning of kast year is 2,030,000) 5) operating cycle 6) total asset turnover (totaled at the beginning if last year at 14,610,000) Lydex Company Comparative Balance Sheet This Year Last...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT