Exercise 13-7 Trend Percentages [LO13-1] market. The company\'s current assets,

Question

Exercise 13-7 Trend Percentages [LO13-1] market. The company's current assets, current liabilities, and sales have been reported as follows over the last five years (Year 5 is the most recent year) Year 2 ear 3 $4,697,190 $4,861,190 $5,081,230 $5,505,480 $5,762,430 ar Sales 89,356 107,337 103,060 88,437 $ 80,553 416,932 428,737 439,478 498,025 565,142 809,738 881,750 817,526 899,462 911,334 Cash Inventory Total current assets $1,316,026 $1,417,824 $1,360,064 $1,485,924 $1,557,029 Current liabilities 305,856 330,399 326,638 330,271 $ 392,428 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 Sales 1000 % 103.5 % 108.21% 117.2% 122.71% 88,437.0 498.025.0 89,356.0 416,932.0 809,736.0 1,316,024.0 305,856.0 107,337.0 428,737.0 881,750.0 1,417,824.0 330,399.0 1,036,060.0 439,478.0 80,553.0 911,334.0 tory 1,557,029.0 326,638.0 330,271.0 Current liabilities

Explanation / Answer

ROTORUA PRODUCTS LTD. Years Year 1 Year 2 Year 3 Year 4 Year 5 Sales 4697190 4861190 5081230 5505480 5762430 Cash 89356 107337 103060 88437 80553 Accounts Receivable net 416932 428737 439478 498025 565142 Inventory 809738 881750 817526 899462 911334 Total Current Assets 1316026 1417824 1360064 1485924 1557029 Current Liabilities 305856 330399 326638 330271 392428 Working Trend Percentage while taking Year 1 as base year Years Year 1 Year 2 Year 3 Year 4 Year 5 Sales (4697190/4697190)*100 (4861190/4697190)*100 (5081230/4697190)*100 (5505480/4697190)*100 (5762430/4697190)*100 Cash (89356/89356)*100 (107337/89356)*100 (103060/89356)*100 (88437/89356)*100 (80553/89356)*100 Accounts Receivable net (416932/416932)*100 (428737/416932)*100 (439478/416932)*100 (498025/416932)*100 (565142/416932)*100 Inventory (809738/809738)*100 (881750/809738)*100 (817526/809738)*100 (899462/809738)*100 (911334/809738)*100 Total Current Assets (1316026/1316026)*100 (1417824/1316026)*100 (1360064/1316026)*100 (1485924/1316026)*100 (1557029/1316026)*100 Current Liabilities (305856/305856)*100 (330399/305856)*100 (326638/305856)*100 (330271/305856)*100 (392428/305856)*100 Trend Percentage while taking Year 1 as base year Years Year 1 Year 2 Year 3 Year 4 Year 5 Sales 100% 103.5% 108.2% 117.2% 122.7% Cash 100% 120.1% 115.3% 99.0% 90.1% Accounts Receivable net 100% 102.8% 105.4% 119.4% 135.5% Inventory 100% 108.9% 101.0% 111.1% 112.5% Total Current Assets 100% 107.7% 103.3% 112.9% 118.3% Current Liabilities 100% 108.0% 106.8% 108.0% 128.3%

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.