How to build a Development Appraisal in Excel
How to build a Development Appraisal in Excel
A development appraisal is an essential tool in property development, used to assess the viability and profitability of a proposed project. Whether you're considering a new residential development, commercial building, or mixed-use scheme, a well-constructed development appraisal helps you understand the financial implications and potential return on investment. Building a development appraisal in Excel is a practical approach, providing flexibility and allowing for detailed customisation. This guide will walk you through creating a robust development appraisal and highlight the key line items to include.
Why Use a Development Appraisal?
A development appraisal is crucial in determining whether a development project is financially feasible. It provides an overview of the project's costs, revenues, and potential profit, helping developers, investors, and lenders make informed decisions. You would use a development appraisal when:
Assessing Project Feasibility: Before committing to a project, it’s vital to ensure it is financially viable. An appraisal helps you identify whether the project will generate an acceptable return.
Securing Finance: Lenders and investors often require a detailed development appraisal to evaluate the risk and potential return on their investment.
Project Planning: A thorough appraisal aids in planning the project's financial aspects, including cash flow and funding requirements.
Managing Risk: By identifying potential cost overruns or revenue shortfalls early, a development appraisal can help mitigate risks.
Building a Development Appraisal in Excel
Excel is a powerful tool for building a development appraisal due to its flexibility, ability to handle complex calculations, and ease of use. Here’s how to create one:
Set up your spreadsheet: Start with a clean spreadsheet. Create separate spaces for different aspects of the appraisal, such as 'Inputs', 'Calculations', and 'Summary'. This will help keep the data organised and make it easier to update.
Define key line items: A comprehensive development appraisal should include the following line items:
Gross Development Value (GDV): This is the total value of the completed development. For residential projects, it might be the total sales value of all units. For commercial projects, it could be the estimated value of the property based on rental income.
Construction Costs: Include all costs associated with building the development, such as materials, labour, contractor fees, and contingencies.
Professional Fees: These are fees paid to architects, engineers, surveyors, and other consultants involved in the project. Typically, these are a percentage of the construction costs.
Finance Costs: This includes interest on loans and any arrangement fees. It’s really important to factor in the cost of borrowing, as this can significantly impact profitability.
Land Acquisition Costs: The cost of purchasing the land is often a major expense. Include legal fees, stamp duty, and any other costs associated with acquiring the site.
Marketing and Sales Costs: Budget for marketing the development and any sales agents' fees. This is particularly important for residential projects.
Contingency: Allocate a contingency fund, usually a percentage of the total construction costs, to cover unforeseen expenses.
Developer’s Profit: This is the desired return on the project, often expressed as a percentage of the GDV or total costs (profit on cost).
Build the calculations: Use Excel formulas to calculate the total costs, expected revenue, and profit. For example, subtract the total costs (including finance and contingency) from the GDV to calculate the profit. Then, divide the profit by the GDV to determine the profit margin.
Create a sensitivity analysis: This is crucial for understanding how changes in key assumptions (like sales prices or construction costs) impact the project's profitability. Use Excel’s 'Data Table' feature to create a sensitivity analysis that shows how changes in key variables affect the outcome.
Summary and presentation: Create a summary tab that presents the key findings of the appraisal, including total costs, GDV, profit, and return on investment. Use charts and graphs to visually represent the data, making it easier to interpret.
Conclusion
A development appraisal is a critical tool for any property development project. By building a detailed appraisal in Excel, you can assess the project's feasibility, manage risk, and secure the necessary financing. Remember to include all key line items such as GDV, construction costs, finance costs, and developer’s profit. With a well-constructed development appraisal, you can make informed decisions and set your project up for success.
Thank you so much for reading. If you want more content, join our free membership in The EiP Academy – http://academy.excelinproperty.com/join
