Real estate business plan: our free model
Summary
- Why make a real estate business plan?
- How does our real estate business plan model work?
- What are the fields of our real estate business plan return?
- What are the key values of the real estate business plan?
- What are the specificities of a business plan for a real estate project?
Why make a real estate business plan?
This business plan is a document that makes it possible to present the company’s real estate project in the most effective way possible (at the time of creation or after). In addition, this document must make it possible to verify the viability and solidity of your project from a strategic and financial point of view.
First of all, the business plan is a good way to take a step back from the structure of your project to identify the ins and outs of the latter in a relevant way. Also, the business plan is very important if you ever want to present your project to investors. They will be very attentive to the profitability of your project.
Often, a business plan can be in the form of two files:
- A word file that explains the key stages of the company’s development gives economic and strategic explanations of the project.
- An excel file that traces all the company’s financial flows gives an economic explanation of the project.
In our model, we focused on the excel file.
How does our real estate business plan model work?
Our model is, therefore, an excel file. We considered it relevant to build it from 2022 to 2024 with monthly results Our document consists of five sheets:
- Account 1 traces all of the company’s income and expenses
- Tab 2, in which you can calculate your cash flow. You have nothing to fill in on this sheet. It is dependent on the others.
- The salaries tab where you fill in the different possible salaries according to the other positions with possible changes
- The assumptions tab is necessary to construct the business plan to evaluate the expenses.
- The depreciation policy tab to calculate the depreciation expense (monthly)
What are the fields of our real estate business plan return?
In this business plan, the values you must enter are in the cells highlighted in blue. All other cells are blue-dependent and therefore adapt accordingly to your choices. You have to be careful because sometimes you have to fill in values for each month of each year, sometimes for each year, and finally, in some cases, it is a single value for the three years. It would help if you, therefore, filled in all the following fields:
- Opening rate, which corresponds to the number of real estate acquisitions during the corresponding period
- Gross turnover
- Purchase of stored raw materials: this expense only occurs when purchasing new real estate
- Rent, per property
- Property maintenance, per property
- Accounting fees, quarterly
- Employer contributions (between 25 and 42% of gross salary)
- Wages. You can modify the names “post 1” and “post 2″… If you want to alter the dates, please write them from the nearest to the furthest (in the first AC3 line closest, then the second furthest). Close…). Finally, you also have the option of specifying any increases. Sometimes there is “n/a” because if the position was created in 2023, for example, there could not be an increase in year 2 (so 2025 compared to 2023). After all, the business plan ends in 2024.
- Travels & displacements .
- Machine prices as well as the amortization period
- Price of developments, works, permits, as well as the amortization period
- Price of computer equipment as well as the depreciation period
- Price of furniture as well as the depreciation period
These last four expenses fall into the category of fixed assets, so they must be depreciated. We have given you guidelines for the amortization periods.
If you want to add information, you will have to modify the formulas (add one more line to a sum, for example) so that your values remain true.
What are the key values of the real estate business plan?
One of the objectives of the business plan is to calculate key values that are supposed to be representative of the health of your business. If you present your business plan to investors, they will be particularly attentive to these indications. Some of these key values are highlighted in green (if positive) or red (if negative). Here are the interesting aggregates calculated by our model:
- EBITDA (earnings before interest, taxes, depreciation, and amortization) and EBITDA margin (equal to EBITDA / CA). EBITDA is an indicator close to EBITDA (gross operating surplus), with the only difference being that EBITDA does not take into account allocations to operating provisions.
- EBIT (earnings before interests and taxes) or REX (operating result), which translates the margin achieved by the company on its industrial and commercial activity and EBIT margin (equal to EBIT / CA)
- End-of-month cash and accumulated cash
What are the specificities of a business plan for a real estate project?
Real estate is often seen as a haven where it is possible to invest your assets without taking too many risks. Many investors are therefore tempted to enter this field. However, in a real estate project, the initial investments are often significant, and making a business plan will allow you to clearly understand when your expenses will be reimbursed, for example.
Also, consider planning work in the “Amortization Policy” sheet. A real estate project is often a long-term project, which is why you can replace the months with years, which will allow you to imagine the business plan for your project over 36 years. Again, do this well in each of the sheets in the file.
If you read more article visit https://ofarticle.com/