help needed asap
Mona Month-end Report At the end of July, Bindi Tjandamurra requires a month-end report on the economic status of the business. Your report to Ms Tjandamurra should be a 350-500-word memo. You should report should analyse (include the relevant ratios) and comment on the following aspects of the financials. [1] Profitability [2] Solvency 31 Jul 2021 Assets 587,805 587,805 Bank Cash at bank Total Bank Current Assets ARC - Accounts Recevable Control Interest Receivable Inventory Office Supplies Prepaid advertising Prepaid Insurance Prepaid Rent Term deposit account no.1 Total Current Assets Fixed Assets Accumulated Depreciation: Cash Registers Accumulated Depreciation: Delivery Bicycles Accumulated Depreciation: Store Fixtures Cash Registers Delivery Bicycles Store Fixtures Total Fixed Assets 32.826 165 366,610 15,230 30,000 11,800 15,000 100,000 571,631 (4.882) (1.002) (12,575) 45,000 35, 381 215,000 276,922 1.436,358 Total Assets Liabilities Current Liabilities APC Accounts Payable Control Electricity Payable GST Interest Payable Rounding Wages and Salaries Payable Water Payable Total Current Liabilities Non-Current Liabilities Loan - Interest Only No. 01 Total Non-Current Liabilities 22,762 4,370 24.904 1,145 (39) 6,600 1.175 60,917 275,000 275,000 335,917 Total Liabilities Net Assets 1.100,441 Equity Balance Sheet Current Year Earnings Retained Earnings Share Capital Total Equity 31 Jul 2021 135,505 554,936 410,000 1,100,441 2002 344,741.35 (206, BSN 134,37329 05,341.25) 77 445.00 2.3.75 Operating Activities Receipts from customers Payments to suppliers and employees Cash receipts from other operating activities Net Cash Flows from Operating Activities Investing Activities Payment for property, plant and equipment Other cash items from investing activities Net Cash Flows from Investing Activities Financing Activities Other cash items from financing activities Met Cash Flows from Financing Activities Net Cash Flows Cash and Cash Equivalents Cash and cash equivalents at beginning of period Net change in cash for period Cash and cash equivalenta at end of period 250,25146 250,251.45 426,894.50 160,310.00 26.894.50 587,80050 Oct-21 Sep-21 Aug-21 Jul-21 YTD Income Interest Income Sales Sales Returns and Allowances Total Income 165 291403 (545) 286,122 216,122 165 291 403 (5.45) 786,122 Gross Profit 226,122 Less Operating Expenses Advertising Expense Bank Fees Depreciation Expense Electricity Expense Insurance Expense Interest Expense Office Supplies Expense Purchase Returns and Allowances Purchases Rent Expense Wages and Salaries Expense Water Expense Total Operating Expenses Net Profit 15,000 25 3,209 4370 2,950 1.145 20,185 (6,377) 7.910 15.000 86,025 1,175 150,617 15,000 25 3,209 4370 2,950 1,145 20,185 (6,3771 7910 15,000 86,025 1.175 150,617 135, SOS 135,505 Reference Description Balance in Xero Amount 587 804,50 Payment: Crop Del Monte Wages 917 920 Date 31 Jul 2021 Plus Outstanding Payments 26 Jul 2021 30 jul 2021 Total Outstanding Payments Less Outstanding Receipts 30 Jul 2021 Total Outstanding Receipts 31 Jul 2021 1,082.62 26,000.00 27,082.62 Cash Sales 56,069.20 56,069.20 558,817.92 Statement Balance Date Source Amount Balance 1 jul 2021 1 Jul 2021 2 Jul 2021 4 jul 2021 4 Jul 2021 Imported Imported Imported Imported 160.910.00 (34,500,00) 126,410.00 (3,500,00) 122,910.00 275,000,00 397,910.00 18,425.00 416,335.00 4 jul 2021 5 Jul 2021 Imported Imported (38,919.38) 377,415.62 6,050.00 383,465.62 Yes 5 Jul 2021 6 jul 2021 6 Jul 2021 Imported Imported Imported (18,716.00) 364,749.62 (6,888.37) 357,861.25 32.806.88 390,668.13 9 Jul 2021 10 jul 2021 Imported Imported (1,107 22) 389,560.91 14,220.00 403,780.91 11 Jul 2021 Description Date Imported Reference Reconciled Into Xero Opening Balance 3 Oct 2021 909 Yes 3 Oct 2021 910 Yes 3 Oct 2021 Loan Yes Freewheelin 3 Oct 2021 Deposit - Yes Coffee Freewheelin Coffee 3 Oct 2021 911 Yes Fremantle 3 Oct 2021 Deposit - Yes Coffee Fremantle Coffee 3 Oct 2021 912 3 Oct 2021 913 Yes 3 Oct 2021 Deposit - Cash Yes Sales 3 Oct 2021 914 Yes Fremantle 3 Oct 2021 Deposit - Yes Coffee Fremantle Coffee 3 Oct 2021 Deposit - Cash Yes Sales 3 Oct 2021 915 Yes 3 Oct 2021 Deposit - Cash Yes Sales 3 Oct 2021 916 Yes Chillzone 3 Oct 2021 Deposit - Yes Chillzone Oct 2021 Deposit - Sarah's Hot Spot Sarah's Hot Spot 3 Oct 2021 Cheque Yes returned - Sarah's Hot Spot 3 Oct 2021 Deposit - Cash Yes Sales 3 Oct 2021 918 Yes Freewheelin 3 Oct 2021 Deposit Yes Coffee Freewheelin Coffee 3 Oct 2021 919 Yes 3 Oct 2021 Transaction fee Yes Closing Balance Imported 47,106.16 450,887.07 14 Jul 2021 18 Jul 2021 Imported Imported (15,720.00) 435,167.07 61,801.52 496,968.59 20 Jul 2021 21 Jul 2021 Imported Imported (25,515.00) 471,453.59 43,222.63 514,676.22 26 Jul 2021 Yes Imported 1,500.00 516,176.22 26 Jul 2021 Imported 1.500.00) 514.676.22 26 Jul 2021 Imported 70,566.38 585,242.60 29 Jul 2021 30 Jul 2021 Imported Imported (17,234.92) 568,00768 18,745.24 586.752.92 30 Jul 2021 31 Jul 2021 Imported Imported (27,910,00) 558,642.92 (25.00) 558.817.92 558,817.92
