Create a cash flow statement from the list of transactions below.

Cash Flow

Use this excel template Download template to create a cash flow statement from the list of transactions below. Your beginning of year cash (before any transactions are done) is $0, and your end of year cash is $940.

Q1

Investor puts $1,500 cash into business for 50% equity

Buy $200 of inventory

Pay utilities of $250

Buy equipment for $150. Will pay in Q2.

Q2

Sell $100 in coffee mugs (COGS is 20% of revenue). Customer (Tim) will pay in Q3.

Obtain bank loan for $750

Pay bill for equipment of $150

Buy $75 in advertising from Facebook

Q3

Sell $150 worth of coffee (COGS is 40% of revenue). Customer pays in cash

Pay utilities $250

Receive $100 payment from Tim

Buy $50 in inventory

Q4

Depreciate equipment expense $25

Buy company scooter for $2,000. Paid $500 in cash and got a 2-year loan for $1,500

Pay $75 off of scooter loan principle

Pay $10 off of scooter loan interest