Supplementary Spreadsheets
Operational data – Information on projects, PoC, among others. (Portuguese Only)
Financial data – Information of balance sheet, income statement, among others.
Para acessar as planilhas em Português, por favor, clique aqui.
Value Drivers
PSV (Potencial Sales Value)
Expectation of amount to be obtained from the sale of all units of a given real estate project, at a certain price at launch (long-term payment schedule), proportionally to the Company’s share in the project.
Brokerage
Fees charged for property sale intermediation. It is worth mentioning that approximately 50% of contracted sales are intermediated by brokers of Tec Vendas, Eztec‘s sales company, whose brokerage fee percentage tends to be lower than that charged by third-party real estate firms, resulting in increased revenue and consequently improving Company gross margin.
Project Costs
Land Cost: comprises costs of acquisition and regularization, if any, of the land, in addition to costs concerning the increase of the construction potential, should they exist (granting or Construction Additional Potential Certificate – CEPAC). Land cost is one of the main costs related to real estate projects, besides being very important for the calculation of PoC (Percentage of Completion), since in accounting terms, regardless of how it is disbursed, it is considered as being incurred right from the beginning. The ratio land cost versus total cost of projects launched is available on the Interactive Results spreadsheet. If an estimate of the index for future developments is required, it is worth stressing that the land cost versus total cost of projects ratio may vary depending on the (i) form of acquisition (cash or exchange); (ii) segment (low or high income); and (iii) location (more/less expensive areas), and, in this case, estimates require a more comprehensive analysis on the part of the analyst.
Construction Cost (CC): comprises costs of raw-material as well as own and third-party labor. It is important to emphasize that raw materials alone do not affect in a significant way the total cost of a project.
In addition to the costs aforementioned, the gross margin is impacted by the Production Financing Cost. The company has the option of contracting production financing to supplement the installments paid by customers during the construction period. Production financing is released as construction works are carried out and, in general, the financing agent requires a minimum percentage of sales and of completed works for the release of funds.
Operating Expenses
Eztec’s operating expenses include:
Commercial Expenses: comprise expenditure related to assembly of sales stands, decoration of apartment in display and advertising. Eztec records all its commercial expenses in the result, including expenses related the assembly of sales stands, as they occur.
Administrative Expenses and Management Fees: administrative expenses mainly include outsourced services (audit, consultancy, legal counsel fees, and others), staff compensation and payroll charges, in addition to rent and legal expenses (publication of minutes of meetings and financial statements, expenses with registry and notary offices, board of trade, and so forth). The expenses with management fees include senior management compensation.
Production Financing
Eztec, so that its customers feel more secure when acquiring a property, adopts the detached assets/designated property (patrimônio de afetação) regime for most of its projects. This way, the amounts disbursed by the real estate unit buyer are mandatorily bound to the building itself, and are separate from the other funds of the developer. Consequently, Eztec only raises financing for production in order to supplement the cash needed to continue construction.
Taxes
By adopting the patrimônio de afetação regime, the company is entitled to use the Special Taxation Regime (RET), whose consolidated tax rate (PIS, Cofins, IR and CSLL) is 6.0%, an amount lower than that provided by the presumed profit regime, which has a 6.73% consolidated tax rate.
It is worth highlighting that the calculation of taxes payable is based on the amount received from customers, while in accounting, taxes are recognized together with the revenue. This way, the mismatch between taxes paid and taxes recognized may generate two items on the balance sheet:
Prepaid Taxes (Assets): when more taxes were paid than recognized in accounting;
Deferred Taxes (Liabilities): when more taxes have been recognized in accounting than were actually paid;
Indexes
Three indexes have a major effect on real estate developers.
INCC: (Brazilian Construction Cost Index) adjusts the outstanding balance of customers during construction, safeguarding the Company from price fluctuation of main inputs used in construction;
IGP: (General Price Index) adjusts, after completion of works, the outstanding balance of customers who chose to finance their property directly with Eztec; and
TR: (Referential Interest Rate) adjusts production financing installments.
Receivables Portfolio
After completion of works, Eztec offers its customers the option of direct financing with the developer. Currently, the effective rate is IGP + 12% p.a.. It is important to stress that the portfolio of performing (finished) receivables is subject to securitization.
Sales Velocity
Sales Velocity History of projects is available on the Valuation Data spreadsheet.
Construction Progress
Construction progress curves, distributed by product type, are available on the Valuation Data spreadsheet. It is worth noticing that there is a time interval between the launch of the project and the actual beginning of works, a period needed both to ensure a minimum percentage of sales for allowing project continuance and to raise funds for beginning the works.
Schedule of Receipt
In fact, the customer may choose from 3 different alternatives:
Short-Term Payment Schedule: a payment schedule by which the customer pays 100% of the value of the purchased real estate unit by the end of works;
Long-Term Payment Schedule: a payment schedule by which the customer pays between 20% and 40% of the value of the purchased real estate unit by the end of works, and the after-delivery-of-keys installment is paid through the financing granted by the developer, with maturity terms of up to 10 years, at the current IGP rate + 12.0% p.a.; and
Bank Schedule: similar to the long-term payment schedule, with a difference in the after-delivery-of-keys installment, which is financed by a financial institution with maturity terms of up to 30 years. When the customer opts for this modality, the financial institution transfers the financing amount to the developer after amortization of the debt of production financing, if any.
Land Payment
Eztec does not dismiss the purchase of land by exchange, but it believes that land acquisition by cash represents a competitive advantage. At the end of 3Q09, 89.5% of the costs related to land acquired by the Company had already been paid.
Accounting Concepts
Percentage of Completion (PoC) Method
According to the Brazilian accounting practices (BR-GAAP), revenues are recognized by the Project Financing Progress (PoC) method, measuring progress of the construction work until its completion, in terms of costs incurred versus total budgeted cost.
Cost of Goods Sold
It comprises land costs, project development, construction costs and financial charges related to the production financing (Brazilian Housing System – SFH). The recognition of Cost of Goods Sold is a function of the product of costs incurred and the percentage of sales contracted.
Adjustment to Present Value
Adjustment to Present Value, implemented by Law 11,638/07, is applied to the payment installments falling due, taking into account the end of the construction work in accordance with its registration by PoC. As Eztec has net cash, the discount rate used is the quarterly weighted average of issues of federal government bonds called NTN-B. The model is simplified by adopting a single rate; however, in practice, the rate used is the rate effective in the quarter when the unit is sold.