Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumermarket. The company's current assets, current liabilities, and sales have been reported as follows over thelast five years (Year 5 is the most recent year):Year 1Year 2Year 3Year 4Year 5Sales$4,546,750$4,760,520 $5,009,460 $5,429,040 $5,695,160$$2$2$87,970513,073895,198$73,368572,803907,666Cash90,291401,499815,05995,951417,195869,22892,001448,219832,208Accounts receivable, netInventoryTotal current assets$1,306,849 $1,382,374$1,372,428$1,496,241$1,553,837Current liabilities$ 318,258$ 335,298$ 335,856 $ 325,402$ 399,778Required: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).)Year 1Year 2Year 3Year 4Year 5Sales%%%%%Current assets:CashAccounts receivableInventoryTotal current assetsCurrent liabilities

Horizontal analysis is prepared to calculate the variance from previous year by showing…

Answered: Rotorua Products, Ltd., of New Zealand…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

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 $ 5,109,920 Year 4 $5,426,160 Sales Cash $ 4,913,430 $ 107,166 418,831 872,823 $ 4,517,760 $ 84,222 404,401 613,759 $ 1,302,382 $314,605 Accounts receivable, net $ 96,378 433,712 823,556 Year 5 $ 5,678,400 $67,491 577,175 896,962 $ 80,729 510,535 897,844 Inventory Total current assets $ 1,541,628 $ 1,398,820 $ 345,031 $ 1,353,646 $ 329,686 $1,489,108 $ 334,022 current liabilities: $ 394,277 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).) Year 1 Year 2 Year 3 Year 4 Year 5 Sales % Current assets Cash Accounts receivable, not Inventory Total current assets Current…
Payton Company has the following segment revenues for the two most recent fiscal years. Segment Current Year (in millions) Prior Year (in millions) China $770 $650 Canada 326 240 Other countries 212 168 Total revenues $1,308 $1,058 Prepare a vertical analysis of the segment data. Calculate the percentage to four decimal places, then round your answer to one decimal place. Payton Company Vertical Analysis Current Year Prior Year Current Year Percent Prior Year Segment Amount Amount Percent (in millions) (in millions) China $770 $650 % Canada 326 240 Other countries 212 168 Total revenues $1,308 $1,058 Previous Next
The data shown were obtained from the financial records of Italian Exports, Inc., for March: Estimated Sales $580,000 Sales 567,930 Purchases 294,832 Ending Inventory* 10% Administrative Salaries 50,280 Marketing Expense** 5% Sales Commissions 2% Rent Expense 7,700 Depreciation Expense 1,200 Utilities 2,500 Taxes*** 15% *of next month's sales **of estimated sales ***of income before taxes Sales are expected to increase each month by 10%. Prepare a budgeted income statement. Round your answers to the nearest dollar. Italian Exports, Inc.Budgeted Income StatementFor the Month Ending Mar. 31, 2020 $Sales Cost of Goods Sold $Beginning Inventory Purchases $Cost of Goods Available for Sale Ending Inventory $Cost of Goods Sold Gross Profit Operating Expenses $Administrative Salaries Marketing Expenses Sales Commissions Rent Expense Depreciation Expense Utilities Total…
Rotorua Products sells agricultural products in the burgeoning Asian 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: Cash Accounts receivable, net Inventory Total current assets Current liabilities Year 11 Year 2 Year 3 Year 4 Year 5 $4,545,400 $4,737,850 $ 5,126,380 $5,421,900 $5,776,190 Year 1 $ 88,854 418,283 800,380 $ 1,307,517 $ 313,578 Required: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. Note: Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3). % % % % % % Year 2 $ 88,845 $ 77,057 435,833 587,279 $ 90,380 417,076 876,061 $1,383,517 $ 1,350,248 $ 1,466,414 $1,552,502 $ 346,822 $ 336,685 $ 335,107 $ 390,612 825,570 882,078 % % % % % % Year 3 % % % % Year 4 % % $ 80,928 569,984…
Domestic
None
Starbucks Corporation reported the following geographical segment revenues for a recent and a prior fiscal year: Recent Year Prior Year (in millions, rounded) (in millions, rounded) Americas $13,293 $11,980 EMEA* 1,217 1,295 China/Asia Pacific 2,396 1,130 Channel Development** 1,731 1,546 Other 526 497 $19,163 $16448 Total *Europe, Middle East, and Africa **Sells packaged coffee and teas globally a. Prepare a horizontal analysis of the segment data using the prior year as the base year. Round whole percents to one decimal place. b. Prepare a vertical analysis of the segment data. Round whole percents to one decimal place. c. What conclusions can be drawn from your analyses?
Payton Company has the following segment revenues for the two most recent years. Segment United States Canada Other countries Total revenues Prepare a horizontal analysis of the segment data. Calculate the percentage to four decimal places, then round your answer to one decimal place. For amount or percentage decreases, enter a minus sign. Segment United States Canada Other countries Current Year (in millions) Prior Year (in millions) $835 $635 328 348 214 163 $1,377 $1,146 Total revenues Payton Company Horizontal Analysis Current Year Prior Year Amount Increase Percent Increase (in millions) (in millions) (Decrease) $835 $635 $ 328 348 214 163 $1,377 $1,146 (Decrease) %
Saved He Chevalier Company has identified five industry segments: plastics, metals, lumber, paper, and finance. t appropriately consolidated each of these segments in producing its annual financial statements. Information describing each segment (in thousands) follows: Accounts Sales to outside parties Intersegment sales Interest income from outside parties Interest income from intersegment loans Operating expenses Interest expense Tangible assets Intangible assets Intersegment loans (debt) Plastics $ 6,625 Metals $ 2,334 Lumber $ 701 Paper $ 412 Finance 146 169 134 146 $ 0 0 0 32 19 0 40 0 0 0 0 197 4,174 74 1,742 1,046 644 29 29 64 30 100 1,467 85 0 3,176 504 751 169 399 0 0 61 0 0 0 702 Chevalier does not allocate its $1,480,000 in common expenses to the various segments. Required: a1. Perform revenue test procedure to determine Chevalier's reportable operating segments. a2. Perform profit or loss test procedure to determine Chevalier's reportable operating segments. a3. Perform…

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS