Answered

Explore Westonci.ca, the premier Q&A site that helps you find precise answers to your questions, no matter the topic. Join our platform to connect with experts ready to provide accurate answers to your questions in various fields. Discover in-depth answers to your questions from a wide network of professionals on our user-friendly Q&A 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 appreciate your visit. Hopefully, the answers you found were beneficial. Don't hesitate to come back for more information. We hope you found what you were looking for. Feel free to revisit us for more answers and updated information. Get the answers you need at Westonci.ca. Stay informed with our latest expert advice.