Chirayuthchai TraisaengsatheanStrategic Finance for Property Development

Group reporting and consolidated financial statements

Reporting at project, company and group level: closing steps, items to eliminate, and an example of intercompany profit in project costs.

Key takeaways

  • A development group needs to look at company-level, project-level and group-wide statements, because each view answers a different question.
  • Entities using TFRS for NPAEs are not required to prepare consolidated financial statements under the 2022 revised version, but banks, investors or listing plans may require them.
  • Consolidated financial statements eliminate all intragroup transactions, including unrealised profit embedded in project costs.

Three reporting levels

LevelQuestion answeredExample data
ProjectHow is this project performing on sales, construction and cash?Presale, CTC, Peak Funding, Project DSCR
Legal EntityIs this company compliant with the law and tax requirements?Financial statements, tax, borrower-level covenants
GroupHow much cash, debt and real profit does the whole group have?Consolidated financial statements, net debt, total liquidity, guarantee obligations

When to prepare consolidated financial statements

EntityApproach
Entities with public accountabilityUse full TFRS and assess control under TFRS 10
Entities using TFRS for NPAEsThe 2022 revised version, applicable to periods beginning on 1 January 2023, permits the presentation of consolidated financial statements but does not require it, according to RSM's summary.
Groups preparing to raise funds or required to do so by a bankShould prepare consolidated or pro forma consolidated statements, and discuss with the auditor before starting.

Accounting consolidation does not change the tax burden, because each company still files its tax returns separately.

Steps to prepare a group pack

  1. Day 1–2 Cut off transactions and record accruals
  2. Day 3–4 Reconcile accounts and match intercompany items
  3. Day 5 Preliminary company-level statements
  4. Day 6 Eliminate items, analyse variances and write explanations
  5. Day 7 CFO reviews and signs off
  6. Day 8–10 Distribute and hold the review meeting

If the group is not yet ready to close within 7 days, start by getting the matching of intercompany items closed first, as this is the most common bottleneck in group accounts.

Items to eliminate

ItemWhat to eliminate
Intercompany loansLoan receivables and payables, together with interest income and expense
Intercompany service feesRevenue and costs or expenses
Intercompany profit in remaining assetsUnrealised profit in project costs
Investments in subsidiariesEliminated against the subsidiary's equity
Intragroup dividendsDividend income against dividends paid
Non-controlling interestsShown separately when an SPV has other shareholders

Example: a project management fee that embeds profit

Service Co charges an SPV THB 20 million on a cost of THB 14 million, a profit of THB 6 million. The SPV records it as project cost and has transferred 50% of the units (illustrative example).

THB millionTwo companies combinedEliminationsConsolidated
Service fee revenue20(20)0
Service Co's costs(14)140
COGS in the SPV(10)3(7)
Effect on profit(4)(3)(7)
Inventory (portion not yet transferred)10(3)7

The group's actual cost is THB 14 million. Half has been transferred, so COGS is 7 and inventory is 7. The unrealised profit of THB 3 million is eliminated, and deferred tax of THB 0.6 million may arise at the 20% rate, depending on the standards and policies applied.

Group dashboard

CategoryKPIFrequency
PerformanceRevenue, gross margin, EBITDAMonthly
CashCash, operating cash flow, Peak Funding, liquidity coverageWeekly
SalePresale %, Velocity, CancellationWeekly
Construction% Completion, SPI, CPIMonthly
Financing and CovenantsDSCR, LTV, LTC, Net D/E, HeadroomMonthly
ReturnsProject IRR, Equity IRRQuarterly
StrategyPipeline, group-wide guarantee obligationsQuarterly

Apply the principle of clarity: the five key figures at the top, compared with budget and the prior year, a 12-month trend, green, amber and red statuses, and the same format every month.

Variances you must be able to explain

Size of varianceAction
<5%Monitor
5–10%Explain in the management report
10–20%In-depth analysis with an action plan
>20%Urgent review and notify the board

Significant items must answer four questions: what happened, why, what the impact is, and what will be done next.

Who needs what

Report recipientMain topicsFrequency (example)
CEO/MDRevenue, EBITDA, cash, pipelineMonthly
BoardROE, ROIC, strategy, risks and approval requestsQuarterly
Project ManagerSPI, CPI, Progress, Cost VarianceMonthly
BankProgress, sales, compliance certificate and financial statementsMonthly, quarterly, annually
InvestorsIRR, MOIC, DPI, TVPI, Capital AccountQuarterly

Compliance Certificate

The CFO signs to confirm the Covenant calculation results. The certificate must include the reporting period, the formula, supporting figures, confirmation of non-financial conditions, representations and a no default statement. Formulas must follow each agreement; if agreements differ, use separate tables.

Covenant levels in the consolidated statements and at SPV level may not match. The group can look strong while one SPV is close to breaching its terms. Report both levels, together with the headroom of each borrower.