Industrial Facility Financial Model

I’m developing a commercial land parcel into an industrial facility and need a dynamic financial model that focuses on both cost estimation and cash-flow analysis.
The spreadsheet should:
• Capture all upfront and staged costs—land acquisition, site preparation, permitting, construction phases, contingency, and professional fees—linked to an editable timeline.
• Map funding sources against those uses, automatically generating monthly and cumulative cash-flow statements through completion and initial operations.
• Allow key assumptions (construction duration, debt terms, interest reserve, contingency rate, inflation) to be adjusted via clear input cells, with results flowing through to summary dashboards and at-a-glance KPIs such as total development cost, peak negative cash, and break-even date.

Please structure the workbook for clarity—separate input, calculation, and output sheets—and include concise on-sheet notes so anyone on the team can update assumptions confidently. A brief walkthrough video or bullet user guide is welcome.

I’ll provide the current site plan, construction schedule, and any preliminary bids as soon as we start.