CIS 110 Cuyamaca College Statement of Cash Flow Excel Task

Wilson Home Entertainment Systems
Statement of Cash Flow
Cash flow from operations
Cash received from clients
Cash received from service contracts
Other cash received
Cash paid for salaries and wages
Cash paid for inventory
Cash paid for office supplies
Cash paid for promotion
Cash paid for taxes
Other cash paid
Net cash from operations
$
–
Net cash from banking and investment
$
–
Increase (decrease) in cash during the quarter
$
–
$
–
Cash flow from banking and investment
Cash received from sale of equipment
Cash received from sale of real estate
Cash received from rental and lease agreements
Cash received from interest on deposits
Other cash received
Cash paid for purchase of equipment
Other cash paid
Cash balance at the beginning of the quarter
Cash balance at the end of the quarter
Wilson Home Entertainment Systems
Statement of Cash Flow
Cash flow from operations
Cash received from clients
$
7,521
Cash received from service contracts
$
12,345
Cash paid for salaries and wages
$
10,875
Cash paid for inventory
$
450
Cash paid for office supplies
$
125
Cash paid for promotion
$
135
$
8,281
Cash received from rental and lease agreements
$
1,200
Cash received from interest on deposits
$
325
Net cash from banking and investment
$
1,525
Increase (decrease) in cash during the quarter
$
9,806
Cash balance at the beginning of the quarter
$
45,755
Cash balance at the end of the quarter
$
55,561
Other cash received
Cash paid for taxes
Other cash paid
Net cash from operations
Cash flow from banking and investment
Cash received from sale of equipment
Cash received from sale of real estate
Other cash received
Cash paid for purchase of equipment
Other cash paid
Wilson Home Entertainment Systems
Statement of Cash Flow
Cash flow from operations
Cash received from clients
$
5,645
Cash received from service contracts
$
15,345
$
8,750
Cash paid for office supplies
$
345
Cash paid for promotion
$
125
$
11,770
$
1,255
Net cash from banking and investment
$
1,255
Increase (decrease) in cash during the quarter
$
13,025
Cash balance at the beginning of the quarter
$
35,234
Cash balance at the end of the quarter
$
48,259
Other cash received
Cash paid for salaries and wages
Cash paid for inventory
Cash paid for taxes
Other cash paid
Net cash from operations
Cash flow from banking and investment
Cash received from sale of equipment
Cash received from sale of real estate
Cash received from rental and lease agreements
Cash received from interest on deposits
Other cash received
Cash paid for purchase of equipment
Other cash paid
Wilson Home Entertainment Systems
Statement of Cash Flow
Cash flow from operations
Cash received from clients
$
4,565
Cash received from service contracts
$
10,900
Cash paid for salaries and wages
$
9,525
Cash paid for inventory
$
550
Cash paid for office supplies
$
95
$
5,295
$
3,500
Cash received from rental and lease agreements
$
450
Cash received from interest on deposits
$
650
Net cash from banking and investment
$
4,600
Increase (decrease) in cash during the quarter
$
9,895
Cash balance at the beginning of the quarter
$
32,575
Cash balance at the end of the quarter
$
42,470
Other cash received
Cash paid for promotion
Cash paid for taxes
Other cash paid
Net cash from operations
Cash flow from banking and investment
Cash received from sale of equipment
Cash received from sale of real estate
Other cash received
Cash paid for purchase of equipment
Other cash paid