3-Year Cash Flow Projections

156277090.xls.
ms_office
YOUR COMPANY NAME Inc.

3-YEAR CASH FLOW PROJECTION
PLEASE NOTE that many of the fields in this spreadsheet automatically calculate totals etc. Note which ones are for you to enter your numbers (blue type
fields) and those which are automatically calculating (usually has a formula in the field, so do not overwrite the formula or the totals won't be correct).
Month-1
Month-2
Month-3
Month-4
Month-5
Month-6
Month-7
Month-8
Jul-02
Aug-02
Sep-02
Oct-02
Nov-02
Dec-02
Jan-03
Feb-03
Opening Cash Balance

CASH IN
Cash From Sales
Cash From Out-Licensing of Intellectual Property
Loans or Other Financial Vehicles
Tax Rebates (eg SR&ED)
Taxes Collected from Sales
Equity Investments
Interest From Bank
TOTAL CASH IN
CASH OUT
Cost of Sale (COS)
Staff Expenses
Salaries: NAME OR TITLE OF PERSON
Benefits: All salaries + 20%
Source Deductions: All salaries + 7%
Marketing Expenses
Website Creation and Maintenance
Website and Email Hosting
Market Research
Media Relations and PR (include writing)
Marketing Collateral (include writing)
Tradeshow and Conference Attendance
Tradeshow Displays
Language Versioning of Website/eCollateral
Advertising
Subscriptions to Publications
Other/miscellaneous
Facilities
Office: Rent
Office: Utilities
Office: Furniture and Fittings (cap)
Office: Buildout (cap)
Office Cleaning and Waste Management
Manufacturing Plant or Workshop: Rent
Manufacturing Plant or Workshop: Utilities
Manufacturing Plant or Workshop: Furniture and Fittings (cap)
Manufacturing Plant or Workshop: Buildout (cap)
Manufacturing Plant or Workshop: Cleaning and Waste Management
IT/IS
Telephones
Integrated Communications System (voice/data)
Workstations, Printers and Peripherals
Software
Network supplies (LAN)
Mobile phones and PDAs
Internal Project Resources
Materials
Equipment
Project Contract Resources
Subcontractor 2: NAME SERVICE
Subcontractor 1: NAME SERVICE
Materials
Facilities and Equipment
Technical Support
Materials
Equipment
Financial
Acquisitions
Loan Payments (P+I)
Month-9
Mar-03
Month-10
Apr-03
Month-11
May-03
Month-12
Jun-03
Total
Year-1
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Page 1
156277090.xls.ms_office
Incidental Loan Repayments

Short-Term Debt
Aged Accounts Payable
R&D Expenses
In-Licensing of Intellectual Property
Subscriptions and Technical Research
Travel
Selling Expenses (eg Commissions)
Office Support
Office Supplies
Office Equipment
Professional Fees
Legal -- General
Legal -- Patents
Accounting
Bookeeping
Advisor Fees
Banking Charges
Bank Fees
Credit Card Charges and Interest
Interest on Line of Credit
Taxes
Sales Tax
Income Tax
Miscellaneous
Insurance
Membership Fees
Couriers, Mail and Postage
TOTAL CASH DISBURSEMENT
Net Cash
Closing Cash Balance (Cummulative)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Page 2
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
YOUR COMPANY NAME Inc.

3-YEAR CASH FLOW PROJECTION
Month-1
Jul-02
TOTAL CASH IN
TOTAL CASH DISBURSEMENT
Closing Cash Balance (Cummulative)
$0
$0
$0
Month-2
Aug-02
$0
$0
$0
Month-3
Sep-02
$0
$0
$0
Month-4
Oct-02
$0
$0
$0
NOTE: Take a look at your deepest negative number across all the months during the 3year period, or the period for which you would like to be funded for this financial round.
The deepest negative number is the amount you should be seeking from financial
partners. You may want to allow some extra for unforeseen events - suggest a 10% slush
fund in addition to the required funding levels if investors agree to it.
Month-5
Nov-02
$0
$0
$0
Month-6
Dec-02
$0
$0
$0
Month-7
Jan-03
$0
$0
$0
Month-8
Feb-03
$0
$0
$0
Month-9
Mar-03
$0
$0
$0
Month-10
Apr-03
$0
$0
$0
Month-11
May-03
$0
$0
$0
IMPORTANT NOTE: This Summary View Sheet is meant to automatically reflect

what you've put into the "Detailed Cash Flow Projections" Sheet. If you manually
overwrite the fields in this summary, it will no longer automatically update the
fields for you.
Month-12
Jun-03
$0
$0
$0
Total
Year-1
$0
$0
$0
Month-13
Jul-03
$0
$0
$0
Month-14
Aug-03
$0
$0
$0
Month-15
Sep-03
$0
$0
$0
Month-16
Oct-03
$0
$0
$0
Month-17
Nov-03
$0
$0
$0
Month-18
Dec-03
$0
$0
$0
Month-19
Jan-04
$0
$0
$0
Month-20
Feb-04
$0
$0
$0
Month-21
Mar-04
$0
$0
$0
Month-22
Apr-04
$0
$0
$0
Month-23
May-04
$0
$0
$0
Month-24
Jun-04
$0
$0
$0
Total
Year-2
$0
$0
$0
Month-25
Jul-04
$0
$0
$0
Month-26
Aug-04
$0
$0
$0
Month-27
Sep-04
$0
$0
$0
Month-28
Oct-04
$0
$0
$0
Month-29
Nov-04
$0
$0
$0
Month-30
Dec-04
$0
$0
$0
Month-31
Jan-05
$0
$0
$0
Month-32
Feb-05
$0
$0
$0
Month-33
Mar-05
$0
$0
$0
Month-34
Apr-05
$0
$0
$0
Month-35
May-05
$0
$0
$0
Month-36
Jun-05
$0
$0
$0
Total
Year-3
$0
$0
$0

3-Year Cash Flow Projections

Uploaded by

Copyright:

Available Formats

3-Year Cash Flow Projections

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

3-Year Cash Flow Projections

Uploaded by

Copyright:

Available Formats

156277090.xls.

YOUR COMPANY NAME Inc.

Opening Cash Balance

Incidental Loan Repayments

YOUR COMPANY NAME Inc.

IMPORTANT NOTE: This Summary View Sheet is meant to automatically reflect

You might also like