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:

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


buy.gif (540 bytes)  - $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


More Millennium Software

Business & Finance

Material Resources Planning Systems    Accounting  Amortization   Business    Business Plan Automation   Finance 

  Info Managers   Inventory Systems  Bar Code Fonts   Legal    Planners/Schedulers   Presentation Tools

  Project Management   Internet Marketing

Management Systems (  

Contact  Management    Document   Management   Sales Management

Real Estate   Vehicles   Venture Capital

Business Using Mail, Phone, or Email

Publishing     Gem Management    Rental   Repair   Travel  )

  Software for MS Excel (Accounting    Analysis     Budgeting     Calculators    Cars      Charting     Checks      Converters      E-Books     Finance     Forecasting    Employment      Inventory        Investment        Management    Marketing   Planners       Project Management      Quality Control    Schedulers )

Business Software

MS Excel Add-ins, Spreadsheets, Templates

Copyright © Millennium Software All Rights Reserved