US Foods Holding Corp. (USFD) DCF Valuation

US Foods Holding Corp. (USFD) 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

US Foods Holding Corp. (USFD) 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 prospects of US Foods Holding Corp. (USFD) with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and costs to calculate the intrinsic value of US Foods Holding Corp. (USFD) and refine your investment approach.


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 25,939.0 22,885.0 29,487.0 34,057.0 35,597.0 38,898.2 42,505.5 46,447.3 50,754.8 55,461.6
Revenue Growth, % 0 -11.77 28.85 15.5 4.52 9.27 9.27 9.27 9.27 9.27
EBITDA 1,121.0 371.0 841.0 1,023.0 1,397.0 1,223.2 1,336.6 1,460.6 1,596.1 1,744.1
EBITDA, % 4.32 1.62 2.85 3 3.92 3.14 3.14 3.14 3.14 3.14
Depreciation 362.0 422.0 378.0 372.0 395.0 523.1 571.6 624.6 682.5 745.8
Depreciation, % 1.4 1.84 1.28 1.09 1.11 1.34 1.34 1.34 1.34 1.34
EBIT 759.0 -51.0 463.0 651.0 1,002.0 700.1 765.1 836.0 913.6 998.3
EBIT, % 2.93 -0.22285 1.57 1.91 2.81 1.8 1.8 1.8 1.8 1.8
Total Cash 90.0 828.0 148.0 211.0 269.0 454.5 496.7 542.7 593.0 648.0
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 1,455.0 1,084.0 1,614.0 1,848.0 2,010.0
Account Receivables, % 5.61 4.74 5.47 5.43 5.65
Inventories 1,432.0 1,273.0 1,686.0 1,616.0 1,600.0 2,025.9 2,213.8 2,419.0 2,643.4 2,888.5
Inventories, % 5.52 5.56 5.72 4.74 4.49 5.21 5.21 5.21 5.21 5.21
Accounts Payable 1,460.0 1,218.0 1,662.0 1,855.0 2,051.0 2,162.4 2,362.9 2,582.1 2,821.5 3,083.2
Accounts Payable, % 5.63 5.32 5.64 5.45 5.76 5.56 5.56 5.56 5.56 5.56
Capital Expenditure -258.0 -189.0 -274.0 -265.0 -309.0 -342.0 -373.7 -408.4 -446.2 -487.6
Capital Expenditure, % -0.99464 -0.82587 -0.92922 -0.77811 -0.86805 -0.87918 -0.87918 -0.87918 -0.87918 -0.87918
Tax Rate, % 25.37 25.37 25.37 25.37 25.37 25.37 25.37 25.37 25.37 25.37
EBITAT 571.8 -39.2 354.8 477.9 747.8 527.8 576.7 630.2 688.6 752.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -751.2 481.8 -40.2 613.9 883.8 312.2 593.2 648.2 708.3 774.0
WACC, % 10.51 10.54 10.53 10.49 10.5 10.51 10.51 10.51 10.51 10.51
PV UFCF
SUM PV UFCF 2,192.9
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) 797
Terminal Value 10,610
Present Terminal Value 6,437
Enterprise Value 8,629
Net Debt 4,933
Equity Value 3,696
Diluted Shares Outstanding, MM 250
Equity Value Per Share 14.79

What You Will Get

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

Key Features

  • Pre-Loaded Data: US Foods Holding Corp.'s historical financial statements and pre-filled forecasts.
  • Fully Adjustable Inputs: Edit WACC, tax rates, revenue growth, and EBITDA margins.
  • Instant Results: See US Foods Holding Corp.'s intrinsic value recalculate in real time.
  • Clear Visual Outputs: Dashboard charts display valuation results and key metrics.
  • Built for Accuracy: A professional tool for analysts, investors, and finance experts.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review US Foods Holding Corp.'s pre-filled financial data and forecasts.
  3. Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Watch the DCF model update instantly as you tweak assumptions.
  5. Step 5: Analyze the outputs and use the results for investment decisions regarding US Foods Holding Corp. (USFD).

Why Choose This Calculator for US Foods Holding Corp. (USFD)?

  • Accuracy: Utilizes real US Foods financial data to ensure precision.
  • Flexibility: Allows users to easily test and adjust inputs as needed.
  • Time-Saving: Eliminate the need to create a DCF model from the ground up.
  • Professional-Grade: Crafted with the expertise and usability expected by CFOs.
  • User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.

Who Should Use US Foods Holding Corp. (USFD)?

  • Investors: Make informed choices with a comprehensive analysis of the food distribution market.
  • Financial Analysts: Streamline your workflow with detailed financial reports and insights on USFD.
  • Consultants: Easily tailor presentations and recommendations for clients in the food service industry.
  • Food Industry Enthusiasts: Enhance your knowledge of market dynamics and trends affecting USFD.
  • Educators and Students: Utilize it as a resource for case studies in finance and business courses.

What the Template Contains

  • Preloaded USFD 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.

Es wurden keine passenden Produkte gefunden.