Let's fill in the missing amounts step-by-step.
1. Receipts for May:
Net Cash Flow for May (NCF-May) can be calculated based on the receipts and expenses for May. We are already given:
- Expenses for May (E-May) = \[tex]$900
- Net Cash Flow for May (NCF-May) = \$[/tex]45
The relationship between receipts, expenses, and net cash flow is:
[tex]\[ \text{Receipts} = \text{Net Cash Flow} + \text{Expenses} \][/tex]
Substituting the given values:
[tex]\[ \text{Receipts for May} = 45 + 900 = \$945 \][/tex]
2. Net Cash Flow for April:
Similarly, Net Cash Flow for April (NCF-Apr) is calculated from the difference between receipts and expenses. We are given:
- Receipts for April (R-Apr) = \[tex]$1250
- Expenses for April (E-Apr) = \$[/tex]990
The formula to calculate Net Cash Flow is:
[tex]\[ \text{Net Cash Flow} = \text{Receipts} - \text{Expenses} \][/tex]
Substituting the given values:
[tex]\[ \text{Net Cash Flow for April} = 1250 - 990 = \$260 \][/tex]
3. Cumulative Balance for March:
Cumulative Balance for April (CB-Apr) is given, and it can be obtained by adding March's Cumulative Balance (CB-Mar) and Net Cash Flow for March (NCF-Mar):
- Net Cash Flow for March (NCF-Mar) = \[tex]$55
- Cumulative Balance for April (CB-Apr) = \$[/tex]315
The relationship is:
[tex]\[ \text{Cumulative Balance for April} = \text{Cumulative Balance for March} + \text{Net Cash Flow for March} \][/tex]
Re-arranging to find March's Cumulative Balance:
[tex]\[ \text{Cumulative Balance for March} = \text{Cumulative Balance for April} - \text{Net Cash Flow for March} \][/tex]
[tex]\[ \text{Cumulative Balance for March} = 315 - 55 = \$260 \][/tex]
Now we have all the missing amounts:
- Receipts in May: \[tex]$945
- Net Cash Flow in April: \$[/tex]260
- Cumulative Balance for March: \[tex]$260
\[
\begin{array}{|c|c|c|c|}
\hline
& \text{Mar} & \text{Apr} & \text{May} \\
\hline
\text{Receipts} & \$[/tex]1,155 & \[tex]$1,250 & \$[/tex]945 \\
\hline
\text{Expenses} & \[tex]$1,100 & \$[/tex]990 & \[tex]$900 \\
\hline
\text{Net Cash Flow} & \$[/tex]55 & \[tex]$260 & \$[/tex]45 \\
\hline
\text{Cumulative Balance} & \[tex]$260 & \$[/tex]315 & \$360 \\
\hline
\end{array}
\]
