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