FY 2019 Balances The balances of relevant accounts at the end of FY 2019 are as follows: Account Type Value Borrowings Liability 110960 Cash and cash equivalents Asset 63126 Contributed equity Equity 18537 Current tax payable Liability 4125 Inventories Asset 34138 Investments Asset 112564 Other current assets Asset 2369 Other current liabilities Liability 3146 Property, plant and equipment (Net) Asset 74562 Retained earnings Equity 184669 Trade payables Liability 17331 Trade receivables Asset 51909 The opening balance of other current assets is comprised entirely of prepaid insurance. The opening balance of other current liabilities is comprised entirely of wages payable. FY 2020 Transaction data A summary of the transactions entered into by the company in FY 2020 are as follows: 1 2 3 4 5 6 7 8 Transaction Platinum Pty Ltd has paid all of its company income tax owing from the previous period. In addition, the company incurs a further $33717 in corporate income tax that it will pay next year. During the year, Platinum Ply Lid purchased an additional $24000 of computer equipment. Half the amount was paid in cash, with the remaining hall on credit. The accountant determines that the credit amount should be allocated to other current liabilities. During the year, the accountants at Platinurn Ply Lid determine that depreciation should be recorded at $7456. They estimate that 10% of the depreciation is related to selling activities, with the remaining related to administration During the year, Platinum Pty Ltd also purchased $47000 of inventory in cash from its suppliers of higher value add material. During the year, Platinum Ply Lid purchased $47000 of inventory from its suppliers of raw materials. The inventory was purchased on credit. During the year Platinum Pty Ltd receives a rental payment of $72243. During the year Platinum Pty Ltd issues 33000 shares to a new investors. These shares are issued at an average price of $2 per share. By the end of the year, Platinum Pty Ltd pays off $19003 of debts owing to its trade creditors. By the end of the year, Platinurn Pty Ltd uses up the remainder of its previous insurance contract that was prepaid in the previous year. Halfway into the year, the company signs a new contract for the next twelve months of 9 1 2 FY 2020 Transaction data A summary of the transactions entered into by the company in FY 2020 are as follows: Transaction Platinum Ply Ltd has paid all of its company income tax owing from the previous period. In addition, the company incurs a further $33717 in corporate income tax that it will pay next year. During the year, Platinum Pty Ltd purchased an additional $24000 of computer equipment. Half the amount was paid in cash, with the remaining half on credit. The accountant determines that the credit amount should be allocated to other current liabilities. administration. 3 During the year, the accountants at Platinum Pty Ltd determine that depreciation should be recorded at $7456. They estimate that 10% of the depreciation is related to selling activities, with the remaining related During the year, Platinum Ply Lid also purchased $47000 of inventory in cash from its suppliers of higher value add material. 5 During the year, Platinum Pty Ltd purchased $47000 of inventory from its suppliers of raw materials. The inventory was purchased on credit. 8 During the year Platinum Ply Ltd receives a rental payment of $72243. 7 During the year Platinum Pty Ltd issues 33000 shares to a new investors. These shares are issued at an average price of $2 per share. 8 By the end of the year, Platinurn Ply Ltd pays off $19003 of debts owing to its trade creditors. By the end of the year, Platinum Pty Ltd uses up the remainder of its previous insurance contract that was prepaid in the previous year. Halfway into the year, the company signs a new contract for the next twelve months of insurance, paying. $19200 upfront. 10 During the year Platinum Pty Ltd makes $53000 in sales on credit terms of 30 days. These sales were carried in inventory at a value of $10600. 11 During the year, Platinum Pty Ltd incurred $15438 of wages costs. The company has paid this amount in full by the end of the year. In addition, the company also paid all wages owing from previous years. 12 During the year Platinum Pty Ltd makes a sale of S67000. Of this amount, 40% was paid in cash with the remainder on credit terms of 60 days. The inventory for this sale was carried at a value of $13400. 13 At the start of the year, Platinum Pty Ltd extended its lease on its premises for 12 months. Each month of rent costs $500 and the company pays its rent on a monthly basis by direct debit to its bank account During the year, Platinum Pty Ltd repays $22172 of its bank debt. The remaining borrowings are to be repaid over the following ten years. On the borrowings of Platinum Pty Ltd, during the year the bank charged Platinum Pty Ltd 14 S7760 in interest. This amount was directly charged to the bank account of the company. 15 At the end of the year, Platinum Ply Ltd declares and pays a $17287 dividend to ils shareholders. 16 By the end of the year, Platinum Pty Ltd collects from its debtors a total of $46787. 9 Borrowings are to be repaid equally over the relevant term. Further notes: The Excel sheet for submission is designed to work through in a linear fashion. Accordingly, you should begin with the first sheet Introduction. You should then progress to the second sheet TA, which contains the transaction analysis. After in in . Il other areas of the spreadsheels are to remain unaltered. Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments A Wran Text 3 V Pasto 1 Insert % Delce Format V Merge & Centre Conditional Format Cell Formatting Table Styles Sort Filter Find Select Analyse Data P8 4 x fx B C 4 E F G M N D R S 1 2 H 1 K L [Name of Entity! Transaction Analysis Worksheet For the year ended 30 June 2020 Liabilities Current tax Investments Trade payables payable Borrowings Cash & cash equivalents Trade receivables Assets Other current Property, plant Inventories ASSATS and equipment Other current liabilities Contributed Equity Equity Retained earnings Expenses Revenue Dividends & Opening balances 9 10 Transactions 11 1 12 2 13 3 14 4 15 5 16 6 17 7 7 18 19 9. 20 10 21 11 22 12 23 13 14 25 15 26 16 Closing retained earnings 28 Closing balances 29 30 31 33 34 35 36 Introduction ATA PL POS TSUM + TO 101% 27 g W *** X Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments A A Wran Text S LE Pastc 1 Uw Insert Merge & Centre Delete Format Conditional Format Cell Formatting as Table Styles Sort Filter Find & Select Analyse Dala D19 A E F H 1 L M N R s T T B C [Name of Entity] Statement of Profit & Loss For the year ending 30 June, 2020 2 3 4 $ 7 Sales revenue 8 Cast of sales 9 Gross profit 10 11 Other revenue 12 13 Selling expenses 14 Administrative experses 15 Finance expenses 16 17 Profit before tax 18 Income tax experse 19 Profit after tax 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Introduction ATA PL APOS TSUM + 27 O w X Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments A A Wran Text 2Y 4 Pasic LG 3 B ar Av Insert I U Delete Merge & Centre $ % Conditional Format Cell Formatting as Table Styles Format Sort Filter Find & Select Analyse Data D36 7 2 c D E F H 1 L M N P. R S 1 1 3 4 As at 30 June, 2020 $ 6 Current assets 7 Cash and cash equivalents 8 Trade receivables 9 Inventories 10 Other current assets 11 Total current assets 12 13 Non-current assets 14 Property, plant and equipment (Net) 15 Investments 16 Total non-current assets 17 18 Tatal assets 19 20 Current liabilities 21 Trade payables 22 Current tax payable 23 Borrowings 24 Other current liabilities 25 Total current liabilities 27 Non-current liabilities 28 Borrowires 29 Tatal non-current liabilities 30 31 Total Liabilities 32 33 Net assets 34 35 Equity 36 Contributed equity 37 Retained earrines 38 Tatal Equity Introduction ATA APL POS ATSUM + 27 o w FY 2019 Balances The balances of relevant accounts at the end of FY 2019 are as follows: Account Type Value Borrowings Liability 110960 Cash and cash equivalents Asset 63126 Contributed equity Equity 18537 Current tax payable Liability 4125 Inventories Asset 34138 Investments Asset 112564 Other current assets Asset 2369 Other current liabilities Liability 3146 Property, plant and equipment (Net) Asset 74562 Retained earnings Equity 184669 Trade payables Liability 17331 Trade receivables Asset 51909 The opening balance of other current assets is comprised entirely of prepaid insurance. The opening balance of other current liabilities is comprised entirely of wages payable. FY 2020 Transaction data A summary of the transactions entered into by the company in FY 2020 are as follows: 1 2 3 4 5 6 7 8 Transaction Platinum Pty Ltd has paid all of its company income tax owing from the previous period. In addition, the company incurs a further $33717 in corporate income tax that it will pay next year. During the year, Platinum Ply Lid purchased an additional $24000 of computer equipment. Half the amount was paid in cash, with the remaining hall on credit. The accountant determines that the credit amount should be allocated to other current liabilities. During the year, the accountants at Platinurn Ply Lid determine that depreciation should be recorded at $7456. They estimate that 10% of the depreciation is related to selling activities, with the remaining related to administration During the year, Platinum Pty Ltd also purchased $47000 of inventory in cash from its suppliers of higher value add material. During the year, Platinum Ply Lid purchased $47000 of inventory from its suppliers of raw materials. The inventory was purchased on credit. During the year Platinum Pty Ltd receives a rental payment of $72243. During the year Platinum Pty Ltd issues 33000 shares to a new investors. These shares are issued at an average price of $2 per share. By the end of the year, Platinum Pty Ltd pays off $19003 of debts owing to its trade creditors. By the end of the year, Platinurn Pty Ltd uses up the remainder of its previous insurance contract that was prepaid in the previous year. Halfway into the year, the company signs a new contract for the next twelve months of 9 1 2 FY 2020 Transaction data A summary of the transactions entered into by the company in FY 2020 are as follows: Transaction Platinum Ply Ltd has paid all of its company income tax owing from the previous period. In addition, the company incurs a further $33717 in corporate income tax that it will pay next year. During the year, Platinum Pty Ltd purchased an additional $24000 of computer equipment. Half the amount was paid in cash, with the remaining half on credit. The accountant determines that the credit amount should be allocated to other current liabilities. administration. 3 During the year, the accountants at Platinum Pty Ltd determine that depreciation should be recorded at $7456. They estimate that 10% of the depreciation is related to selling activities, with the remaining related During the year, Platinum Ply Lid also purchased $47000 of inventory in cash from its suppliers of higher value add material. 5 During the year, Platinum Pty Ltd purchased $47000 of inventory from its suppliers of raw materials. The inventory was purchased on credit. 8 During the year Platinum Ply Ltd receives a rental payment of $72243. 7 During the year Platinum Pty Ltd issues 33000 shares to a new investors. These shares are issued at an average price of $2 per share. 8 By the end of the year, Platinurn Ply Ltd pays off $19003 of debts owing to its trade creditors. By the end of the year, Platinum Pty Ltd uses up the remainder of its previous insurance contract that was prepaid in the previous year. Halfway into the year, the company signs a new contract for the next twelve months of insurance, paying. $19200 upfront. 10 During the year Platinum Pty Ltd makes $53000 in sales on credit terms of 30 days. These sales were carried in inventory at a value of $10600. 11 During the year, Platinum Pty Ltd incurred $15438 of wages costs. The company has paid this amount in full by the end of the year. In addition, the company also paid all wages owing from previous years. 12 During the year Platinum Pty Ltd makes a sale of S67000. Of this amount, 40% was paid in cash with the remainder on credit terms of 60 days. The inventory for this sale was carried at a value of $13400. 13 At the start of the year, Platinum Pty Ltd extended its lease on its premises for 12 months. Each month of rent costs $500 and the company pays its rent on a monthly basis by direct debit to its bank account During the year, Platinum Pty Ltd repays $22172 of its bank debt. The remaining borrowings are to be repaid over the following ten years. On the borrowings of Platinum Pty Ltd, during the year the bank charged Platinum Pty Ltd 14 S7760 in interest. This amount was directly charged to the bank account of the company. 15 At the end of the year, Platinum Ply Ltd declares and pays a $17287 dividend to ils shareholders. 16 By the end of the year, Platinum Pty Ltd collects from its debtors a total of $46787. 9 Borrowings are to be repaid equally over the relevant term. Further notes: The Excel sheet for submission is designed to work through in a linear fashion. Accordingly, you should begin with the first sheet Introduction. You should then progress to the second sheet TA, which contains the transaction analysis. After in in . Il other areas of the spreadsheels are to remain unaltered. Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments A Wran Text 3 V Pasto 1 Insert % Delce Format V Merge & Centre Conditional Format Cell Formatting Table Styles Sort Filter Find Select Analyse Data P8 4 x fx B C 4 E F G M N D R S 1 2 H 1 K L [Name of Entity! Transaction Analysis Worksheet For the year ended 30 June 2020 Liabilities Current tax Investments Trade payables payable Borrowings Cash & cash equivalents Trade receivables Assets Other current Property, plant Inventories ASSATS and equipment Other current liabilities Contributed Equity Equity Retained earnings Expenses Revenue Dividends & Opening balances 9 10 Transactions 11 1 12 2 13 3 14 4 15 5 16 6 17 7 7 18 19 9. 20 10 21 11 22 12 23 13 14 25 15 26 16 Closing retained earnings 28 Closing balances 29 30 31 33 34 35 36 Introduction ATA PL POS TSUM + TO 101% 27 g W *** X Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments A A Wran Text S LE Pastc 1 Uw Insert Merge & Centre Delete Format Conditional Format Cell Formatting as Table Styles Sort Filter Find & Select Analyse Dala D19 A E F H 1 L M N R s T T B C [Name of Entity] Statement of Profit & Loss For the year ending 30 June, 2020 2 3 4 $ 7 Sales revenue 8 Cast of sales 9 Gross profit 10 11 Other revenue 12 13 Selling expenses 14 Administrative experses 15 Finance expenses 16 17 Profit before tax 18 Income tax experse 19 Profit after tax 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Introduction ATA PL APOS TSUM + 27 O w X Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments A A Wran Text 2Y 4 Pasic LG 3 B ar Av Insert I U Delete Merge & Centre $ % Conditional Format Cell Formatting as Table Styles Format Sort Filter Find & Select Analyse Data D36 7 2 c D E F H 1 L M N P. R S 1 1 3 4 As at 30 June, 2020 $ 6 Current assets 7 Cash and cash equivalents 8 Trade receivables 9 Inventories 10 Other current assets 11 Total current assets 12 13 Non-current assets 14 Property, plant and equipment (Net) 15 Investments 16 Total non-current assets 17 18 Tatal assets 19 20 Current liabilities 21 Trade payables 22 Current tax payable 23 Borrowings 24 Other current liabilities 25 Total current liabilities 27 Non-current liabilities 28 Borrowires 29 Tatal non-current liabilities 30 31 Total Liabilities 32 33 Net assets 34 35 Equity 36 Contributed equity 37 Retained earrines 38 Tatal Equity Introduction ATA APL POS ATSUM + 27 o w