Here is a link to version 3.0 of the spreadsheet that simplifies and demystifies financial analysis.
Here too is a link to the recording of a recent session, where Brandy and Craig walked 75 entrepreneurs and mentors through the process of completing 3 years of financial projections, KPIs, Financial Ratios, graphs and charts.
If you have more than one revenue stream, you will need to complete the additional cells in the assumptions tab for their revenues to be included in the rest of the tabs.
Version 3 is a fully featured version that includes the ability to forecast and analyze up to three revenue streams and allows for enhanced scenario analysis by utilizing a robust set of assumptions users can modify to create a truly tailored 3-year financial analysis.
Version 3.0 integrates six months of feedback from founders, funders, and financial experts in Canada’s startup community on version 2.0.
There is a macro in the spreadsheet that powers the disclaimer you must accept to access the full template.
You must download the spreadsheet to your computer and enable macros to accept the disclaimer to access the working spreadsheet.
Here is a link to a video that shows how to enable macros after you download the file from Dropbox to your computer/laptop- https://www.youtube.com/watch?v=cGwJhLtpgP4
If that does not work for you, here is a link to written instructions from the Microsoft website on a different way to enable macros – https://bit.ly/how-to-enable-excel-macros.
Once you accept the disclaimer, you can follow along with the video, and in as little as 30 minutes, you can build three years of the following:
- Balance sheet
- Income statement
- Cash flow statement
- 44 investor KPIs
- 10 important charts
- 13 financial ratios
There are notes for most row headings that you access by hovering over the cells. Where applicable, these notes contain:
- A definition
- An example
- The calculation
- Links to additional resources