The Interim Controller

Tool Kit

The Interim Controller Tool Kit

Useful files for Management Accountants
 


Budget Planning


Financial Ops Plan (financial forecast)

This Microsoft Excel Financial Operations Plan model has been used in negotiations of over $1.2 billion of venture funding in Silicon Valley. 

The user provides resource-level data input (people, salaries, expenses, equipment, etc) and the model automatically produces a 27 page report consisting of complete financial statements all presented in landscape mode. The model is fully integrated, meaning that all data input to the worksheets affects the cash balance.

The models all use simple Excel configuration, There are no hidden cells, named ranges, protected cells or macros. Just basic MS Excel cell formulas. The models are completely configurable to allow for detailed lists or additional customer schedule construction by the user.

Simplified use - Input cells are identified with either blue text or blue numbers.

three versions of the microsoft excel planning tools are available: 

See a comparison between the Start-up Plan and the Corporate Budgeting Model here.

1 - Short Ops Model - This model is meant to be used for a small company (no departments) with minimal financial reporting needs.

The model can be downloaded for personal use here.

This model is free for personal use.


PLEASE NOTE: The following plans have 2 years (24 months) of schedules for bottoms-up planning. However, these Adobe Acrobat samples only show the first year (12 months) of schedules.


2 - The Start-up Plan - This plan includes an organization chart, headcount, salaries, expenses by department for 4 or 5 departments, equipment, sales/COS, income statement, equity funding and cash balance, all by month for 24 months. Also has a 5 year income statement projection suitable for presentation in a business plan. Has the cash balance chart (money in the bank). This model does not contain a balance sheet or financing options such as personal loan, revolving line of credit, capital lease or operating lease. It does however, provide a month to month cash balance schedule and chart that can be easily understood by financing sources.

An Adobe Acrobat view of this plan is downloadable here.

This model sells for $95 and can be purchased here.

3 - Standard Corporate Budget Model - All-in-one Department

This plan includes a balance sheet and cash flow by month for 24 months, full balance sheet integration of financing options such as a term loan, revolving line of credit, capital lease and operating lease, and full 36 and 60 month asset straight-line deprecation. This plan has all of the components of the Corporate Budget Model below, except all expenses are considered in one group without departments. That is, all expenses are on one expense sheet. Most young companies will find this version more to their liking as it plans at a higher level and does not require department breakouts of expenses.

An Adobe Acrobat view of this plan is downloadable here.

This model sells for $195 and can be purchased here.

4 - Standard Corporate Budget Model - 6 Departments - This plan has all of the components of the Standard Corporate Budget Model with the added feature of 6 Departments.

Included are a balance sheet and cash flow by month for 24 months, full integration of financing options such as a term loan, revolving line of credit, capital lease and operating lease, and full 36 and 60 month asset straight-line deprecation. This version is most often used by existing multi-departmental companies for their annual budgeting processes. This model may require a little more customization for specific uses.

An Adobe Acrobat view of this plan is downloadable here.

This model sells for $195 and can be purchased here.

Also included with the Standard and the Corporate Budget Model (3 and 4 above), is 4 hours of phone consulting time for model modifications, status review at any stage along the way and a final overview for reasonableness. We have completed hundreds of these plans and know what is realistic in terms of a realistic budget.

Technical support and general questions can be called into Ron Johnson at 916-524-3999 (9:00 AM to 5:00 PM Pacific time). A free phone orientation with Ron is recommended prior to beginning the model building process with any of the above models.


Support Schedules


Depreciation Schedule

This is a free Microsoft Excel template.  Registration is not required.  Download here

Technology Valuation

This is a free Microsoft Excel template.  Registration is not required.  Download here

Biotechnology Valuation

This is a free Microsoft Excel template referred to as the rNPV Biotech Valuation Model.  Registration is not required.  Download here.

Medical Device valuation

This is a free Microsoft Excel template.  Registration is not required.  (To be added soon).

Deferred Revenue Schedule

This is a free Microsoft Excel template.  Registration is not required.  Download here.

stock distribution and valuation

This is a free Microsoft Excel template.  Registration is not required.  Download here.


Checklists


IPO Checklist

If you are planning on an initial public offering or a sale/merger down the road, you might want to consider this checklist now rather than later... 

This is a free Microsoft Excel template.  Registration is not required.  Download here

Insurance Checklist

What types of insurances are appropriate for what stage of business growth?  This is a free Microsoft Excel template.  Registration is not required.  Download here.

acquisition strategy document

What kind of detail is required to support a sale or merger of your business?  This is a free Microsoft Word template.  Registration is not required.  Download here