Software for financial planning and cash forecasting

PENDOCK FINANCIAL PLANS (PFP) is a powerful, flexible and fully-integrated financial forecasting model designed to help accounting professionals in public practice and companies prepare complete financial forecasts within a very short timeframe.

The model produces a multitude of financial statements and supporting schedules including the balance sheet, profit & loss account, and statement of cash flows, as well as supporting schedules for trading profit & loss and stocks (if the business involves the sale of goods), operating expenses, interest, banking, debtors, creditors, and cash flow assumptions. In addition, the model prepares an index automatically adjusted to show the statements and schedules included in the forecast.

PFP 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 Pendock Financial Plans simple to use and extremely efficient:

PFP formats the financial statements automatically for virtually any size and type of company- from distributors and manufacturers to retailers and service companies. In addition, since each company is unique, accounts can be added, deleted or changed.

PFP features automatic, presentation quality printing. Reports in Pendock Financial Plans look as if they were done in a word processor.

PFP calculates company or personal taxes automatically. Since U.K. 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 profit & loss accounts for each year, the balance sheets, operating expense 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. PFP automatically creates a budget-to-date report for any budget period. After actuals to date are entered in each report, the model calculates the budget variance in percentages as well as amounts.

Monthly balance sheets. PFP includes monthly and annual balance sheet formats.The annual balance sheet format shows the opening, closing and increase/decreaseamounts from the prior year. The monthly balance sheet format shows 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 debtors 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 stock 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. Schedules can be created showing revenue, direct costs, and if applicable, non-cash charges for each profit center. The schedules consolidate automatically into the profit & loss account.

Where cost schedules are not required, the profit & loss account formats automatically for a service company without cost schedules.

Non-cash charges (eg: depreciation and/or allocated operating expenses) can be shown on each cost of sales/revenue schedule, if required. PFP automatically creates the offsetting credit to the main operating expenses 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.

PFP includes automatic ratio analysis and break-even points, including the ability to add ratios of particular interest to your company. Pendock Financial Plans is so flexible, Excel files created outside the model can be imported and linked directly into it.


Two Versions Available:

Corporate Edition "Standard", Corporate Edition "Plus"

Corporate Edition Standard contains all the features mentioned above. It is compatible with Excel 97 and higher. Corporate Edition Standard is priced at £379. Telephone support is available.

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. These include:

Short Fiscal Periods. Forecasts can be prepared for a period of less than 12 months. CE+ produces profit and loss accounts, overhead schedule, balance sheets,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.

Fixed 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 rates 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 fixed 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 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 profit and loss accounts 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 profit & loss accounts, balance sheets, 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. 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 stocks, as direct costs below the cost of sales line, or can be eliminated. If shown as part of stocks, payment assumptions can be made for the fixed and variable portions.

Corporate Edition Plus is compatible with Excel 97 and higher. It is priced at £399. Telephone support is available.


Telephone Support, System Requirements, and Price:

Since Pendock Financial Plans is so easy to learn and use, telephone support is seldom needed.

PFP Corporate Edition "Standard" is compatible with Excel 97 and higher. It is priced at £379 plus £9 Shipping and Handling.

PFP Corporate Edition "Plus" is compatible with Excel 97 and higher. It is priced at £399 plus £9 Shipping and Handling.

How To Order: Complete the Purchase Form, or telephone us at 0800 967043

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