Immediate Bank Presentation Plan

BUSINESS PLAN FINANCIAL SOLUTIONS
Immediate Bank Presentation Plan

Five Year forecasts – balance sheets – income statements – cash flows – bank covenant ratios – seasonality – days sales outstanding – payables and inventory days drivers

Contact us: help@exceltemplates.com

Return to Store

"I may be interested in purchasing and needed to know the following: 1. Is there a limit to the size of a company, e.g., $200.0M in sales, that the software would not accommodate? 2. Will the software allow you to budget on an annual basis for 5 years using days sales outstanding and annual sales growth rates and do the covenants include debt ratios?"

The total annual sales limit is 999,999,999, and YES! Our new version of Bank Presentation Plan software will create your five year monthly & annual profit & loss income forecasts, cash flows, bank forecasts, balance sheets with receivables, inventory, payables balances, fixed asset forecasts and straight line depreciaiton forecasts plus taxation, all created from the very simple starting point of your first year monthly budget and your balance sheet drivers and sales growth rates. Bank covenants calculated include days sales outstanding, return on equity, EBIT/interest, day's sales outstanding, inventory turn, debt ratios etc.

27 integrated financial spreadsheets provide quick neat presentations to give your bank or investors. All figures match and balance automatically. 4.8MB file.

No previous accounting knowledge required. Easy to follow tutorial version.

Immediate Bank Presentation Plan provides:

First year monthly p/l budgets with varying c.o.s % – is your starting base.
Set annual growth rates for all product lines each year.
Edit (if you wish) year 1 fixed and variable expenses per $ sales to calculate years 2–5 expenses.
Set fixed asset budget either by direct entry of plan figures or as % of sales forecast – 5 years.
Generates monthly and annual income statement forecasts – 5 years.
Generates monthly and annual balance sheet forecasts – 5 years.
Generates monthly and annual cash flow forecasts – 5 years.
Generates annual bank/loan covenant balance forecasts – 5 years.

* Ratios include: Annual Current ratios, Quick Ratios, EBIT/Interest. Days Sales Outstanding, Debt Ratio, ROA – ROI – ROIC – Current ratio, Quick Ratio, Debt Ratios.

Plus:

Equity financing monthly plan – 5 years.
Annual Capital purchase plan with option to switch between MACRS or straight line depreciation calculations to make deferred tax calculations easier.
Flexible report layouts, edit sales by product name, expenses, expense categories, balance sheet terms.
A demo program shows you how to use the software to prepare your plan.

Quick plan development

Start by setting up your year one monthly revenues, cost of sales percentages and company expenses, enter projected growth rates for each revenue item plus balance sheet drivers (days sales outstanding, inventory days and receivable days) and this software immediately calculates and presents your yearly budget forecasts, five year profit & loss, balance sheets, cash flows and covenants plan with all balances "balancing" and internally consistent.

The screen below shows a typical budget plan with unwanted rows hidden from view. We explain how you apply Excel tools to hide unwanted rows containing blank (zero) values to create a neat spreadsheet presentation.

Introduce seasonal variations into all your budgets, and vary sales growth rates within each annual forecast.

Year 1 budget

Year 2 budget

Enter your Cash Cycle Days to drive balance sheets. Quick calculation of working capital requirements.

Enter your fixed asset budget plan using either method. Direct entry or as percentage of sales.

Fixed asset plan

Automatically generates monthly profit/loss for years 1–5. (The expense headings are your choice). Tax rates, bad debts, exceptional items, and dividends all enter directly into these forecasts.

Automatically generates monthly balance sheets for years 1–5. Month end bank balances forecasts. (The balance sheet terms can be edited). Select straight line or MACRS depreciation (for deferred tax calc).

Year 1 income
Year 2 balance sheets

Automatically generates monthly cash flow forecasts.

Year 1 cash flow forecasts

5 year annual profit & loss forecast summary.

5 year annual balance sheet forecasts summary.

Annual plan

5 year Cash flow forecasts summary.

Annual closing bank balances forecast summary.

Annual plan

5 year key operating results forecasts.

Year end bank covenants forecasts.

Create additional covenant forecasts.

Additional covenants

Back to top

Enter your Cash Cycle Days to drive balance sheets. Quick calculation of working capital requirements.		Enter your fixed asset budget plan using either method. Direct entry or as percentage of sales.

Automatically generates monthly profit/loss for years 1–5. (The expense headings are your choice). Tax rates, bad debts, exceptional items, and dividends all enter directly into these forecasts.		Automatically generates monthly balance sheets for years 1–5. Month end bank balances forecasts. (The balance sheet terms can be edited). Select straight line or MACRS depreciation (for deferred tax calc).

5 year annual profit & loss forecast summary.		5 year annual balance sheet forecasts summary.

5 year Cash flow forecasts summary.		Annual closing bank balances forecast summary.

5 year key operating results forecasts.		Year end bank covenants forecasts.