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:16:48

Final Answer:

Rendered Raw Text
Did you like this answer?
# Established Manufacturers (Pty) Ltd ## 1.1 Debtors Schedule for November 2025, December 2025, January 2026 ### **Step 1: Monthly Sales Calculation** - **Annual Sales (2025):** R120,000,000 - **Monthly Sales (Evenly distributed):** \( R120,000,000 \div 12 = R10,000,000 \) per month - **Sales Growth (from July 2025):** 5% \( \text{New Monthly Sales} = R10,000,000 \times 1.05 = R10,500,000 \) (from July 2025 onwards) ### **Step 2: Cash vs Credit Sales** - **Cash Sales:** 15% (with 1% discount) - **Credit Sales:** 85% Monthly Credit Sales = R10,500,000 × 85% = **R8,925,000** ### **Step 3: Debtors Collection Pattern** - 50% of credit sales collected in 30 days - 30% collected in 60 days - 5% written off as bad debt (not collected) - 15% is cash sales (collected immediately, not included in debtors) #### **Schedule Calculation (Credit Sales Only):** | Month | Credit Sales | 50% Collected Next Month | 30% Collected In 2nd Month | 5% Bad Debt | |----------------|-------------|--------------------------|----------------------------|-------------| | Nov 2025 | R8,925,000 | R4,462,500 (Dec) | R2,677,500 (Jan) | R446,250 | | Dec 2025 | R8,925,000 | R4,462,500 (Jan) | R2,677,500 (Feb) | R446,250 | | Jan 2026 | R8,925,000 | R4,462,500 (Feb) | R2,677,500 (Mar) | R446,250 | #### **Debtors at End of Each Month** - **Nov 2025:** 30% of Oct + 80% of Nov - **Dec 2025:** 30% of Nov + 80% of Dec - **Jan 2026:** 30% of Dec + 80% of Jan But since only 50% is collected in 1 month, 30% in 2 months, and 5% is never collected, at the end of each month, the debtors balance is: - **30% of sales from 2 months before** + **50% of sales from previous month** + **30% of sales from current month** But typically, the debtors schedule for each month is simply all amounts not yet collected. | Month | From Previous Month (30%) | Current Month (50%) | Total Debtors at Month End | |---------------|--------------------------|---------------------|----------------------------| | Nov 2025 | R2,677,500 (Oct) | R4,462,500 (Nov) | R7,140,000 | | Dec 2025 | R2,677,500 (Nov) | R4,462,500 (Dec) | R7,140,000 | | Jan 2026 | R2,677,500 (Dec) | R4,462,500 (Jan) | R7,140,000 | **Note:** The above assumes a rolling pattern; in reality, you add 30% of last month’s credit sales (still owing) plus 50% of this month (which will be collected next month). --- ## 1.2 Cash Flow Projection (Nov 2025, Dec 2025, Jan 2026) ### **A. Cash Inflows** 1. **Cash Sales (15% of monthly sales, less 1% discount):** - \( R10,500,000 \times 15\% = R1,575,000 \) - Less 1% discount: \( R1,575,000 \times 99\% = R1,559,250 \) 2. **Collection from Debtors (from prior credit sales):** - 50% of prior month’s credit sales: \( R8,925,000 \times 50\% = R4,462,500 \) - 30% of credit sales from two months prior: \( R8,925,000 \times 30\% = R2,677,500 \) 3. **Other income (Sale of old equipment):** - Sale in October, payment in November: **R800,000** (November only) ### **B. Cash Outflows** 1. **Purchases:** 50% of monthly sales \( R10,500,000 \times 50\% = R5,250,000 \) - 65% on credit (payable in 60 days), 35% cash. - Cash purchases this month: \( R5,250,000 \times 35\% = R1,837,500 \) - Credit purchases (paid for purchases from 2 months ago): \( R5,250,000 \times 65\% = R3,412,500 \) (from 2 months ago) 2. **Operating Expenses:** Per month, as per income statement (except depreciation is non-cash) - Insurance: \( R6,600,000/12 = R550,000 \) - Salaries and Wages: \( R15,000,000/12 = R1,250,000 \) (assume increase applied after October) - Rent: \( R4,494,000/12 = R374,500 \) (increase by 10% from Jan 2026) - Interest: \( R3,156,000/12 = R263,000 \) (increase by 6% for 2026, but applies FYE) 3. **Short-term Loan Repayment:** Fully paid by October 2025 (no outflow Nov-Jan) 4. **Truck Deposit:** 12% of R1.2m = **R144,000** (paid in December 2025) 5. **Dividend:** 65c/share × 690,000 shares = **R448,500** (assume paid in January 2026) ### **C. Cash Flow Table** #### **November 2025** - **Inflows:** - Cash sales: R1,559,250 - Collections: R4,462,500 (Oct credit sales) + R2,677,500 (Sep credit sales) - Sale of equipment: R800,000 - **Total:** R9,499,250 - **Outflows:** - Cash purchases: R1,837,500 - Credit purchases (Sep): R3,412,500 - Insurance: R550,000 - Salaries: R1,250,000 - Rent: R374,500 - Interest: R263,000 - **Total:** R7,687,500 #### **December 2025** - **Inflows:** - Cash sales: R1,559,250 - Collections: R4,462,500 (Nov credit sales) + R2,677,500 (Oct credit sales) - **Total:** R8,699,250 - **Outflows:** - Cash purchases: R1,837,500 - Credit purchases (Oct): R3,412,500 - Insurance: R550,000 - Salaries: R1,250,000 - Rent: R374,500 - Interest: R263,000 - Truck deposit: R144,000 - **Total:** R7,831,500 #### **January 2026** - **Inflows:** - Cash sales: R1,559,250 - Collections: R4,462,500 (Dec credit sales) + R2,677,500 (Nov credit sales) - **Total:** R8,699,250 - **Outflows:** - Cash purchases: R1,837,500 - Credit purchases (Nov): R3,412,500 - Insurance: R550,000 - Salaries (increase by 4.25%): R1,250,000 × 1.0425 = R1,303,125 - Rent (increase by 10%): R374,500 × 1.10 = R411,950 - Interest: R263,000 - Dividend: R448,500 - **Total:** R8,226,575 --- ### **Summary Table** | Month | Inflows | Outflows | Net Cash Flow | |------------|-----------|-----------|---------------| | Nov 2025 | 9,499,250 | 7,687,500 | 1,811,750 | | Dec 2025 | 8,699,250 | 7,831,500 | 867,750 | | Jan 2026 | 8,699,250 | 8,226,575 | 472,675 | --- ## **Summary: Key Assumptions** - Monthly values are based on 5% sales growth, even monthly sales, and cost/sales ratios provided. - Only cash-related items are included; depreciation and bad debts excluded from cash flow. - Creditors and debtors paid/collected as per provided terms. - Dividend is paid in January. - Truck deposit is paid in December. - Short-term loan repaid in October, so not considered in Nov-Jan. --- If you need the schedules in Excel format or want to see the calculations for *every* line item (e.g., exact creditor balances), please specify!

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