Question

Which of the following spreadsheets shows the financial plan with the greatest net cash flow?

a.
A
B
1 Cash Inflows
2 Disposable income
$2,350
3 Interest on deposits
SO
4 Income from investments
$0
5 Total Cash Inflow
$2,350
6
7 Cash outflows
8 Rent
$800
9 Utilities
$235
10 Cable and telephone
$125
11 Groceries
$400
12 Car expenses
$320
13 Recreation
$175
14 Insurance
$200
15 Miscellaneous
$80
16 Total Cash Outflow
$2,335

Answer 1

Answer:The answer is A

Answer 2

Net Cash-flow = Cash Inflows - Cash Outflows

The net amount of cash that a company has is the difference between the cash coming in(revenue) and the cash going out (expenses).

Spreadsheet 1

= Cash Inflows - Cashflows

= 2,350 - 2,335

= $15

Spreadsheet 2

= Cash Inflows - Cashflows

= 2,270 - 2,260

= $10

Spreadsheet 3

= Cash Inflows - Cashflows

= 2,380 - 2,380

= $0

Spreadsheet 4

= Cash Inflows - Cashflows

= 2,150 - 2,055

= $95

Spreadsheet 4 has the greatest net cash flow at $95.