Residential Development — Cost, Cashflow & Funding | 32-Month Model

Independent portfolio project: a commercial and cash planning model for the six-block, 70,560 m² residential development. The 11-worksheet Excel workbook carries forward 32 BOQ packages and models 24 months of construction plus close-out through month 32. It separates cost accrual, gross earned value, advance recovery, retention, certified payments and cash collections. Funding calculations include equity, a minimum cash balance, revolving drawdowns, principal repayment and monthly interest. Long-lead procurement and deposit exposure are recorded separately. Reconciliation checks cover the BOQ budget, contract allocation, advance recovery, retention releases, collections, cost payments and financing balances. Editable assumptions are documented in the workbook.