MercadoLibre, Inc. (MELI) Discounted Cash Flow to Firm - Perpetual Growth

MercadoLibre, Inc.

MELI (NASDAQ)

(%)

Models
MercadoLibre, Inc. Discounted Cash Flow to Firm - Perpetual Growth

# Render description block
model.render_description({
    "data": r"""
## Discounted Cash Flow to Firm (Perpetual Growth)

This model estimates the fair value of a share by discounting projected **Free Cash Flow to the Firm (FCFF)**, also known as Unlevered Free Cash Flow.

The terminal value assumes cashflow grows at a constant **Growth in Perpetuity** rate forever:

`Terminal Enterprise Value` = `FCFF_(final forecast year)` × (1 + `Growth in Perpetuity`) / (`Discount Rate` - `Growth in Perpetuity`)

The terminal value and projected FCFF are discounted to present value using **WACC**.
Equity value is obtained by adjusting enterprise value for net debt:

`Equity Value` =
`Cumulative Present Value of FCFF` +
`Present Value of Terminal EV` +
`Cash and Short Term Investments` −
`Total Debt`

`Fair Value per Share` = `Equity Value` ÷ `Shares Outstanding`

> This model was inspired by Prof. Aswath Damodaran's spreadsheet [⬇️fcff2st.xls](https://pages.stern.nyu.edu/~adamodar/pc/fcff2st.xls)

> Learn more: Prof. Aswath Damodaran's [Guide to Discounted Cash Flow Valuation](https://pages.stern.nyu.edu/~adamodar/pdfiles/eqnotes/dcfallOld.pdf)
""",
    "properties": {
        "width": "responsive"
    }
})

# --- Discount Rate (WACC)
assumptions.set({
    "timeseries": "annual",
    "data": {
        "#historicalYears": """
            3
        """,
        "#beta": """
            profile:beta
        """,
        "%riskFreeRate": """
            treasury:year10
        """,
        "%equityRiskPremium": """
            risk:totalEquityRiskPremium
        """,
        "%taxRate": """
            income:incomeTaxExpense / income:incomeBeforeTax 
            or if this <= 0:
            risk:corporateTaxRate
        """,
    },
    "titles": {
        "#historicalYears": "Historical Years",
        "#beta": "Beta",
        "%riskFreeRate": "Risk Free Rate",
        "%equityRiskPremium": "Equity Risk Premium",
        "%taxRate": "Tax Rate",
    },
    "properties": {
        "width": "responsive",
        "title": "Discount Rate (WACC)",
        "id": "component-1",
        "bindTo": None
    },
    "descriptions": {
        "#historicalYears": r"""
Number of trailing fiscal years used to compute historical averages/trends that feed the model’s default forecast assumptions (e.g., margins and growth).
        """,
        "#beta": r"""
Beta measures the volatility of a stock's price in relation to the overall stock market. A higher beta indicates greater price fluctuations relative to the market.
        """,
        "%riskFreeRate": r"""
The risk-free rate represents the return an investor expects from an absolutely risk-free investment over a specified time period. By default, it is set to the current yield of the U.S. 10-Year Treasury Bond.
        """,
        "%equityRiskPremium": r"""
The market risk premium represents the additional return over the risk-free rate that investors expect for taking on the risks associated with equities.
        """,
        "%taxRate": r"""
`Tax Rate` = `Income Tax Expense` / `Income Before Tax`

This is the company’s **effective tax rate**, reflecting the average rate of tax actually paid on its pre-tax earnings (including all statutory, deferred, and non-recurring items).

This rate is used to adjust the after-tax cost of debt, since interest expense is tax-deductible.

## Discount Rate

`Discount Rate` =  
`Debt Weight` × `Cost of Debt` × (1 − `Tax Rate`)  
+ `Equity Weight` × `Cost of Equity`
        """,
    }
})

# --- WACC Calculation
data.compute_results({
    "%costOfEquity": """
        assumption:%riskFreeRate +  assumption:#beta *  assumption:%equityRiskPremium
    """,
    "%costOfDebt": """
        income:interestExpense /  balance:totalDebt
    """,
    "%debtWeight": """
        balance:totalDebt / (profile:mktCap +  balance:totalDebt)
    """,
    "%equityWeight": """
        1 -  result:%debtWeight
    """,
    "%1TaxRate": """
        1 - assumption:%taxRate
    """,
    "%wacc": """
        result:%debtWeight *  result:%costOfDebt * (1 - assumption:%taxRate) +  result:%equityWeight* result:%costOfEquity
    """,
}, timeseries="annual")

model.render_results({
    "timeseries": "annual",
    "data": {
        "assumption:#beta": {
            "label": "Beta",
            "type": ""
        },
        "assumption:%equityRiskPremium": {
            "label": "* Equity Risk Premium",
            "type": "%"
        },
        "assumption:%riskFreeRate": {
            "label": "+ Risk Free Rate",
            "type": "%"
        },
        "result:%costOfEquity": {
            "label": "= Cost of Equity",
            "type": "%"
        },
        "result:%equityWeight": {
            "label": "* Equity Weight",
            "type": "%"
        },
        "result:%costOfDebt": {
            "label": "+ Cost of Debt",
            "type": "%"
        },
        "result:%debtWeight": {
            "label": "* Debt Weight",
            "type": "%"
        },
        "result:%1TaxRate": {
            "label": "* (1 - Tax Rate)",
            "type": "%"
        },
        "result:%wacc": {
            "label": "= WACC (Discount Rate)",
            "type": "%"
        },
    },
    "properties": {
        "title": "WACC Calculation",
        "width": "responsive",
        "hidden_keys": []
    }
})

# --- Discount Rate (WACC)
assumptions.set({
    "timeseries": "annual",
    "data": {
        "%discountRate": """
            result:%wacc
        """,
    },
    "titles": {
        "%discountRate": "Discount Rate",
    },
    "properties": {
        "width": "full",
        "title": "Discount Rate (WACC)",
        "id": "component-3",
        "bindTo": "component-1"
    },
    "descriptions": {
        "%discountRate": r"""
`Discount Rate` = `Equity Weight` * `Cost of Equity` + `Debt Weight` * `Cost of Debt` * (1 - `Tax Rate`)

Calculated using Weighted Average Cost of Capital (WACC) formula. It represents a firm’s average after-tax cost of capital from all sources, including common stock, preferred stock, bonds, and other forms of debt.

[Read More](https://www.investopedia.com/terms/w/wacc.asp)

---

### Cost of Equity

`Cost of Equity` = `Risk Free Rate` + `Beta` * `Market Premium`

The cost of equity is the theoretical rate of return that an equity investment should generate. It is calculated using the CAPM formula.

[Read More](https://www.investopedia.com/terms/c/costofequity.asp#mntl-sc-block_1-0-20)

---

### Cost of Debt

`Cost of Debt` = `Interest Expense` / `Total Debt`

The cost of debt is the effective rate that a company pays on its debt, such as bonds and loans.

[Read More](https://www.investopedia.com/terms/c/costofdebt.asp)

---

### Equity & Debt Weights

`Debt Weight` = `Total Debt` / (`Market Capitalization` + `Total Debt`) = 1 - `Equity Weight`

The Equity Weight represents the proportion of equity-based financing (Market Capitalization), while the Debt Weight represents the proportion of debt-based financing (Total Debt).

---

### Tax Rate

`Tax Rate` = `Income Tax Expense` / `Income Before Tax`

The overall tax rate paid by the company on its earned income.
        """,
    },
    "hierarchies": [
        {
            "parent": "%discountRate",
            "children": [
                "#beta",
                "%riskFreeRate",
                "%equityRiskPremium",
                "%taxRate",
            ]
        },
    ]
})

# --- Historical Averages
data.compute({
    "user:%revenueGrowthRate": """
        ( income:revenue / income:revenue:-1 ) - 1
    """,
    "user:ebit": """
        income:ebitda - income:depreciationAndAmortization
    """,
    "user:%ebitMargin": """
        user:ebit / income:revenue
    """,
    "user:%incomeTaxRate": """
        income:incomeTaxExpense / income:incomeBeforeTax 
        or if this <= 0:
        risk:corporateTaxRate
    """,
    "user:%dAMargin": """
        income:depreciationAndAmortization / income:revenue
    """,
    "user:%capexMargin": """
        flow:capitalExpenditure / income:revenue
    """,
    "user:%changeInWcMargin": """
        flow:changeInWorkingCapital / income:revenue
    """,
    "user:freeCashflowToFirmFcff": """
        user:ebit * (1 - user:%incomeTaxRate)
        + flow:capitalExpenditure 
        + income:depreciationAndAmortization 
        + flow:changeInWorkingCapital
    """,
    "user:%fcffMargin": """
        user:freeCashflowToFirmFcff / income:revenue
    """,
}, forecast=0, timeseries="annual")

model.render_table({
    "timeseries": "annual",
    "data": {
        "income:revenue": "Revenue",
        "user:%revenueGrowthRate": "Revenue Growth Rate",
        "user:ebit": "Earnings Before Interest and Taxes (EBIT)",
        "user:%ebitMargin": "EBIT Margin",
        "income:incomeTaxExpense": "Income Tax Expense",
        "user:%incomeTaxRate": "Income Tax Rate",
        "income:depreciationAndAmortization": "Depreciation and Amortization (D&A)",
        "user:%dAMargin": "D&A Margin",
        "flow:capitalExpenditure": "Capital Expenditure (CapEx)",
        "user:%capexMargin": "CapEx Margin",
        "flow:changeInWorkingCapital": "Change in Working Capital",
        "user:%changeInWcMargin": "Change in WC Margin",
        "user:freeCashflowToFirmFcff": "Free Cashflow to Firm (FCFF)",
        "user:%fcffMargin": "FCFF Margin",
    },
    "start": data.get("""
        -assumption:#historicalYears
    """),
    "end": 0,
    "properties": {
        "title": "Historical Averages",
        "order": "descending",
        "number_format": "M",
        "include_ltm": True,
        "display_averages": True,
        "width": "responsive"
    }
})

# --- Forecast Assumptions
assumptions.set({
    "timeseries": "annual",
    "data": {
        "#highGrowthYears": """
            5
        """,
        "%growthInPerpetuity": """
            2.5%
        """,
        "%revenueGrowthRate": """
             function:average(start=-assumption:#historicalYears, end=0):user:%revenueGrowthRate
        """,
        "%ebitMargin": """
             function:average(start=-assumption:#historicalYears, end=0):user:%ebitMargin
        """,
        "%changeInWorkingCapitalMargin": """
            function:average(start=-assumption:#historicalYears, end=0):user:%changeInWcMargin
        """,
        "%depreciationAndAmortizationMargin": """
             function:average(start=-assumption:#historicalYears, end=0):user:%dAMargin
        """,
        "%capitalExpenditureMargin": """
            function:average(start=-assumption:#historicalYears, end=0):user:%capexMargin
        """,
    },
    "titles": {
        "#highGrowthYears": "High Growth Years",
        "%growthInPerpetuity": "Growth in Perpetuity",
        "%revenueGrowthRate": "Revenue Growth Rate",
        "%ebitMargin": "EBIT Margin",
        "%changeInWorkingCapitalMargin": "Change in Working Capital Margin",
        "%depreciationAndAmortizationMargin": "Depreciation and Amortization Margin",
        "%capitalExpenditureMargin": "Capital Expenditure Margin",
    },
    "properties": {
        "width": "responsive",
        "title": "Forecast Assumptions",
        "id": "component-5",
        "bindTo": None
    },
    "descriptions": {
        "#highGrowthYears": r"""
Number of years with explicit projections before the model shifts to the terminal (perpetuity) period.
        """,
        "%growthInPerpetuity": r"""
Long-run constant growth rate used to calculate terminal value after the forecast period.
        """,
        "%revenueGrowthRate": r"""
Annual % increase in revenue during the forecast period.
        """,
        "%ebitMargin": r"""
EBIT as a % of revenue; reflects operating profitability and business mix.
        """,
        "%changeInWorkingCapitalMargin": r"""
Annual change in net working capital as a % of revenue; captures cash tied up (or released) in receivables, inventory, and payables.

- A negative value represents cash tied up in operations (reduces FCFF).
- A positive value represents a release of working capital (increases FCFF).
        """,
        "%depreciationAndAmortizationMargin": r"""
D&A as a % of revenue; a non-cash expense added back in cash flow, often linked to the asset base.
        """,
        "%capitalExpenditureMargin": r"""
CapEx as a % of revenue; cash reinvestment required to maintain and grow operations.
        """,
    }
})

# --- Forecasting
data.compute({
    "income:revenue": """
        income:revenue:-1 * (1+ assumption:%revenueGrowthRate)
    """,
    "user:ebit": """
        assumption:%ebitMargin * income:revenue
    """,
    "user:freeCashflowToFirmFcff": """
        user:ebit * (1 - assumption:%taxRate)
        + income:revenue * (
        assumption:%depreciationAndAmortizationMargin 
        + assumption:%capitalExpenditureMargin
        + assumption:%changeInWorkingCapitalMargin
        )
    """,
    "user:discountedFreeCashFlow": """
        user:freeCashflowToFirmFcff / (1 + assumption:%discountRate) ** time:index * (time:index > 0)
    """,
}, forecast=data.get("""
    assumption:#highGrowthYears
"""), timeseries="annual")

model.render_chart({
    "timeseries": "annual",
    "data": {
        "income:revenue": "Revenue",
        "user:ebit": "EBIT",
        "user:freeCashflowToFirmFcff": "Free Cashflow to Firm",
    },
    "start": -10,
    "end": data.get("""
        assumption:#highGrowthYears
    """),
    "properties": {
        "title": "Forecasting",
        "include_ltm": False,
        "set_editable": ["income:revenue", "user:freeCashflowToFirmFcff"],
        "hidden_keys": [],
        "bar_keys": [],
        "width": "full"
    }
})

# --- Fair Value Calculation
data.compute_results({
    "terminalValue": """
        user:freeCashflowToFirmFcff:assumption:#highGrowthYears * (1 + assumption:%growthInPerpetuity ) / ( assumption:%discountRate - assumption:%growthInPerpetuity) 
    """,
    "%totalTerminalValueDiscountRate": """
        (1 + assumption:%discountRate) ** assumption:#highGrowthYears - 1
    """,
    "discountedTerminalValue": """
        result:terminalValue / (1 + result:%totalTerminalValueDiscountRate)
    """,
    "sumOfDiscountedFreeCashFlow": """
         function:sum(start=1, end=assumption:#highGrowthYears):user:discountedFreeCashFlow
    """,
    "equityValue": """
        result:discountedTerminalValue + result:sumOfDiscountedFreeCashFlow + balance:cashAndShortTermInvestments - balance:totalDebt
    """,
    "#valuePerShare": """
        result:equityValue / income:weightedAverageShsOut
    """,
}, timeseries="annual")

model.render_results({
    "timeseries": "annual",
    "data": {
        "user:freeCashflowToFirmFcff:assumption:#highGrowthYears": {
            "label": "Exit Free Cashflow to Firm (FCFF)",
            "type": "$"
        },
        "result:terminalValue": {
            "label": "Terminal Enterprise Value (EV)",
            "type": "$"
        },
        "result:%totalTerminalValueDiscountRate": {
            "label": "Terminal Value Discount Factor",
            "type": "%"
        },
        "result:discountedTerminalValue": {
            "label": "Present Value of Terminal EV",
            "type": "$"
        },
        "result:sumOfDiscountedFreeCashFlow": {
            "label": "+ Cumulative Present Value of FCFF",
            "type": "$"
        },
        "balance:cashAndShortTermInvestments": {
            "label": "+ Cash and Short Term Investments",
            "type": "$"
        },
        "balance:totalDebt": {
            "label": "- Total Debt",
            "type": "$"
        },
        "result:equityValue": {
            "label": "= Equity Value",
            "type": "$"
        },
        "income:weightedAverageShsOut": {
            "label": "/ Shares Outstanding",
            "type": ""
        },
        "result:#valuePerShare": {
            "label": "= Fair Value per Share",
            "type": "$"
        },
    },
    "properties": {
        "title": "Fair Value Calculation",
        "width": "responsive",
        "hidden_keys": []
    }
})

# --- Fair Value per Share
model.set_final_value({
    "value": data.get("""
        result:#valuePerShare
    """, timeseries="annual"),
    "units": "$",
    "title": "Fair Value per Share",
    "properties": {
        "width": "responsive" 
    }
})

# --- Forecasted Data
data.compute({
    "user:%revenueGrowthRate": """
        ( income:revenue / income:revenue:-1 ) - 1
    """,
    "user:%freeCashFlowMargin": """
        user:freeCashflowToFirmFcff / income:revenue
    """,
}, forecast=data.get("""
    assumption:#highGrowthYears
"""), timeseries="annual")

model.render_table({
    "timeseries": "annual",
    "data": {
        "income:revenue": "Revenue",
        "user:%revenueGrowthRate": "Revenue Growth Rate",
        "user:freeCashflowToFirmFcff": "Free Cashflow to Firm (FCFF)",
        "user:%freeCashFlowMargin": "FCFF Margin",
        "user:discountedFreeCashFlow": "Present Value of FCFF",
    },
    "start": 1,
    "end": data.get("""
        assumption:#highGrowthYears
    """),
    "properties": {
        "title": "Forecasted Data",
        "order": "ascending",
        "number_format": "M",
        "include_ltm": False,
        "display_averages": False,
        "width": "responsive"
    }
})

Fair Value per Share

USD

Market Price USD

* Values are not guaranteed, please do your own
research before making investment decisions.

Discounted Cash Flow to Firm (Perpetual Growth)

This model estimates the fair value of a share by discounting projected Free Cash Flow to the Firm (FCFF), also known as Unlevered Free Cash Flow.

The terminal value assumes cashflow grows at a constant Growth in Perpetuity rate forever:

Terminal Enterprise Value = FCFF_(final forecast year) × (1 + Growth in Perpetuity) / (Discount Rate - Growth in Perpetuity)

The terminal value and projected FCFF are discounted to present value using WACC. Equity value is obtained by adjusting enterprise value for net debt:

Equity Value = Cumulative Present Value of FCFF + Present Value of Terminal EV + Cash and Short Term Investments − Total Debt

Fair Value per Share = Equity Value ÷ Shares Outstanding

This model was inspired by Prof. Aswath Damodaran's spreadsheet ⬇️fcff2st.xls

Learn more: Prof. Aswath Damodaran's Guide to Discounted Cash Flow Valuation

Discount Rate (WACC)

Discount Rate Discount Rate `Discount Rate` = `Equity Weight` * `Cost of Equity` + `Debt Weight` * `Cost of Debt` * (1 - `Tax Rate`) Calculated using Weighted Average Cost of Capital (WACC) formula. It represents a firm’s average after-tax cost of capital from all sources, including common stock, preferred stock, bonds, and other forms of debt. Read More Cost of Equity `Cost of Equity` = `Risk Free Rate` + `Beta` * `Market Premium` The cost of equity is the theoretical rate of return that an equity investment should generate. It is calculated using the CAPM formula. Read More Cost of Debt `Cost of Debt` = `Interest Expense` / `Total Debt` The cost of debt is the effective rate that a company pays on its debt, such as bonds and loans. Read More Equity & Debt Weights `Debt Weight` = `Total Debt` / (`Market Capitalization` + `Total Debt`) = 1 - `Equity Weight` The Equity Weight represents the proportion of equity-based financing (Market Capitalization), while the Debt Weight represents the proportion of debt-based financing (Total Debt). Tax Rate `Tax Rate` = `Income Tax Expense` / `Income Before Tax` The overall tax rate paid by the company on its earned income.	%
↳ Beta Beta Beta measures the volatility of a stock's price in relation to the overall stock market. A higher beta indicates greater price fluctuations relative to the market.	#
↳ Risk Free Rate Risk Free Rate The risk-free rate represents the return an investor expects from an absolutely risk-free investment over a specified time period. By default, it is set to the current yield of the U.S. 10-Year Treasury Bond.	%
↳ Equity Risk Premium Equity Risk Premium The market risk premium represents the additional return over the risk-free rate that investors expect for taking on the risks associated with equities.	%
↳ Tax Rate Tax Rate `Tax Rate` = `Income Tax Expense` / `Income Before Tax` This is the company’s effective tax rate, reflecting the average rate of tax actually paid on its pre-tax earnings (including all statutory, deferred, and non-recurring items). This rate is used to adjust the after-tax cost of debt, since interest expense is tax-deductible. Discount Rate `Discount Rate` = `Debt Weight` × `Cost of Debt` × (1 − `Tax Rate`) + `Equity Weight` × `Cost of Equity`	%
Historical Years Historical Years Number of trailing fiscal years used to compute historical averages/trends that feed the model’s default forecast assumptions (e.g., margins and growth).	#

WACC Calculation
Beta	1.53
* Equity Risk Premium	4.46%
+ Risk Free Rate	4.25%
= Cost of Equity	11.06%
* Equity Weight	88.12%
+ Cost of Debt	1.3%
* Debt Weight	11.88%
* (1 - Tax Rate)	83.04%
= WACC (Discount Rate)	9.88%

Historical Averages

Monetary values in USD amounts except #	Average	LTM Mar 20	2025 Dec 31	2024 Dec 31	2023 Dec 31
Revenue	23,418	28,893	28,893	20,777	15,107
Revenue Growth Rate	29.18%	0%	39.06%	37.53%	40.14%
Earnings Before Interest and Taxes (EBIT)	2,810	3,201	3,201	2,631	2,207
EBIT Margin	12.36%	11.08%	11.08%	12.66%	14.61%
Income Tax Expense	587.5	415	845	521	569
Income Tax Rate	26.17%	16.96%	29.73%	21.42%	36.57%
Depreciation and Amortization (D&A)	632.5	818	571	617	524
D&A Margin	2.81%	2.83%	1.98%	2.97%	3.47%
Capital Expenditure (CapEx)	-988	-1,240	-1,343	-860	-509
CapEx Margin	-4.11%	-4.29%	-4.65%	-4.14%	-3.37%
Change in Working Capital	3,666	5,240	4,436	3,191	1,795
Change in WC Margin	15.18%	18.14%	15.35%	15.36%	11.88%
Free Cashflow to Firm (FCFF)	5,404	7,476	5,913	5,015	3,210
FCFF Margin	22.94%	25.88%	20.47%	24.14%	21.25%

Forecast Assumptions

High Growth Years High Growth Years Number of years with explicit projections before the model shifts to the terminal (perpetuity) period.	#
Growth in Perpetuity Growth in Perpetuity Long-run constant growth rate used to calculate terminal value after the forecast period.	%
Revenue Growth Rate Revenue Growth Rate Annual % increase in revenue during the forecast period.	%
EBIT Margin EBIT Margin EBIT as a % of revenue; reflects operating profitability and business mix.	%
Change in Working Capital Margin Change in Working Capital Margin Annual change in net working capital as a % of revenue; captures cash tied up (or released) in receivables, inventory, and payables. A negative value represents cash tied up in operations (reduces FCFF). A positive value represents a release of working capital (increases FCFF).	%
Depreciation and Amortization Margin Depreciation and Amortization Margin D&A as a % of revenue; a non-cash expense added back in cash flow, often linked to the asset base.	%
Capital Expenditure Margin Capital Expenditure Margin CapEx as a % of revenue; cash reinvestment required to maintain and grow operations.	%

Forecasting

Monetary values in USD

{"sectionId": "section-chart-1", "sectionType": "chart", "title": "Forecasting", "timeseries": "annual", "series": [{"label": "Revenue", "mappingKey": "income:revenue", "data": [{"l": "2016", "x": "2016-12-31", "y": 844396000}, {"l": "2017", "x": "2017-12-31", "y": 1216542000}, {"l": "2018", "x": "2018-12-31", "y": 1439653000}, {"l": "2019", "x": "2019-12-31", "y": 2296314000}, {"l": "2020", "x": "2020-12-31", "y": 3974000000}, {"l": "2021", "x": "2021-12-31", "y": 7069000000}, {"l": "2022", "x": "2022-12-31", "y": 10780000000}, {"l": "2023", "x": "2023-12-31", "y": 15107000000}, {"l": "2024", "x": "2024-12-31", "y": 20777000000}, {"l": "2025", "x": "2025-12-31", "y": 28893000000}, {"l": "2026", "x": "2026-12-31", "y": 37324977182, "oy": 37324977182, "e": true, "d": 2026, "g": 29.18, "og": 29.18}, {"l": "2027", "x": "2027-12-31", "y": 48217697078, "oy": 48217697078, "e": true, "d": 2027, "g": 29.18, "og": 29.18}, {"l": "2028", "x": "2028-12-31", "y": 62289289559, "oy": 62289289559, "e": true, "d": 2028, "g": 29.18, "og": 29.18}, {"l": "2029", "x": "2029-12-31", "y": 80467459644, "oy": 80467459644, "e": true, "d": 2029, "g": 29.18, "og": 29.18}, {"l": "2030", "x": "2030-12-31", "y": 103950648779, "oy": 103950648779, "e": true, "d": 2030, "g": 29.18, "og": 29.18}], "dataType": ".", "displayAs": "line", "dataTimeseries": "annual", "hidden": false}, {"label": "EBIT", "mappingKey": "user:ebit", "data": [{"l": "2016", "x": "2016-12-31", "y": 181056000}, {"l": "2017", "x": "2017-12-31", "y": 56273000}, {"l": "2018", "x": "2018-12-31", "y": -69482000}, {"l": "2019", "x": "2019-12-31", "y": -153161000}, {"l": "2020", "x": "2020-12-31", "y": 128000000}, {"l": "2021", "x": "2021-12-31", "y": 441000000}, {"l": "2022", "x": "2022-12-31", "y": 1069000000}, {"l": "2023", "x": "2023-12-31", "y": 2207000000}, {"l": "2024", "x": "2024-12-31", "y": 2631000000}, {"l": "2025", "x": "2025-12-31", "y": 3201000000}, {"l": "2026", "x": "2026-12-31", "y": 4612413386}, {"l": "2027", "x": "2027-12-31", "y": 5958475215}, {"l": "2028", "x": "2028-12-31", "y": 7697364463}, {"l": "2029", "x": "2029-12-31", "y": 9943721765}, {"l": "2030", "x": "2030-12-31", "y": 12845643858}], "dataType": ".", "displayAs": "line", "dataTimeseries": "annual", "hidden": false}, {"label": "Free Cashflow to Firm", "mappingKey": "user:freeCashflowToFirmFcff", "data": [{"l": "2016", "x": "2016-12-31", "y": 66504624}, {"l": "2017", "x": "2017-12-31", "y": 53271445}, {"l": "2018", "x": "2018-12-31", "y": 174499394}, {"l": "2019", "x": "2019-12-31", "y": 176503250}, {"l": "2020", "x": "2020-12-31", "y": 629106753}, {"l": "2021", "x": "2021-12-31", "y": -248036448}, {"l": "2022", "x": "2022-12-31", "y": 1019587179}, {"l": "2023", "x": "2023-12-31", "y": 3209941516}, {"l": "2024", "x": "2024-12-31", "y": 5015368832}, {"l": "2025", "x": "2025-12-31", "y": 5913260028}, {"l": "2026", "x": "2026-12-31", "y": 9011561486, "oy": 9011561486, "e": true, "d": 2026, "g": 52.4, "og": 52.4}, {"l": "2027", "x": "2027-12-31", "y": 11641446954, "oy": 11641446954, "e": true, "d": 2027, "g": 29.18, "og": 29.18}, {"l": "2028", "x": "2028-12-31", "y": 15038824003, "oy": 15038824003, "e": true, "d": 2028, "g": 29.18, "og": 29.18}, {"l": "2029", "x": "2029-12-31", "y": 19427673235, "oy": 19427673235, "e": true, "d": 2029, "g": 29.18, "og": 29.18}, {"l": "2030", "x": "2030-12-31", "y": 25097340540, "oy": 25097340540, "e": true, "d": 2030, "g": 29.18, "og": 29.18}], "dataType": ".", "displayAs": "line", "dataTimeseries": "annual", "hidden": false}], "editableDates": {"2026-12-31": 25, "2027-12-31": 26, "2028-12-31": 27, "2029-12-31": 28, "2030-12-31": 29}, "properties": {"display_table": true}, "width": "full"}

Edit Chart Values	2026-12-31	2027-12-31	2028-12-31	2029-12-31	2030-12-31

↳ Growth Rate

Fair Value Calculation
Exit Free Cashflow to Firm (FCFF)	25.1 Bil. USD
Terminal Enterprise Value (EV)	348.8 Bil. USD
Terminal Value Discount Factor	60.14%
Present Value of Terminal EV	217.8 Bil. USD
+ Cumulative Present Value of FCFF	58.18 Bil. USD
+ Cash and Short Term Investments	6.3 Bil. USD
- Total Debt	11.39 Bil. USD
= Equity Value	270.9 Bil. USD
/ Shares Outstanding	50.7 Mil.
= Fair Value per Share	5.34 Thou. USD

Forecasted Data

Monetary values in USD amounts except #	2026 Dec 31	2027 Dec 31	2028 Dec 31	2029 Dec 31	2030 Dec 31
Revenue	37,325	48,218	62,289	80,467	103,951
Revenue Growth Rate	29.18%	29.18%	29.18%	29.18%	29.18%
Free Cashflow to Firm (FCFF)	9,012	11,641	15,039	19,428	25,097
FCFF Margin	24.14%	24.14%	24.14%	24.14%	24.14%
Present Value of FCFF	8,202	9,643	11,338	13,330	15,673

Market is Open

After-Hours Quote

Market is Open

After-Hours Quote

MercadoLibre, Inc. Discounted Cash Flow to Firm - Perpetual Growth

Fair Value per Share

USD

Market Price USD

Discounted Cash Flow to Firm (Perpetual Growth)

Discount Rate (WACC)

Discount Rate

Cost of Equity

Cost of Debt

Equity & Debt Weights

Tax Rate

Beta

Risk Free Rate

Equity Risk Premium

Tax Rate

Discount Rate

Historical Years

WACC Calculation

Historical Averages

Forecast Assumptions

High Growth Years

Growth in Perpetuity

Revenue Growth Rate

EBIT Margin

Change in Working Capital Margin

Depreciation and Amortization Margin

Capital Expenditure Margin

Forecasting

Fair Value Calculation

Forecasted Data

Discounted Cash Flow to Firm - Perpetual Growth

Earnings Power Value

Simple Dividend Discount Model

Simple Excess Return Model

Two-Stage Dividend Discount Model

Two-Stage Excess Return Model

Discounted Cash Flow to Firm - Exit Multiple

Discounted Future Market Cap

Peter Lynch Fair Value

Altman Z-Score

Beneish M-Score

Capital Asset Pricing Model (CAPM)

Margin Analysis

Piotroski F-Score

Return on Invested Capital (ROIC)

Shiller PE (CAPE) Ratio

Weighted Average Cost of Capital (WACC)