Natural Grocers by Vitamin Cottage, Inc. (NGVC) DCF Valuation

Natural Grocers by Vitamin Cottage, Inc. (NGVC) 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

Natural Grocers by Vitamin Cottage, Inc. (NGVC) 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:

Gain insights into your Natural Grocers by Vitamin Cottage, Inc. (NGVC) valuation analysis using our sophisticated DCF Calculator! This Excel template comes preloaded with real (NGVC) data, enabling you to adjust forecasts and assumptions to accurately determine the intrinsic value of Natural Grocers by Vitamin Cottage, Inc.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2020		 AY2
2021		 AY3
2022		 AY4
2023		 AY5
2024		 FY1
2025		 FY2
2026		 FY3
2027		 FY4
2028		 FY5
2029
Revenue 1,036.8 1,055.5 1,089.6 1,140.6 1,241.6 1,299.2 1,359.5 1,422.6 1,488.6 1,557.7
Revenue Growth, % 0 1.8 3.23 4.68 8.86 4.64 4.64 4.64 4.64 4.64
EBITDA 60.3 59.9 61.7 62.1 47.0 68.5 71.7 75.0 78.5 82.2
EBITDA, % 5.82 5.67 5.66 5.44 3.78 5.28 5.28 5.28 5.28 5.28
Depreciation 32.0 30.4 28.6 30.4 .0 29.3 30.6 32.0 33.5 35.1
Depreciation, % 3.09 2.88 2.63 2.67 0 2.25 2.25 2.25 2.25 2.25
EBIT 28.3 29.4 33.1 31.7 47.0 39.3 41.1 43.0 45.0 47.1
EBIT, % 2.73 2.79 3.03 2.78 3.78 3.02 3.02 3.02 3.02 3.02
Total Cash 28.5 23.7 12.0 18.3 8.9 21.9 22.9 24.0 25.1 26.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 8.5 8.5 10.5 10.8 12.6
Account Receivables, % 0.82163 0.80425 0.96327 0.94663 1.02
Inventories 100.2 100.5 113.8 119.3 120.7 129.4 135.4 141.7 148.3 155.2
Inventories, % 9.66 9.53 10.44 10.46 9.72 9.96 9.96 9.96 9.96 9.96
Accounts Payable 69.2 68.9 71.3 80.7 88.4 88.2 92.3 96.6 101.0 105.7
Accounts Payable, % 6.67 6.53 6.54 7.07 7.12 6.79 6.79 6.79 6.79 6.79
Capital Expenditure -29.6 -28.3 -31.4 -38.1 -38.7 -38.6 -40.4 -42.3 -44.3 -46.3
Capital Expenditure, % -2.85 -2.68 -2.89 -3.34 -3.12 -2.97 -2.97 -2.97 -2.97 -2.97
Tax Rate, % 20.71 20.71 20.71 20.71 20.71 20.71 20.71 20.71 20.71 20.71
EBITAT 22.1 23.2 25.4 25.9 37.2 31.0 32.5 34.0 35.5 37.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -15.1 24.8 9.7 21.8 3.1 13.5 20.2 21.1 22.1 23.1
WACC, % 7.86 7.88 7.85 7.91 7.88 7.88 7.88 7.88 7.88 7.88
PV UFCF
SUM PV UFCF 78.8
Long Term Growth Rate, % 1.00
Free cash flow (T + 1) 23
Terminal Value 340
Present Terminal Value 232
Enterprise Value 311
Net Debt 338
Equity Value -26
Diluted Shares Outstanding, MM 23
Equity Value Per Share -1.14

What You Will Get

  • Pre-Filled Financial Model: Natural Grocers' actual data allows for accurate DCF valuation.
  • Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
  • Instant Calculations: Automatic updates provide immediate results as you make adjustments.
  • Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
  • Customizable and Reusable: Designed for adaptability, enabling repeated use for comprehensive forecasts.

Key Features

  • Customizable Nutritional Parameters: Adjust essential inputs such as dietary preferences, product types, and pricing strategies.
  • Instant Nutritional Analysis: Provides quick insights into product nutrition, ingredient sourcing, and health benefits.
  • High-Quality Standards: Utilizes Natural Grocers' commitment to organic and natural products for reliable health outcomes.
  • Effortless Market Comparison: Evaluate different product offerings and assess market positioning with ease.
  • Efficiency Booster: Streamlines the process of developing health-focused product strategies without starting from scratch.

How It Works

  • Step 1: Download the prebuilt Excel template featuring Natural Grocers' data included.
  • Step 2: Navigate through the pre-filled sheets to grasp the essential metrics.
  • Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
  • Step 4: Instantly see the recalculated results, including Natural Grocers' intrinsic value.
  • Step 5: Make informed investment choices or create reports based on the outputs.

Why Choose Natural Grocers by Vitamin Cottage, Inc. (NGVC)?

  • Quality Products: Committed to providing organic and natural groceries.
  • Community Focused: Strong emphasis on supporting local farmers and sustainable practices.
  • Health-Conscious: A wide range of products catering to various dietary needs.
  • Expert Guidance: Knowledgeable staff available to assist with health and nutrition questions.
  • Accessible Pricing: Competitive pricing on high-quality products for all customers.

Who Should Use This Product?

  • Investors: Accurately assess Natural Grocers' fair value before making investment decisions.
  • CFOs: Utilize a professional-grade DCF model for financial reporting and analysis related to Natural Grocers (NGVC).
  • Consultants: Efficiently customize the template for valuation reports focused on Natural Grocers (NGVC) for clients.
  • Entrepreneurs: Discover insights into financial modeling techniques employed by leading grocery retailers.
  • Educators: Implement it as a teaching resource to illustrate valuation methods in the retail sector.

What the Template Contains

  • Pre-Filled Data: Includes Natural Grocers' historical financials and forecasts.
  • Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
  • Key Financial Ratios: Analyze Natural Grocers' profitability, efficiency, and leverage.
  • Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
  • Clear Dashboard: Charts and tables summarizing key valuation results.

No products were found matching.