Question Tag: Cash Flow Forecast

Search 500 + past questions and counting.
  • Filter by Professional Bodies

  • Filter by Subject

  • Filter by Series

  • Filter by Topics

  • Filter by Levels

AAA – May 2022 – L3 – Q3 – Audit of Prospective Financial Information

Discuss auditor assurance work on prospective financial information, cash flow forecast procedures, and forming an opinion on PFI.

Tijara Nigeria Limited has a credit facility of N6 million with Godiya Bank. The facility was due to expire on December 31, 2021. The overdraft in the recently audited statement of financial position as at September 30, 2021 is N5.5 million. The directors of Tijara have started negotiations with their bankers for a renewal of the facility and to increase the amount to N9 million. To support this request, the bank has asked Tijara to provide a business plan for the coming twelve months consisting of a cash flow forecast supported by a forecast income statement and statement of financial position.

The management of Tijara has produced a cash flow forecast for the period October 1, 2021, to September 30, 2022, and, at the request of the bank, has asked an auditor to examine and report on it.

The Audit Manager, who has recently completed Tijara’s audit, has been asked to make a preliminary examination of the cash flow forecast and supporting materials. The manager has made the following observations:

  1. The cash flows from sales are based on the assumption of an overall increase in sales of 24% compared to the previous financial year. Analysis shows that this is based on an increase in selling price of 5% and an increase in the volume of sales of 18%. Just over a quarter of all Tijara sales are made to foreign customers.
  2. The cost of sales in the recently audited comprehensive income to September 30, 2021, was 80% of sales revenue, giving a gross profit of 20%. In the forecast income statement for the year to September 30, 2022, the cost of sales has fallen to 72%, giving a gross profit of 28%. Manufacturing costs are made up of equal proportions of materials, labor, and production overheads.
  3. The trade receivables collection period used in the cash flow forecast to September 30, 2022, is 61 days. In the year to September 30, 2021, this period averaged 93 days. Management has stated that it is its intention to inform all customers of a new standard 60-day credit period. In addition, an early settlement discount of 1% will apply to customers who settle their accounts within 30 days of the statement. Conversely, the credit period for trade payables has been extended from an average of 45 days in the current year to 90 days in the forecast.
  4. The cash flow forecast showed that the maximum credit required during the period would rise to nearly N9 million in August 2022.

Required:

a. Describe the general approach to the assurance work an auditor should consider before accepting the engagement of a reporting accountant on Prospective Financial Information (PFI) under ISAE 3400: The Examination of Prospective Financial Information. (8 Marks)

b. Detail the procedures applicable to the cash flow forecast of Tijara for the year to September 30, 2022. (7 Marks)

c. Prepare a summarized presentation of what the reporting accountant should consider in forming an opinion on prospective financial information (PFI). (5 Marks)

Login or create a free account to see answers

Find Related Questions by Tags, levels, etc.

AAA – July 2023 – L3 – Q2 – Assurance services | The audit approach | Planning

Discuss matters to consider before accepting a review engagement and recommend procedures for examining a cash flow forecast.

Eebuks Ltd is a retailer of academic textbooks that sells through its own network of bookshops and online through its website. The revenue from the website includes both cash sales and sales on credit to educational institutions. The company has provided historical analysis from its trade receivables ledger indicating that for sales made on credit, 25% payment is received in the month of sale, 70% after 30 days, and the remainder are irrecoverable debts.

You are a Manager in Makafui & Associates, a firm of Chartered Accountants offering a range of services from audit to non-audit for its clients. On 1 July 2023, your firm was asked by Eebuks Ltd, a company that is not an audit client of your firm, to consider a potential engagement to review and provide an assurance report on Prospective Financial Information. Makafui & Associates has already conducted specific client identification procedures in line with money laundering regulations with satisfactory results.

Additionally, Eebuks Ltd has approached your firm to obtain an independent assurance opinion on its cash flow forecast, which is being prepared for its bankers in support of an application for an increase in its existing overdraft facility.

Required:

a) In line with ISAE 3400: The Examination of Prospective Financial Information, discuss FIVE (5) matters to be considered by Makafui & Associates before accepting the engagement to review and report on Eebuks Ltd’s Prospective Financial Information. (10 marks)

b) Assuming Makafui & Associates accepts the engagement, recommend EIGHT (8) procedures to be performed in respect of Eebuks Ltd’s cash flow forecast. (10 marks)

Login or create a free account to see answers

Find Related Questions by Tags, levels, etc.

PSAF – July 2023 – L2 – Q5a – Public sector fiscal planning and budgeting

Prepare a Cash Flow Forecast for Tham District Assembly for the first quarter of 2022.

The following transactions relate to Tham District Assembly (TDA):

i) The estimated internally generated funds of the Assembly for the fourth quarter of 2021 and the first quarter of 2022 are given below:

Source of Revenue Oct 2021 (GH¢’000) Nov 2021 (GH¢’000) Dec 2021 (GH¢’000) Jan 2022 (GH¢’000) Feb 2022 (GH¢’000) Mar 2022 (GH¢’000)
Fees and Charges 300,000 320,000 310,000 400,000 450,000 420,000
Licenses 120,000 120,000 200,000 180,000 140,000 160,000
Property rate 800,000 1,200,000 1,000,000 900,000 900,000 1,300,000
Fines and Penalties 50,000 50,000 40,000 60,000 80,000 80,000

ii) The revenue policy of the Assembly is as follows:

  • Fees and Charges: 100% of Fees and Charges are expected to be collected in the month of estimation.
  • Licenses: Licenses are collected in the month following the month of estimation.
  • Property Rate: Property rates are collected in the third month after the month of estimation.
  • Fines and Penalties: Fines and Penalties are collected on the spot.

iii) Experience shows that about 10% of the amount owed in respect to property rate is never received.

iv) Decentralised transfer is estimated at GH¢2,000,000 and GH¢1,800,000 for the first and second quarters of 2022 respectively. The decentralised transfers are often released in the second month of each quarter, except for the first quarter, which is released in the last month.

v) Goods and services are paid two months in arrears. The projected expenses in the Assembly’s 2021 and 2022 budgets are as follows:

Oct 2021 (GH¢’000) Nov 2021 (GH¢’000) Dec 2021 (GH¢’000) Jan 2022 (GH¢’000) Feb 2022 (GH¢’000) Mar 2022 (GH¢’000)
365,000 280,000 280,000 290,000 200,000 320,000

vi) The Assembly budgets to acquire equipment and furniture amounting to GH¢300,000,000 in the month of February 2022. It has planned that 50% of the amount will be paid in the month of purchase, and the balance paid equally over the following two months. The equipment and furniture will be depreciated at the rate of 10% per annum.

vii) The cash and cash equivalent balance at the end of the 2021 financial year was GH¢63,000.

Required:
Prepare a Cash Flow Forecast for the first quarter of 2022, showing clearly the forecast for each month and the quarter as a whole. (10 marks)

Login or create a free account to see answers

Find Related Questions by Tags, levels, etc.

AAA – May 2022 – L3 – Q3 – Audit of Prospective Financial Information

Discuss auditor assurance work on prospective financial information, cash flow forecast procedures, and forming an opinion on PFI.

Tijara Nigeria Limited has a credit facility of N6 million with Godiya Bank. The facility was due to expire on December 31, 2021. The overdraft in the recently audited statement of financial position as at September 30, 2021 is N5.5 million. The directors of Tijara have started negotiations with their bankers for a renewal of the facility and to increase the amount to N9 million. To support this request, the bank has asked Tijara to provide a business plan for the coming twelve months consisting of a cash flow forecast supported by a forecast income statement and statement of financial position.

The management of Tijara has produced a cash flow forecast for the period October 1, 2021, to September 30, 2022, and, at the request of the bank, has asked an auditor to examine and report on it.

The Audit Manager, who has recently completed Tijara’s audit, has been asked to make a preliminary examination of the cash flow forecast and supporting materials. The manager has made the following observations:

  1. The cash flows from sales are based on the assumption of an overall increase in sales of 24% compared to the previous financial year. Analysis shows that this is based on an increase in selling price of 5% and an increase in the volume of sales of 18%. Just over a quarter of all Tijara sales are made to foreign customers.
  2. The cost of sales in the recently audited comprehensive income to September 30, 2021, was 80% of sales revenue, giving a gross profit of 20%. In the forecast income statement for the year to September 30, 2022, the cost of sales has fallen to 72%, giving a gross profit of 28%. Manufacturing costs are made up of equal proportions of materials, labor, and production overheads.
  3. The trade receivables collection period used in the cash flow forecast to September 30, 2022, is 61 days. In the year to September 30, 2021, this period averaged 93 days. Management has stated that it is its intention to inform all customers of a new standard 60-day credit period. In addition, an early settlement discount of 1% will apply to customers who settle their accounts within 30 days of the statement. Conversely, the credit period for trade payables has been extended from an average of 45 days in the current year to 90 days in the forecast.
  4. The cash flow forecast showed that the maximum credit required during the period would rise to nearly N9 million in August 2022.

Required:

a. Describe the general approach to the assurance work an auditor should consider before accepting the engagement of a reporting accountant on Prospective Financial Information (PFI) under ISAE 3400: The Examination of Prospective Financial Information. (8 Marks)

b. Detail the procedures applicable to the cash flow forecast of Tijara for the year to September 30, 2022. (7 Marks)

c. Prepare a summarized presentation of what the reporting accountant should consider in forming an opinion on prospective financial information (PFI). (5 Marks)

Login or create a free account to see answers

Find Related Questions by Tags, levels, etc.

AAA – July 2023 – L3 – Q2 – Assurance services | The audit approach | Planning

Discuss matters to consider before accepting a review engagement and recommend procedures for examining a cash flow forecast.

Eebuks Ltd is a retailer of academic textbooks that sells through its own network of bookshops and online through its website. The revenue from the website includes both cash sales and sales on credit to educational institutions. The company has provided historical analysis from its trade receivables ledger indicating that for sales made on credit, 25% payment is received in the month of sale, 70% after 30 days, and the remainder are irrecoverable debts.

You are a Manager in Makafui & Associates, a firm of Chartered Accountants offering a range of services from audit to non-audit for its clients. On 1 July 2023, your firm was asked by Eebuks Ltd, a company that is not an audit client of your firm, to consider a potential engagement to review and provide an assurance report on Prospective Financial Information. Makafui & Associates has already conducted specific client identification procedures in line with money laundering regulations with satisfactory results.

Additionally, Eebuks Ltd has approached your firm to obtain an independent assurance opinion on its cash flow forecast, which is being prepared for its bankers in support of an application for an increase in its existing overdraft facility.

Required:

a) In line with ISAE 3400: The Examination of Prospective Financial Information, discuss FIVE (5) matters to be considered by Makafui & Associates before accepting the engagement to review and report on Eebuks Ltd’s Prospective Financial Information. (10 marks)

b) Assuming Makafui & Associates accepts the engagement, recommend EIGHT (8) procedures to be performed in respect of Eebuks Ltd’s cash flow forecast. (10 marks)

Login or create a free account to see answers

Find Related Questions by Tags, levels, etc.

PSAF – July 2023 – L2 – Q5a – Public sector fiscal planning and budgeting

Prepare a Cash Flow Forecast for Tham District Assembly for the first quarter of 2022.

The following transactions relate to Tham District Assembly (TDA):

i) The estimated internally generated funds of the Assembly for the fourth quarter of 2021 and the first quarter of 2022 are given below:

Source of Revenue Oct 2021 (GH¢’000) Nov 2021 (GH¢’000) Dec 2021 (GH¢’000) Jan 2022 (GH¢’000) Feb 2022 (GH¢’000) Mar 2022 (GH¢’000)
Fees and Charges 300,000 320,000 310,000 400,000 450,000 420,000
Licenses 120,000 120,000 200,000 180,000 140,000 160,000
Property rate 800,000 1,200,000 1,000,000 900,000 900,000 1,300,000
Fines and Penalties 50,000 50,000 40,000 60,000 80,000 80,000

ii) The revenue policy of the Assembly is as follows:

  • Fees and Charges: 100% of Fees and Charges are expected to be collected in the month of estimation.
  • Licenses: Licenses are collected in the month following the month of estimation.
  • Property Rate: Property rates are collected in the third month after the month of estimation.
  • Fines and Penalties: Fines and Penalties are collected on the spot.

iii) Experience shows that about 10% of the amount owed in respect to property rate is never received.

iv) Decentralised transfer is estimated at GH¢2,000,000 and GH¢1,800,000 for the first and second quarters of 2022 respectively. The decentralised transfers are often released in the second month of each quarter, except for the first quarter, which is released in the last month.

v) Goods and services are paid two months in arrears. The projected expenses in the Assembly’s 2021 and 2022 budgets are as follows:

Oct 2021 (GH¢’000) Nov 2021 (GH¢’000) Dec 2021 (GH¢’000) Jan 2022 (GH¢’000) Feb 2022 (GH¢’000) Mar 2022 (GH¢’000)
365,000 280,000 280,000 290,000 200,000 320,000

vi) The Assembly budgets to acquire equipment and furniture amounting to GH¢300,000,000 in the month of February 2022. It has planned that 50% of the amount will be paid in the month of purchase, and the balance paid equally over the following two months. The equipment and furniture will be depreciated at the rate of 10% per annum.

vii) The cash and cash equivalent balance at the end of the 2021 financial year was GH¢63,000.

Required:
Prepare a Cash Flow Forecast for the first quarter of 2022, showing clearly the forecast for each month and the quarter as a whole. (10 marks)

Login or create a free account to see answers

Find Related Questions by Tags, levels, etc.