fill in the missing amounts. jan feb mar apr may june receipts $1200 $1325 $1375 $1250 $ $1050 expenses $950…

fill in the missing amounts. jan feb mar apr may june receipts $1200 $1325 $1375 $1250 $ $1050 expenses $950 $1025 $1100 $900 $975 $825 net cash flow $250 $ $275 $ $145 $225 cumulative balance $ $550 $ $1175 $1320 $
Answer
Explanation:
Step1: Calculate Feb net - cash flow
Net cash flow = Receipts - Expenses. For Feb, Receipts = $1325 and Expenses = $1025. So, $1325−$1025 = $300.
Step2: Calculate Apr net - cash flow
For Apr, Receipts = $1250 and Expenses = $900. So, $1250−$900 = $350.
Step3: Calculate Jan cumulative balance
The cumulative balance for Jan is the net - cash flow for Jan since it's the first month. So it's $250.
Step4: Calculate Mar cumulative balance
The cumulative balance for Mar is the cumulative balance for Feb plus the net - cash flow for Mar. Cumulative balance for Feb is $550 and net - cash flow for Mar is $275. So, $550 + $275=$825.
Step5: Calculate May receipts
Net cash flow for May is $145 and Expenses is $975. Using Net cash flow = Receipts - Expenses, we can find Receipts. Receipts=Net cash flow + Expenses. So, $145 + $975 = $1120.
Step6: Calculate June cumulative balance
The cumulative balance for June is the cumulative balance for May plus the net - cash flow for June. Cumulative balance for May is $1320 and net - cash flow for June is $225. So, $1320+ $225 = $1545.
Answer:
| Jan | Feb | Mar | Apr | May | June | |
|---|---|---|---|---|---|---|
| Receipts | $1200 | $1325 | $1375 | $1250 | $1120 | $1050 |
| Expenses | $950 | $1025 | $1100 | $900 | $975 | $825 |
| Net Cash Flow | $250 | $300 | $275 | $350 | $145 | $225 |
| Cumulative Balance | $250 | $550 | $825 | $1175 | $1320 | $1545 |