JaxWorks
Provides all kinds of financial templates and even provides some
excellent tutorials on Excel. A site well worth your time to visit.
Corporate Training Partners doesn't offer many, but
the ones they do are excellent templates
to help accomplish the following tasks:
-
Monthly Sales Forecast that reflect trends and seasonabilty of sales-my favorite
-
Price Analysis that provides estimates that aid in maximizing
gross revenue and margins
-
Statistical Tool that charts a time series of numbers and calculates
and charts the average and +/- 3 standard deviations
-
Net Present Value calculation that incorporates the time value of money in
its calculation
Matt H Evans, CPA
Provides a variety of financial templates that aid in accomplishing many different
types of business tasks.
Business Tools Organization
Provides an excellent ratio analysis spreadsheet, mini-tutorial, and explanations
of how to calculate ratios and what they mean. Also has a pretty good
break-even analysis tool.
Mortgage-Investment
Excellent Mortgage and Other Templates
OzGrid-Excel Information
An excellent Excel site with
free and pay for services is Ozgrid.
OzGrid's main business focus is Microsoft Excel ® and
all aspects of it.
Their site has over 4000 pages (and growing) of information on Excel.
Microsoft Templates
Microsoft also provides free business templates that
you might want to check out.
SCORE
Score provides quite a few free templates that might just be what you're looking for.
PlanWare is an excellent site that provides a free Business Plan Guide & Template-Free-Plan
and a 6 month Business Financial Planner-Exl-Plan and 6 month Cash Forecast-Cash Planner.
Free-Plan is a Microsoft Word document and
Exl-Plan and Cash-Plan are a Microsoft Excel templates.
Their site also has some excllent
checklists and guides and free on-line business tools.
Bean Counter's Cash Forecasting Workbook
Need help managing your cash ?
For many small businesses, a good spreadsheet template is a good place to start. The template normally has
an input area(s) where you enter basic financial information about your business usually from your financial statements. You
also enter information such as your selling terms (credit terms to your customers) and payment terms to your suppliers.
After entering your basic financial information, the spreadsheet performs the necessary calculations and provides you with an estimated
cash forecast (projection). An added benefit, is that you can play what if with this business tool by changing your assumptions
and see the results in a new calculated cash forecast. This is not a bad solution for those comfortable with using a spreadsheet
program such as Excel.
For those individuals and businesses that feel more comfortable using a spreadsheet, I have developed just
the solution for you - my Bean Counter Cash Forecasting Workbook. This Excel Template is designed to be simple, yet
powerful enough to perform the calculations that make the job of preparing a cash forecast hassle free.
See for yourself what Bean Counter's Cash Forecasting Workbook looks like and provides.
Sample of Bean Counter's Cash Forecasting Workbook
Note: This may take a little while to load and display on your computer. After the workbook displays click the links that
appear on the bottom of the pages
to see the different sections that make up the contents of my workbook.
If this is the right solution for your cash forecasting
needs you can get it for free compliments of Bean Counter.
BC's Free Excel Cash Forecast Template
Need help Understanding how to use Excel ? Try out my recommended free Excel Tutorials.
Free Excel Tutorials
