Iโve seen beautiful financial models, so full of colors, charts, and diagrams... only to uncover wrong data and misleading conclusions.
Accurate financial models can be incredibly insightful for making long-term decisions, budgeting for scale, and safely testing ideas.
You have to decide the investment and value for your financial model. Here are some thoughts.
๐๐ผ๐ป๐๐๐ฟ๐๐ฐ๐๐ถ๐ป๐ด ๐๐ต๐ฒ ๐ ๐ผ๐ฑ๐ฒ๐น ๐
To build anything, you need a strong foundation.
๐๐ต๐ข๐ณ๐ต ๐ธ๐ช๐ต๐ฉ ๐๐ค๐ค๐ถ๐ณ๐ข๐ค๐บ. A useful financial model depends on strong bookkeeping. Base expenses on known costs and expected increases. Ground sales forecasts in realistic experience.
๐๐ฏ๐ค๐ญ๐ถ๐ฅ๐ฆ ๐ด๐ฐ๐ฎ๐ฆ ๐๐ถ๐ด๐ฉ๐ช๐ฐ๐ฏ. To get the most value from a model, underestimate revenues and overestimate expenses. Also include a 5-10% contingency for unexpected circumstances.
๐๐ถ๐ช๐ญ๐ฅ ๐๐ฐ๐ฏ๐ด๐ฆ๐ฏ๐ด๐ถ๐ด. Share the model with leadership and team to get valuable feedback and to set expectations on budgets and results.
๐ ๐ฎ๐ป๐ฎ๐ด๐ฒ๐บ๐ฒ๐ป๐ ๐๐ถ๐๐ฐ๐๐๐๐ถ๐ผ๐ป ๐
To inform decisions, here are some considerations:
ยท Evaluate spend in terms of investment. Think about how costs will impact revenues, save money or time later, and best help you grow.
ยท Transparency is valuable. Informed employees are more likely to be mindful of ways to increase revenues and reduce expenses.
ยท Build a model for you. While investors and other outsiders may demand the model, its primary purpose is for your planning.
๐๐บ๐ฝ๐น๐ผ๐๐ฒ๐ฒ ๐๐น๐ถ๐ด๐ป๐บ๐ฒ๐ป๐ ๐
Share responsibility for success with the whole team.
๐๐ถ๐จ๐จ๐ฆ๐ด๐ต๐ช๐ฐ๐ฏ๐ด. Ask employees for ways to improve and reward results by announcing wins and offering a one-time bonus for cost-cutting.
๐๐ฏ๐จ๐ข๐จ๐ฆ๐ฎ๐ฆ๐ฏ๐ต. Require managers justify all expenses for each budget. Review existing software and services to ensure their necessity.
๐๐ข๐ญ๐ถ๐ฆ. Allow for drastically increasing a budget if the additional spend will show significant benefit or resiliency in the future.
๐ฆ๐ฐ๐ฒ๐ป๐ฎ๐ฟ๐ถ๐ผ ๐ฃ๐น๐ฎ๐ป๐ป๐ถ๐ป๐ด ๐
Start with the expected forecast and then build at least two more models based on expedited and reduced revenue growth.
"๐ฐ๐ ๐๐๐๐๐๐๐๐๐ ๐๐๐ ๐๐๐๐๐๐, ๐ฐ ๐๐๐๐๐ ๐๐๐๐ ๐๐๐๐๐ ๐๐๐ ๐๐๐๐๐๐๐, ๐๐๐ ๐๐๐๐๐๐๐๐ ๐๐ ๐๐๐ ๐๐๐๐๐๐๐๐๐๐.โ โ ๐ซ๐๐๐๐๐ ๐ซ. ๐ฌ๐๐๐๐๐๐๐๐๐
Use the scenarios to wrestle with inflection points and to prompt potential solutions earlier (e.g. adjusting head count as needed).
During stressful changes, itโs tough to think objectively. This process urges you to consider options before the actual, hard choices.
The model should tell you what you need to know, not want to hear. Seek tough feedback both on the data and on the overall trends.
The power in tools comes from their quality. With financial models, make sure there is substance and not just aesthetics. ๐
Comments