Example 3 You are presented with the following flow forecasted data for your organisation for the period November 2021 to March 2022. It has been extracted from functional flow forecasts that have already been prepared Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Sales 160,000,000 200,000,000 220,000,000 260,000,000 280,000,000 Purchases 80,000,000 120,000,000 160,000,000 180,000,000 220,000,000 Wages 20,000,000 24,000,000 32,000,000 40,000,000 48,000,000 Overheads 20,000,000 20,000,000 30,000,000 30,000,000 30,000,000 You are also told the following. Sales are 40% cash 60% credit. Credit sales are paid two months after month of sale. Purchases are paid the month following purchase. 75 % of wages are paid in the current month and 25% the following month. Overheads are paid the month after they are incurred. The company purchases state-of-art equipment for TZS 45,000,000 in January 2022 The firm must maintain a minimum cash balance of TZS 1,000,000 and to facilitate this, it maintains a 12% open line of credit for TZS 10,000,000. Loans are repaid at the end of the month. On March 31 st 2022, the company received rental income of TZS 18,500,000. The opening cash balance is TZS 30,000,000. Required: Prepare a cash flow forecast for the three-month period January to March 2022