Vacasa, Inc. (VCSA) DCF Valuation

Vacasa, Inc. (VCSA) DCF Valuation
  • Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • Professional Design: Trusted, Industry-Standard Templates
  • Pre-Built For Quick And Efficient Use
  • No Expertise Is Needed; Easy To Follow

Vacasa, Inc. (VCSA) 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 Vacasa, Inc.'s (VCSA) financial outlook with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and expenses to determine Vacasa, Inc.'s (VCSA) intrinsic value and enhance your investment strategy.


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 299.3 491.8 889.1 1,188.0 1,118.0 1,601.0 2,292.7 3,283.4 4,702.1 6,733.7
Revenue Growth, % 0 64.31 80.79 33.62 -5.89 43.21 43.21 43.21 43.21 43.21
EBITDA -66.5 -50.4 -60.8 -227.1 -426.9 -309.3 -443.0 -634.4 -908.5 -1,301.1
EBITDA, % -22.21 -10.26 -6.84 -19.12 -38.18 -19.32 -19.32 -19.32 -19.32 -19.32
Depreciation 13.7 34.3 61.3 101.4 97.3 114.3 163.6 234.3 335.6 480.6
Depreciation, % 4.57 6.97 6.89 8.54 8.71 7.14 7.14 7.14 7.14 7.14
EBIT -80.2 -84.7 -122.1 -328.6 -524.2 -423.6 -606.6 -868.8 -1,244.1 -1,781.7
EBIT, % -26.78 -17.23 -13.73 -27.66 -46.89 -26.46 -26.46 -26.46 -26.46 -26.46
Total Cash 144.2 218.5 353.8 157.8 88.0 491.7 704.2 1,008.5 1,444.2 2,068.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 19.5 10.2 49.0 17.2 14.2
Account Receivables, % 6.51 2.07 5.51 1.45 1.27
Inventories 65.3 72.5 165.3 161.9 .0 220.2 315.4 451.7 646.8 926.3
Inventories, % 21.81 14.75 18.59 13.62 0 13.76 13.76 13.76 13.76 13.76
Accounts Payable 19.1 15.6 34.8 35.4 30.4 61.4 87.9 125.9 180.4 258.3
Accounts Payable, % 6.39 3.18 3.91 2.98 2.72 3.84 3.84 3.84 3.84 3.84
Capital Expenditure -21.5 -9.5 -11.2 -18.6 -12.7 -41.8 -59.9 -85.8 -122.9 -176.0
Capital Expenditure, % -7.17 -1.93 -1.26 -1.57 -1.14 -2.61 -2.61 -2.61 -2.61 -2.61
Tax Rate, % 43.28 43.28 43.28 43.28 43.28 43.28 43.28 43.28 43.28 43.28
EBITAT -80.1 -84.5 -122.7 -329.6 -297.3 -386.6 -553.6 -792.8 -1,135.4 -1,625.9
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -153.5 -61.0 -185.1 -210.9 -52.9 -542.9 -541.8 -775.9 -1,111.1 -1,591.2
WACC, % 8 7.99 8 8 6.54 7.7 7.7 7.7 7.7 7.7
PV UFCF
SUM PV UFCF -3,515.7
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -1,623
Terminal Value -28,452
Present Terminal Value -19,631
Enterprise Value -23,147
Net Debt -62
Equity Value -23,085
Diluted Shares Outstanding, MM 12
Equity Value Per Share -1,891.87

What You Will Receive

  • Pre-Filled Financial Model: Vacasa’s actual data allows for accurate DCF valuation.
  • Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
  • Real-Time Calculations: Automatic updates provide immediate feedback as you make adjustments.
  • Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
  • Customizable and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.

Key Features

  • Comprehensive Data: Vacasa, Inc.’s historical financial statements and pre-filled forecasts.
  • Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
  • Real-Time Results: View Vacasa’s intrinsic value recalculated instantly.
  • Visual Performance Metrics: Dashboard charts present valuation results and essential metrics clearly.
  • Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.

How It Works

  • Step 1: Download the prebuilt Excel template featuring Vacasa, Inc.'s (VCSA) data.
  • Step 2: Navigate through the pre-filled sheets to grasp the essential metrics.
  • Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
  • Step 4: Immediately view recalculated results, including Vacasa, Inc.'s (VCSA) intrinsic value.
  • Step 5: Make well-informed investment decisions or create reports using the generated outputs.

Why Choose This Calculator?

  • Designed for Industry Experts: A sophisticated tool utilized by property managers, real estate analysts, and investors.
  • Comprehensive Data: Vacasa’s historical and projected performance metrics are preloaded for your convenience.
  • Flexible Scenario Analysis: Easily model various rental scenarios and market conditions.
  • Insightful Outputs: Automatically computes intrinsic value, ROI, and other essential metrics.
  • User-Friendly Interface: Step-by-step guidance ensures a smooth navigation experience.

Who Should Use Vacasa, Inc. (VCSA)?

  • Property Owners: Optimize rental income with expert management solutions tailored for your property.
  • Real Estate Investors: Make informed decisions using data-driven insights and market analysis.
  • Vacation Rental Hosts: Streamline operations with customizable tools for bookings and guest communication.
  • Travel Enthusiasts: Discover unique vacation experiences through curated rental options.
  • Industry Professionals: Enhance your understanding of the vacation rental market with comprehensive resources and case studies.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled Vacasa, Inc. (VCSA) 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 Vacasa, Inc. (VCSA).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.