FOR A PROPERTY DEVELOPER
Client
A PUBLIC-LISTED PROPERTY DEVELOPER IN MALAYSIA
Products & Services
- Financial Modelling
- Scenario Planning
- Financial Statement Analysis
- Forecast & Budgeting
Description of Project
Client
The client is a public-listed company, and one of Malaysia’s top property developer It is the flagship company for township and property development businesses of a Malaysian sovereign wealth fund.
Background
The company’s required to develop a comprehensive financial projection extending to the year 2030, based on bottom-up approach with multiple scenario planning. Subsequently, this forecast will serve as the Annual Operating Budget (AOP) until 2030, subject to board approval and annual review.
Challenges & Expectations
Previously, the team utilised a basic model to derive the five-year forecast, wherein the three financial statements were updated independently, leading to potential errors. Moreover, some of the projection parameters relied solely on estimates without aligning with fundamental project assumptions.
In response to the Board’s request, management is expected to propose the optimal scenario for the long-term expansion plan. Consequently, the financial model must be adaptable to various scenarios and provide immediate comparative results.
Our Role on the Project
Scope of Services
Our team, comprised of seasoned accountant and financial modeler, is tasked to design a robust and flexible financial model (FM) tailored for tracking, scenario planning, and budgeting effectively. This involves integrating latest project assumptions, transformation initiatives, capital rebalancing projections and other assumptions into the FM.
Designed with flexibility in mind, the FM allows for swift alternation of outputs through scenario switches, to provide immediate results and facilitate informed decision-making.
Solutions / Outcomes Delivered
We provided the FM in a set of 6 separate models, complemented by project assumption and other supporting spreadsheets. These components are intricately linked to the output files, resulting in a robust and comprehensive financial projection comprising three consolidated financial statements.
Our solution facilitates the simultaneous execution of six different scenarios, delivering output results with just a single click, thereby streamlining the decision-making process.
