Industrial Underwriting Excel Decision Model
Budget: $30 – $250 USD
I need a streamlined Excel model that lets me underwrite small-bay industrial deals—either ground-up developments or refurbishments—without having to open half a dozen spreadsheets every time. A single assumptions tab should feed the whole file, including a dedicated line for land purchase costs, and from there the workbook must return an unmistakable “Go / No-Go” decision.
The analysis has to provide clear outputs for standard metrics used in these types of CRE analyses. Examples: Net Present Value (NPV), Internal Rate of Return (IRR), Cash Flow Analysis, year on year cash, and Cap rate. I’d like these summarised on a clean dashboard along with colour-coded flags that show whether each metric meets my hurdle rates.
Deliverables
• Unlocked Excel workbook with clearly labelled input sheet, cash-flow model, and summary dashboard
• Scenario switch or comparable logic that recalculates all outputs for new-build versus refurbishment assumptions
• Automatic Go / No-Go indicator tied to user-set thresholds
• Built-in treatment of land purchase costs within total project budget
Acceptance criteria
• Formulas are transparent; no hard-coded numbers outside the input sheet
• All four metrics calculate correctly when stress-testing with sample data I will provide
• Workbook runs natively in Excel 2021/365 without external add-ins
If you’ve built similar real-estate underwriting tools, please share a live sample or screenshots so I can see your approach before we start.
The analysis has to provide clear outputs for standard metrics used in these types of CRE analyses. Examples: Net Present Value (NPV), Internal Rate of Return (IRR), Cash Flow Analysis, year on year cash, and Cap rate. I’d like these summarised on a clean dashboard along with colour-coded flags that show whether each metric meets my hurdle rates.
Deliverables
• Unlocked Excel workbook with clearly labelled input sheet, cash-flow model, and summary dashboard
• Scenario switch or comparable logic that recalculates all outputs for new-build versus refurbishment assumptions
• Automatic Go / No-Go indicator tied to user-set thresholds
• Built-in treatment of land purchase costs within total project budget
Acceptance criteria
• Formulas are transparent; no hard-coded numbers outside the input sheet
• All four metrics calculate correctly when stress-testing with sample data I will provide
• Workbook runs natively in Excel 2021/365 without external add-ins
If you’ve built similar real-estate underwriting tools, please share a live sample or screenshots so I can see your approach before we start.