Excel Templates: 10 Year Budget Forecasting in Excel

10 Year Budget Forecasting in Excel

Funding Plan PRO for Excel provides the perfect financial planner for any 10 year projection.

You need no accounting knowledge, Funding Plan provides ready made templates to create the profit/loss forecasts, balance sheets, cash flows, loan repayment schedules and the overall summary from your starting ten year projections in very professional looking presentations.

You can use Funding Plan PRO as a quick financial modeller of your business.

Variables can be adjusted anyway you want and as you know Excel will translate any input change instantly into the appropriate outcome.

You start with an empty sequence of a family of connected financial plan templates. Each input template provides monthly forecasts covering any ten year period, starting any month or year. The sequence of spreadsheets include the following:

Monthly equity plan (Common share issues & financing).
3 Loan notes (Loan finance).
Monthly Fixed asset schedules.
Five depreciation classes (any useful life periods from zero upwards).
Sales plan incorporating unit volume projections (any types of units), price per product and cost of sales per product. You can vary volumes and prices by any percentage value control to produce best case, expected case and worst case projections.
Company expenses - straightforward monthly expense templates. Expenses are divided into six separate categories (Personnel, G&A, Marketing.....). Category expenses are summarized in the P/L schedules. You can change the category title headers any way you want.
Working capital variables include Days sales outstanding, Days inventories outstanding, Percentage payable to sales. You can change any assumption to produce best, expected and worst cases again.
Your inputs are instantly converted into monthly income (proft/loss) statement forecasts. Each annual forecast contains federal and state tax rate assumptions, dividends, exceptional expenditures and financing costs (if any).

Your inputs are converted into monthly balance sheets covering the ten year period.

Your inputs are converted into monthly cash flows covering the ten year period. Cash flow projections are divided into operating cash generated, investment capital expenditures and financing capital.

The overall summary collects all your the key inputs and outputs forecasts as a 10 year summary of Prices, Yields and COS, Sales, Operating margins and Company expenses, Gross margins, EBITDA, Break even sales revenue, year end Receivable, Payable and Inventories, year end loan balances, free cash flows, year end cash positions and company value based on EBITDA multiples.

All spreadsheet pages are optimized for printing and presentation in landscape.

GUIDE TO FUNDING PLAN 10

Funding Plan 10 provides you with ready to use templates to set up all the basic information needed to generate a 10 year financial plan/forecast.

Review the screen images to look through the templates to enter sales volumes (unit forecasts), product prices, product yields (if required), cost of sales, variance percentages, direct expenses, fixed asset purchase plans, shareholder investments, loan terms, days of sales and inventories outstanding.

Funding Plan 10 PRO turns your basic financial forecast data into properly presented income forecasts, balance sheets, cash flows, closing cash balances and loan repayment schedules.

Calculations that often give non financial folks big headaches, like cumulative depreciation, loan interest, reducing loan balances, receivable, payable balances and shareholder reserves are all handled by Funding Plan PRO to give you a neat financial plan package that you can print on one page for each schedule.

Templates that do positively require input of basic forecasting data have red cells at the top left hand (A1), like the one on this page.

If there is no red cell at A1, there is no need to enter data. (There are some cells on these pages that you might want to enter data, though you don't have to).

New Features

Several users in North America have asked for a Euro version because they were raising finance in London UK. We have added a Euro version of our Fundng Plan PRO 10 Year Plan for Excel into the zip file you will be able to download immediately after your order.

Output presentations are:

The income plans
The balance sheets
Cash Flow plans and closing cash balances
The loan interest and balances due schedules
The Plan Summary

With Funding Plan you have no need to incur the expense of hiring an accountant to create your complete financial plan forecast. FundingPlan handles all the accounting stuff for you.

There are 8 INPUT modules

Module	Function
Set Up	Enter the starting date of the plan and your business name.	All pages
Equity plan	Enter your (owners) equity in the top left table and investors equity in the larger table.	Balance sheets
Fixed Assets plan	Enter the fixed asset plan and up to four separate depreciation lives.	Balance sheets/Cash flows/Income plan
Sales plan	Enter units, unit prices and yield. You can vary prices and yields to produce differeing plans.	Income plans/Cash flows
Cost of sales plan	Enter unit cost of sales. You can vary cost of sales by changing the variance percentages.	Income plans
Fixed expenses	Three fixed expense schedules for year 1, years 2-3 and years 4-10.	Income plans
Working capital (drivers)	Enter the sales days, inventory days outstanding and payable percentage of sales	Balance sheets
Loan amortization	Enter the loan principal, interest rate and term, and the number of months holiday.	Loan interest & balances

The SUMMARY outputs the key assumptions, variances and results from the 10 year plan.

* (The loan amortization schedule is too large to print on one page).

There are two versions of Funding Plan PRO at the present time, the Dollar version and Euro version. Please ask if you need the Euro version, or any other currency format.

Screenshots

Funding Plan 10 helps you prepare a professional financial plan incorporating alternative scenarios. You can vary a base forecast using variance percentages and recalculate several possible outcomes.

Plan/Forecast Excel Template View

Plan Summary

Input

SHAREHOLDER CAPITAL PLAN

FIXED ASSETS PLAN & DEPRECIATION CALCS

SALES PLAN WITH VOLUME, PRICE AND YIELD VARIATIONS

COST OF SALES PLAN

COMPANY EXPENSE PLAN

WORKING CAPITAL VARIABLES PLAN

LOAN FINANCE - PAYMENT PLAN

Output

INCOME FORECASTS - YEARS 1-10

BALANCE SHEET SCHEDULES YEARS 1-10

CASH FLOW SCHEDULES YEARS 1-10

LOAN BALANCES YEARS 1-10

LOAN INTEREST YEARS 1-10

SUMMARY PLAN YEARS 1-10

This program is supplied as a part of the Complete Edition of Business Support Programs.

More Millennium Software

System Requirements

Platform : Windows or Mac & MS Excel97/Excel 2000/Excel XP/Excel 2002/Excel 2003 or MS Office 97 or later.

Order

You will be able to download this product immediately after your order

30 day money back guarantee!

All Our Financial Excel Templates

Additional Information: Financial Excel All Programs Complete Edition
OS : Windows 95, 98, ME, NT/2000 or XP Excel 97 or later. Web data requires Excel 2000 or above and Windows XP/2000/2003 or later.	Buy Online $189.95
	Regular Price : 299.95

- ~~$299.95~~ $189.95

Additional Information: Funding Plan PRO 10 Year Plan for Excel
OS : Windows 95, 98, ME, NT/2000 or XP Excel 97 or later. Web data requires Excel 2000 or above and Windows XP/2000/2003 or later.	Buy Online $139.95