Build an Excel Feasibility Model

MediumSQL · PostgreSQL

Problem

Walk me through how you would set up an Excel model to analyze the financial feasibility of a mixed-use development for an HR&A Advisors client.

Using the provided project, component, and cash flow data, produce the core feasibility outputs that would support the model. Include only projects currently under review.

Output

One row per project, with project_id, project_name, total_revenue, total_cost, roi, total_cash_flow, peak_funding, payback_date, and feasibility_status.
Treat missing component or cash flow records as zero totals where appropriate.
Order by project_id ascending.

Schema

development_projects

Column	Type	Description
project_idPK	INT	Unique development project identifier
project_name	VARCHAR(150)	Project name
status	VARCHAR(40)	Current project review status

project_components

Column	Type	Description
component_idPK	INT	Unique component identifier
project_id	INT	Related development project
component_type	VARCHAR(50)	Residential, retail, office, or other component
units	INT	Number of units or saleable spaces
sale_price	NUMERIC(14,2)	Expected price per unit or space
development_cost	NUMERIC(14,2)	Expected cost per unit or space

project_cash_flows

Column	Type	Description
cash_flow_idPK	INT	Unique cash flow record identifier
project_id	INT	Related development project
flow_date	DATE	Date of projected cash flow
cash_flow	NUMERIC(14,2)	Projected inflow or outflow

Tablesdevelopment_projectsproject_componentsproject_cash_flows