Constantine Ventures
Constantine Ventures Home
Home About Us Contact Information
Constantine Ventures
CFO Support SIte

All Products
Back to Category Name

Download Business Tools
NEW! Integrated Financial Plan For Your Business Plan - 12 months
Updated: 02/03/2004

Format: MS Excel

This program integrates your P&L, Balance Sheet and Cash Flow statements. There are three spreadsheets contained in this program, one for your P&L statement, one for your Balance Sheet, and one for your Cash Flow Statement. All you need to do is input your P&L information, select Balance Sheet items, along with five additional informational requirements.

Software Notes:

Software Notes:

1) General information for all spreadsheets: Input your financial data into the blue highlighted cells. The black highlighted cells are calculated cells. We have protected these cells so you cannot inadvertently change a formula. If you do wish to change a formula or cell format in order to customize this spreadsheet to your business, simply click off the cell protection feature of your EXCEL software. Once saved, any changes you make to the program will be final.

2) Begin by inputting your P&L information into the spreadsheet labelled "Income Statement". An example has been provided for you. Be sure to input your company-specific information into the blue highlighted cells.

3) Next proceed to the spreadsheet labelled "Balance Sheet". There are two areas on this spreadsheet for you to enter information; 1) the blue highlighted cells within the Balance Sheet and 2) the blue highlighted items starting below Row 76 "Additional Input Requirements".

Please note that "Cash" has been selected as the "plug" to insure that your Balance Sheet
balances. By selecting cash as the plug, you will know approximately how much cash is
required to support your financial statement assumptions. Again, an example has been
provided for you.

4) Once you have completed steps 2 and 3, the Cash Flow Statement will automatically
calculate for you.