Exercise 14-7 (Algo) Trend Percentages [LO14-1] 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: Sales Cash Accounts receivable, net Inventory Total current assets Current liabilities Required: Year 1 $ 4,680,030 $ 82,770 403,609 800,154 $ 1,286,533 $ 318,714 Year 2 $ 4,900,840 $ 101,787 417,705 868,059 $ 1,387,551 $ 332,732 Year 3 $ 5,029,390 $ 98,893 445,314 828,216 $ 1,372,423 $ 339,560 Year 4 $ 5,504,210 $ 88,301 509,629 885,290 $ 1,483,220 $ 329,136 Year 5 $ 5,628,180 $ 70,089 571,343 907,134 $ 1,548,566 $ 402,845 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 Year 1 Year 2 Year 3 Year 4 Year 5 100.0% % % % % Current assets: Cash 100.0% % % % % Accounts receivable, net 100.0 % % % % % Inventory 100.0 % % % % % Total current assets 100.0 % % % % % Current liabilities 100.0 % % % % %
Exercise 14-7 (Algo) Trend Percentages [LO14-1] 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: Sales Cash Accounts receivable, net Inventory Total current assets Current liabilities Required: Year 1 $ 4,680,030 $ 82,770 403,609 800,154 $ 1,286,533 $ 318,714 Year 2 $ 4,900,840 $ 101,787 417,705 868,059 $ 1,387,551 $ 332,732 Year 3 $ 5,029,390 $ 98,893 445,314 828,216 $ 1,372,423 $ 339,560 Year 4 $ 5,504,210 $ 88,301 509,629 885,290 $ 1,483,220 $ 329,136 Year 5 $ 5,628,180 $ 70,089 571,343 907,134 $ 1,548,566 $ 402,845 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 Year 1 Year 2 Year 3 Year 4 Year 5 100.0% % % % % Current assets: Cash 100.0% % % % % Accounts receivable, net 100.0 % % % % % Inventory 100.0 % % % % % Total current assets 100.0 % % % % % Current liabilities 100.0 % % % % %
Survey of Accounting (Accounting I)
8th Edition
ISBN:9781305961883
Author:Carl Warren
Publisher:Carl Warren
Chapter15: Capital Investment Analysis
Section: Chapter Questions
Problem 15.5.1MBA
Related questions
Question
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 with 2 images
Recommended textbooks for you
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning