VIPSolutions logo ✨ VIPSolutions

QUESTION 1 ( 2 5 marks ) Using the relevant information provided in the case study, prepare the following for Established Manufacturers ( Pty ) Ltd: 1 . 1 A Debtors scheduled for November 2 0 2 5 , December 2 0 2 5 , and January 2 0 2 6 ( 5 marks ) 1 . 2 A Cash flow projection for November 2 0 2 5 , December 2 0 2 5 , and January 2 0 2 6 ( 2 0 marks ) Statement of Financial Position as of 3 0 June 2 0 2 5 Assets Property, Plant, and Equipment Cash and Cash Equivalents Total Equity and Liabilities The Road Ahead Looking forward to the next financial year, the management team identified opportunities and challenges. Sales were evenly distributed over the past 1 2 months and are expected to grow by 5 % in the next financial year, while the cost of sales remains constant at 6 5 % of total sales revenue. Cost pressures are real in the current economy and the following have been identified: Salaries and Wages were incurred evenly throughout the year. However, this is expected to increase by 4 . 2 5 % after the anticipated industry - wide union negotiations in October Rent is paid quarterly, with the annual 1 0 % increase effective 1 January 2 0 2 6 . Insurance premiums are paid monthly and increase by 8 % on 1 July, each year. Due to planned changes in Established Manufacturers' credit policy, the total value of debtors is expected to double in the financial year. However, the 4 5 - day payment terms granted to debtors will remain, despite the widely varying payment patterns. 5 0 % of credit sales are collected within 3 0 days. 3 0 % are collected within 6 0 days. 5 % are written off as bad debts. 1 5 % of sales are cash sales, with a 1 % discount offered. Purchases are linked to sales, with monthly purchases equal to 5 0 % of monthly sales. 6 5 % of purchases are made on credit, with 6 0 - day payment terms. The balance is paid for in cash. The total trade creditors at the end of the financial year are envisaged to increase by R 4 . 4 m YOY, while the opening inventory as of 1 July 2 0 2 6 is expected to be R 1 m more than 1 July 2 0 2 5 . A new project will commence in January 2 0 2 6 , with a capital investment of R 1 . 2 million to be made in a new truck. While a 1 2 % cash deposit is required 3 0 days prior, the first repayment for the truck will be on 1 July 2 0 2 6 . Old equipment with a zero - book value will be sold in October 2 0 2 5 for R 8 0 0 , 0 0 0 , with payment terms of 3 0 days after the sale. The company maintains a depreciation policy of 1 0 % per annum on a straight - line basis. The short - term loan will be extinguished by October 2 0 2 5 , while the term loan with Home Bank has an annual repayment of R 5 m due on 3 1 March 2 0 2 6 . The total interest expense for FYE 2 0 2 6 is expected to rise by 6 % Based on the review and discussion, the CFO projected an unfavourable bank balance of R 1 8 3 7 3 5 0 at the end of October 2 0 2 5 . He also mentioned that given the loyalty and support of the shareholders, it is anticipated a dividend of 6 5 cents per share will be declared and paid out in theCASE STUDY Information Established Manufacturers (Pty) Ltd is a South African company specialising in producing and distributing electronic components. The company operates in a highly competitive market and sells its products locally and internationally. The year has been particularly eventful for the company, filled with growth, challenges, and critical decisions that will shape its financial future. | Reflections on the Past Year The management team, led by CEO Mr Dlamini, reviewed the company’s performance and presented the financial statements for Established Manufacturers (Pty) Ltd for the year ended 30 June 2025: Income Statement for the Year Ended 30 June 2025 Amount (R'000) EE 120000 Cost of Sales (78,000) Operating Expenses EE +200 oo%0 Salaries and Wages 15,000 EN hi Operating Profit 11,706 0199 Profi Before Tex EN Income Tax Expense (2,565) (30%) Position as of 30 June 2025 Assets Equipment Equivalents Liabilities ‘I'he total interest expense Tor FYE 2026 is expected to rise by 6% Based on the review and discussion, the CFO projected an unfavourable bank balance of R1837 350 at the end of October 2025. He also mentioned that given the loyalty and support of the shareholders, it is anticipated a dividend of 65 cents per share will be declared and paid out in the financial year. Established Manufacturers (Pty) Ltd has an authorised share capital of 800 000 ordinary shares of which 690 000 have been issued.

Question:

QUESTION 1 ( 2 5 marks ) Using the relevant information provided in the case study, prepare the following for Established Manufacturers ( Pty ) Ltd: 1 . 1 A Debtors scheduled for November 2 0 2 5 , December 2 0 2 5 , and January 2 0 2 6 ( 5 marks ) 1 . 2 A Cash flow projection for November 2 0 2 5 , December 2 0 2 5 , and January 2 0 2 6 ( 2 0 marks ) Statement of Financial Position as of 3 0 June 2 0 2 5 Assets Property, Plant, and Equipment Cash and Cash Equivalents Total Equity and Liabilities The Road Ahead Looking forward to the next financial year, the management team identified opportunities and challenges. Sales were evenly distributed over the past 1 2 months and are expected to grow by 5 % in the next financial year, while the cost of sales remains constant at 6 5 % of total sales revenue. Cost pressures are real in the current economy and the following have been identified: Salaries and Wages were incurred evenly throughout the year. However, this is expected to increase by 4 . 2 5 % after the anticipated industry - wide union negotiations in October Rent is paid quarterly, with the annual 1 0 % increase effective 1 January 2 0 2 6 . Insurance premiums are paid monthly and increase by 8 % on 1 July, each year. Due to planned changes in Established Manufacturers' credit policy, the total value of debtors is expected to double in the financial year. However, the 4 5 - day payment terms granted to debtors will remain, despite the widely varying payment patterns. 5 0 % of credit sales are collected within 3 0 days. 3 0 % are collected within 6 0 days. 5 % are written off as bad debts. 1 5 % of sales are cash sales, with a 1 % discount offered. Purchases are linked to sales, with monthly purchases equal to 5 0 % of monthly sales. 6 5 % of purchases are made on credit, with 6 0 - day payment terms. The balance is paid for in cash. The total trade creditors at the end of the financial year are envisaged to increase by R 4 . 4 m YOY, while the opening inventory as of 1 July 2 0 2 6 is expected to be R 1 m more than 1 July 2 0 2 5 . A new project will commence in January 2 0 2 6 , with a capital investment of R 1 . 2 million to be made in a new truck. While a 1 2 % cash deposit is required 3 0 days prior, the first repayment for the truck will be on 1 July 2 0 2 6 . Old equipment with a zero - book value will be sold in October 2 0 2 5 for R 8 0 0 , 0 0 0 , with payment terms of 3 0 days after the sale. The company maintains a depreciation policy of 1 0 % per annum on a straight - line basis. The short - term loan will be extinguished by October 2 0 2 5 , while the term loan with Home Bank has an annual repayment of R 5 m due on 3 1 March 2 0 2 6 . The total interest expense for FYE 2 0 2 6 is expected to rise by 6 % Based on the review and discussion, the CFO projected an unfavourable bank balance of R 1 8 3 7 3 5 0 at the end of October 2 0 2 5 . He also mentioned that given the loyalty and support of the shareholders, it is anticipated a dividend of 6 5 cents per share will be declared and paid out in theUploaded ImageUploaded ImageUploaded ImageCASE STUDY Information Established Manufacturers (Pty) Ltd is a South African company specialising in producing and distributing electronic components. The company operates in a highly competitive market and sells its products locally and internationally. The year has been particularly eventful for the company, filled with growth, challenges, and critical decisions that will shape its financial future. | Reflections on the Past Year The management team, led by CEO Mr Dlamini, reviewed the company’s performance and presented the financial statements for Established Manufacturers (Pty) Ltd for the year ended 30 June 2025: Income Statement for the Year Ended 30 June 2025 Amount (R'000) EE 120000 Cost of Sales (78,000) Operating Expenses EE +200 oo%0 Salaries and Wages 15,000 EN hi Operating Profit 11,706 0199 Profi Before Tex EN Income Tax Expense (2,565) (30%) Position as of 30 June 2025 Assets Equipment Equivalents Liabilities ‘I'he total interest expense Tor FYE 2026 is expected to rise by 6% Based on the review and discussion, the CFO projected an unfavourable bank balance of R1837 350 at the end of October 2025. He also mentioned that given the loyalty and support of the shareholders, it is anticipated a dividend of 65 cents per share will be declared and paid out in the financial year. Established Manufacturers (Pty) Ltd has an authorised share capital of 800 000 ordinary shares of which 690 000 have been issued.

This is AI generated Response.
Asked by: REDDY BHARGAVA SURYA TEJA
Created at: 2025-11-16 15:44:24

Final Answer:

Rendered Raw Text
Did you like this answer?
# Established Manufacturers (Pty) Ltd ## 1.1 Debtors Schedule for Nov 2025, Dec 2025, Jan 2026 ### **Step 1: Extract Key Data** - **Sales for year ended 30 June 2025:** R120,000,000 (R120,000k) - **Sales evenly distributed:** Monthly sales = R120,000k / 12 = R10,000k - **Expected sales growth:** 5% for 2025/26 → New monthly sales = R10,000k × 1.05 = R10,500k - **Credit Sales:** 85% of sales (since 15% are cash sales) - **Cash sales discount:** 1% (applies only to cash sales) - **Collection pattern for credit sales:** - 50% in 30 days (month after sale) - 30% in 60 days (second month after sale) - 5% written off as bad debts ### **Step 2: Calculate Credit and Cash Sales** | Month | Total Sales (R'000) | Credit Sales (85%) | Cash Sales (15%) | |------------|---------------------|--------------------|------------------| | Nov 2025 | 10,500 | 8,925 | 1,575 | | Dec 2025 | 10,500 | 8,925 | 1,575 | | Jan 2026 | 10,500 | 8,925 | 1,575 | ### **Step 3: Debtors Schedule** #### **Debtors Outstanding at Month-End** | | Nov 2025 | Dec 2025 | Jan 2026 | |--------------------|----------|----------|----------| | **Credit Sales** | | | | | Current month | 8,925 | 8,925 | 8,925 | | Less: Collected | (50%) | (4,463) | (4,463) | (4,463) | | Add: 30% from prev month | 2,678 | 2,678 | 2,678 | | Add: 30% from 2 months prior | 2,678 (Sep) | 2,678 (Oct) | 2,678 (Nov) | | Less: Bad debts (5% of credit sales) | (446) | (446) | (446) | | **Closing Debtors**| *see below* | *see below* | *see below* | #### **Tabulated Calculation** Let's clarify the monthly flow: - **Nov 2025 closing debtors:** - 50% of Nov sales outstanding (to be collected in Dec): 8,925 × 50% = 4,463 - 30% of Oct sales outstanding (to be collected in Dec): 8,925 × 30% = 2,678 - 30% of Sep sales outstanding (to be collected in Nov): 8,925 × 30% = 2,678 - Less: Bad debts (5%): 8,925 × 5% = 446 But sales in Sep and Oct should use prior year's monthly sales (without growth): R10,000k × 85% = R8,500k | Description | Nov 2025 | Dec 2025 | Jan 2026 | |--------------------|----------|----------|----------| | 50% Credit Sales (current month) | 4,463 | 4,463 | 4,463 | | 30% Credit Sales (prev month) | 2,678*| 2,678 | 2,678 | | 30% Credit Sales (2 months prior)| 2,550**| 2,678*| 2,678 | | Less: Bad Debts | (446) | (446) | (446) | | **Closing Debtors** | 9,245 | 9,373 | 9,373 | *\*2,678 = 30% of 8,925 (Oct 2025), **2,550 = 30% of 8,500 (Sep 2025)* ### **Summary Table: Debtors Schedule** | Month | Debtors Closing Balance (R'000) | |------------|-------------------------------| | Nov 2025 | 9,245 | | Dec 2025 | 9,373 | | Jan 2026 | 9,373 | --- ## 1.2 Cash Flow Projection for Nov 2025, Dec 2025, Jan 2026 ### **Extract Key Data** - **Sales per month:** R10,500k (with 5% growth) - **Cash sales:** 15% × R10,500k = R1,575k less 1% discount = R1,559k - **Collections from credit sales:** - 50% from prior month’s credit sales - 30% from two months prior - **Payments:** - **Purchases:** 50% of monthly sales = R5,250k per month (65% on credit, 35% cash) - **Salaries/Wages:** R15,000k/year × 1.0425 / 12 = R1,302k/month (with 4.25% increase in Oct) - **Rent:** R4,494k/year. Paid quarterly. No rent in Nov and Dec. Jan 2026 rent = R4,494k × 1.10 = R4,943k - **Insurance:** R6,600k/year = R550k/month - **Interest:** R3,156k/year × 1.06 / 12 = R279k/month - **New truck:** R1,200k in Jan 2026; 12% deposit (R144k) paid in Dec 2025 - **Dividends:** 690,000 shares × R.65 = R448,500 (timing not specified, can assume Jan 2026) - **Old equipment sale:** R800k in Oct 2025 (payment in Nov 2025) ### **Cash Receipts** | Month | Nov 2025 | Dec 2025 | Jan 2026 | |------------|----------|----------|----------| | Cash Sales | 1,559 | 1,559 | 1,559 | | Credit Sales collected (from prior sales): | | | | | 50% of prev month (Oct) | 4,250* | 4,463 | 4,463 | | 30% of 2 months prior | 2,550** | 2,678 | 2,678 | | Sale of equipment | 800 | | | | **Total Receipts** | 9,159 | 8,700 | 8,700 | *\*50% of Oct credit sales (R8,925k); **30% of Sep credit sales (R8,500k)* ### **Cash Payments** | Month | Nov 2025 | Dec 2025 | Jan 2026 | |------------|----------|----------|----------| | Purchases - Cash (35% of 5,250) | 1,838 | 1,838 | 1,838 | | Purchases - Credit (payment for purchases 2 months ago) | 2,275* | 2,275 | 2,275 | | Salaries & Wages | 1,302 | 1,302 | 1,302 | | Insurance | 550 | 550 | 550 | | Rent (quarterly, Jan only) | | | 4,943 | | Interest | 279 | 279 | 279 | | Truck deposit (Dec only) | | 144 | | | Truck purchase (Jan only) | | | 1,200 | | Dividends (Jan only) | | | *** | | **Total Payments** | 6,244 | 6,388 | 12,187 | *\*Assumes regular credit purchase payment cycle; ***add R if not specified, or R448.5k if paid in Jan* ### **Net Cash Flow** | Month | Nov 2025 | Dec 2025 | Jan 2026 | |------------|----------|----------|----------| | Receipts | 9,159 | 8,700 | 8,700 | | Payments | 6,244 | 6,388 | 12,187 | | **Net Cash Flow** | 2,915 | 2,312 | (3,487) | --- # **Summary** ## 1.1 Debtors Schedule (R'000) | Month | Closing Debtors | |------------|----------------| | Nov 2025 | 9,245 | | Dec 2025 | 9,373 | | Jan 2026 | 9,373 | ## 1.2 Cash Flow Projection (R'000) | Month | Net Cash Flow | |------------|---------------| | Nov 2025 | 2,915 | | Dec 2025 | 2,312 | | Jan 2026 | (3,487) | **_Note: This schedule is based on the information provided and reasonable assumptions. Adjustments may be needed if further information is supplied or specific timing of certain transactions is clarified._**

📢 Instructions:

  • Ask anything relatd to above question only.
  • For new Question goto :

Study Help, Fast Answers

VIPSolutions focuses on clear, step‑by‑step explanations so you can learn quickly. Whether you need an AI‑generated walkthrough or a short hint to get unstuck, each solution is organized for fast reading and easy review later.

Search similar questions, compare approaches, and bookmark the best answers for revision. Our goal is simple: quick, reliable study help that feels natural—not noisy.