A Land Development company based in Edmonton, Canada. They are specialized in acquiring growing land, build infrastructure for individual, mixed family, corporate, and tenants.
The Company was going to start a new project and was planning to acquire another land. But before that, they want proper research and analysis of the cost that is attached to the project and the profitability of the project. They wanted to have depth financial models, through which they can evaluate the project.
Oak Business Consultant helped him to build a dynamic and depth financial model so that they can play with the numbers in the forecast model.Real Estate business models have multiple factors to analyze, as the cost structure is very complex and link with many other industries, sectors like Steel, Cement, Engineering, and Plastics.The development cost would vary if any of the raw material cost increases. On the other hand, the land has to capitalize with maximum level, and they will have more houses, apartments, etc.So, real estate has a financial model which is far different and complicated as compared to SaaS or restaurant economic model as there is a lot of input variable to do a depth analysis.We created the model in the following way.
The first step to creating a project structure, how much percentage of the land area will be used for houses, apartments, and rental offices. We built a chart as an input assumption.
We evaluated the hard cost. Hard cost consists of tangible assets that are needed to complete the construction. This means that the thorough analysis of cost that would be incurred in the project. This sheet not only provided the projection input but also provided an option for variance analysis when the project is completed.
Following are the hard cost that we analyzed.
Water Treatment Plant
Fire/ Irrigation / recirculation pumping
Storm Water Management / Sewer
Community Facilities & Amenities
Domestic Water Supply
Internal Roadway System
Trail & Pathway Network
Fire Protection Mains
Waste Water Treatment Plant
Intensive capital projects like in real estate have to control the cost so that the overall cost per unit would decrease. Similarly, the Client needs to calculate the per-unit cost to build one house, apartment, or commercial building in order to determine the cost and the price.Oak business consultant also provided the per-unit cost analysis.
Soft costs are the intangible cost, which includes architectural, engineering, financing, and legal fees, and other pre- and post-construction expenses. We created a detailed input chart in order to estimate the soft cost.
Following are the head cost that we analyzed.
Architectural Design & Building Plans
Fees Payable To County
After analyzing the hard and soft cost, we summarize both to determine the whole project cost.
There are many phases of the land like houses for single-family, mixed family, Duplex, apartments, and every phase will have different costing and value according to demand.
We built a dynamic financial model, having input for every phase. So that we can forecast accurate revenue.
Profit and Loss Forecasting
After developing the cost structure and the revenue model, we compiled the data and built a profit and loss statement. In addition to an estimated profit and loss statement, we also created a sheet for data, so that it would easier for the client to conduct variance analysis.
Project evaluation is conducted with the help of a financial model which helps in checking the feasibility of any given project. After analyzing the in-depth analysis of cost structure and expected value, we need to examine the project profitability.
Oak Business Consultant provided Evaluation tools, i.e. NPV, IRR, Payback period and ROI.
Last but not least, we provided them with a dashboard, which summarizes the whole projection.
Hammad Hasan is a Financial Analyst at Oaks Business Consultant having an Excellence of analyzing financials of the company and expert in Financial Modeling. Hammad holds a bachelor’s degree in business. Being a Financial Analyst, he has built various financial models for startups, growing company and do a company’s evaluation. He is a quick learner, keen to gain new experiences and love critical situations because it makes him able to take better decision in life.