Answered

Looking for answers? Westonci.ca is your go-to Q&A platform, offering quick, trustworthy responses from a community of experts. Discover in-depth solutions to your questions from a wide range of experts on our user-friendly Q&A platform. Get immediate and reliable solutions to your questions from a community of experienced professionals on our platform.

Activity 2:

The finance director of Cool-it Ltd is putting together the business's cash-flow forecast for the coming year. The Australian-based business's sales are growing strongly, and there is a need to manage cash flow carefully. It is particularly important to manage trade receivables carefully. Table 1 sets out an incomplete cash-flow forecast for Cool-it Ltd for the coming year.

Table 1: Incomplete cash-flow forecast for Cool-it Ltd for the coming year

\begin{tabular}{|l|c|c|c|c|c|c|}
\hline
\multicolumn{1}{|c|}{\[tex]$ \$[/tex] \prime 000s} & Jan & Feb & Mar & Apr & May & Jun \\
\hline
Cash inflow & & & & & & \\
\hline
Receipts & 18 & 18 & 20 & 21 & 22 & 23 \\
\hline
Total inflow & 18 & 18 & 20 & 21 & 22 & 23 \\
\hline
Cash outflow & & & & & & \\
\hline
Payments & 12 & 22 & 13 & 18 & 15 & 16 \\
\hline
Total outflow & 12 & 22 & 13 & 18 & 15 & 16 \\
\hline
Net cash flow & 6 & -4 & 7 & 3 & 7 & 7 \\
\hline
Opening balance & 4 & 10 & 6 & 10 & 13 & 20 \\
\hline
Closing balance & 10 & 6 & 13 & 10 & 20 & 23 \\
\hline
\end{tabular}

Sagot :

GinnyAnswer
Certainly! Let's complete the cash-flow forecast step-by-step.

### Step-by-Step Solution

1. Given Data:
- Receipts: 18, 18, 20, 21, 22, 23
- Payments: 12, 22, 13, 18, 15, 16
- Net Cash Flow: 6, (14), 7, 3, (A), 7
- Opening Balance: 4, 10, 6, (C), (D), 2
- Closing Balance: 10, 6, 13, (F), (E), 23

2. Identify Net Cash Flow:
- Net Cash Flow = Receipts - Payments
- Jan: 18 - 12 = 6 (Already given)
- Feb: Given as (14), likely correct value (10 - (-4) = 14 is incorrect).
- Mar: 20 - 13 = 7 (Already given)
- Apr: 21 - 18 = 3 (Already given)
- May: 22 - 15 = 7 (Let's assume A = 7)
- Jun: 23 - 16 = 7 (Already given)

3. Identify Closing Balances:
- Closing Balance = Opening Balance + Net Cash Flow
- Jan: 4 + 6 = 10 (Given correctly as 10)
- Feb: 10 - 4 = 6 (Given correctly as 6)
- Mar: 6 + 7 = 13 (Given correctly as 13)
- Apr: 6 + 3 = 9 (Assuming F = 9)
- May: 9 + 7 = 16 (Assuming E = 23; Need correction since closing balance & payment not matching)
- Jun: Given correctly as 23

4. Identify Opening Balances:
- Opening Balance = Closing Balance of the previous month
- Jan: 4 (Given)
- Feb: 10 (Given)
- Mar: 6 (Given)
- Apr: 13 (C)
- May: (D)
- Jun: 9 (Next Month)

5. Closing balance calculation:
- Closing Balance = Opening Balance + Net Cash Flow
- Jan : Closing balance = 4 + 6 = 10
- Feb: Closing balance = 10 - 4 = 6
- Mar: Closing balance = 6 + 7 = 13
- Apr: Closing balance = 6+ 3 = 9 (Assuming F = 9)
- May: Closing balance = 9 + 7 = 16(Assuming 16 since payments not match) 2 + 7 = 9
- Jun: 2 = 23 -7 => 16 (a mismatch)

### Using above into
\begin{tabular}{|l|c|c|c|c|c|c|}
\hline \multicolumn{1}{|c|}{[tex]$\$[/tex] \[tex]$ \prime 000$[/tex] s } & Jan & Feb & Mar & Apr & May & Jun \\
\hline Cash inflow & & & & & & \\
\hline Receipts & 18 & 18 & 20 & 21 & 22 & 23 \\
\hline Total inflow & 18 & 18 & 20 & 21 & 22 & 23 \\
\hline Cash outflow & & & & & & \\
\hline Payments & 12 & 22 & 13 & 18 & 15 &16 \\
\hline Total outflow & 12 & 22 & 13 & 18 & 15 & 16 \\
\hline Net cash flow & 6 & -4 & 7 & 3 & 7 &7 \\
\hline Opening balance & 4 & 10 & 6 &13 & 2 & 9\\
\hline Closing balance & 10 & 6 & 13 &9 & 16 & 23 \\
\hline
\end{tabular}
We hope you found what you were looking for. Feel free to revisit us for more answers and updated information. We hope our answers were useful. Return anytime for more information and answers to any other questions you have. Westonci.ca is your trusted source for answers. Visit us again to find more information on diverse topics.