Financial forecasting & budgeting software for accountants

PRO-FORMA PLUS (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.

Pro-forma Plus 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:Pro-forma Plus 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.)

Pro-forma Plus features automatic, presentation quality printing, including an automatic "print-to-fit" option when printing legal-size reports on letter-size paper.

Pro-forma Plus calculates company taxes automatically. Since Australian 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.

Pro-forma Plus 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.

Pro-forma Plus creates amortization schedules automatically for an unlimited number of long-term loans (Payable and Receivable) - 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.

Pro-forma Plus 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.

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.

Pro-forma Plus 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-forma Plus includes automatic ratio analysis and break-even points, including the ability to add ratios of particular interest to your company.

PDF file creation is a fully automatic, simple point and click process. PFP ships with the necessary .pdf software.

Double click navigation. Navigation couldn't be easier - just doubleclick anywhere.

Short Fiscal Periods. Forecasts can be prepared for a period of less than 12 months. The model 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 half year amortization in the year of acquisition 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 statement of changes in financial position is included. 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!

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.

PFP is so flexible and robust, Excel files created outside the model can be imported and linked directly into it.

Two Series Available:
"Corporate Edition Plus" and "Modula Edition".

Corporate Edition Plus is available in two versions - Silver and Gold:
Silver: Contains all the features mentioned above.
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.

Pricing: Corporate Edition Plus is priced at $799 for the Silver version and $999 for the Gold. 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 two versions - Silver and Gold.

Silver:
Operating Budgets: Modula Edition's operating budget module can be distributed to operating department managers for direct completion. The consolidation hierarchy 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.

Pricing: Modula Edition is priced at $1199 for the Silver version and $1499 for the Gold. Telephone support is toll free. Modula Edition is compatible with Excel 97 through to Excel 2007.

Support, System Requirements, and Price:

Since Pro Forma Plus is so easy to learn and use, support is seldom needed. But when you do, just send an email to support@pendock.com

PFP Corporate Edition "Plus" is compatible with Excel 97 through to Excel 2007. It is priced at $799 for the Silver version and $999 for the Gold version, plus $25 shipping throughout Australia. All orders are shipped by overnight Federal Express.

PFP Modula Edition is compatible with Excel 97 through to Excel 2007. It is priced at $1,199 for the Silver version and $1,499 for the Gold version, plus $25 shipping throughout Australia. All orders are shipped by overnight Federal Express.

How to Order: Click on Purchase Form and complete the order form.

All orders are shipped by FedEx the same day we receive them. We accept Visa, Mastercard, Amex and cheques