Lesson 7 of 7

Produce the lender-ready reports

5 min

Profit and loss, balance sheet, cashflow statement, key metrics and sensitivity — exported to PDF or Excel.

"Reports" is the end of the north-star journey: the outputs you send to a lender, an equity partner or an investment committee. Everything here is derived from the study's cashflow.

  1. 1

    Open Reports

    Select "Reports". Five sub-tabs are available: "Profit & loss", "Balance sheet", "Cashflow statement", "Key metrics" and "Sensitivity".

  2. 2

    Read the profit and loss

    It runs "Revenue" → "Backend sales commission" → "GST liability" → "Net revenue" → "Cost of sales" (land, construction, professional fees, other) → "Gross profit" → "Operating expenses" → "Interest expense" → "Financing fees" → "Net profit before tax" → "Tax expense" → "Net profit after tax".

  3. 3

    Set the reporting period

    Use "Period start", "Period end" and "Apply" to scope the report, or "All" for the whole programme. "Corporate tax rate" drives the tax expense line.

  4. 4

    Check the other statements

  5. 5

    Recalculate first

  6. 6

    Export