creating a financial model for your entrepreneurial startup business
DESCRIPTION
As an entrepreneur, you are fully expected to fall in love with your idea. The key, however, is to ensure that you don’t become blinded by that love and end up making stupid choices in business. Your financial model is a great protection against blind love. A financial model, or a financial plan, is basically an excel document into which you can plug various factors that will impact your financial future as an entrepreneur.TRANSCRIPT
![Page 1: Creating a Financial Model for Your Entrepreneurial Startup Business](https://reader035.vdocuments.us/reader035/viewer/2022062614/54789e75b4af9fc43d8b4764/html5/thumbnails/1.jpg)
8swellstrategies
Financial Models for Startup Entrepreneurs
Virginia GinsburgPresident & Chief Consultant
Swell Strategieswww.swellstrategies.com
8
![Page 2: Creating a Financial Model for Your Entrepreneurial Startup Business](https://reader035.vdocuments.us/reader035/viewer/2022062614/54789e75b4af9fc43d8b4764/html5/thumbnails/2.jpg)
8swellstrategies
As an entrepreneur, you are fully expected to fall in love with your idea.
The key, however, is to ensure that you don’t become blinded by that love and end up making stupid choices in business.
Your financial model is a great protection against blind love.
Your Idea = True Love
![Page 3: Creating a Financial Model for Your Entrepreneurial Startup Business](https://reader035.vdocuments.us/reader035/viewer/2022062614/54789e75b4af9fc43d8b4764/html5/thumbnails/3.jpg)
8swellstrategies
A financial model, or a financial plan, is basically an excel document into which you can plug various factors that will impact your financial future as an entrepreneur.
What is a Financial Model?
This is not the right type of model to build for your business.
![Page 4: Creating a Financial Model for Your Entrepreneurial Startup Business](https://reader035.vdocuments.us/reader035/viewer/2022062614/54789e75b4af9fc43d8b4764/html5/thumbnails/4.jpg)
8swellstrategies
A software entrepreneur needs to sketch out pricing packages and then model what will happen if 10, 100, and 1,000 people start using his software.
For example, if he gets 100 people to pay for his software, at $100 each, he will make $100,000.
But in addition to this “happy number,” he also needs his model to tie in how much it will cost him to acquire each customer and fulfill each order.
Financial Model: Example
![Page 5: Creating a Financial Model for Your Entrepreneurial Startup Business](https://reader035.vdocuments.us/reader035/viewer/2022062614/54789e75b4af9fc43d8b4764/html5/thumbnails/5.jpg)
8swellstrategies
You need to estimate both prospective customers and sold customers.
Financial Model: Customer Acquisition
![Page 6: Creating a Financial Model for Your Entrepreneurial Startup Business](https://reader035.vdocuments.us/reader035/viewer/2022062614/54789e75b4af9fc43d8b4764/html5/thumbnails/6.jpg)
8swellstrategies
Based on your customer acquisition model, you can estimate revenue.
Financial Model: Revenue Streams
![Page 7: Creating a Financial Model for Your Entrepreneurial Startup Business](https://reader035.vdocuments.us/reader035/viewer/2022062614/54789e75b4af9fc43d8b4764/html5/thumbnails/7.jpg)
8swellstrategies
Your fixed costs are the expenses that your business has to carry just to “keep the lights on.”
Financial Model: Fixed Costs
![Page 8: Creating a Financial Model for Your Entrepreneurial Startup Business](https://reader035.vdocuments.us/reader035/viewer/2022062614/54789e75b4af9fc43d8b4764/html5/thumbnails/8.jpg)
8swellstrategies
Your variable costs are the expenses that vary based on the number of customers you serve.
Financial Model: Variable Costs
![Page 9: Creating a Financial Model for Your Entrepreneurial Startup Business](https://reader035.vdocuments.us/reader035/viewer/2022062614/54789e75b4af9fc43d8b4764/html5/thumbnails/9.jpg)
8swellstrategies
Your profit and loss (P&L) worksheet is also called an Income Statement.
This will bring all of your information together so that you can see how your income and expenses compare and, ultimately, when you can expect to see a profit from your business.
Financial Model: Profit and Loss
Check out this template available from Entrepreneur Magazine.
http://www.entrepreneur.com/formnet/form/
939
![Page 10: Creating a Financial Model for Your Entrepreneurial Startup Business](https://reader035.vdocuments.us/reader035/viewer/2022062614/54789e75b4af9fc43d8b4764/html5/thumbnails/10.jpg)
8swellstrategies
Once you have set your financial model up as a linked workbook in Excel, then you will have the opportunity to play with your numbers.
For example, you can create “worst case,” “average,” and “best case” scenarios to help you determine the risk level walking into an opportunity.
Financial Plan: Having Fun
![Page 11: Creating a Financial Model for Your Entrepreneurial Startup Business](https://reader035.vdocuments.us/reader035/viewer/2022062614/54789e75b4af9fc43d8b4764/html5/thumbnails/11.jpg)
8swellstrategies
Your financial model should be a living, breathing document that you reference regularly to make sure you are on the right track.
Financial Plan: Don’t Forget!
![Page 12: Creating a Financial Model for Your Entrepreneurial Startup Business](https://reader035.vdocuments.us/reader035/viewer/2022062614/54789e75b4af9fc43d8b4764/html5/thumbnails/12.jpg)
8swellstrategies
Good Luck!Virginia Ginsburg
President & Chief Consultant Swell Strategies
www.swellstrategies.com