Asst 2 - Case Study Answer for Q1 Provide Financial &Business Information - Excel Annalyn Closter X File Home Insert Draw Page Layout Formulas Data Review View Developer Help Acrobat Tell me what you want to do X Calibri - 11 - A A = al Wrap Text General EX CI _ AutoSum AY O + Fill Paste E = = Merge & Center $~ % " 00 0 Conditional Format as Cell Insert Delete Format Sort & Find & Add-ins Create and Share Formatting Table Styles Clear Filter ~ Select Adobe PDF Clipboard Font Alignment Number Styles Cells Editing Add-ins Adobe Acrobat L22 X Y B C D E F G H K M N O P Q 5 Case Study 2 George Pty Ltd Balance Sheet as at 30" June 2022 George Pty Ltd Profit & Loss Statement as at 30" June 2022 2020 2021 2022 2020 2021 2022 8 Assets A.) Current Ratio 5.7 5.5 5.0 2020 2021 2022 Current Assets 10 B.) Liquid Ratio 0.76 1.77 2.62 Income Bank 2,848 239,871 403,580 C.) Inventory Turn 11 Over Rate 690,768.00 668,438.00 527,988.50 12 Sales 1,365,218 1,529,381 1,331,658 Stock 706,355 630,521 425,456 1.40 1.56 1.95 Divide 365 days Commissions 35,193 38,22 24,895 Debtors 35,852 59,321 65,537 per year/ Inventory 13 turnover 260 234 187 D. Accounts Interest 2,953 3,568 1,129 Prepayments 1,650 1,294 Recievable 14 Collection Period 1,023,913.500 47586.5 62,429.00 15 Total Income 1,403,364 1,571,172 1,357,682 Total Current Assets 816,705 931,007 894,573 13 1,147,035.75 998,743.50 16 15.14 22.82 17 Less Cost Of Sales Non Current Assets E. Gross Profit Ratio 32% 35% 25% Opening Stock 675,181 706,355 630,521 Plant & Equipment 45,893 48,900 51,265 18 F. Net Profit Ratio 1% 5% -2% Plus Purchases 1,000,200 965,201 Less Acc Depreciation 38,953 43,153 G. Debt to Equity 19 823,856 -40,753 Ratio 21% 32% 35% Less Closing Stock 706,355 630,521 425,456 Vehicles 25,00 25,000 53,000 H. Long Term Debt 20 to Assets 11% 11% 21 Total Cost of Sales 969,026 1,041,035 1,028,921 Less Acc Depreciation -20,621 22,621 32,521 1. Total Debt to Total Assets 17% 24% 26% Land @ 53 Hicks Rd 100,000 100,000 22 Sheet1 + Ready Accessibility: Investigate 79% Type here to search w 8:18 PM 1 6 5.C Mostly cloudy 6/15/2024