NN, Inc. (NNBR) DCF Valuation

NN, Inc. (NNBR) DCF Valuation

US | Industrials | Conglomerates | NASDAQ
NN, Inc. (NNBR) DCF Valuation
  • Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
  • Design Profissional: Modelos Confiáveis ​​E Padrão Da Indústria
  • Pré-Construídos Para Uso Rápido E Eficiente
  • Não É Necessária Experiência; Fácil De Seguir

NN, Inc. (NNBR) Bundle

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

TOTAL:

As an investor or analyst, the (NNBR) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from NN, Inc., you can easily adjust forecasts and observe the effects in real-time.


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 847.5 427.5 477.6 498.7 489.3 446.1 406.7 370.8 338.1 308.2
Revenue Growth, % 0 -49.55 11.71 4.43 -1.9 -8.83 -8.83 -8.83 -8.83 -8.83
EBITDA 24.4 -96.4 36.3 31.6 15.4 -2.3 -2.1 -1.9 -1.7 -1.6
EBITDA, % 2.88 -22.55 7.61 6.34 3.15 -0.51474 -0.51474 -0.51474 -0.51474 -0.51474
Depreciation 44.9 45.7 46.2 47.2 46.1 39.7 36.2 33.0 30.1 27.5
Depreciation, % 5.3 10.68 9.67 9.47 9.43 8.91 8.91 8.91 8.91 8.91
EBIT -20.5 -142.1 -9.9 -15.6 -30.7 -42.0 -38.3 -34.9 -31.9 -29.0
EBIT, % -2.42 -33.24 -2.06 -3.13 -6.28 -9.43 -9.43 -9.43 -9.43 -9.43
Total Cash 31.7 48.1 28.7 12.8 21.9 25.0 22.8 20.8 19.0 17.3
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 131.6 93.4 83.2 86.3 77.4
Account Receivables, % 15.52 21.85 17.43 17.3 15.83
Inventories 118.7 62.5 75.0 80.7 71.6 67.0 61.1 55.7 50.8 46.3
Inventories, % 14.01 14.62 15.71 16.18 14.63 15.03 15.03 15.03 15.03 15.03
Accounts Payable 41.7 37.4 36.7 45.9 45.5 35.6 32.4 29.6 26.9 24.6
Accounts Payable, % 4.92 8.76 7.69 9.2 9.3 7.97 7.97 7.97 7.97 7.97
Capital Expenditure -53.3 -23.8 -18.2 -18.0 -20.5 -20.9 -19.1 -17.4 -15.9 -14.5
Capital Expenditure, % -6.29 -5.56 -3.82 -3.6 -4.19 -4.69 -4.69 -4.69 -4.69 -4.69
Tax Rate, % 6.56 6.56 6.56 6.56 6.56 6.56 6.56 6.56 6.56 6.56
EBITAT -19.2 -133.7 -9.1 -16.4 -28.7 -39.8 -36.3 -33.1 -30.2 -27.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -236.3 -21.7 15.8 13.3 14.5 -27.4 -9.4 -8.6 -7.8 -7.1
WACC, % 13.66 13.68 13.56 14.05 13.64 13.72 13.72 13.72 13.72 13.72
PV UFCF
SUM PV UFCF -45.7
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -7
Terminal Value -62
Present Terminal Value -33
Enterprise Value -78
Net Debt 191
Equity Value -269
Diluted Shares Outstanding, MM 47
Equity Value Per Share -5.76

What You Will Receive

  • Comprehensive Financial Model: NN, Inc.'s (NNBR) real data facilitates accurate DCF valuation.
  • Complete Forecasting Control: Modify revenue growth, profit margins, WACC, and other critical factors.
  • Real-Time Calculations: Automatic updates provide immediate results as adjustments are made.
  • Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
  • Flexible and Reusable: Designed for adaptability, allowing for repeated use in thorough forecasting.

Key Features

  • 🔍 Real-Life NNBR Financials: Pre-filled historical and projected data for NN, Inc.
  • ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • 📊 Professional DCF Valuation: Built-in formulas calculate NN, Inc.’s intrinsic value using the Discounted Cash Flow method.
  • ⚡ Instant Results: Visualize NN, Inc.’s valuation instantly after making changes.
  • Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.

How It Works

  1. Download the Template: Gain immediate access to the Excel-based NN, Inc. (NNBR) DCF Calculator.
  2. Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
  3. Instant Calculations: The model automatically recalculates NN, Inc.'s (NNBR) intrinsic value.
  4. Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
  5. Analyze and Decide: Utilize the findings to inform your investment or financial analysis.

Why Choose NN, Inc. (NNBR) Calculator?

  • Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses all in one convenient package.
  • Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
  • Detailed Insights: Automatically computes NN, Inc.’s intrinsic value and Net Present Value.
  • Preloaded Data: Includes historical and forecasted data for precise starting points.
  • Professional Quality: Perfect for financial analysts, investors, and business consultants.

Who Should Use NN, Inc. (NNBR)?

  • Professional Investors: Develop comprehensive and accurate valuation models for investment assessments.
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decision-making.
  • Consultants and Advisors: Deliver precise valuation insights for NN, Inc. (NNBR) to clients.
  • Students and Educators: Utilize real-world data to practice and instruct financial modeling techniques.
  • Industry Analysts: Gain insights into how companies like NN, Inc. (NNBR) are valued within their sectors.

What the Template Contains

  • Pre-Filled DCF Model: NN, Inc.'s (NNBR) financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate NN, Inc.'s (NNBR) profitability, leverage, and efficiency.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
  • Financial Statements: Annual and quarterly reports to support detailed analysis.
  • Interactive Dashboard: Easily visualize key valuation metrics and results.