# Home Builder Operating Dashboard

Assess a five-year production homebuilder forecast through Y5 revenue, EBITDA, margins, closings, average ASP, ROIC, ROE, segment mix, and traffic-light status for home gross margin and returns.

- Canonical: https://finamodel.com/excel-dashboard/home-builder
- Excel download: https://finamodel.com/templates/home-builder.xlsx

## About this dashboard

The Home Builder dashboard presents the fifth-year outcomes of a production homebuilder forecast. It highlights revenue, EBITDA, EBITDA margin, home gross margin, total closings, average ASP, ROIC, ROE, and the Y5 closing mix across entry-level, move-up, and luxury segments. Traffic-light status flags home gross margin and ROIC against the model’s on-track and watch thresholds.

Supporting schedules build those outputs from active communities, segment mix, deliveries per community, ASP and growth, home gross margin, financial-services activity, and operating costs. Communities and Closings show production; Revenue and P&L separate homebuilding and financial-services economics; Inventory_ROIC links inventory turns, debt, equity, NOPAT, ROIC, and ROE.

Use the dashboard to compare community growth with closings, understand how buyer mix affects average selling price and home margin, and review returns generated by the forecast capital structure. The segment view helps distinguish volume-led outcomes from changes in pricing, absorption, margin, or inventory efficiency.

## What's included

- Y5 total revenue and EBITDA
- Y5 EBITDA margin and home gross margin
- Y5 total closings
- Y5 average ASP
- Y5 ROIC and ROE with status
- Y5 closing mix by buyer segment

## Frequently asked questions

### What does the Home Builder dashboard show?

It shows Y5 revenue, EBITDA, EBITDA margin, home gross margin, total closings, average ASP, ROIC, ROE, and closing mix across entry-level, move-up, and luxury buyers. Traffic-light indicators provide status for home gross margin and ROIC against the forecast thresholds.

### Why does the dashboard show buyer segments?

Entry-level, move-up, and luxury communities differ in deliveries per community, average selling price, and home gross margin. Showing their Y5 closing mix makes it easier to understand whether production volume, pricing, or segment composition is shaping the builder’s revenue and profitability outputs.

### How is average ASP presented?

Average ASP is the forecast’s homebuilding revenue divided by total closings. It gives a blended view across the three buyer segments, while the supporting Revenue schedule retains the segment-level ASP and revenue figures that explain changes in the dashboard average.

### What do ROIC and ROE represent here?

ROIC is NOPAT divided by inventory, reflecting returns on the modelled homebuilder inventory base. ROE is net income divided by average equity. Together they show operating return on the core asset base and earnings return on the equity roll-forward.

### Does this dashboard include a full land pipeline?

The dashboard covers production, revenue, profitability, inventory efficiency, and capital returns for the forecast. It does not show a separate land-pipeline build, full balance sheet, or cash flow statement, so those analyses require additional supporting schedules or models.

## Related dashboards

- [Ecommerce Forecast Dashboard](https://finamodel.com/excel-dashboard/ecommerce)
- [Retail Store Dashboard](https://finamodel.com/excel-dashboard/retail-store)
- [Restaurant Dashboard](https://finamodel.com/excel-dashboard/restaurant)
- [Hotel Dashboard](https://finamodel.com/excel-dashboard/hotel)