5 years monthly budget planner spreadsheets - cash forecasting plus options

Excel Spreadsheets: FastPlan PRO 9.0

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

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.

Click to enlarge

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

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

Hiding unwanted rows gives neater presentations.

Hiding unwanted rows gives neater presentations
Click to enlarge

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

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

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.

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
Click to enlarge

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

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

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.

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

Cash Flow forecasts – closing monthly cash.

Cash Flow forecasts – closing monthly cash
Click to enlarge

The five year plan is summarized two ways:

1. Annual Plan Summary Years 1–5.

1. Annual Plan Summary Years 1–5
Click to enlarge

2. Management Report Years 1–5.

2. Management Report Years 1–5
Click to enlarge

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.

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
Click to enlarge

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

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

System Requirements

Excel 2000 or above and MS Windows XP/2000/2003 or later.

Order

30 day money back guarantee!

Additional Information: Fastplan Pro
FastPlan PRO V9.0 – Price: $125.00	Buy Online

This program is supplied also as part of the Gold Disk Edition Colection Business Support Programs for Excel.

30 day money back guarantee!

Additional Information: All Programs Gold Edition
Requires: Excel 2000 or above and Windows XP/2000/2003 or later.	Buy Online $189.95
	Regular Price : 299.95

- ~~$299.95~~ $189.95

More Millennium Software

Business Software

MS Excel Add-ins, Spreadsheets, Templates