Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

include the PnL and Balance sheet Comment on the financial performance of Sandy Manufacturing Pty Ltd, did the financial performance improve or deteriorate during the

include the PnL and Balance sheet

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Comment on the financial performance of Sandy Manufacturing Pty Ltd, did the financial performance improve or deteriorate during the past financial year. Use financial ratio analysis (at least 4 ratios) to substantiate your answer and provide a complete interpretation of the financial position of the company. (Note that you will have to rewrite the income statement and the balance sheet to obtain the correct figures for the ratio analysis). INFORMATION: MR SANDY SCOTT AND SANDY MANUFACTURING PTY LTD Background Mr Sandy Scott, a customer of another bank, approached you as a banker at NAB. Mr Sandy claimed that he is not happy with this current bank and wants to move to NAB if you could be able to offer him favourable rates and better facilities. He also gave you permission to obtain all the necessary information that you will require from his auditor and current bank, provided that it is regarded as highly confidential and that you sign a document in this regard with his auditor. You obtained the following information from the auditor: Bank statements for three months - Mr Sandy Audited financial statements for the previous two financial years for the business that Mr Sandy owns 60% shares in. A letter stating Mr Sandy's income is $600 000 per month. A personal balance sheet for Mr Sandy. INFORMATION CONTAINED IN THREE MONTH BANK STATEMENTS FROM THE EXISTING BANK OF MR SANDY Turnover on account for three months: $ 2 100 435 Highest balance: $ 724 756 Lowest balance: $ (165 433) Interest rate on overdraft facility: Supreme client facility rate - at present 7.7% Bank charges: Standard Overdraft excesses: 2 Cheques returned to drawer (Rd's): None Monthly debit order payments: $ 235 268 per month Approved overdraft facility: $150 000 LETTER FROM AUDITOR Muller Khan Chartered Accountant Tel: Fax: (08) 786 7234 (08) 786 7233 Martell Building Perth 23 August 2021 To whom it may concern Based on the information provided to me Mr Sandy Scott earns an amount of $ 600 000 per month as salary and fringe benefits from Sandy Manufacturing Pty Ltd. MULLER KHAN Muller Khan Chartered Accountant Tel: (08) 786 7234 Fax: (08) 786 7233 Martell Building Perth REPORT FROM THE AUDITORS To the shareholders of Sandy Manufacturing Pty Ltd We have examined the financial statements set out on the following pages. In our opinion these financial statements fairly present the financial position of the company at 30 June 2021 and the results of its operations for the year then ended in the manner required by the Corporations Act. MULLER KHAN 23 August 2021 Perth REPORT OF THE DIRECTORS FOR THE YEAR ENDED 30 JUNE 2021 To the shareholders Your directors have pleasure in submitting their report in terms of the Corporations Act. BUSINESS The company operated for the entire financial year manufactures specialised parts for the transport and vehicle industry. SHARE CAPITAL No shares were issued during the year under review. FINANCIAL RESULTS 2021 2020 Net income before taxation 24 300 183 000 Taxation Net income after taxation 24 300 183 000 FIXED ASSETS The company is at present, as part of its ongoing policy of presenting meaningful financial statements, having its fixed assets valued for insurance purposes. The directors' initial investigations and discussions indicate that a minimum realistic value of the plant and equipment having a book value of $ 2 804 700, is $25 000 000. Once the valuation is complete, it is intended to revalue the assets in question in the books of the company. DIVIDENDS No dividend is proposed in respect of the past year. DIRECTORS Sandy Scott Elianna Scott SANDY MANUFACTURING PTY LTD STATEMENT OF FINANCIAL POSTION AT 30 JUNE 2021 Notes 2021 2020 3 1 000 SHAREHOLDER CONTRIBUTION Share capital Shareholders loans Distributable reserve 1 000 10 651 600 3 054 200 13 706 800 5637 400 3 029 900 8 668 300 NON-CURRENT LIABILITIES Long term liability 11 2 961 200 1 550 000 CURRENT LIABILITIES Accounts payable (including current portion of long term liability) Bank overdraft 17 396 000 5772 700 9 927 300 27 323 300 43 991 300 4 465 000 10 237 700 20 456 000 TOTAL NON-CURRENT ASSETS Equipment, fittings and vehicles Trade investment 5 7 093 500 164 300 7 257 800 5 921 600 1 415 400 7337000 CURRENT ASSETS Stock Accounts receivable Cash on hand 7476 900 5 599 700 9 291 100 27 389 200 53 200 36 733 500 43 991 300 42 400 13 119 000 20 456 000 TOTAL Rent SANDY MANUFACUTURING PTY LTD DETAILED STATEMENT OF FINANCIAL PERFORMANCE FOR THE YEAR ENDED 30 JUNE 2021 2021 2020 PRINCIPAL REVENUE 159 697 500 107 043 200 Less: COST OF SALES Opening stock 7 476 900 6 486 900 Purchases 89 881 400 56 820 100 Closing stock 9 291 100 7 476 900 DIRECT OPERATING EXPENSES Repairs and maintenance 1 158 600 21100 Depreciation -tools 100 100 100 000 Depreciation - plant/ equip 2 455 300 1 075 800 3958 100 3 883 100 Wages 28 337 400 22 519 800 Water and electricity 1 602 900 1 178 300 OTHER OPERATING EXPENSES Advertising 531 100 256 000 Accounting fee 407 900 Auditors' remuneration 199 000 190 000 Bank charges 497 800 469 600 Bad debts 247 100 Depreciation - motor vehicle 905 900 750 900 Depreciation - Furn/ fittings 215 600 213 100 Marketing & entertainment 3 341 300 2 669 000 General expenses 576 100 479 200 Insurance 2 446 700 2 302 900 Legal expenses 8 100 129 300 Motor vehicle expenses 3 720 000 2 443 200 Printing and stationery 259 100 210 500 Salaries and contributions 17 992 900 10 456 800 Telephone 970 700 668 400 OTHER INCOME Profit on sale of fixed assets 447 500 Interest received 6 000 304 000 INTEREST PAID 2 127 800 1 317 100 NET INCOME FOR THE YEAR 24 300 183 000 NOTES TO THE FINANCIAL STATEMENTS - 30 JUNE 2021 1. ACCOUNTING POLICIES The financial statements have been prepared on the historical cost basis. The main accounting policies adopted by the company, which are consistent with those of the previous year, are as follows: Depreciation Fixed assets of the company have been depreciated on a straight line basis over the expected useful life of the assets, after taking into account initial allowances on assets used in the process of manufacturing Stock Stock has been valued at the lower of cost or net realisable value on a first-in first-out basis. The cost of finished goods and work in progress includes material and direct labour costs only. 2. PRINCIPAL REVENUE Principal revenue represents the invoiced value of goods supplied to customers, net of returns and discounts allowed. b. 2021 2020 3. SHARE CAPITAL Authorised: 400 000 shares of $ 1 each Issued: 1 000 shares of $ 1 each $ 400 000 $ 400 000 $ 1 000 $ 1 000 4. SHAREHOLDERS' LOANS $ 4 500 000 $ 4 500 000 Fixed unsecured loans, bearing interest at the rate of 10% (previous year - 9.5%) per annum. No fixed terms of repayment have been set. Floating loan accounts, having no fixed term of repayment other than by mutual shareholders' consent. $ 6 151 600 $ 1 137 400 5. NON-CURRENT ASSETS Net book value Net book value 2021 2020 2 804 700 2479 400 Cost Accumulated depreciation Plant and 17 058 800 14 254 100 equipment Tools 5 523 300 5281 500 Office equipment 589 800 440 600 Factory fittings 559 500 394 900 Motor vehicles 4 979 800 1246 600 28 711 200 21 617 700 (Previous year) (24705500) (18783900) 6. TRADE INVESTMENT 241 800 149 200 164 600 3 733 200 7 093 500 341 900 267 000 262 300 2 571 000 5 921 600 2021 2020 Maple Pty Ltd: Shares at cost Loan TOTAL $ 2 500 $ 161 800 $ 164 300 $ 2 500 $ 1 412 900 $ 1 415 400 The directors are of the opinion that the unlisted investment's value exceeds $ 200 000 $ 1 400 000 7. STOCK Raw materials $ 9 291 100 $ 7 476 900 8. ACCOUNTS RECEIVABLE The accounts receivables have been pledged/ceded to the company's bankers as security for overdraft facilities. 2021 2020 9. $ 1 000 000 $ 10 830 800 $ 4639 700 DIRECTORS' EMOLUMENTS As directors Other All director emoluments were allocated on a 60:40 basis for Sandy Scott and Elianna Scott 10. TAXATION No taxation has been provided for as the company has an estimated loss for tax purposes amounting to $ 90 100 11. LONG TERM LIABILITY $ 5657 500 $ 2 324 900 Outstanding loan on machineryl equipment and vehicles. Current portion of outstanding loan included in accounts payable $ 2696 300 $ 774 900 12. CONTINGENT LIABILITY The company signed a limited guarantee for the overdraft facility of $ 5 000 000 of Maple Pty Limited SANDY SCOTT STATEMENT OF FINANCIAL POSITION AS AT 20 AUGUST 2021 ASSETS $ 15 000 000 $5 160 000 $ 7 500 000 Residential property - Mill Point Rd, South Perth Holiday home - Dunsborough Vineyard farm - Margaret River Investments: SANDY MANUFACTURING Pty Ltd - 60% shareholding SANDY MANUFACTURING Pty Ltd - loan account Fixed deposit Vehicles: 2019 Range Rover 2018 Mercedes 600 SL 2015 Porsche Household goods, Persian carpets and work of art $ 1 527 600 $5325 800 $ 750 000 $ 130 000 $ 190 000 $ 190 000 $ 1 000 000 $36 773 400 LIABILITIES 1* Mortgage on Mill Point Rd, South Perth property 1* Mortgage on Dunsborough property 1 Mortgage on farm Bank loans on vehicles Overdraft $ 11 500 000 $ 2 500 000 $ 4 500 000 $ 400 000 $ 50 000 $ 18 950 000 $ 17 823 400 Net asset value Asset valuations: Peter Bowrie (Property valuer consultant of the bank) valued the properties in the name of Sandy Scott as follows: Residential property - Mill Point Rd, South Perth $ 13 000 000 Holiday home - Dunsborough $ 4 500 000 Vineyard farm - Margaret River $ 6 000 000 TOTAL $23 500 000 You checked Redbook car values (used by dealers in vehicle trading for determining the values of second hand vehicles) and the vehicle values in the balance sheet of Mr Sandy are well aligned with the Redbook car values. The fixed deposit of $750 000 of Mr Sandy has been confirmed with his bank. It is a 12 month fixed deposit that will expire 9 months from now. The bank credit policy contains the following information regarding the assignment of realistic bank collateral values to assets: Type of collateral Value of collateral Investments at this bank 100% of the value of the investment Investments at other financial institutions. 90% of the value of the investment. Listed shares 50% of the market value. Precious coins 60% of the market value. Cession of insurance policies 85% of the surrender value of the policy. Fixed property: residential 80% of value as per bank valuation. Fixed property 70% of value as per bank valuation. commercial/industrial/farms Unlisted shares 0% Motor vehicles 70% of Redbook values or 50% of book values in financial statements of businesses. Machinery and equipment 0% if no used market price valuation was obtained. 40% of used market value provided by experts like accredited auctioneers and used machinery/ equipment industry dealers Household goods including carpets and 0%. Only in exceptional cases will a maximum of paintings 40% of investment painting values be considered. Expert valuation have to be conducted in such cases. Accounts receivable 40% maximum of regular 90 days or less accounts receivable balances. Office equipment/factory fittings 0% Inventory 0% Investments in unlisted companies/loans 0% to companies Comment on the financial performance of Sandy Manufacturing Pty Ltd, did the financial performance improve or deteriorate during the past financial year. Use financial ratio analysis (at least 4 ratios) to substantiate your answer and provide a complete interpretation of the financial position of the company. (Note that you will have to rewrite the income statement and the balance sheet to obtain the correct figures for the ratio analysis). INFORMATION: MR SANDY SCOTT AND SANDY MANUFACTURING PTY LTD Background Mr Sandy Scott, a customer of another bank, approached you as a banker at NAB. Mr Sandy claimed that he is not happy with this current bank and wants to move to NAB if you could be able to offer him favourable rates and better facilities. He also gave you permission to obtain all the necessary information that you will require from his auditor and current bank, provided that it is regarded as highly confidential and that you sign a document in this regard with his auditor. You obtained the following information from the auditor: Bank statements for three months - Mr Sandy Audited financial statements for the previous two financial years for the business that Mr Sandy owns 60% shares in. A letter stating Mr Sandy's income is $600 000 per month. A personal balance sheet for Mr Sandy. INFORMATION CONTAINED IN THREE MONTH BANK STATEMENTS FROM THE EXISTING BANK OF MR SANDY Turnover on account for three months: $ 2 100 435 Highest balance: $ 724 756 Lowest balance: $ (165 433) Interest rate on overdraft facility: Supreme client facility rate - at present 7.7% Bank charges: Standard Overdraft excesses: 2 Cheques returned to drawer (Rd's): None Monthly debit order payments: $ 235 268 per month Approved overdraft facility: $150 000 LETTER FROM AUDITOR Muller Khan Chartered Accountant Tel: Fax: (08) 786 7234 (08) 786 7233 Martell Building Perth 23 August 2021 To whom it may concern Based on the information provided to me Mr Sandy Scott earns an amount of $ 600 000 per month as salary and fringe benefits from Sandy Manufacturing Pty Ltd. MULLER KHAN Muller Khan Chartered Accountant Tel: (08) 786 7234 Fax: (08) 786 7233 Martell Building Perth REPORT FROM THE AUDITORS To the shareholders of Sandy Manufacturing Pty Ltd We have examined the financial statements set out on the following pages. In our opinion these financial statements fairly present the financial position of the company at 30 June 2021 and the results of its operations for the year then ended in the manner required by the Corporations Act. MULLER KHAN 23 August 2021 Perth REPORT OF THE DIRECTORS FOR THE YEAR ENDED 30 JUNE 2021 To the shareholders Your directors have pleasure in submitting their report in terms of the Corporations Act. BUSINESS The company operated for the entire financial year manufactures specialised parts for the transport and vehicle industry. SHARE CAPITAL No shares were issued during the year under review. FINANCIAL RESULTS 2021 2020 Net income before taxation 24 300 183 000 Taxation Net income after taxation 24 300 183 000 FIXED ASSETS The company is at present, as part of its ongoing policy of presenting meaningful financial statements, having its fixed assets valued for insurance purposes. The directors' initial investigations and discussions indicate that a minimum realistic value of the plant and equipment having a book value of $ 2 804 700, is $25 000 000. Once the valuation is complete, it is intended to revalue the assets in question in the books of the company. DIVIDENDS No dividend is proposed in respect of the past year. DIRECTORS Sandy Scott Elianna Scott SANDY MANUFACTURING PTY LTD STATEMENT OF FINANCIAL POSTION AT 30 JUNE 2021 Notes 2021 2020 3 1 000 SHAREHOLDER CONTRIBUTION Share capital Shareholders loans Distributable reserve 1 000 10 651 600 3 054 200 13 706 800 5637 400 3 029 900 8 668 300 NON-CURRENT LIABILITIES Long term liability 11 2 961 200 1 550 000 CURRENT LIABILITIES Accounts payable (including current portion of long term liability) Bank overdraft 17 396 000 5772 700 9 927 300 27 323 300 43 991 300 4 465 000 10 237 700 20 456 000 TOTAL NON-CURRENT ASSETS Equipment, fittings and vehicles Trade investment 5 7 093 500 164 300 7 257 800 5 921 600 1 415 400 7337000 CURRENT ASSETS Stock Accounts receivable Cash on hand 7476 900 5 599 700 9 291 100 27 389 200 53 200 36 733 500 43 991 300 42 400 13 119 000 20 456 000 TOTAL Rent SANDY MANUFACUTURING PTY LTD DETAILED STATEMENT OF FINANCIAL PERFORMANCE FOR THE YEAR ENDED 30 JUNE 2021 2021 2020 PRINCIPAL REVENUE 159 697 500 107 043 200 Less: COST OF SALES Opening stock 7 476 900 6 486 900 Purchases 89 881 400 56 820 100 Closing stock 9 291 100 7 476 900 DIRECT OPERATING EXPENSES Repairs and maintenance 1 158 600 21100 Depreciation -tools 100 100 100 000 Depreciation - plant/ equip 2 455 300 1 075 800 3958 100 3 883 100 Wages 28 337 400 22 519 800 Water and electricity 1 602 900 1 178 300 OTHER OPERATING EXPENSES Advertising 531 100 256 000 Accounting fee 407 900 Auditors' remuneration 199 000 190 000 Bank charges 497 800 469 600 Bad debts 247 100 Depreciation - motor vehicle 905 900 750 900 Depreciation - Furn/ fittings 215 600 213 100 Marketing & entertainment 3 341 300 2 669 000 General expenses 576 100 479 200 Insurance 2 446 700 2 302 900 Legal expenses 8 100 129 300 Motor vehicle expenses 3 720 000 2 443 200 Printing and stationery 259 100 210 500 Salaries and contributions 17 992 900 10 456 800 Telephone 970 700 668 400 OTHER INCOME Profit on sale of fixed assets 447 500 Interest received 6 000 304 000 INTEREST PAID 2 127 800 1 317 100 NET INCOME FOR THE YEAR 24 300 183 000 NOTES TO THE FINANCIAL STATEMENTS - 30 JUNE 2021 1. ACCOUNTING POLICIES The financial statements have been prepared on the historical cost basis. The main accounting policies adopted by the company, which are consistent with those of the previous year, are as follows: Depreciation Fixed assets of the company have been depreciated on a straight line basis over the expected useful life of the assets, after taking into account initial allowances on assets used in the process of manufacturing Stock Stock has been valued at the lower of cost or net realisable value on a first-in first-out basis. The cost of finished goods and work in progress includes material and direct labour costs only. 2. PRINCIPAL REVENUE Principal revenue represents the invoiced value of goods supplied to customers, net of returns and discounts allowed. b. 2021 2020 3. SHARE CAPITAL Authorised: 400 000 shares of $ 1 each Issued: 1 000 shares of $ 1 each $ 400 000 $ 400 000 $ 1 000 $ 1 000 4. SHAREHOLDERS' LOANS $ 4 500 000 $ 4 500 000 Fixed unsecured loans, bearing interest at the rate of 10% (previous year - 9.5%) per annum. No fixed terms of repayment have been set. Floating loan accounts, having no fixed term of repayment other than by mutual shareholders' consent. $ 6 151 600 $ 1 137 400 5. NON-CURRENT ASSETS Net book value Net book value 2021 2020 2 804 700 2479 400 Cost Accumulated depreciation Plant and 17 058 800 14 254 100 equipment Tools 5 523 300 5281 500 Office equipment 589 800 440 600 Factory fittings 559 500 394 900 Motor vehicles 4 979 800 1246 600 28 711 200 21 617 700 (Previous year) (24705500) (18783900) 6. TRADE INVESTMENT 241 800 149 200 164 600 3 733 200 7 093 500 341 900 267 000 262 300 2 571 000 5 921 600 2021 2020 Maple Pty Ltd: Shares at cost Loan TOTAL $ 2 500 $ 161 800 $ 164 300 $ 2 500 $ 1 412 900 $ 1 415 400 The directors are of the opinion that the unlisted investment's value exceeds $ 200 000 $ 1 400 000 7. STOCK Raw materials $ 9 291 100 $ 7 476 900 8. ACCOUNTS RECEIVABLE The accounts receivables have been pledged/ceded to the company's bankers as security for overdraft facilities. 2021 2020 9. $ 1 000 000 $ 10 830 800 $ 4639 700 DIRECTORS' EMOLUMENTS As directors Other All director emoluments were allocated on a 60:40 basis for Sandy Scott and Elianna Scott 10. TAXATION No taxation has been provided for as the company has an estimated loss for tax purposes amounting to $ 90 100 11. LONG TERM LIABILITY $ 5657 500 $ 2 324 900 Outstanding loan on machineryl equipment and vehicles. Current portion of outstanding loan included in accounts payable $ 2696 300 $ 774 900 12. CONTINGENT LIABILITY The company signed a limited guarantee for the overdraft facility of $ 5 000 000 of Maple Pty Limited SANDY SCOTT STATEMENT OF FINANCIAL POSITION AS AT 20 AUGUST 2021 ASSETS $ 15 000 000 $5 160 000 $ 7 500 000 Residential property - Mill Point Rd, South Perth Holiday home - Dunsborough Vineyard farm - Margaret River Investments: SANDY MANUFACTURING Pty Ltd - 60% shareholding SANDY MANUFACTURING Pty Ltd - loan account Fixed deposit Vehicles: 2019 Range Rover 2018 Mercedes 600 SL 2015 Porsche Household goods, Persian carpets and work of art $ 1 527 600 $5325 800 $ 750 000 $ 130 000 $ 190 000 $ 190 000 $ 1 000 000 $36 773 400 LIABILITIES 1* Mortgage on Mill Point Rd, South Perth property 1* Mortgage on Dunsborough property 1 Mortgage on farm Bank loans on vehicles Overdraft $ 11 500 000 $ 2 500 000 $ 4 500 000 $ 400 000 $ 50 000 $ 18 950 000 $ 17 823 400 Net asset value Asset valuations: Peter Bowrie (Property valuer consultant of the bank) valued the properties in the name of Sandy Scott as follows: Residential property - Mill Point Rd, South Perth $ 13 000 000 Holiday home - Dunsborough $ 4 500 000 Vineyard farm - Margaret River $ 6 000 000 TOTAL $23 500 000 You checked Redbook car values (used by dealers in vehicle trading for determining the values of second hand vehicles) and the vehicle values in the balance sheet of Mr Sandy are well aligned with the Redbook car values. The fixed deposit of $750 000 of Mr Sandy has been confirmed with his bank. It is a 12 month fixed deposit that will expire 9 months from now. The bank credit policy contains the following information regarding the assignment of realistic bank collateral values to assets: Type of collateral Value of collateral Investments at this bank 100% of the value of the investment Investments at other financial institutions. 90% of the value of the investment. Listed shares 50% of the market value. Precious coins 60% of the market value. Cession of insurance policies 85% of the surrender value of the policy. Fixed property: residential 80% of value as per bank valuation. Fixed property 70% of value as per bank valuation. commercial/industrial/farms Unlisted shares 0% Motor vehicles 70% of Redbook values or 50% of book values in financial statements of businesses. Machinery and equipment 0% if no used market price valuation was obtained. 40% of used market value provided by experts like accredited auctioneers and used machinery/ equipment industry dealers Household goods including carpets and 0%. Only in exceptional cases will a maximum of paintings 40% of investment painting values be considered. Expert valuation have to be conducted in such cases. Accounts receivable 40% maximum of regular 90 days or less accounts receivable balances. Office equipment/factory fittings 0% Inventory 0% Investments in unlisted companies/loans 0% to companies

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions