CBL & Associates Properties, Inc. (CBL) DCF Valuation

CBL & Associates Properties, Inc. (CBL) DCF Valuation
  • ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
  • ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
  • ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
  • ✓ Aucune Expertise N'Est Requise; Facile À Suivre

CBL & Associates Properties, Inc. (CBL) 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:

Streamline your analysis and improve precision with our CBL (CBL) DCF Calculator! Utilizing up-to-date data from CBL & Associates Properties, Inc. and customizable assumptions, this tool empowers you to forecast, analyze, and value CBL like a seasoned investor.


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 768.7 575.9 576.9 563.0 535.3 492.1 452.5 416.0 382.5 351.7
Revenue Growth, % 0 -25.09 0.17608 -2.4 -4.92 -8.06 -8.06 -8.06 -8.06 -8.06
EBITDA 473.9 310.7 339.4 328.0 283.9 281.2 258.5 237.7 218.6 200.9
EBITDA, % 61.65 53.95 58.83 58.25 53.03 57.14 57.14 57.14 57.14 57.14
Depreciation 552.6 480.2 208.1 516.1 190.5 313.6 288.3 265.1 243.7 224.1
Depreciation, % 71.89 83.39 36.07 91.67 35.59 63.72 63.72 63.72 63.72 63.72
EBIT -78.7 -169.5 131.3 -188.1 93.4 -32.4 -29.8 -27.4 -25.2 -23.1
EBIT, % -10.24 -29.44 22.76 -33.41 17.44 -6.58 -6.58 -6.58 -6.58 -6.58
Total Cash 32.8 294.9 319.6 337.1 34.2 174.4 160.3 147.4 135.5 124.6
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 75.3 109.6 649.0 463.3 43.4
Account Receivables, % 9.79 19.03 112.5 82.28 8.11
Inventories -4,598.7 171.4 199.5 .0 .0 -35.1 -32.3 -29.7 -27.3 -25.1
Inventories, % -598.25 29.76 34.59 0.000000178 0 -7.13 -7.13 -7.13 -7.13 -7.13
Accounts Payable 219.0 164.0 184.4 200.3 106.1 142.1 130.6 120.1 110.4 101.5
Accounts Payable, % 28.49 28.48 31.97 35.58 19.82 28.87 28.87 28.87 28.87 28.87
Capital Expenditure 5.8 -1.3 -4.8 -4.2 .0 -1.8 -1.6 -1.5 -1.4 -1.3
Capital Expenditure, % 0.7527 -0.21932 -0.83606 -0.75274 0 -0.36162 -0.36162 -0.36162 -0.36162 -0.36162
Tax Rate, % 184.28 184.28 184.28 184.28 184.28 184.28 184.28 184.28 184.28 184.28
EBITAT -80.6 -178.5 128.8 -194.1 -78.7 -25.8 -23.7 -21.8 -20.0 -18.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 5,220.2 -4,559.0 -215.0 718.9 437.4 184.8 266.1 244.6 224.9 206.8
WACC, % 9.63 9.63 9.52 9.63 3.67 8.42 8.42 8.42 8.42 8.42
PV UFCF
SUM PV UFCF 889.6
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 211
Terminal Value 3,287
Present Terminal Value 2,194
Enterprise Value 3,084
Net Debt 1,935
Equity Value 1,149
Diluted Shares Outstanding, MM 31
Equity Value Per Share 36.71

What You Will Receive

  • Comprehensive Financial Model: CBL's actual data allows for accurate DCF valuation.
  • Complete Forecast Control: Modify revenue growth, profit margins, WACC, and other essential variables.
  • Real-Time Calculations: Automatic updates ensure you see the outcomes as adjustments are made.
  • Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
  • Flexible and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.

Key Features

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

How It Works

  • Step 1: Download the prebuilt Excel template containing CBL & Associates Properties, Inc. (CBL) data.
  • Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
  • Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
  • Step 4: Instantly see the recalculated results, including CBL & Associates Properties, Inc.'s intrinsic value.
  • Step 5: Use the outputs to make informed investment decisions or to create reports.

Why Choose This CBL & Associates Properties, Inc. (CBL) Calculator?

  • Accuracy: Utilizes real CBL financial data to ensure precise calculations.
  • Flexibility: Allows users to easily test and adjust inputs as needed.
  • Time-Saving: Avoid the complexities of creating a financial model from the ground up.
  • Professional-Grade: Crafted with the expertise and precision expected at the CFO level.
  • User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.

Who Should Use This Product?

  • Investors: Accurately estimate CBL & Associates Properties, Inc.'s (CBL) fair value before making investment decisions.
  • CFOs: Utilize a professional-grade DCF model for financial reporting and analysis related to CBL.
  • Consultants: Swiftly adapt the template for valuation reports for clients focusing on CBL.
  • Entrepreneurs: Acquire insights into financial modeling practices used by major real estate firms like CBL.
  • Educators: Employ it as a teaching tool to illustrate valuation methodologies relevant to CBL.

What the Template Contains

  • Preloaded CBL Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
  • DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
  • Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
  • Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
  • Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
  • Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.

No products were found matching.