Learn how to make the financial plan of a business plan

6
37087
Excel Spreadsheets

O financial plan is the last stage of a business plan, in which the projections of revenues and expenses will be made and the feasibility of the project being planned from the investment being projected will be measured.

Go back to:
How to make a business plan

More concepts related to financial plan:
What is Discounted Cash Flow?
What is Projected Cash Flow?
How to make an economic and financial feasibility study?
What is and how to calculate the NPV (Net Present Value)?
What is and how to calculate the Internal Rate of Return (IRR)?
What is and how to calculate Payback?

In this article we will talk about:

Why Think About the Financial Plan of a Business Plan

If you are thinking of making a business plan, keep in mind that the most important part is financial planning. I say that, because at the end of the day, “it doesn't matter” what your product is, the market segment you want to reach or even the way you are going to put it all into practice, if you don't have enough revenue forecast to allow it or that attractive to potential investors.

Obviously you can not come up with a financial plan for a well done business plan without other information, but thinking about it and how it will materialize is essential.

Business Plan Sheet

You need to keep in mind that the main reason for the bankruptcy of new companies is the lack of business vision to create a good financial structure, planned and directed to the development of the company. This brings us exactly to how to make this plan:

How to make the financial plan in the business plan

To make a good financial planning it is not necessary to be an economist. Simply identify the details of the new business, set goals, consider the resources to be applied in each case and convert them into reality. See the step by step to get this result:

Step 1: Define the initial investment required

You should coldly analyze the initial investment required and check all expenses for the implementation of the business, such as installation expenses, supplies, electronic equipment, physical headquarters, furniture and everything else that is necessary to set up your business.

This number may even be small. Let's assume that an entrepreneur needs R $ 50.000 to get his business to run, but he only has R $ 30.000.

Financial plan in the Business Plan - initial availability

Having this notion will allow him to know exactly what to do before he gets into the business. In this case, the entrepreneur would have three options:

- ask for a loan / investment with a big concern on how the interest would affect the non-operating results of the business

- remake the financial plan by analyzing cost reductions and how that would affect the end result

- give up the idea, for having less money than necessary

It may sound cruel, but business life is like this, or you stay tuned and make difficult decisions right from the first step or you're doomed to fail.

Business Plan: Step by Step to Create Your Own

Step 2: Make a projection of expenses and revenues

If you have the cash needed for the initial step, you need to check out what the cost of the business is normally turning and this involves projections of expenses and revenues. You must carefully calculate all the other costs required and how much you can and will be able to sell throughout this process.

Financial plan in the Business Plan - projections

A major problem is the impressive number of entrepreneurs who tend to be extremely optimistic when making their projections. If you want to escape this risk, try approaches in which you already have information about your business working, even if in an embryonic way, in beta or with a capacity lower than your final goal.

3 Step: Analyze the main feasibility indicators

The indicators are produced based on previously calculated values, in order to monitor the development and growth of your business. Here are the key indicators:

- NPV - Net present value

- TIR - Internal rate of return

- Payback - Time to Recover Investment Made in Business

Depending on the investor, it may be that other indicators such as EBITDA may be required, but in general, if you have these 3, you will have a good idea. An interesting exercise to do at these times is to calculate a possible valuation, since that would give you a good idea of ​​how much to ask in exchange for what percentage of your shares in investment cases.

Business Plan Sheet

Financial Plan on an Excel Business Plan worksheet:

Now that you have understood exactly the step-by-step of how to make a financial plan of a business plan, let's make an example for a machine shop:

Step 1 - Investments

As we talked about here, the first step is to understand how much you will spend on initial investments. In this case of the Mechanic Workshop we will need to calculate the pre-operational investments (before the business starts) and the one-time investments (which are made over the course of the business).

It is important to make this distinction because these expenditures are not operational in nature. Let's see each one of them:

  • Initial Investments

In the case of a workshop, would be spent as the physical space for the business to operate, equipment and machinery required and general office supplies. As an example, we raise the following investments:

- Shed: R $ 150.000 (remembering that it could be a leased shed and the cost enter as rent month to month)

- Car lifts: R $ 15.000

- Tools: R $ 10.000

- Computers R $ 5.000

- Reform of the Warehouse: R $ 20.000

Financial plan in the Business Plan - initial investments

Be careful not to let anything pass.

  • Other investments

Usually these are investments associated with the possible growth of the business. Imagine that the workshop has an increase in revenue and customer service needs to be increased with the purchase of new lifts in the second year. In this case, this cost (R $ 15.000) must enter into your investment flow:

Financial plan in the Business Plan - new investments

Step 2 - Revenue and Expense Projection

  • Fixed costs

Fixed costs are those that occur every month, regardless of variations in service delivery. They are also known as indirect costs, because they are not directly tied to the provision of services or production.

Business Plan: Step by Step to Create Your Own

In our case, from a Mechanic Workshop, we could think of mechanic salaries, the pro-labor of managing partners, the purchase of parts for the vehicles and some other costs. For simplicity, I'll keep these 3, but you need to drill down as much as you can:

- 5 employees getting $ 3.000 each - $ 15.000

- 2 members getting R $ 10.000 each - R $ 20.000

- Cost with suppliers in general - R $ 30.000

Financial plan in the Business Plan - fixed costs

  • Revenue projections

So far, there is usually not much difficulty, but when it comes to making the revenue projections there are a lot of people who give that skating and end up being very optimistic. Anyway, the first step is to list your products or services. In our case, we can have the services of electronic injection and motor care; maintenance of the electrical part, installation of air conditioning, sound and the like; maintenance, overhaul, oil or tire replacement, tinsmithing and painting services.

Financial plan in the Business Plan - revenue projection

After listing your services or products, calculate a projected quantity sold for each of them. Finally, enter the average sales value for the services. This will give you a good approximation of your revenue forecast. See in the image above you see the average ticket and in another tab of the spreadsheet we had already put the amount of sales year by year.

Business Plan Sheet

Step 3 - Analysis of Indicators

  • Consolidated results

Finally, of course, every investor or entrepreneur wants to know if the main indicators of a business plan is making sense. For this, the 3 indicators that I always make a point of looking at are the NPV, IRR and Payback. In the case of our Workshop, the results were as follows:

- VPL - R $ 1.594.593

- TIR - 95%

- Payback - 3 Years

Financial plan in the Business Plan - financial result

Of these 3 indicators, the first 2 (NPV and IRR) are positive, which is a sign that the business is promising, but Payback is very high because of the high expenses nature at the beginning of the business. This could be a hindrance to the decision to invest in it. One way to modify this could be by renting a space instead of buying it. There are other ways to modify your metrics and see what works best. This will depend on each case.

  • Graphics

To end our third and final step, it's worth having a graphical analysis of your indicators and a separate dashboard for that.

Financial plan in the Business Plan - graphs

By monitoring and maintaining a monthly financial report, where all the actual data should be collected, it is possible to compare with the initial financial planning and make the necessary corrections in the company's trajectory.

Business Plan Sheet in Excel:

As you can see, the financial plan is only part of the business plan. If your goal is to present a business plan complete, you need to look at the other most important topics (which will vary from PN to PN):

  • Executive summary
  • Information of the partners / managers
  • Business modeling
  • Marketing plan and market segmentation
  • Strategy and execution plan

Business Plan Sheet

If you only have interest in the financial part, I recommend 2 paths depending on your situation:

  • If you have a business running - Control your finances with a cash flow and make predictions about how your financier may behave in the future. I recommend the Cash Projected Cash Flow Worksheet for this task.
  • If you want to see the viability of a business that does not yet exist - make the same projections of investments, costs and revenues that we spoke of throughout this article, except that Economic Feasibility Study Sheet, which deals exclusively with this financial part.

Did you like the tips? Acquire the business plan sheet here and start now the ideal financial planning for your business!

Excel Spreadsheets

6 COMMENTS

  1. Hi, Vanessa, what's your question about the calculations? Did you read our posts explaining how to get in the NPV and the IRR?

  2. hello, good night, I did not quite understand, how to calculate calculus (NPV and IRR), can you help me?

  3. Hi José, this is the goal itself, always evolve and learn from our past mistakes

  4. Hello, I really like calculations and I was very happy to visualize and learn a little more methods and concepts so disciplinary in business plan, I confess that I have already broken several times for lack of planning and disobedience to administrative processes, but I am seeking more and more knowledge to miss less and achieve the much desired success.

LEAVE AN ANSWER

Please, write your comment
Please enter your name