Rotorua Products, Limited, of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company’s 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,629,850 $ 4,882,820 $ 5,051,360 $ 5,561,430 $ 5,779,850 Cash $ 92,281 $ 100,754 $ 100,089 $ 88,760 $ 74,387 Accounts receivable, net 400,699 434,827 445,236 507,424 568,470 Inventory 805,036 874,663 822,264 897,114 903,388 Total current assets $ 1,298,016 $ 1,410,244 $ 1,367,589 $ 1,493,298 $ 1,546,245 Current liabilities $ 317,424 $ 340,337 $ 332,468 $ 321,672 $ 391,861 Required: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. (Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3).)
Rotorua Products, Limited, of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company’s 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,629,850 $ 4,882,820 $ 5,051,360 $ 5,561,430 $ 5,779,850 Cash $ 92,281 $ 100,754 $ 100,089 $ 88,760 $ 74,387 Accounts receivable, net 400,699 434,827 445,236 507,424 568,470 Inventory 805,036 874,663 822,264 897,114 903,388 Total current assets $ 1,298,016 $ 1,410,244 $ 1,367,589 $ 1,493,298 $ 1,546,245 Current liabilities $ 317,424 $ 340,337 $ 332,468 $ 321,672 $ 391,861 Required: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. (Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3).)
Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter15: Financial Statement Analysis
Section: Chapter Questions
Problem 39E: Cuneo Companys income statements for the last 3 years are as follows: Refer to the information for...
Related questions
Question
Rotorua Products, Limited, of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company’s 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,629,850 | $ 4,882,820 | $ 5,051,360 | $ 5,561,430 | $ 5,779,850 |
| Cash | $ 92,281 | $ 100,754 | $ 100,089 | $ 88,760 | $ 74,387 |
| Accounts receivable, net | 400,699 | 434,827 | 445,236 | 507,424 | 568,470 |
| Inventory | 805,036 | 874,663 | 822,264 | 897,114 | 903,388 |
| Total current assets | $ 1,298,016 | $ 1,410,244 | $ 1,367,589 | $ 1,493,298 | $ 1,546,245 |
| Current liabilities | $ 317,424 | $ 340,337 | $ 332,468 | $ 321,672 | $ 391,861 |
Required:
1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. (Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3).)
Transcribed Image Text:Required:
1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. (Round your percentage answers
to 1 decimal place (i.e., 0.1234 should be entered as 12.3).)
Sales
Current assets:
Cash
Accounts receivable, net
Inventory
Total current assets
Current liabilities
Year 1
100.0
100.0
100.0
100.0
100.0
100.0
%
%
%
%
%
%
Answer is complete but not entirely correct.
Year 2
Year 3
109.0
Year 4
120.0
105.0 %
109.0 X %
109.0 %
109.0 %
109.0 %
107.0 %
%
%
108.0
111.0 %
102.0 %
105.0 X %
105.0 X %
%
96.0 %
127.0 %
111.0 X %
115.0 %
101.0 X %
Year 5
125.0 X %
81.0 %
142.0 %
112.0 %
119.0 %
123.0 x %
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT