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 Sales Current assets Accounts receivable net Total curent asses Cument abs Year 1 $4,599,170 $ 98,780 403,731 806,316 $1,308,827 $ 307,643 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 (.e., 0.1234 should be entered as 12.3).) % % 1% Year 2 Year 2 $4,766,250 $89,994 431,432 869,464 $ 1,390,890 $336,456 Year 3 % % % Year 3 $5,097,530 $ 91,640 435,015 826,871 $1,354,326 $ 330,139 Year 4 % % Year 4 $ 5,467,000 $84,639 511,755 890,352 $ 1,486,746 $ 328,184 Year 5 Tear 5 $ 5,812,500 $ 64,779 568,003 911,752 $1,544,534 $ 407,388 %

Principles of Accounting Volume 1
19th Edition
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax
Chapter6: Merchandising Transactions
Section: Chapter Questions
Problem 22Q: The following is select account information for August Sundries. Sales: $850,360; Sales Returns and...
icon
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:
Sales
Cash
Accounts receivable, net
Inventory
Total current assets
Current liabilities
Sains
Current assets
Cash
Accounts receivable, net
inventory
Total current asses
Cument labes
Year 1
%
%
%
Year 1
$4,599,170
$ 98,780
403,731
806,316
$1,308,827
$ 307,643
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 (.e., 0.1234 should be entered as 12.3).)
%
Year 2
%
%
%
%
%
Year 2
$4,766,250
$89,994
431,432
869,464
$1,390,890
$336,456
Year 3
%
%
%
%
%
Year 3
$ 5,097,530
$91,640
435,815
826,871
$1,354,326
$330,139
Year 4
%
%
%
Year 4
$ 5,467,000
$84,639
511,755
890,352
$1,486,746
Year 5
Year 5
$ 5,812,500
%
%
%
64,779
560,003
911,752
$1,544,534
$ 407,308
Transcribed Image Text: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 Sains Current assets Cash Accounts receivable, net inventory Total current asses Cument labes Year 1 % % % Year 1 $4,599,170 $ 98,780 403,731 806,316 $1,308,827 $ 307,643 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 (.e., 0.1234 should be entered as 12.3).) % Year 2 % % % % % Year 2 $4,766,250 $89,994 431,432 869,464 $1,390,890 $336,456 Year 3 % % % % % Year 3 $ 5,097,530 $91,640 435,815 826,871 $1,354,326 $330,139 Year 4 % % % Year 4 $ 5,467,000 $84,639 511,755 890,352 $1,486,746 Year 5 Year 5 $ 5,812,500 % % % 64,779 560,003 911,752 $1,544,534 $ 407,308
A comparative Income statement is given below for McKenzie Sales, Limited, of Toronto:
McKenzie Sales, Limited
Comparative Income Statement
Sales
Cost of goods sold
Gross margin
Selling and administrative expenses:
Selling expenses
Administrative expenses
Total expenses
Net operating income
Interest expense
Net incone before taxes
Sales
Cost of goods sold
Gross margin
Selling and administrative expenses
Selling expenses
Administrative expenses
Total selling and administrative expenses
This Year
$ 7,360,000
4,740,000
2,620,000
Net operating income
Interest expense
Net income before taxes
This Year
Members of the company's board of directors are surprised to see that net income increased by only $134,900 when sales increased
by
Required:
1 Express each year's income statement in common-size percentages. (Round your percentage answers to 1 decimal place (ie..
0.1234 should be entered as 12.3).)
0.0 %
%
%
0.0 %
0.0 %
1,374,000
703,000
2,077,000
%
543,000
100,000
0443,000
0.0 %
Last Year
Last Year
$5,593,600
3,514,000
2,079,600
00%
%
1,073,500
600,000
1,681,500
0.0 %
0,0 %
%
0.0 %
398,100
90,000
$300,100
Transcribed Image Text:A comparative Income statement is given below for McKenzie Sales, Limited, of Toronto: McKenzie Sales, Limited Comparative Income Statement Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling expenses Administrative expenses Total expenses Net operating income Interest expense Net incone before taxes Sales Cost of goods sold Gross margin Selling and administrative expenses Selling expenses Administrative expenses Total selling and administrative expenses This Year $ 7,360,000 4,740,000 2,620,000 Net operating income Interest expense Net income before taxes This Year Members of the company's board of directors are surprised to see that net income increased by only $134,900 when sales increased by Required: 1 Express each year's income statement in common-size percentages. (Round your percentage answers to 1 decimal place (ie.. 0.1234 should be entered as 12.3).) 0.0 % % % 0.0 % 0.0 % 1,374,000 703,000 2,077,000 % 543,000 100,000 0443,000 0.0 % Last Year Last Year $5,593,600 3,514,000 2,079,600 00% % 1,073,500 600,000 1,681,500 0.0 % 0,0 % % 0.0 % 398,100 90,000 $300,100
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Income Statement Analysis
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College