tell the financial position of the company using the balance sheet and p & l
Written Report - Financial performance factors (3 marks) Your report explains the financial results and performance of your company in September 2020. You are required to provide two discussion factors to analyse the financial performance of the company. These can be items taken from either balance sheet or profit and loss that you feel had an impact on the financial performance of the company. You are required to calculate ratios to support your discussion of each factor you have chosen to highlight. I Your report explains how the company managed its inventories during September by providing an appropriate inventory report from Xero. You are required to indicate how many units of inventory is purchased and sold from each type of bicycles during September. How many units of inventories remain on hand from each type of bicycles at month-end, etc? Your report explains how the company managed its Accounts Receivables and Payables during September by providing appropriate reports from Xero. Ashman Aujla, 20285418 As at 30 September 2020 30 Sep 2020 31 Aug 2020 Assets Current Assets 608 - Prepaid fire insurance 609 - Cash at bank 610 - Accounts Receivable 615 - Delivery van 618 - Prepaid society insurance 630 - Inventory Total Current Assets 30,000 3,258,412 250,890 80,000 6,933 256,561 3,882,797 30,000 166,483 1,148,178 80,000 1,325,800 2,750,461 (16,800) (16,800) (4.800) Fixed Assets 616. Accumulated depreciation 617. Less Accumulated depreciation on welding machinery 708 - Store building 714 - Less accumulated depreciation delivery van 720 - Digicom - Computer Total Fixed Assets 700,000 700,000 (14,400) 909 664.909 683,200 Non-current Assets 619. Prepaid supplies 621 - Welding machine equipment 625. Prepaid subscription Total Non-current Assets Total Assets 139 93,500 42,500 136,139 4,683,845 3,433,661 Liabilities Current Liabilities 800 - Accounts Payable 810. Northern Bank 820 - GST Total Current Liabilities 705,120 561,612 104,000 17,965 683,578 (197,743) 507,377 Non-Current Llabilities 802 - Loan payable 803 - Allowance for doubtfuldebts 805 - Unearned delivery revenue 806 - Less allowance for doubtfuldebts 815 - Service revenue Total Non-Current Liabilities Total Liabilities 117,605 104,380 49,600 117,605 104,380 67,600 (87.812) 147,732 349,505 1,031,082 271,585 778,961 Net Assets Equity 950 - Capital 3.650,762 2,654,700 1,497,040 1,497,040 Balance Sheet Alman Aujla 20285416 5 October 2020 Page 1 of 2 Current Year Earnings Total Equity 30 Sep 2020 2,153,723 3,650,762 31 Aug 2020 1,157,660 2,654,700 Profit and Loss Ashman Aujla, 20285418 For the month ended 30 September 2020 SEP 2020 AUG 2010 Trading Income Interest Income Sales Service revenue received in advance Total Trading Income 115.07 2,476,536.39 (96,463.83) 2,380,187.63 1,043,798.20 1,043,798.20 Cost of Sales Cost of Goods Sold Total Cost of Sales 1,192,440.31 1,192,440.31 Gross Profit 1,187,747.32 1,043,798.20 I (125,000.00 6,000.00 Operating Expenses Accumulated depreciation on store building Advertising Apache petrol Bank Fees Depreciation Fire Insurance expense Freight & Courier Insurance expense Interest Expense Online Advertisement Provision for warranty Salaries expense Society insurance Supply expense telecommunication expense Warehouse rent expense Warranty claims Total Operating Expenses (30,000.00 6,030.55 480.00 3.30 49,200.00 13,300.00 230.00 6.151.51 1,430.00 1,326.00 123.826.82 25,000.00 3,466.66 1,110.00 680.00 2,200.00 3,850.00 191,684.84 1,568.06 (52.189.921 50,000.00 1,360.00 4,400.00 (113,861.86) Net Profit 996,042.48 1,157,660.06 Written Report - Financial performance factors (3 marks) Your report explains the financial results and performance of your company in September 2020. You are required to provide two discussion factors to analyse the financial performance of the company. These can be items taken from either balance sheet or profit and loss that you feel had an impact on the financial performance of the company. You are required to calculate ratios to support your discussion of each factor you have chosen to highlight. I Your report explains how the company managed its inventories during September by providing an appropriate inventory report from Xero. You are required to indicate how many units of inventory is purchased and sold from each type of bicycles during September. How many units of inventories remain on hand from each type of bicycles at month-end, etc? Your report explains how the company managed its Accounts Receivables and Payables during September by providing appropriate reports from Xero. Ashman Aujla, 20285418 As at 30 September 2020 30 Sep 2020 31 Aug 2020 Assets Current Assets 608 - Prepaid fire insurance 609 - Cash at bank 610 - Accounts Receivable 615 - Delivery van 618 - Prepaid society insurance 630 - Inventory Total Current Assets 30,000 3,258,412 250,890 80,000 6,933 256,561 3,882,797 30,000 166,483 1,148,178 80,000 1,325,800 2,750,461 (16,800) (16,800) (4.800) Fixed Assets 616. Accumulated depreciation 617. Less Accumulated depreciation on welding machinery 708 - Store building 714 - Less accumulated depreciation delivery van 720 - Digicom - Computer Total Fixed Assets 700,000 700,000 (14,400) 909 664.909 683,200 Non-current Assets 619. Prepaid supplies 621 - Welding machine equipment 625. Prepaid subscription Total Non-current Assets Total Assets 139 93,500 42,500 136,139 4,683,845 3,433,661 Liabilities Current Liabilities 800 - Accounts Payable 810. Northern Bank 820 - GST Total Current Liabilities 705,120 561,612 104,000 17,965 683,578 (197,743) 507,377 Non-Current Llabilities 802 - Loan payable 803 - Allowance for doubtfuldebts 805 - Unearned delivery revenue 806 - Less allowance for doubtfuldebts 815 - Service revenue Total Non-Current Liabilities Total Liabilities 117,605 104,380 49,600 117,605 104,380 67,600 (87.812) 147,732 349,505 1,031,082 271,585 778,961 Net Assets Equity 950 - Capital 3.650,762 2,654,700 1,497,040 1,497,040 Balance Sheet Alman Aujla 20285416 5 October 2020 Page 1 of 2 Current Year Earnings Total Equity 30 Sep 2020 2,153,723 3,650,762 31 Aug 2020 1,157,660 2,654,700 Profit and Loss Ashman Aujla, 20285418 For the month ended 30 September 2020 SEP 2020 AUG 2010 Trading Income Interest Income Sales Service revenue received in advance Total Trading Income 115.07 2,476,536.39 (96,463.83) 2,380,187.63 1,043,798.20 1,043,798.20 Cost of Sales Cost of Goods Sold Total Cost of Sales 1,192,440.31 1,192,440.31 Gross Profit 1,187,747.32 1,043,798.20 I (125,000.00 6,000.00 Operating Expenses Accumulated depreciation on store building Advertising Apache petrol Bank Fees Depreciation Fire Insurance expense Freight & Courier Insurance expense Interest Expense Online Advertisement Provision for warranty Salaries expense Society insurance Supply expense telecommunication expense Warehouse rent expense Warranty claims Total Operating Expenses (30,000.00 6,030.55 480.00 3.30 49,200.00 13,300.00 230.00 6.151.51 1,430.00 1,326.00 123.826.82 25,000.00 3,466.66 1,110.00 680.00 2,200.00 3,850.00 191,684.84 1,568.06 (52.189.921 50,000.00 1,360.00 4,400.00 (113,861.86) Net Profit 996,042.48 1,157,660.06