Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started