CALCULATING YOUR MONTHLY CASH FLOW FORECAST (Add your specific calcualtions to the boxes with red text. For additional instuctions on useage, see the Instruction tab at the bottom left of this spreadsheet)
Name of business: Owner: Date:
Estimate*
Actual*
Jan
Feb
March
April
May
June
July
Aug
Sept
Oct
Nov
Dec
1 2 a b c 3 4 5 a b c d e f g h i j k l m n o p r s t u v w x 5 6 7
Cash on hand (beginning month) Cash In Cash sales Wages Loan and other cash injections (specify) Total cash reciepts Total cash available (before cash out) Cash Out Purchases (stock) Gross wages (excludes withdrawals) Payroll expenses (taxes, etc.) Outside services Supplies (office and operating) Repairs and maintenance Advertising Car, delivery and travel Accounting and legal Rent Telephone Utilities Insurance Taxes Interest Other expenses (specify each) Miscellaneous (unspecified) Subtotal (Operating costs) Loan principal payment Capital purchases (specify) Other start-up costs Reserve Owner’s Drawings Total cash paid out
$40,000
$63,879
$87,758 $109,637 $125,516 $134,395
$131,474 $153,353
$40,000
$40,000
$40,000
$40,000
$25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $1,269 $1,269 $1,269 $1,269 $1,269 $1,269 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $66,269 $66,269 $66,269 $66,269 $66,269 $66,269 $106,269 $130,148 $154,027 $175,906 $191,785 $200,664 $35,000 $1,000 $90 $200 $100 $1,000 $150 $250 $1,200 $90 $90 $35,000 $1,000 $90 $200 $100 $1,000 $150 $250 $1,200 $90 $90 $35,000 $1,000 $90 $200 $100 $1,000 $150 $250 $1,200 $90 $90 $40,000 $1,000 $90 $200 $100 $1,000 $150 $250 $1,200 $90 $90 $50,000 $1,000 $90 $200 $100 $1,000 $150 $250 $1,200 $90 $90 $60,000 $1,000 $90 $200 $100 $1,000 $150 $250 $1,200 $90 $90
$25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $1,269 $1,269 $1,269 $1,269 $1,269 $1,269 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $66,269 $66,269 $66,269 $66,269 $66,269 $66,269 $197,743 $219,622 $106,269 $106,269 $106,269 $106,269 $35,000 $1,000 $90 $200 $100 $1,000 $150 $250 $1,200 $90 $90 $70,000 $1,000 $90 $200 $100 $1,000 $150 $250 $1,200 $90 $90 $35,000 $1,000 $90 $200 $100 $1,000 $150 $250 $1,200 $90 $90 $35,000 $1,000 $90 $200 $100 $1,000 $150 $250 $1,200 $90 $90 $35,000 $1,000 $90 $200 $100 $1,000 $150 $250 $1,200 $90 $90 $35,000 $1,000 $90 $200 $100 $1,000 $150 $250 $1,200 $90 $90
$60 $560 $39,790 $800 $800 $1,000 $42,390 $23,879 $63,879
$60 $560 $39,790 $800 $800 $2,000 $43,390
$60 $560 $39,790 $800 $800 $3,000 $44,390
$60 $560 $44,790 $800 $800 $4,000 $50,390
$60 $560 $54,790 $800 $800 $1,000 $57,390
$60 $560 $64,790 $800 $800 $2,800 $69,190
$60 $560 $39,790 $800 $800 $3,000 $44,390
$60 $560 $74,790 $800 $800 $3,200 $79,590
$60 $560 $39,790 $800 $800 $3,400 $44,790 $21,479 $61,479
$60 $560 $39,790 $800 $800 $3,600 $44,990 $21,279 $61,279
$60 $560 $39,790 $800 $800 $3,800 $45,190 $21,079 $61,079
$60 $560 $39,790 $800 $800 $4,000 $45,390 $20,879 $60,879
Cash Flow Cash Balance
$22,879 $21,879 $15,879 $8,879 -$2,921 $86,758 $109,637 $125,516 $134,395 $131,474
$21,879 -$13,321 $153,353 $140,032
Essential operating data (non-cash flow information) Sales Volume (dollars) Accounts receivable (end of month) Bad debt (end of month) Stock on hand (end of month) Accounts payable (end of month)
30000 4313 13125 2000
MONTHLY CASH FLOW PROJECTION Introduction
Your cash flow is the amount of money you have available to over a specific time period that can be used to make purchases and pay bills. It is the d (cash receipts), and the money you spend (cash dispursements).
A cash flow forecast is an estimate of your receipts and dispursements over either a weekly, monthly or quaterly period and is commonly used to en a yearly, of even daily basis.
Note: All calculations have been presaved in the template, so you don’t have to manually add or subtract etc. If you wish to make chan stgeorge. Populate cash on hand (beginning month) (1) This is the same as the Cash Balance from the previous month. Estimate Cash In (2) a) Cash sales – All cash sales. Omit credit sales unless cash is actually received b) Gross wages (including withdrawals) – Amount to be expected from all accounts c) Loan or other cash injection – Indicate here all cash injections not shown in either of the above Calculate total Cash receipts (3)
This will automatically calculate if you have entered the relevant figures. To manually calculate add cash sales (2a), gross wages (2b) and Loan or o Calculate total Cash available (4) This will automatically calculate if you have entered the relevant figures. To manually calculate add total cash receipts (3) to cash on hand (1). Estimate Cash Out (5) a) Purchases (stock) - Stock for resale or for use in product (parod for in current month) b Gross wages (including withdrawals) – Base pay plus overtime (if any). c) Payroll expenses (taxes, etc.) – Include paid holidays & paid sick leave. d) Outside services – This could outside labour and/or material for specialised or overflow work, including subcontracting. e) Supplies (office and operating) – Items purchased for use in the business (not for resale. f) Repairs and maintenance – Include periodic large expenditures such as painting and decorating. g) Advertising – This amount should be adequate to maintain sales volume. h) Car, delivery and travel – If personal car is used, charge in this column, include parking. i) Accounting and legal – Outside services including, for example, bookkeeping. j) Rent k) Telephone l) Utilities – Water, Electricity, Gas m) Insurance – Coverage on business property and products (fire, liability); also worker’s compensation. n) Taxes o) Interest – Remember to add interest on loan as it is injected (see 2c above).
p) Other expenses (specify each) – Unexpected expenditures may be included here as a safety factor. Equipment expenses during the month should be included here (non-capital equipment). When equipment is rented or leases, record payments h q) Miscellaneous (unspecified) – Small expenditures for which separate accounts would be practical. r) Subtotal – This subtotal indicates cash out for operating costs. s) Loan principal payment – Include payment on all loans, including vehicle and equipment purchases on hire purchase. t) Capital purchases (specify) – Non-expensed (depreciable) expenditures such as equipment, building purchases on hire purchase. u) Other start-up costs – Expenses incurred prior to first month projection and paid for after start-up. v) Reserve – Example: insurance, tax or equipment agreement to reduce impact of large periodic payments. w) Owner’s withdrawal – Should include payment for such things as owner’s income tax, health insurance, executive life insurance premiums, etc. Calculate total Cash paid out (5) This will automatically calculate if you have entered the relevant figures. To manually calculate add (5a - w) Calculate Flow (6) This is the actual cash earnt by the business during the month, once cash out has been removed. This figure will automatically calculate if you have calculate subtract Cash Paid Out (5) from Cash In (2)
Calculate Balance (7)
This is the actual cash earnt by the business during the month, in addition to the cash on hand available form the previous month. This figure will aut relevant numbers. To manually calculate subtract total cash paid out (5) form total cash available (4) Essential operating data (non-cash flow information)
Sales volume (dollars) – This is a very important figure and should be estimated carefully, taking into account size of facility and employee output as sales, not orders received).
Accounts receivable (end of month) – Previous unpaid credit sales plus current month’s credit sales, less amounts received current month (deduct C Bad debt (end of month) – Bad debts should be subtracted from (B) in the month anticipated. Stock on hand (end of month) – Last month’s stock plus goods received and/or manufactured current month minus amount sold current month. Accounts payable (end of month) – Previous month’s payable plus current month’s payable minus amount paid during month.
HLY CASH FLOW PROJECTION
riod that can be used to make purchases and pay bills. It is the difference between the money you take in
a weekly, monthly or quaterly period and is commonly used to enable you to plpan the finiance you require over
ve to manually add or subtract etc. If you wish to make changes to the locked cells, the password is stgeorge.
nts
her of the above
y calculate add cash sales (2a), gross wages (2b) and Loan or other cash injection (2c).
y calculate add total cash receipts (3) to cash on hand (1).
onth)
verflow work, including subcontracting.
or resale.
g and decorating.
parking.
orker’s compensation.
re as a safety factor. pment). When equipment is rented or leases, record payments here.
would be practical.
quipment purchases on hire purchase. for after start-up.
s equipment, building purchases on hire purchase.
f large periodic payments.
me tax, health insurance, executive life insurance premiums, etc.
y calculate add (5a - w)
een removed. This figure will automatically calculate if you have entered the relevant figures. To manually
sh on hand available form the previous month. This figure will automatically calculate if you have entered the ash available (4)
efully, taking into account size of facility and employee output as well as realistic anticipated sales (actual
th’s credit sales, less amounts received current month (deduct C below).
ticipated.
ufactured current month minus amount sold current month.
payable minus amount paid during month.