Feasibility Analysis for Commercial Property Development: A Practical Guide

Introduction

Planning a commercial property development requires meticulous feasibility analysis to assess its financial viability. Developers must consider major capital expenditures, cash flow forecasting, and financing structures while analysing potential returns. This guide provides a practical approach, including Excel-based techniques, to streamline the process and make data-driven decisions.

Key Components of a Feasibility Analysis

1. Major Capital Expenditures

A detailed breakdown of costs is essential for identifying funding requirements and minimising budget overruns.

Key Categories:

• Labour Costs: Wages, contractor fees, and associated benefits.
• Material Costs: Building materials, fittings, and equipment.
• Licences and Permits: Council approvals, legal fees, and zoning compliance costs.

Example Table:

By organising expenses into categories, you can track spending and adjust projections based on actual costs.

2. Cash Flow Forecasting

Cash flow forecasting ensures you have adequate funds to cover operational and development costs throughout the project lifecycle.

Steps:

1. Create an Inflow Schedule:
   • Include projected rental income (if pre-leased) and equity financing.
2. Add Outflow Categories:
   • Include capital expenditures, loan repayments, and contingency reserves.
3. Use Excel Formulas:
   • Use =SUMIFS to segregate inflows and outflows by category.
   • Automate cash flow calculation using =OpeningBalance + TotalInflows - TotalOutflows.

Example Table:

3. Depreciation Calculations

Accurate depreciation helps you estimate tax savings and long-term profitability.

Steps:

1. Identify Depreciable Assets:
   • E.g., building structure, fittings, HVAC systems.
2. Use Straight-Line or Diminishing Value Method:
   • For straight-line depreciation, use =AssetCost / UsefulLife.
3. Organise Depreciation by Category:
   • Allocate depreciation across relevant fiscal years.

Example Table:

4. Loan Schedule and Debt-Equity Financing

Design a financing structure that optimises costs and aligns with project cash flow.

Steps:

1. Create a Loan Schedule:
   • Include principal, interest, and balance calculations.
2. Structure Debt-Equity Financing:
   • Use a debt-to-equity ratio that balances risk and return.

Loan Schedule Example:

5. Rental Income and Sales Forecasting

Predicting revenue from rentals and sales ensures the project meets its return targets.

Steps:

1. Create a Rental Schedule:
   • Include estimated rent per square metre and occupancy rates.
2. Sales Growth Projections:
   • Use historical data or industry benchmarks to forecast revenue growth.

Rental Schedule Example:

6. Scenario Analysis and Growth Forecasts

Perform scenario analysis to evaluate the project's sensitivity to key variables.

Steps:

1. Identify Variables:
   • E.g., material cost increases, interest rate changes, occupancy rate drops.
2. Run Best, Worst, and Base Scenarios:
   • Use Excel's What-If Analysis to assess outcomes under different conditions.

Example Table:

Worked Example: Mixed-Use Development

Consider a developer assessing a mixed-use commercial project in a growth corridor. The proposal involves:

• 3,000 sqm of retail space across ground and first floors
• 500 sqm of office space on the second floor
• Estimated construction cost of $6.2 million
• Expected completion in 18 months

The feasibility model in Excel covered:

1. Build cost phase - construction expenditure spread across quarters, with a 10% contingency ($620,000)
2. Leasing phase - phased occupancy starting at 60% in month 1 post-completion, reaching 90% by month 6
3. Financing structure - 65% debt, 35% equity, with interest-only payments during construction
4. Return metrics - project IRR of 12.8%, equity multiple of 1.8x over a 5-year hold

Note: The above figures are illustrative. Every development is unique and feasibility outcomes depend on specific site conditions, market factors, and financing terms.

Best Practices for Commercial Property Feasibility Analysis

1. Engage Experts: Work with accountants, property consultants, and financial modellers to validate your assumptions.
2. Monitor Market Trends: Stay informed about rental rates, construction costs, and financing conditions.
3. Use Excel for Forecasting: Build dynamic models to update projections as variables change.
4. Maintain Contingency Plans: Allocate 10–15% of the budget for unexpected costs.
5. Focus on Sustainability: Factor in energy efficiency and green certifications to enhance long-term value.

Frequently Asked Questions

What is the first step in a commercial property feasibility analysis?

Start with a detailed cost breakdown covering land acquisition, construction, approvals, and financing. Without accurate cost inputs, the entire feasibility model is unreliable.

How do I choose between debt and equity financing?

Consider your cost of capital and risk tolerance. Debt is cheaper but requires regular servicing. Equity is more expensive but preserves cash flow during the development phase. A ratio of 60-70% debt is common for commercial developments in Australia.

What contingency percentage should I budget?

Industry practice is 10-15% of total project costs for commercial developments. Higher contingencies (up to 20%) are advisable for projects with long timelines or on complex sites.

Can I use Excel's Goal Seek for feasibility analysis?

Yes. Goal Seek is useful for finding the required rental rate, occupancy level, or sale price needed to achieve a target return. Set up your IRR as the target cell and the variable you want to solve for as the changing cell.

How do interest rate changes affect feasibility?

Higher rates increase debt servicing costs and reduce net cash flow. Run sensitivity tables in Excel showing how your project metrics change across a range of interest rates to understand your exposure.

Conclusion

Feasibility analysis is a critical step for commercial property developers, involving detailed cost breakdowns, cash flow forecasting, and investment analysis. By leveraging tools like Excel to model scenarios and assess profitability, you can make informed decisions and increase the likelihood of a successful project. Whether you're a seasoned developer or a first-time investor, a well-structured feasibility study is the foundation of any successful property venture.

For more practical guides on financial modelling and investment analysis, visit ExcelWiz.com.au.