Ratio 20XX (CY) 20XX-1 (PY) Difference Explanation/Analysis Gross profit ratio= Gross profit/Net sales (EX: $XX) 50% #VALUE! a. EX: The Change is within the threshold of 5%, 3iii. Trend Analysis for past 5 years. Differen) ce- PY20XX (CY) 20XX-1 (PY) 20XX-3 (3yrs 20XX-2 (2yrs ago) ago) 20XX-4 (4yrs ago) Explanation/Analysis to CY $ 103,175 $ 85,540 $ 65,500 $ 49,500 $ 36,000 Device Sale ANSWER: Income (Net of Sales Returns and Discoun ts) Account S Receiva ble Acct Recl (EX: CY Revenu minus $ 51,719 $ 40,741 $ 31,000 $ 23,500 $ 17,000 a. We are auditing 20XX(CY) so see if the ratio changed by more than 5% (threshold per above) from 20XX-1(PY). (Answer based on what you 47% calculate in Column H.) Ratio PY) (EX:XX%) (EX: XX%) (EX:XX%) (EX: XX%)