Excel Templates: self calculating balance sheets, income and cash flow forecasts

Excel Spreadsheets: FastPlan PRO 9.0 - 2006

Planning Excel Templates

Excel Templates for accounting

FastPlan 9.0 is based on version 7 with the following additions.

FastPlan has been expanded following requests received from customers: (1) asset purchases and depreciation expenses can be entered and adjusted on a month by month basis for 60 months. (2) Note/loan repayment schedules automatically supply monthly repayment balances within the balance sheets. Three Loan Notes monthly repayment schedules have been added. This helps customers using FastPlan to prepare and vary balance sheets projections using loan financing.

FastPlan 9.0 is the latest version (2006) of our popular financial forecasting workbook.

In FastPlan 9.0 you can achieve the following:

With a few simple entries into the 5 years monthly budget planner spreadsheets, generate monthly five year balance sheets, profit & loss schedules and cash flow tables.
The balance sheets always balance! (By cross linking with the source and application of funds spreadsheets, the closing cash balance balances all balance sheet entries which is precisely how real business finances operate).
Vary any unit volume monthly forecast, price and cost of sales and instantly recalculate the monthly and profit & loss forecasts, balance sheets, month end closing cash balances.
Instantly calculate all the key operating ratios.
Instantly calculate times covered quick working capital and inventory levels above or below credit facility covenants or agreed credit limits.
Review the five year plan in one easy report that contains the income forecast, balance sheets and cash flows (source and application of finances).

No accounting knowledge is required.

Sensitivity and Flexibility

The entire set of spreadsheets within FastPlan 9.0 is linked together using Excel's 3-D links. You can change any input variable and all the summary forecasts, balance sheets, working capital and monthly cash balance calculations change in synch.

You can set the currency to any symbol by opening the Format menu in Excel and selecting Cells from the drop down list, which produces the Format Cells table. Click Currency and then choose the currency you want to work with from the Symbol panel.

Five year P-L/balance sheet/cash forecasting plus options to value using EBITDA & Revenue multiples or continuing value after year 5.

Index of pages and spreadsheets:

Index of pages and spreadsheets 1

Additional Information

Easy directions no accounting knowledge is required Monthly P-L forecasts, balance sheets, cash flows and management report calculated from monthly revenue and expense plans, plus business valuation.

You can use open up to fully extended spreadsheets or Hide all unwanted rows.

Hiding unwanted rows gives neater presentations.

You can forecast cost of sales percentage and monthly $ costs by individual revenue streams as well.

Each forecast is composed into a Profit & Loss account summarizing expense categories and allowing for returns or bad debts if you wish to include these possible costs.

Forecast Days Outstanding each year to drive balance sheet calculations and closing cash balances.

You now have all the data entered* for FastPlan to calculate the Balance Sheets and the Cash Flows.

*You need to enter your capital expenditure plans as well, set up your shareholder capital and tell FastPlan if (and by how much) new equity capital your company intends to raise during the life of the plan, if any.

Cash Flow forecasts closing monthly cash.

The five year plan is summarized two ways:

1. Annual Plan Summary Years 15.

2. Management Report Years 15.

Use the forecast in FastPlan to value the business from year 5 using three alternative methods. The continuing value after year 5 is brought forward from the Continuing Value Calc spreadsheet.

Plus Cash Reporting template helps you keep track of cash receipts and payments out on a monthly basis.

New features included: risk analysis - $30.

Please see additional Fastplan Excel spreadsheets