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