Use this excel template Download template to 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

1. Investor puts $1,500 cash into business for 50% equity
2. Buy $200 of inventory
3. Pay utilities of $250
4. Buy equipment for $150. Will pay in Q2.

Q2

1. Sell $100 in coffee mugs (COGS is 20% of revenue). Customer (Tim) will pay in Q3.
2. Obtain bank loan for $750
3. Pay bill for equipment of $150
4. Buy $75 in advertising from Facebook

Q3

1. Sell $150 worth of coffee (COGS is 40% of revenue). Customer pays in cash
2. Pay utilities $250
3. Receive $100 payment from Tim
4. Buy $50 in inventory

Q4

1. Depreciate equipment expense $25
2. Buy company scooter for $2,000. Paid $500 in cash and got a 2-year loan for $1,500
3. Pay $75 off of scooter loan principle
4. Pay $10 off of scooter loan interest