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 The Road Ahead Looking forward to the next financial year, the management team identified opportunities and challenges. Sales were evenly distributed over the past 12 months and are expected to grow by 5% in the next financial year, while the cost of sales remains constant at 65% 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.25% after the anticipated industry-wide union negotiations in October 2025. Rent is paid quarterly, with the annual 10% increase effective 1 January 2026. 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 45-day payment terms granted to debtors will remain, despite the widely varying payment patterns. + 50% of credit sales are collected within 30 days. + 30%are collected within 60 days. + S%are written off as bad debts. + 15%of sales are cash sales, with a 1% discount offered. Purchases are linked to sales, with monthly purchases equal to 50% of monthly sales. 65% of purchases are made on credit, with 60-day payment terms. The balance is paid forin cash. The total trade creditors at the end of the financial year are envisaged to increase by R4.4m YOY, while the opening inventory as of 1 July 2026 is expected to be RTm more than 1 July 2025. Anew project will commence in January 2026, with a capital investment of R1.2 million to be made in a new truck. While a 12% cash deposit is required 30 days prior, the first repayment for the truck will be on 1 July 2026. Old equipment with a zero-book value will be sold in October 2025 for R800,000, with payment terms of 30 days after the sale. The company maintains a depreciation policy of 10% per annum on a straight-line basis. The short-term loan will be extinguished by October 2025, while the term loan with Home Bank has an annual repayment of R5m due on 31 March 2026 ‘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 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 The Road Ahead Looking forward to the next financial year, the management team identified opportunities and challenges. Sales were evenly distributed over the past 12 months and are expected to grow by 5% in the next financial year, while the cost of sales remains constant at 65% 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.25% after the anticipated industry-wide union negotiations in October 2025. Rent is paid quarterly, with the annual 10% increase effective 1 January 2026. 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 45-day payment terms granted to debtors will remain, despite the widely varying payment patterns. + 50% of credit sales are collected within 30 days. + 30%are collected within 60 days. + S%are written off as bad debts. + 15%of sales are cash sales, with a 1% discount offered. Purchases are linked to sales, with monthly purchases equal to 50% of monthly sales. 65% of purchases are made on credit, with 60-day payment terms. The balance is paid forin cash. The total trade creditors at the end of the financial year are envisaged to increase by R4.4m YOY, while the opening inventory as of 1 July 2026 is expected to be RTm more than 1 July 2025. Anew project will commence in January 2026, with a capital investment of R1.2 million to be made in a new truck. While a 12% cash deposit is required 30 days prior, the first repayment for the truck will be on 1 July 2026. Old equipment with a zero-book value will be sold in October 2025 for R800,000, with payment terms of 30 days after the sale. The company maintains a depreciation policy of 10% per annum on a straight-line basis. The short-term loan will be extinguished by October 2025, while the term loan with Home Bank has an annual repayment of R5m due on 31 March 2026 ‘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 16:14:56

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 ### **Key Data from the Case** - **Annual Sales FY25:** R120,000,000R10,,000 per; expect 5% growth FY26) - **Sales mix:** - 15% Cash sales (with 1% discount) - 85% Credit sales - 50% collected in 30 days (next month) - 30% collected in 60 days (second month) - 5% written off as bad debts ### **Monthly Sales (from Nov 2025)** - **July–Dec 2025:** R10,000,000/month - **Jan 2026:** R10,500,000 (5% increase) #### **Monthly Breakdown:** | Month | Total Sales | Cash Sales (15%) | Credit Sales (85%) | |--------------|------------|------------------|--------------------| | Nov 2025 | 10,000,000 | 1,500,000 | 8,500,000 | | Dec 2025 | 10,000,000 | 1,500,000 | 8,500,000 | | Jan 2026 | 10,500,000 | 1,575,000 | 8,925,000 | #### **Debtors Calculation:** - **Credit sales collected:** - 50% in next month - 30% in 2nd month - 5% written off - 15% is cash (does not show as debtor) #### **Debtors Outstanding at Month-End:** - **Debtors at end of Nov 2025:** - From Oct 2025 sales: 30% of 8,500,000 = **2,550,000** (collected in Dec) - From Nov 2025 sales: 85% of 10,000,000 = 8,500,000 → 50% collected in Dec, 30% in Jan, 5% written off - Uncollected in Nov = 85% = 8,500,000 - **Debtors at end of Dec 2025:** - From Nov: 30% of 8,500,000 = **2,550,000** (to be collected Jan) - From Dec: 85% of 10,000,000 = 8,500,000 → only 50% will be collected in Jan - Uncollected in Dec = 85% = 8,500,000 - **Debtors at end of Jan 2026:** - From Dec: 30% of 8,500,000 = **2,550,000** (to be collected Feb) - From Jan: 85% of 10,500,000 = 8,925,000 → only 50% will be collected in Feb - Uncollected in Jan = 85% = 8,925,000 #### **Debtors Schedule Table:** | Month | Credit Sales in Month | Outstanding from previous months | Total Debtors at Month-End | |------------|----------------------|----------------------------------|---------------------------| | Nov 2025 | 8,500,000 | 2,550,000 (Oct, 30%) | 8,500,000 + 2,550,000 = **11,050,000** | | Dec 2025 | 8,500,000 | 2,550,000 (Nov, 30%) | 8,500,000 + 2,550,000 = **11,050,000** | | Jan 2026 | 8,925,000 | 2,550,000 (Dec, 30%) | 8,925,000 + 2,550,000 = **11,475,000** | --- ## 1.2 Cash Flow Projection (Nov 2025 – Jan 2026) ### **Key Cash Flow Items:** #### **Inflows:** - **Cash Sales:** 15% of total sales, less 1% discount - **Collections from Debtors:** - 50% of last month's credit sales - 30% of credit sales from two months ago - **Other Receipts:** - Sale of old equipment (R800,000, paid in Nov) #### **Outflows:** - **Purchases:** 50% of sales (65% on credit, 35% cash) - **Salaries and Wages:** Evenly (increase only after Oct, so use R1,250,000/month) - **Rent:** Paid quarterly (R4,494,000/year; R1,123,500/quarter; check if paid in Dec) - **Insurance:** R6,600,000/year = R550,000/month - **Interest:** R3,156,000/year; R263,000/month (6% increase in FY26, but after June) - **Tax:** No payment due until March - **Loan repayments:** Short-term loan ends in Oct - **Capex:** Truck deposit for Jan (12% × R1.2m = R144,000, paid in Dec) - **Dividends:** 690,000 × R.65 = R448,500 (timing not specified; assume in Jan) ### **Cash Flow Calculation Table** #### **Cash Inflows** | Item | Nov 2025 | Dec 2025 | Jan 2026 | |-----------------------------|-------------|-------------|-------------| | Cash sales (net) | 1,485,000 | 1,485,000 | 1,559,250 | | Collect prev month (50%) | 4,250,000 | 4,250,000 | 4,462,500 | | Collect 2 months ago (30%) | 2,550,000 | 2,550,000 | 2,550,000 | | Sale of equipment | 800,000 | | | | **Total Inflows** | 9,085,000 | 8,285,000 | 8,571,750 | #### **Cash Outflows** | Item | Nov 2025 | Dec 2025 | Jan 2026 | |-----------------------------|-------------|-------------|-------------| | Purchases (50% × sales) | 5,000,000 | 5,000,000 | 5,250,000 | | -Cash portion (35%) | 1,750,000 | 1,750,000 | 1,837,500 | | Salaries & Wages | 1,250,000 | 1,250,000 | 1,250,000 | | Insurance | 550,000 | 550,000 | 550,000 | | Interest Expense | 263,000 | 263,000 | 263,000 | | Rent (quarterly, Dec only) | | 1,123,500 | | | Capex (truck deposit Dec) | | 144,000 | | | Dividends (assume Jan) | | | 448,500 | | **Total Outflows** | 3,813,000 | 5,080,500 | 4,348,000 | #### **Net Cash Flow** | Month | Inflows | Outflows | Net Cash Flow | |--------------|------------|------------|---------------| | Nov 2025 | 9,085,000 | 3,813,000 | 5,272,000 | | Dec 2025 | 8,285,000 | 5,080,500 | 3,204,500 | | Jan 2026 | 8,571,750 | 4,348,000 | 4,223,750 | --- ## **Summary** ### **1.1 Debtors Schedule** | Month | Debtors at Month-End | |------------|----------------------| | Nov 2025 | R11,050,000 | | Dec 2025 | R11,050,000 | | Jan 2026 | R11,475,000 | ### **1.2 Cash Flow Projection** | Month | Net Cash Flow | |------------|---------------| | Nov 2025 | R5,272,000 | | Dec 2025 | R3,204,500 | | Jan 2026 | R4,223,750 | > **Note:** - These are simplified calculations for exam purposes. - For full accuracy, more precise timing on some expenses and receipts may be needed. - Opening bank balance for November is not provided; add/subtract these net cash flows to/from the October closing balance for projected cash position. --- ### **If you need calculations for credit purchases, creditors schedule, or a more detailed monthly breakdown, let me know!**

📢 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.