A 9 0 1 2 3 B D E G H K M N Gross Profit $ 51,342 $ 42,770 USE THE TABLE BELOW TO ANSWER iii) Calculate the Account Receivable / Revenue Ratio (Accounts Receivable divided by/Revenue) for 20X4-20X8. Do you see any unusual trends? (Briefly explain) (EX: USE THE TABLE BELOW TO ANSWER 4 3i. Ratio Analysis-DSO Ratio Ratio 20XX (CY) 20XX-1 (PY) Difference Explanation/Analysis 5 6 (EX: $XX) 239.98 #VALUE! 1. EX: The Change is within the threshold of 5%, Average Days Sales Outstanding Ratio (aka DSO 3ii. Ratio Analysis-Gross Profit Ratio Explanation/Analysis EX: The Change is within the threshold of 5%, Explanation/Analysis Ratio 20XX (CY) 20XX-1 (PY) Difference 8 9 Gross profit ratio=Gross profit/Net sales (EX: $XX) 50% #VALUE! 0 1 3iii. Trend Analysis for past 5 years. Differen 20XX-3 (3yrs 20XX-4 (4yrs ce-PY 20XX (CY) 20XX-1 (PY) 20XX-2 (2yrs ago) 2 to CY ago) ago) Device ANSWER: Sale Income (Net of Sales $ 103,175 $ 85,540 $ 65,500 $ 49,500 $ 36,000 Returns and Discoun ts) Account S $ 51,719 $ 40,741 $ 31,000 $ 23,500 $ Receiva 17,000 4 ble