Please solve all parts to this problem. Show work so I can solve the actual prob
ID: 2453382 • Letter: P
Question
Please solve all parts to this problem. Show work so I can solve the actual problem! Thank you! (All years)
Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer 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 Year 3 ear ear ear Sales $4,591,060 $4,904,750 $5,098,470 $5,506,090 $5,656,890 Cash Accounts receivable, net Inventory $ 93,536 $ 91,733 $ 97,418 $ 85,026 S 67,189 563,788 915,911 413,580 806,686 431,069 876,365 433,016 834,445 496,608 892,023 Total current assets $1,313,802 $1,399,167 $1,364,879 $1,473,657 $1,546,888 Current liabilities $ 304,768 S 342,113 S 330,452 $ 333,839 $ 403,142 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).) ear 1 Year 2 Year 3 ear 4 Year 5 Sales Current assets Cash Accounts receivable Inventory Total current assets Current liabilitiesExplanation / Answer
Year 1 % Year 2 % Year 3 % Year 4 % Year 5 % Sales 4,591,060 100.00% 4,904,750 106.8% 5,098,470 111.1% 5,506,090 119.9% 5,656,890 123.2% Cash 93,536 100.00% 91,733 98.1% 97,418 104.2% 85,026 90.9% 67,189 71.8% Accounts Receivable Net 413,580 100.00% 431,069 104.2% 433,016 104.7% 496,608 120.1% 563,788 136.3% Inventory 806,686 100.00% 876,365 108.6% 834,445 103.4% 892,023 110.6% 915,911 113.5% Total current Assets 1,313,802 100.00% 1,399,167 106.5% 1,364,879 103.9% 1,473,657 112.2% 1,546,888 117.7% Current Liabilities 304,768 100.00% 342,113 112.3% 330,452 108.4% 333,839 109.5% 403,142 132.3%