Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The companys current assets, current liabilities, and sales over the

Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The companys current assets, current liabilities, and sales over the last five years (Year 5 is the most recent year) are as follows:

Year 1 Year 2 Year 3 Year 4 Year 5
Sales $ 4,573,740 $ 4,806,100 $ 5,099,070 $ 5,562,450 $ 5,657,510
Cash $ 88,463 $ 102,926 $ 98,664 $ 77,117 $ 75,255
Accounts receivable, net 403,938 418,166 443,656 502,108 563,660
Inventory 812,152 873,165 819,625 891,120 899,792
Total current assets $ 1,304,553 $ 1,394,257 $ 1,361,945 $ 1,470,345 $ 1,538,707
Current liabilities $ 305,499 $ 348,009 $ 342,317 $ 333,433 $ 396,958

Required:

1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year.

Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 600,000 shares of common stock were outstanding. The interest rate on the bond payable was 10%, the income tax rate was 40%, and the dividend per share of common stock was $0.75 last year and $0.40 this year. The market value of the companys common stock at the end of the year was $22. All of the companys sales are on account.

Weller Corporation Comparative Balance Sheet (dollars in thousands)
This Year Last Year
Assets
Current assets:
Cash $ 1,210 $ 1,260
Accounts receivable, net 10,900 6,900
Inventory 13,600 12,000
Prepaid expenses 770 590
Total current assets 26,480 20,750
Property and equipment:
Land 9,200 9,200
Buildings and equipment, net 46,618 42,206
Total property and equipment 55,818 51,406
Total assets $ 82,298 $ 72,156
Liabilities and Stockholders' Equity
Current liabilities:
Accounts payable $ 19,500 $ 18,900
Accrued liabilities 930 760
Notes payable, short term 190 190
Total current liabilities 20,620 19,850
Long-term liabilities:
Bonds payable 9,900 9,900
Total liabilities 30,520 29,750
Stockholders' equity:
Common stock 600 600
Additional paid-in capital 4,000 4,000
Total paid-in capital 4,600 4,600
Retained earnings 47,178 37,806
Total stockholders' equity 51,778 42,406
Total liabilities and stockholders' equity $ 82,298 $ 72,156

Weller Corporation Comparative Income Statement and Reconciliation (dollars in thousands)
This Year Last Year
Sales $ 82,770 $ 65,000
Cost of goods sold 47,360 35,000
Gross margin 35,410 30,000
Selling and administrative expenses:
Selling expenses 11,200 10,000
Administrative expenses 7,200 6,400
Total selling and administrative expenses 18,400 16,400
Net operating income 17,010 13,600
Interest expense 990 990
Net income before taxes 16,020 12,610
Income taxes 6,408 5,044
Net income 9,612 7,566
Dividends to common stockholders 240 300
Net income added to retained earnings 9,372 7,266
Beginning retained earnings 37,806 30,540
Ending retained earnings $ 47,178 $ 37,806

Required:

Compute the following financial data for this year:

1. Accounts receivable turnover. (Assume that all sales are on account.) (Round your answer to 2 decimal places.)

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

3. Inventory turnover. (Round your answer to 2 decimal places.)

4. Average sale period. (Use 365 days in a year. Round your intermediate calculations and final answer to 2 decimal places.)

5. Operating cycle. (Round your intermediate calculations and final answer to 2 decimal places.)

6. Total asset turnover. (Round your answer to 2 decimal places.)

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_2

Step: 3

blur-text-image_3

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

Cost Accounting A Managerial Emphasis

Authors: Charles T. Horngren, Foster George, Srikand M. Datar, Maureen P. Gowing

5th Canadian Edition

0135004934, 978-0135004937

More Books

Students also viewed these Accounting questions

Question

Differentiate between gender equality and gender equity.

Answered: 1 week ago