Apartment Development Planning Assistance

I want to build a residential development (residual) appraisal and cashflow spreadsheet giving me KPI's such as profit, IRR, NPV and RoE, with a summary dashboard. I'll also need to model debt and equity split.