Tools for Entrepreneurs: Have, Be, Do Spreadsheet
Posted: Sun Jan 19, 2025 11:06 am
The Have, Be, Do spreadsheet is one of the tools for entrepreneurs that we provide in our Tapa Na Cara course . It is in the “Turning the Key” module and serves precisely this purpose, to turn the key in your head so that you better understand what your needs and desires are and how to achieve them.
A very common mistake among new entrepreneurs is to do all the calculations and spreadsheets related to the business, but forget to calculate how much money you will need to maintain your lifestyle and your personal dreams .
If you haven't stopped to think about how much your dreams cost, you're in the right place! Check out how the Have, Be, Do spreadsheet works and, at the end of the article, download this and other tools for entrepreneurs for free.
What is the have, be, do spreadsheet
The name says it all, the have, be, do spreadsheet is there to kenya phone number lead help you put down on paper everything you want to have, be and do and, most importantly, how much each of these things will cost you.
It is essential during the entrepreneurial process, as it helps you to price your dreams and start saving the money you need to make them come true. If you already know everything you want to do, I recommend filling out the spreadsheet anyway. It can help you get an overview of everything and help you establish the first steps to achieve what you want.
Steps
List
In the first step, you should list everything you want to achieve. So, in the first square, list five things you want to have. In the second, list five goals you want to be, and finally, list five things you want to do.
Here you can enter your wishes for the next year or for five, ten, or twenty years from now. These could be things you want to include in your routine, like eating out once a week with the whole family, or something you want to start preparing to achieve in the future, like buying an apartment for each child in 18 years.
Next steps
What will you need to do to achieve these goals? You can draw up the entire plan, but at least to get started, take the first step. Using our examples, if you want to eat out once a week with your family, what will you need to do? We put “research restaurants and create a gourmet itinerary” on the spreadsheet. This way, you can look for more affordable restaurants that have playrooms and that will please everyone.
As for apartments, the first step may be to research the best value for money options. Even if you are not sure how much it will cost, consider doing some research as the first step to find out how much this dream will cost and what you need to do to make it happen.
How much does it cost?
Now it's time to establish the costs. First, you should indicate the general value of your dreams. In the case of the dinner, we put R$2,400 reais per month and, for the apartments, R$500 thousand. If you don't know the exact value, give an estimate. The important thing here is to have an idea of how much each one can cost and how much you will need to achieve everything.
Next, we need to divide the monthly amount that you will need to invest to be able to achieve this in the time you expect, which is the repayment period. This step allows you to bring your dreams closer to reality.
At first glance, having R$500,000 to buy two apartments seems like a very difficult goal to achieve, but understanding that this goal means investing R$2,314.81 per month makes it more accessible and easier to get started.
Expected results
The cool thing about this spreadsheet is that, once you fill it out, it automatically completes the results for you! So, at the end, you will know:
Monthly total have + be + do
Current monthly expenses (how much you will need to invest per month)
Reserve 30% (that emergency reserve that everyone needs to have)
Required monthly income
Daily prescription required
With this data, you can see if you are currently able to start investing in these dreams. If not, how much do you need to achieve them? In our example, the daily income required is R$2,275.17. Charging R$285 per hour worked, you can do this in less than 8 hours per day.
A very common mistake among new entrepreneurs is to do all the calculations and spreadsheets related to the business, but forget to calculate how much money you will need to maintain your lifestyle and your personal dreams .
If you haven't stopped to think about how much your dreams cost, you're in the right place! Check out how the Have, Be, Do spreadsheet works and, at the end of the article, download this and other tools for entrepreneurs for free.
What is the have, be, do spreadsheet
The name says it all, the have, be, do spreadsheet is there to kenya phone number lead help you put down on paper everything you want to have, be and do and, most importantly, how much each of these things will cost you.
It is essential during the entrepreneurial process, as it helps you to price your dreams and start saving the money you need to make them come true. If you already know everything you want to do, I recommend filling out the spreadsheet anyway. It can help you get an overview of everything and help you establish the first steps to achieve what you want.
Steps
List
In the first step, you should list everything you want to achieve. So, in the first square, list five things you want to have. In the second, list five goals you want to be, and finally, list five things you want to do.
Here you can enter your wishes for the next year or for five, ten, or twenty years from now. These could be things you want to include in your routine, like eating out once a week with the whole family, or something you want to start preparing to achieve in the future, like buying an apartment for each child in 18 years.
Next steps
What will you need to do to achieve these goals? You can draw up the entire plan, but at least to get started, take the first step. Using our examples, if you want to eat out once a week with your family, what will you need to do? We put “research restaurants and create a gourmet itinerary” on the spreadsheet. This way, you can look for more affordable restaurants that have playrooms and that will please everyone.
As for apartments, the first step may be to research the best value for money options. Even if you are not sure how much it will cost, consider doing some research as the first step to find out how much this dream will cost and what you need to do to make it happen.
How much does it cost?
Now it's time to establish the costs. First, you should indicate the general value of your dreams. In the case of the dinner, we put R$2,400 reais per month and, for the apartments, R$500 thousand. If you don't know the exact value, give an estimate. The important thing here is to have an idea of how much each one can cost and how much you will need to achieve everything.
Next, we need to divide the monthly amount that you will need to invest to be able to achieve this in the time you expect, which is the repayment period. This step allows you to bring your dreams closer to reality.
At first glance, having R$500,000 to buy two apartments seems like a very difficult goal to achieve, but understanding that this goal means investing R$2,314.81 per month makes it more accessible and easier to get started.
Expected results
The cool thing about this spreadsheet is that, once you fill it out, it automatically completes the results for you! So, at the end, you will know:
Monthly total have + be + do
Current monthly expenses (how much you will need to invest per month)
Reserve 30% (that emergency reserve that everyone needs to have)
Required monthly income
Daily prescription required
With this data, you can see if you are currently able to start investing in these dreams. If not, how much do you need to achieve them? In our example, the daily income required is R$2,275.17. Charging R$285 per hour worked, you can do this in less than 8 hours per day.