Corporate budgeting & financial forecasting software
Pro-formas For Professionals (PFP) is a powerful, flexible and fully-integrated model. It is designed to help accounting professionals in public practice and companies prepare complete financial forecasts and budgets within a very short timeframe.
The model produces a multitude of financial statements and supporting schedules including the balance sheet, income statement, and statement of cash flows, as well as supporting schedules for cost of sales and inventory (if the business involves the sale of goods), overheads, banking, accounts receivable, accounts payable, and cash flow assumptions. In addition, the model prepares an index automatically adjusted to show the statements and schedules included in the forecast.
PFP complies fully with AICPA guidelines related to prospective financial statements.
Pro-formas For Professionals was created within a spreadsheet environment to ensure maximum flexibility and provide a sense of immediate familiarity. Only a basic spreadsheet knowledge is required to run the model: all spreadsheet commands have been automated, all formulas are included and accessible, and all statements are integrated. With PFP, you can work with confidence.
Key Features
Whether you're preparing banking presentations, budgets or business plans, a host of features make Pro-forma Plus simple to use and extremely efficient:
PFP formats the financial statements automatically for any size and type of company -from distributors, manufacturers, and retailers to service companies. (In addition, since each company is unique, accounts can be added, deleted or changed.)
PFP features automatic, presentation quality printing, including an automatic "print-to-fit" option when printing legal-size reports on letter-size paper.
PFP calculates federal, state and local taxes automatically. Since tax formulas are used in the program, instead of a tax table, you don't have to come back to us for updates every time tax rates change.
Interest expense and interest income calculations are automatic. Enter the interest rates for loans and if applicable, surplus cash above a pre-set cushion. The model does the rest.
Loan balances are automatically monitored and updated. If cash flows are positive in any month and if there is a loan balance, the loan will be paid down to the lower of available cash or the outstanding balance. Conversely, if cash flows are negative, the model will automatically borrow. Minimum balance requirements, if applicable, are respected. PFP calculates bank credit lines and predicts collateral shortfalls, if any. This means financing proposals can be submitted knowing the bank's requirements beforehand - not finding out after the submission has been made.
PFP creates amortization schedules automatically for an unlimited number of long-term loans - existing and proposed. Loan proceeds and repayments are posted automatically to the appropriate statements and schedules. PFP also calculates and records the current and deferred portions on the balance sheet.
PFP contains a powerful, multi-year forecasting capability. Forecasts can be created in monthly detail for as many years as required (balance sheets are carried forward automatically each year), then automatically summarized in a comparative annual format. The summaries include the balance sheets for each year, income statements, overhead schedules, cash flow schedules, ratio analysis, and an index.
Full cell protection. Cells containing formulas cannot be accidently over-written - although they can be accessed if editing or viewing is required.
Variance analysis. This powerful management tool can be used to update forecasts as actuals become known. The model automatically creates a budget-to-date report for any budget period. After actuals to date are entered in each report, PFP calculates the budget variance in percentages as well as amounts.
Monthly balance sheets. The model includes monthly and annual balance sheet formats. The annual balance sheet format displays the opening, closing and increase/decrease amounts from the prior year. The monthly balance sheet format displays the opening and monthly amounts for 12 months.
Both balance sheet formats (annual and monthly) can be included in the forecast presentation.
Cash flow assumptions for the collection of accounts receivable can be made for each product line or service. Collection assumptions do not have to be averaged over different profit centers. The Projected Cash Flow Schedule shows cash flow receipts for each product line or service.
Cash flow assumptions can be made for each product line for the payment of regular and seasonal/special inventory purchases. Similar to the collection feature, payment assumptions do not have to be averaged over different profit centers.
Cost of revenue schedules can be created for a service company. Up to seven schedules can be created showing revenue, direct costs, and if applicable, non-cash charges. The cost of revenue schedules consolidate automatically into the income statement.
Where cost schedules are not required, the income statement formats automatically for a service company without cost schedules.
Non-cash charges (eg: depreciation and/or allocated overheads) can be shown on each cost of sales/revenue schedule, if required. PFP automatically creates the offsetting credit to the main overhead schedule.
PFP calculates "what-if's" instantly. Create best, expected, and worst case scenarios. Since the model is fully integrated, areas impacted by a "what-if" are updated immediately. With PFP's automatic split-screen option, you can do "what-if's" in one screen and see the impact in the other.
Pro-formas For Professionals includes automatic ratio analysis and break-even points, including the ability to add ratios of particular interest to your company.
PFP is so flexible and robust, Excel files created outside the model can be imported and linked directly into it.
Three Versions Available:
Corporate Edition "Standard", Corporate Edition "Plus" and "Modula Edition".
Corporate Edition Standard contains all the features mentioned above. It is compatible with Excel 97 through to Excel 2003. Corporate Edition Standard is priced at $599.
Corporate Edition Plus (CE+) will help fine-tune the most demanding financial forecast and budget. Corporate Edition Plus retains all of the features of Corporate Edition Standard and adds a multitude of new features. CE+ is available in three versions - Silver, Gold and Platinum:
Silver:
PDF file creation is a fully automatic, simple point and click process. CE+ ships with the necessary .pdf software.
Double click navigation. Navigation in CE+ couldn't be easier - just doubleclick anywhere.
Short Fiscal Periods. Forecasts can be prepared for a period of less than 12 months. CE+ produces the balance sheets, income statements, overhead schedule, cash flow schedule, cash flow assumptions and an index.
Expense and Sales Details. Separate sheets provide complete budget details for each expense and sales item. For example, salaries can be shown for each individual with the totals linked automatically to the overhead schedule.
As much detail as necessary can be entered along with narrative commentary and the comparative to prior year numbers.
If the details are not required, the overhead account(s) can be instantly reformatted to remove the link.
Capital Asset Budget. A separate sheet is available for proposed capital asset purchases. Calculation of amortization (depreciation) is fully automatic including an option for the half year rule and can be based on the declining balance or straight line for each class.
Purchases and amortization are linked to the cash flow disbursements schedule and the non-cash section of the overhead schedule respectively.
The capital asset budget sheet includes a section to calculate expected ROI on proposed acquisitions using the discounted cash flow method.
Full Year Variance Analysis. The variance analysis section includes a projected variance for the full year as well as the year to date. Each of the remaining months can be recast while the original budget is retained.
Statement of Changes in Financial Position. In addition to the cash flow schedule, a new statement of changes in financial position has been created. Details of cash flows from operations, investments, financing activities and details of changes in non-cash working capital items is produced automatically.
Business Valuation Calculations. Cash flows from operations are picked up automatically from each year's statement of changes in financial position and discounted to present values after the necessary adjustments have been entered.
Historical income statements for up to 12 years are converted to current values using CPI where the current year is converted automatically to 100. As many adjustments as necessary can be entered.
An adjustable valuation range showing the high and low ranges is created automatically. Ranges are based on each of weighted and simple averages at plus or minus 10%. An alternative range can be entered manually.
Similarly, historical balance sheets for up to 12 years can be entered. Adjustments to the current year for fair market value of capital and other assets can be made along with adjustments for surplus assets, etc. The ratio of the range of maintainable earnings to adjusted equity is calculated automatically along with working capital and debt to equity ratios. User-defined ratios can also be entered.
Consolidations. Up to 15 entities can be consolidated. The consolidation includes the balance sheets, income statements, overhead schedules, and cash flow schedules. Features include eliminations, automatic currency conversion and the ability to realign accounts for dissimilar entities.
When consolidated budgets are prepared for more than one year, a multi-year summary of consolidated results can be created automatically.
File Saving: If you're in public practice, you'll find saving PFP files to your client's directory is simply a matter of specifying the drive letter and directory name. And if the directory does not exist, PFP can create it. It's that easy!
Long Term Loans Receivable: Corporate Edition Plus provides for an unlimited number of long term loans receivable, with an automatic allocation between the current and deferred portions.
Factory Overheads: For manufacturers, factory overheads can be shown as part of inventory, as direct costs below the cost of sales line, or can be eliminated. If shown as part of inventory costs, payment assumptions can be made for the fixed and variable portions.
Gold:
The Gold version includes all of the features in the Silver version and adds two powerful features:
1. Download income and expense numbers from any accounting program that can export to Excel. This feature means actual-to-date numbers are entered automatically when updating the variance analysis.
2. Create Five Years Historical Analysis. This powerful feature compares up to five years historical data (which is automatically downloaded into PFP), creates a trend line for each item, and compares this to the corresponding item in the budget for the coming year. The analysis includes each profit centre, the income statement and overhead schedule and includes percentages as well as amounts.
Platinum:
The Platinum version includes all of the features of the Gold version and adds Business Planning.
Whether you are with a company or in public practice, the Platinum version of PFP is designed to take you through the planning process easily and expertly. You'll see the steps involved in setting up the initial plan, articulating the strategies, and activating the review process. You'll see how PFP makes a complex process simple. The only requirement from you is the desire to grow and do better.
The Platinum version can be used for start-ups or established companies for financing proposals or for ongoing business planning.
Word 2000 or higher is recommended (in addition to Excel).
Pricing: Corporate Edition Plus is priced at $899 for the Silver version, $1199 for Gold and and $1,499 for Platinum. Corporate Edition Plus is compatible with Excel 97 through to Excel 2007.
Modula Edition is our most powerful version.
It is designed for organizations which need the ability to collect and consolidate budgets from many different divisions or profit centres. Modula Edition retains all of the features in Corporate Edition Plus and is available in three versions - Silver, Gold, and Platinum.
Silver:
Operating Budgets: Modula Edition's operating budget module can be distributed to operating department managers for direct completion. The consolidation hierarcy has been designed so that you can create as many operating budgets as you need.
Having each manager complete their own budget electronically means the annual budget process is shortened considerably. Changes are done in seconds and mathematical accuracy is a given. Next year's budget process is even faster since the prior year numbers just need updating.
Since number crunching is no longer a time-consuming process, managers can devote more time to the strategic elements of the budget preparation exercise.
Administrative Budgets: Modula Edition includes an option to create up to 12 administrative departmental budgets directly by each department manager with full details provided for each budget item. If more than 12 budgets are required, a simple work-around can be used.
The administrative budget modules can be used for all or some administrative departments and can be distributed in the same manner as the operating budget modules. This module can also be used to prepare administrative budgets for operating department expenses.
Consolidations: Up to 30 companies can be consolidated.
Up to four consolidated companies can be further consolidated.
Gold:
The Gold version includes all of the features in the Silver version and adds three powerful features:
1. Download income and expense numbers from any accounting program that can export to Excel. This feature means actual-to-date numbers are entered automatically when updating the variance analysis.
2. Create Five Years Historical Analysis. This powerful feature compares up to five years historical data (which is automatically downloaded into PFP), creates a trend line for each item, and compares this to the corresponding item in the budget for the coming year. The analysis includes each profit centre, the income statement and overhead schedule and includes percentages as well as amounts.
3. Quarterly Reports. Budgets for every profit and support centre is shown in quarterly comparative format (with totals for the year and year to date) for the original budget, actual to date, and revised budget.
Platinum:
The Platinum version includes all of the features of the Gold version and adds Business Planning.
Whether you are with a company or in public practice, the Platinum version of PFP is designed to take you through the planning process easily and expertly. You'll see the steps involved in setting up the initial plan, articulating the strategies, and activating the review process. You'll see how PFP makes a complex process simple. The only requirement from you is the desire to grow and do better.
The Platinum version can be used for start-ups or established companies for financing proposals or for ongoing business planning.
Word 2000 or higher is recommended (in addition to Excel).
Pricing: Modula Edition is priced at $1599 for the Silver version, $1799 for Gold, and $2,199 for Platinum. Modula Edition is compatible with Excel 97 through to Excel 2007.
Support, System Requirements, and Price:
Priority Support is available for $275 annually. The Priority Support Plan includes unlimited telephone support using our toll-free 800 number, updates within the same version of PFP as they become available, and repairs to damaged files.
Non-priority support is available by fax or email at no charge. Support requests will be handled within 36 to 48 hours.
PFP Corporate Edition "Standard" is compatible with Excel 97 through to Excel 2003. It is priced at $599 plus $25 shipping throughout the USA. All orders are shipped by overnight Federal Express.
PFP Corporate Edition "Plus" is compatible with Excel 97 through to Excel 2003. It is priced at $899 for the Silver version, $1199 for the Gold version, and $1499 for the Platinum version, plus $25 shipping throughout the USA. All orders are shipped by overnight Federal Express.
PFP Modula Edition is compatible with Excel 97 through to Excel 2003. It is priced at $1599 for the Silver version, $1799 for the Gold version, and $2199 for the Platinum version, plus $25 shipping throughout the USA. All orders are shipped by overnight Federal Express.
All orders are shipped by FedEx the same day we receive them. We accept Visa, Mastercard, Amex and cheques
How To Order: Complete the Purchase Form or telephone us at (800)567-4500