Check the breakdown and sensitivity

See where the money goes and how fragile the result is.

A single margin hides both the shape of the deal and its fragility. Two collapsible sections above the footer fix that.

1. 1

   Open the breakdown

   Select "How it adds up" to expand the ledger. Each line shows its "Total" and its share of total development cost ("% TDC").

2. 2

   Follow the revenue lines

   Under "Revenue" the ledger runs "GDV", "Less GST", then "Net Revenue".

3. 3

   Follow the cost lines

   Then "Acquisition" ("Land", "Stamp Duty"), "Build" ("Construction", "Professional Fees", contingency), "Sales" ("Agents' Commission") and "Holding & Finance" ("Interest" and the holding lines), ending under "Result" in "Total Development Cost" and "Profit after finance". "Margin on cost" and "Margin on revenue" close the ledger.

4. 4

   Open the sensitivity table

5. 5

   Read the two rows

6. 6

   Judge the fragility