Goldman Sachs BDC, Inc. (GSBD) DCF Valuation

Goldman Sachs BDC, Inc. (GSBD) 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

Goldman Sachs BDC, Inc. (GSBD) 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:

Designed for accuracy, our (GSBD) DCF Calculator empowers you to evaluate Goldman Sachs BDC, Inc. valuation using real-world financial data while offering complete flexibility to modify all essential parameters for enhanced projections.


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 43.3 146.6 170.1 56.6 454.9 624.7 858.0 1,178.3 1,618.2 2,222.3
Revenue Growth, % 0 238.64 16.03 -66.7 703.17 37.33 37.33 37.33 37.33 37.33
EBITDA .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
EBITDA, % 0 0 0 0 0 0 0 0 0 0
Depreciation 71.3 -93.7 138.4 201.0 -363.4 171.9 236.1 324.3 445.3 611.6
Depreciation, % 164.62 -63.89 81.37 354.92 -79.88 27.52 27.52 27.52 27.52 27.52
EBIT -71.3 93.7 -138.4 -201.0 363.4 -171.9 -236.1 -324.3 -445.3 -611.6
EBIT, % -164.62 63.89 -81.37 -354.92 79.88 -27.52 -27.52 -27.52 -27.52 -27.52
Total Cash 9.4 32.1 33.8 39.6 52.4 181.1 248.7 341.6 469.1 644.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 5.8 24.2 23.3 31.8 38.5
Account Receivables, % 13.39 16.5 13.69 56.11 8.47
Inventories .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Inventories, % 0 0 0 0 0 0 0 0 0 0
Accounts Payable 20.5 55.9 60.8 59.6 62.7 293.5 403.1 553.5 760.2 1,044.0
Accounts Payable, % 47.29 38.1 35.72 105.21 13.78 46.98 46.98 46.98 46.98 46.98
Capital Expenditure .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Capital Expenditure, % 0 0 0 0 0 0 0 0 0 0
Tax Rate, % 2.72 2.72 2.72 2.72 2.72 2.72 2.72 2.72 2.72 2.72
EBITAT -68.2 92.9 -137.2 -185.2 353.5 -166.2 -228.3 -313.5 -430.6 -591.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 17.8 16.2 7.0 6.1 -13.6 139.9 66.9 91.9 126.3 173.4
WACC, % 7.51 7.63 7.63 7.39 7.57 7.55 7.55 7.55 7.55 7.55
PV UFCF
SUM PV UFCF 476.8
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 177
Terminal Value 3,190
Present Terminal Value 2,217
Enterprise Value 2,694
Net Debt 1,774
Equity Value 920
Diluted Shares Outstanding, MM 108
Equity Value Per Share 8.49

What You Will Get

  • Real Goldman Sachs BDC Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
  • Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Goldman Sachs BDC’s fair value.
  • Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
  • Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.

Key Features

  • Comprehensive Financial Data: Goldman Sachs BDC, Inc.'s historical financial statements and pre-filled projections.
  • Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
  • Real-Time Valuation: Observe Goldman Sachs BDC, Inc.'s intrinsic value update instantly.
  • Intuitive Visuals: Dashboard graphics present valuation outcomes and essential metrics clearly.
  • Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.

How It Works

  1. Step 1: Download the Excel file for Goldman Sachs BDC, Inc. (GSBD).
  2. Step 2: Review the pre-filled financial data and forecasts for Goldman Sachs BDC, Inc. (GSBD).
  3. Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you modify your assumptions.
  5. Step 5: Evaluate the outputs and leverage the results for your investment strategies.

Why Choose This Calculator for Goldman Sachs BDC, Inc. (GSBD)?

  • User-Friendly Interface: Tailored for both novice users and seasoned professionals.
  • Customizable Inputs: Adjust assumptions effortlessly to suit your financial analysis.
  • Real-Time Valuation: Observe immediate updates to Goldman Sachs BDC’s valuation with input changes.
  • Preloaded Data: Comes with Goldman Sachs BDC’s actual financial metrics for swift evaluations.
  • Preferred by Experts: A go-to tool for investors and analysts seeking reliable insights.

Who Should Use Goldman Sachs BDC, Inc. (GSBD)?

  • Investors: Gain insights and make informed choices with a leading investment vehicle.
  • Financial Analysts: Streamline your analysis with comprehensive data and reports tailored for GSBD.
  • Consultants: Effortlessly modify resources for client engagements or investment strategies involving GSBD.
  • Finance Enthusiasts: Enhance your knowledge of business development companies through GSBD's performance and strategies.
  • Educators and Students: Utilize GSBD as a case study for practical applications in finance education.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled Goldman Sachs BDC, Inc. (GSBD) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
  • WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
  • DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
  • Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
  • Key Ratios: Includes profitability, leverage, and efficiency ratios for Goldman Sachs BDC, Inc. (GSBD).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

No products were found matching.