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: Inventory Sales Cash Accounts receivable, net Total current assets Current liabilities Required: Year 1 $ 4,632,170 $83,577 410,196 800,639 $ 1,294,412 $319,168 Year 2 $ 4,904,210 $105,356 434,842 Year 3 $ 5,109,320 $100,330 $74,200 442,419 829,717 $1,372,466 $333,203 $1,413,678 $344,753 Year 4 $5,551,450 $77,625 410,938 rea $5, $ 883 657 $1,460,220 $329,697 $ 1. $ 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 (ie., 0.1234 should be entered as 12.3).) Cument asso Year 1 1000% Year 2 Year 3 Year 4 Year S 105.9% DELL 24 4 09 # $ % 2 3 5 w E R T Y U FIO B O ' A S D F G H J K L z x C v B N 300 2-in-1 All P12 insert P ? CASPM 100/20 Delete Backspace + Poup Alt Ctri M -Home PgDn Ente % 5 ast five years (Year 5 is the most recent year) are as follows: Year 1 $ 4,632,170 $ 83,577 410,196 Year 2 $ 4,904,210 $ 105,356 434,042 800,639 874,280 $ 1,294,412 $ 1,413,678 $ 319,168 $ 344,753 Year 3 $ 5,109,320 $ 100,330 442,419 829,717 $ 1,372,466 $333,203 Year 4 $ 5,551,490 $ 77,625 498,938 883,657 $ 1,460,220 $ 329,697 Year 5 $ 5,773,850 $ 65,023 574,912 911,996 $ 1,551,931 $ 395,531 trend percentages. Use Year 1 as the base year. (Round your percentage answers as 12.3).) Year 2 Year 3 Year 4 Year 5 105.9 % % % % Prev 1 of 6 Next > OL DELL F6 F7 FB F9 F10 F11 F12 PrtScr 9 T T 66 Y 27 & U * 00 8 9 O { P Inventory Total current assets Current liabilities Required: 880,639 $ 1,294,412 $319,168 874,288 $1,413,678 $344,753 829,717 $ 1,372,466 $333,203 Check my work 883,657 $1,460,220 $329,697 $ 1, 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 (ie., 0.1234 should be entered as 12.3).) Year 1 Year 2 Year 3 Year 4 Year 5 Sales Current a 1000% 105.9% Cash 100.0% 1251% % % Accounts receivable net 100.0% 105.8% % 1% Inventory 100.0% 109.21% % Total current assets 1000% 10921% Current abilities 100.0% 100.0 Prex 16 Next > DELL Fe 3 $ 4 % 5 w E R T Y 7 3 986 5:40PM 7/20/2022 FU F11 PLZ Sisart Deiste B > O Backspace - P [ 1 S D F G H J K L x C V B N M Alt V. A. Alt Ctri E ? . -Home + Pylip PgDn