Answered

Discover the answers to your questions at Westonci.ca, where experts share their knowledge and insights with you. Get quick and reliable solutions to your questions from a community of seasoned experts on our user-friendly platform. Our platform provides a seamless experience for finding reliable answers from a network of experienced professionals.

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}
Thanks for stopping by. We strive to provide the best answers for all your questions. See you again soon. We appreciate your time. Please revisit us for more reliable answers to any questions you may have. Thank you for visiting Westonci.ca. Stay informed by coming back for more detailed answers.