Modeling Guide

The following data refer to conceptual examples of Localiza's main business divisions. The information provided is intended to guide the reader to understand the Company's business platform and to be able to perform financial modeling of its results.
1
Purchase and sale

The purchase and sale of vehicles is a practice that depends on the Company's strategic direction. Therefore, the main starting point for modeling is the estimate of the net addition of the fleet, calculated by the difference between the number of vehicles purchased and sold.

Net fleet adition = # purchased vehicles (P) – # sold vehicles (S)

There are three possible scenarios:
TODAY
IF (P) > (S)
Growth
IF (P) = (S)
Maintenance
IF (P) < (S)
Reduction
Total fleet
Total number of vehicles from purchase to sale
Operational fleet
Number of vehicles in operation, including cars from registration to available for sale. Percentage of total fleet.
Rented fleet
Number of vehicles rented during the period. Percentage of the operational fleet.
Utilization rate
The utilization rate shows, in percentage terms, the proportion of the vehicle fleet that was actually rented during the period. The number disclosed by Localiza is based on the fleet available for rental, which does not consider cars being activated or deactivated (vehicles being transported or prepared for sale, for example).
Disclosed utilization rate example

Fleet available for rent: 530k vehicles

Average rented fleet: 480k vehicles

Disclosed utilization rate: 480k/530k = 90.6%

Utilization rate example

Average operational fleet: 560k vehicles

Average rented fleet: 480k vehicles

Utilization rate: 480k/560k = 85.7%

Global utilization rate example

End of current period fleet: 650k

End of last period fleet: 600k

Average: (650k + 600k)/2 = 625k

Average rented fleet: 480k vehicles

Global utilization rate: 480k/625k = 76.8%

Number of rental days = average rented fleet x number of days in the period*

*In Fleet Rental, contracts consider 30-day months.
By multiplying the average rented fleet by the number of days in the period, we find the number of rental days. This value will be the starting point for modeling the results of the Rental segments, which are divided into Car Rental and Fleet Rental.
  • Cars with an average useful life cycle of 15 to 18 months;
  • Greater physical structure costs with branches and personnel;
  • Higher fixed costs characterize lower margins when compared to the Fleet Rental division.
  • Cars with an average useful life cycle of 36 months, with contracts from 12 to 84 months;
  • The absence of a physical structure results in lower fixed costs;
  • Lower fixed costs result in higher margins;
  • Services are offered based on customer demand, thus reducing idleness.
2
RENTAL INCOME STATEMENT

Car Rental and Fleet Rental are the Company's core business and revenue from these segments refers to Rental services.

Rental gross revenues = rental rate (R$) x rental days

The product of the average rental rate by the number of rental days found previously gets us to the first line of results for the segment - the gross rental revenue.

Rental net revenues = rental gross revenues x (1 – PIS/COFINS tax rate*)

*Tax rate of 9.25%

Rental EBITDA = rental net revenues – rental costs – rental expenses

Rental costs
Refer to expenses with maintenance, car property taxes (IPVA), property rental, personnel, among others.
Rental expenses
Refer to expenses with advertising, commissions, third-party services, profit sharing, among others.

Rental EBITDA margin = rental EBITDA/rental net revenues

The EBITDA Margin is the metric used to assess the operational efficiency of the business.

Rental EBIT = rental EBITDA – other assets depreciation and amortization

What is “Other assets depreciation and amortization”?
“Other assets depreciation and amortization” reflects the depreciation of fixed assets (excluding cars) during the period. Refers mainly to Car Rental agencies, administrative buildings, among others.
3
Seminovos Model

Seminovos is not a business unit of the Company, but rather an efficiency area responsible for selling decommissioned cars from the Car and Fleet Rental divisions. It is through the sale of vehicles that Localiza renews its fleet and maintains the quality of its assets over time.

The number of vehicles sold for each of the divisions can be estimated based on the need to renew the fleet. Thus, considering an average cycle of 15 months in Car Rental and 36 months in Fleet Rental, in 12 months it would be necessary to sell 12/15 or 80% of the RAC fleet and 12/36 or 33% of the GF fleet.

Sales revenue = average sale price (R$) x number of vehicles sold

For the Seminovos model, we take as a starting point the sales revenue, which can be estimated by the product between the average sales price and the number of vehicles sold.

Sales gross profit = sales revenue – book value of cars sold

Book value of cars sold = purchase price – accumulated depreciation

What is “Book value of cars sold”?
The “book value of cars sold” corresponds to the purchase price of the cars sold, net of the depreciation that was accumulated during the period. Depreciation is calculated using the linear method and considers the difference between the purchase price of the car and the estimated selling price at the end of its useful life, net of the estimated costs and expenses for selling. The selling price is reassessed quarterly in accordance with market prices.
Depreciation
Book value
Gross profit
Depreciation
Book value
Gross profit

The diagram above shows how car depreciation influences gross profit. As cars depreciate over their useful life, their book value decreases, resulting in a higher gross profit at the time of sale, depending on market prices.

Seminovos EBITDA = sales gross profit – SG&A Seminovos

What is "SG&A Seminovos"?
SG&A (selling, general and administrative expenses) are the expenses necessary to sell the number of cars that generated the sales revenue. In addition to employee salaries and commissions, it includes rent for Seminovos' stores, marketing expenses, among others.
To evaluate Seminovos efficiency, one used metric is SG&A/Seminovos net revenue.

Seminovos EBIT = Seminovos EBITDA – cars depreciation – other assets depreciation and amortization

What is “cars depreciation”?
“Cars depreciation” reflects the depreciation of vehicles in the operating fleet during the period. This amount corresponds to the difference accrued during the period between the purchase price of the car and the estimated selling price at the end of its useful life, net of the estimated costs and expenses for sale.
4
Consolidated Income Statement

Consolidated EBIT = Rental EBIT + Seminovos EBIT

Localiza is part of a capital-intensive industry, which means that the business requires high investments to operate, such as cars, agencies and stores. These investments are financed through third-party or own capital:

Financial result* =
financial revenues
– financial expenses
*conceptual example for calculation approximation
cash x profitability rate (%)
gross debt x cost of debt
Third party capital
These are resources from other financial institutions and individuals. They include loans and financing, debentures, among others. The Company remunerates them through the payment of interest.
Own capital
These are resources from the Company's cash generation and shareholders. These include practices such as IPO, follow-on, among others. The Company remunerates them through dividends.
Gross debt
Consists of the sum of all obligations that the company must bear with third parties.
Cost of debt
The cost of debt is calculated using the average interest rate (brazilian CDI) for the period plus the funding spread.

Consolidated EBT = Consolidated EBIT – financial result

Over the EBT, Earnings Before Taxes, IRPJ and CSLL are levied at a total rate of 34%. The effective rate can be reduced in a number of ways, one of which is through the distribution of IoC (Interest on Capital), one of the alternatives that the company has to remunerate its shareholders.

Tax rate:

EBT:


R$1000M

IoC:


R$0

Current tax:

34% * R$1000M = R$340M

Example of effective tax rate:

EBT:


R$1000M

IoC:

R$200M

Taxable income:

R$1000 – R$200 = R$800M

Effective tax rate:

34% * 800M = 272/1000
27.2%

IoC is calculated by multiplying Total Equity by the Long-Term Interest Rate (brazilian TJLP), and cannot exceed 50% of the Company's profit reserve or 50% of the net profit of the previous fiscal year.

Tax = EBT x (1 – tax rate)

Consolidated net income = EBT – taxes

5
Cash flow
(+) Cash generation
Seminovos

(+) Seminovos net revenues – SG&A

Rental ressult

(+) Rental EBITDA

(-) Cash consumption
Capex

(-) Capex cars

(-) Capex others

Others

(-) Taxes

(-) Dividends

(+/-) Financial result

Cash flow = cash generation - cash consumption

If there is greater consumption than cash generation in the period, it becomes necessary to raise funds to finance the expansion.

(-) Net renewal capex (R$) = fleet investment – car sales revenue

Net Renewal Capex is the result of fleet investment minus sales revenue. We usually look at this number as the purchase price subtracted from the selling price per car.
Cash Flow summary

(+) Seminovos net revenues – SG&A: corresponds to the revenue from Seminovos net of expenses.

(+) Rental EBITDA: corresponds to the operating result of Rentals, that is, it is the revenue from the company’s core business, net of costs and expenses.

(-) Capex cars: corresponds to the investment in fleet for expansion, maintenance or reduction of operations.

(-) Capex others: Corresponds to expenses with telemetry hardware installed in new cars, as well as with the expansion of RAC agencies and used car stores.

(-) Taxes: Corresponds to income tax expenses.

(-) Dividends: refer to the distribution of dividends and IoC.

(-) Financial result: refer to revenues and expenses from the receipt or payment of interest.

6
Indicators

Indicators help in the study of financial modeling. Below we will present the main ones used by the Company.

ROIC spread

We use ROIC spread as a key indicator of value generation, demonstrating the Company's ability to generate consistent returns above the cost of debt, adding value to the shareholder.

ROIC

(Return on invested capital)

=
NOPAT

Invested capital

NOPAT

NOPAT, Net Operating Profit After Taxes
NOPAT = EBIT * (1 – effective tax rate)

Invested capital

Capital allocated by the Company in its operating activities. For simplification purposes, we consider it as:
Invested capital = total equity* + net debt

*deducted from the business combination goodwill 

Cost of debt after taxes

The cost of debt, also called “KD”, is obtained using the average interest rates (brazilian CDI) for the period, plus the Company’s fundraising spread, minus taxes.

KD = cost of debt * (1 – 34%)

ROIC spread = ROIC – cost of debt after taxes

Debt ratios

To assess the Company’s financial health, we use indicators such as Net debt/LTM EBITDA” and Net debt/fleet value. Net debt is comprised of short and long-term debt +/- results from swap operations, net of cash, cash equivalents and financial investments.

Net debt/LTM EBITDA*
Net debt/fleet value
*LTM = Last Twelve Months