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.