10 Year Budget Forecasting in Excel

FUNDING PLAN 10 years

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).

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.

Read More

Home