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 is most often used by corporate start-up companies. Schedules include 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 $295 and can be purchased here.

3 - Corporate Budget Model - This plan has all of the components of the standard plan, but includes 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. Though integration is automatic, users should be knowledgeable in how the income statement, balance sheet and cash flow integrate.

An Adobe Acrobat view of this plan is downloadable here.

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

Also included with the Corporate Budget Model, 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