Financial Modeling Tips
A sound financial model and projection is one of the core ingredients of a venture capital business plan.
Here are some thoughts on how to do it right:
- Keep it real. Don't overstate sales projections. It is a common enough mistake to make because human nature says we want to put the best case forward. The solution os to have various scenarios, assign some probabilities, and tell an investor honestly what needs to happen to reach the targets.
- State the assumptions clearly in the projection, so the investor knows what it is based on.
- Make it easy to adjust and show the consequences - what if sales are lower, what if churn is higher, what if our costs decrease, what if our main customer leaves? Investors are a (justifiably) cynical bunch, so you need to be able to lay out a best case and a worst case scenario.
- Show the effect of growth on cash flow. As sales increase, what is the increased need for further capital. This will show an investor not only how much they'll need to put in, but when.
- If you don't know something, that is OK. Explain the gap in the knowledge and either how you'll get the knowledge, or its likely impact if you don't. If you claim to know everything, it'll be clear you are not being honest.
- Focus on readability - it's easy to get wrapped up in the complexity of your own spreadsheet and end up with a wall of numbers which is incomprehensible. KISS. Use clear labels, colour code, space, and remove less material variations (put them elsewhere). Separate inputs and variables from calculations - so the user can see what they can adjust.
- Get in a pro. You may be surprised by what you can achieve in Excel. For a small investment (a few hundred to a few thousand dollars) you can may build something which wins over an investor. Remember the quality of the brief to the programmer may have a major impact to the success don't assume they know anything about your industry. Explain everything.
- GIGO. Get good input figures.
Consider all of these factors in your financial model and use them to build a comprehensive growth capital business plan.
Here are some thoughts on how to do it right:
- Keep it real. Don't overstate sales projections. It is a common enough mistake to make because human nature says we want to put the best case forward. The solution os to have various scenarios, assign some probabilities, and tell an investor honestly what needs to happen to reach the targets.
- State the assumptions clearly in the projection, so the investor knows what it is based on.
- Make it easy to adjust and show the consequences - what if sales are lower, what if churn is higher, what if our costs decrease, what if our main customer leaves? Investors are a (justifiably) cynical bunch, so you need to be able to lay out a best case and a worst case scenario.
- Show the effect of growth on cash flow. As sales increase, what is the increased need for further capital. This will show an investor not only how much they'll need to put in, but when.
- If you don't know something, that is OK. Explain the gap in the knowledge and either how you'll get the knowledge, or its likely impact if you don't. If you claim to know everything, it'll be clear you are not being honest.
- Focus on readability - it's easy to get wrapped up in the complexity of your own spreadsheet and end up with a wall of numbers which is incomprehensible. KISS. Use clear labels, colour code, space, and remove less material variations (put them elsewhere). Separate inputs and variables from calculations - so the user can see what they can adjust.
- Get in a pro. You may be surprised by what you can achieve in Excel. For a small investment (a few hundred to a few thousand dollars) you can may build something which wins over an investor. Remember the quality of the brief to the programmer may have a major impact to the success don't assume they know anything about your industry. Explain everything.
- GIGO. Get good input figures.
Consider all of these factors in your financial model and use them to build a comprehensive growth capital business plan.
