Build a protected property feasibility workbook
Project brief
Need an easy-to-use property feasibility calculator with separate Residential and Townhouse tabs. Inputs should cover land and resale comparables, construction costs, contributions and percentages. Calculate acquisition costs, development costs, net proceeds and profit on cost.
Protect and hide formulas while leaving input cells editable. Show a green/red verdict against an adjustable return threshold, initially 25%. Include a Start Here example and a printable summary. It must work in Excel and Google Sheets. Calculation assumptions and three validation cases will be agreed before work begins. Please show a similar interactive workbook.
Deliverables & acceptance
What you'll deliver
- Excel workbook, Google Sheets version and PDF summary.
What the result must meet
- Both property tabs recalculate correctly from editable inputs while formula cells stay protected.
- The three agreed test cases, including a loss and a threshold result, produce the expected totals and verdicts.