The Anderson family wants to look at their cash flow over a year. They decide to write out their cash flow for 4 months as given in the spreadsheet below. In which of the months did they have the greatest net cash flow?

\begin{tabular}{|l|l|r|r|r|r|}
\hline
& \multicolumn{1}{|c|}{A} & \multicolumn{1}{|c|}{January} & \multicolumn{1}{|c|}{April} & \multicolumn{1}{|c|}{August} & \multicolumn{1}{|c|}{December} \\
\hline
1 & Cash Inflows & \[tex]$2,760 & \$[/tex]3,060 & \[tex]$2,760 & \$[/tex]2,900 \\
\hline
2 & Disposable income & & & & \\
\hline
3 & Interest on deposits & \[tex]$0 & \$[/tex]0 & \[tex]$0 & \$[/tex]0 \\
\hline
4 & Income from investments & \[tex]$2,760 & \$[/tex]3,060 & \[tex]$2,760 & \$[/tex]2,900 \\
\hline
5 & Total Cash Inflow & & & & \\
\hline
6 & Cash Outflows & \[tex]$1,020 & \$[/tex]1,020 & \[tex]$1,020 & \$[/tex]1,020 \\
\hline
7 & Mortgage & \[tex]$230 & \$[/tex]185 & \[tex]$115 & \$[/tex]205 \\
\hline
8 & Electric & \[tex]$85 & \$[/tex]80 & \[tex]$100 & \$[/tex]90 \\
\hline
9 & Water & \[tex]$115 & \$[/tex]115 & \[tex]$115 & \$[/tex]115 \\
\hline
10 & Cable and telephone & \[tex]$150 & \$[/tex]540 & \[tex]$585 & \$[/tex]710 \\
\hline
11 & Groceries & \[tex]$5000 & \$[/tex]75 & & \\
\hline
\end{tabular}



Answer :

To determine the month in which the Anderson family had the greatest net cash flow, we need to perform the following steps:

1. Identify and sum the total cash inflows for each month.
2. Identify and sum the total cash outflows for each month.
3. Subtract the total cash outflows from the cash inflows to get the net cash flow for each month.
4. Compare the net cash flows to determine the month with the greatest net cash flow.

Given data:
- Cash Inflows:
- January: \[tex]$2,760 - April: \$[/tex]3,060
- August: \[tex]$2,760 - December: \$[/tex]2,900

- Cash Outflows:
- January:
- Total: \[tex]$1,020 (base) + \$[/tex]230 (mortgage) + \[tex]$85 (electric) + \$[/tex]115 (water) + \[tex]$150 (cable and telephone) - Sum: \$[/tex]1,600
- April:
- Total: \[tex]$1,020 (base) + \$[/tex]185 (mortgage) + \[tex]$80 (electric) + \$[/tex]115 (water) + \[tex]$540 (cable and telephone) - Sum: \$[/tex]1,940
- August:
- Total: \[tex]$1,020 (base) + \$[/tex]115 (mortgage) + \[tex]$100 (electric) + \$[/tex]115 (water) + \[tex]$585 (cable and telephone) - Sum: \$[/tex]1,935
- December:
- Total: \[tex]$1,020 (base) + \$[/tex]205 (mortgage) + \[tex]$90 (electric) + \$[/tex]115 (water) + \[tex]$710 (cable and telephone) - Sum: \$[/tex]2,140

Let's calculate the net cash flow for each month:

1. Net Cash Flow Calculation:
- January:
[tex]\[ \text{Net Cash Flow} = \text{Inflows} - \text{Outflows} = 2,760 - 1,600 = \$1,160 \][/tex]
- April:
[tex]\[ \text{Net Cash Flow} = 3,060 - 1,940 = \$1,120 \][/tex]
- August:
[tex]\[ \text{Net Cash Flow} = 2,760 - 1,935 = \$825 \][/tex]
- December:
[tex]\[ \text{Net Cash Flow} = 2,900 - 2,140 = \$760 \][/tex]

2. Comparison of Net Cash Flows:
- January: \[tex]$1,160 - April: \$[/tex]1,120
- August: \[tex]$825 - December: \$[/tex]760

Upon comparing these net cash flows, the month with the greatest net cash flow is January with \$1,160.

Therefore, the Anderson family had the greatest net cash flow in January.