StoneCo Ltd. (STNE) DCF Valuation

StoneCo Ltd. (STNE) DCF Valuation
  • ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
  • ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
  • ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
  • ✓ No Se Necesita Experiencia; Fáciles De Seguir

StoneCo Ltd. (STNE) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Explore the financial potential of StoneCo Ltd. (STNE) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of StoneCo Ltd. (STNE) and inform your investment decisions.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2019		 AY2
2020		 AY3
2021		 AY4
2022		 AY5
2023		 FY1
2024		 FY2
2025		 FY3
2026		 FY4
2027		 FY5
2028
Revenue 385.7 513.1 738.6 1,455.1 1,834.0 2,751.1 4,127.0 6,190.9 9,287.1 13,931.5
Revenue Growth, % 0 33.03 43.95 97.02 26.04 50.01 50.01 50.01 50.01 50.01
EBITDA 259.4 278.2 .1 217.3 572.0 922.4 1,383.6 2,075.6 3,113.6 4,670.8
EBITDA, % 67.27 54.22 0.01616093 14.94 31.19 33.53 33.53 33.53 33.53 33.53
Depreciation 26.4 41.4 81.9 129.2 141.7 234.3 351.5 527.3 791.1 1,186.7
Depreciation, % 6.84 8.06 11.09 8.88 7.73 8.52 8.52 8.52 8.52 8.52
EBIT 233.1 236.8 -81.8 88.2 430.3 688.0 1,032.1 1,548.3 2,322.6 3,484.1
EBIT, % 60.43 46.16 -11.07 6.06 23.46 25.01 25.01 25.01 25.01 25.01
Total Cash 630.3 1,706.6 1,425.9 1,440.7 913.1 2,469.4 3,704.4 5,557.0 8,336.1 12,504.9
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 2,318.5 2,869.3 3,290.2 3,442.4 3,930.6
Account Receivables, % 601.19 559.25 445.49 236.57 214.32
Inventories 4.3 17.9 62.8 26.7 .0 82.2 123.2 184.9 277.3 416.0
Inventories, % 1.11 3.48 8.5 1.84 0 2.99 2.99 2.99 2.99 2.99
Accounts Payable 15.8 29.1 60.1 96.2 82.9 159.8 239.7 359.6 539.5 809.3
Accounts Payable, % 4.09 5.68 8.14 6.61 4.52 5.81 5.81 5.81 5.81 5.81
Capital Expenditure -64.6 -73.4 -209.6 -116.7 -195.3 -429.7 -644.7 -967.1 -1,450.7 -2,176.2
Capital Expenditure, % -16.74 -14.32 -28.38 -8.02 -10.65 -15.62 -15.62 -15.62 -15.62 -15.62
Tax Rate, % 19.22 19.22 19.22 19.22 19.22 19.22 19.22 19.22 19.22 19.22
EBITAT 171.8 179.4 -77.9 119.9 347.6 585.6 878.4 1,317.7 1,976.7 2,965.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -2,173.4 -403.7 -640.4 52.3 -180.8 1,564.3 -751.8 -1,127.7 -1,691.7 -2,537.7
WACC, % 13.74 13.81 14.43 14.58 13.97 14.11 14.11 14.11 14.11 14.11
PV UFCF
SUM PV UFCF -2,275.2
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -2,588
Terminal Value -21,381
Present Terminal Value -11,053
Enterprise Value -13,328
Net Debt 539
Equity Value -13,867
Diluted Shares Outstanding, MM 319
Equity Value Per Share -43.44

What You Will Get

  • Real STNE Financials: Access to historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
  • Scenario Analysis: Explore various scenarios to assess StoneCo's future performance.
  • User-Friendly Design: Designed for professionals while remaining accessible to newcomers.

Key Features

  • Pre-Loaded Data: StoneCo Ltd.'s historical financial statements and pre-filled forecasts.
  • Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
  • Instant Results: Watch StoneCo Ltd.'s intrinsic value update in real time.
  • Clear Visual Outputs: Dashboard charts illustrate valuation results and key metrics effectively.
  • Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered StoneCo Ltd. (STNE) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for StoneCo Ltd. (STNE)’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator for StoneCo Ltd. (STNE)?

  • User-Friendly Interface: Tailored for both novices and seasoned professionals.
  • Customizable Inputs: Adjust parameters easily to suit your financial analysis.
  • Real-Time Valuation: Observe immediate changes to StoneCo's valuation as you modify inputs.
  • Preloaded Data: Comes equipped with StoneCo's actual financial metrics for swift evaluations.
  • Preferred by Experts: Utilized by investors and analysts for making well-informed choices.

Who Should Use This Product?

  • Finance Students: Master valuation techniques and apply them using real data from StoneCo Ltd. (STNE).
  • Academics: Integrate industry-standard models into your coursework or research focused on StoneCo Ltd. (STNE).
  • Investors: Validate your own assumptions and analyze valuation outcomes for StoneCo Ltd. (STNE) stock.
  • Analysts: Enhance your efficiency with a pre-built, customizable DCF model tailored for StoneCo Ltd. (STNE).
  • Small Business Owners: Understand the analytical approaches used for large public companies like StoneCo Ltd. (STNE).

What the Template Contains

  • Pre-Filled Data: Includes StoneCo Ltd.'s historical financials and forecasts.
  • Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
  • Key Financial Ratios: Analyze StoneCo Ltd.'s profitability, efficiency, and leverage.
  • Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
  • Clear Dashboard: Charts and tables summarizing key valuation results.

No products were found matching.