Useful files for Management Accountants
Budget Planning
Financial Ops Plans
These are the models referenced in the book; “Principles for a Successful Tech Start-up Company with Little or No Money”. The models all use simple Excel configuration, There are no hidden cells, named ranges, protected cells or macros. Just basic Microsoft 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.
full operATING PLAN - VERSION 5.0
This Microsoft Excel Operating/Financial Plan model has been used in negotiations of over $1.2 billion of venture funding in Silicon Valley. This model requires a bit of accounting background. So if you are unfamiliar with financial statements, it will be best to enroll someone with accounting knowledge.
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.
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.
Short OperatiNG PLAN
This is the model referenced in the book; “Principles for a Successful Tech Start-up Company with Little or No Money”. This model is meant to be used for a small company with minimal financial reporting needs.
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.
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
Equity planning and Milestones
This is a free Microsoft Excel template that provides for planning your company milestones and relates these milestones to stock value.
(Values in this worksheet are placeholders only and are not suggestive of a valid Equity plan). Registration is not required. Download here.