Build the revenue and cost workbook

Enter line items, use bundles, set GST, and heed benchmark warnings.

"Revenue & Costs" is the heart of the study — one combined workbook where revenue folds in at the top and costs follow beneath, ending in total development cost and gross profit. It is where most of your time goes.

1. 1

   Open the workbook

   Select "Revenue & Costs". The page is titled "Revenue & Cost Management".

2. 2

   Add revenue lines

   Revenue categories are "Residential Sales", "Commercial Sales", "Car Parks" and "Other Revenue". Add a line, name it, then set "Units" and "Rate per unit", and a "Settlement month".

3. 3

   Set the GST method

   Beneath "Total revenue", the "Less GST" row carries a selector: "General tax rule", "Margin scheme", "Margin scheme (cost %)" or "Manual GST".

4. 4

   Set the sales commission

5. 5

   Add cost lines

6. 6

   Choose how a line is calculated

7. 7

   Use bundles to save typing

8. 8

   Handle the land line and stamp duty

9. 9

   Read benchmark warnings

10. 10

    Check the totals

11. 11

    Export the workbook