WidePoint Corporation (WYY) DCF Valuation

WidePoint Corporation (WYY) 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

WidePoint Corporation (WYY) 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 WidePoint Corporation (WYY) valuation analysis using our cutting-edge DCF Calculator! This Excel template comes preloaded with real (WYY) data, enabling you to adjust forecasts and assumptions to accurately determine the intrinsic value of WidePoint Corporation.


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 101.7 180.3 87.3 94.1 106.0 118.3 131.9 147.1 164.1 183.0
Revenue Growth, % 0 77.29 -51.57 7.75 12.67 11.53 11.53 11.53 11.53 11.53
EBITDA 2.8 4.9 2.9 -15.7 -.3 -1.9 -2.2 -2.4 -2.7 -3.0
EBITDA, % 2.75 2.69 3.34 -16.7 -0.28563 -1.64 -1.64 -1.64 -1.64 -1.64
Depreciation 1.9 1.6 1.7 2.5 3.4 2.5 2.8 3.1 3.5 3.9
Depreciation, % 1.88 0.90535 1.9 2.69 3.18 2.11 2.11 2.11 2.11 2.11
EBIT .9 3.2 1.3 -18.2 -3.7 -4.4 -4.9 -5.5 -6.2 -6.9
EBIT, % 0.87028 1.79 1.44 -19.39 -3.46 -3.75 -3.75 -3.75 -3.75 -3.75
Total Cash 6.9 16.0 6.5 7.5 6.9 8.9 9.9 11.1 12.3 13.8
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 28.6 49.7 23.5 19.5 24.8
Account Receivables, % 28.07 27.58 26.88 20.74 23.43
Inventories .2 1.0 .6 .2 .4 .5 .5 .6 .7 .7
Inventories, % 0.2101 0.5495 0.67561 0.23621 0.34532 0.40335 0.40335 0.40335 0.40335 0.40335
Accounts Payable 13.6 36.2 10.3 12.5 12.6 16.7 18.6 20.7 23.1 25.8
Accounts Payable, % 13.35 20.09 11.75 13.3 11.92 14.08 14.08 14.08 14.08 14.08
Capital Expenditure -.5 -1.2 -2.8 -3.4 -1.1 -2.1 -2.4 -2.6 -2.9 -3.3
Capital Expenditure, % -0.50781 -0.64157 -3.15 -3.62 -1.03 -1.79 -1.79 -1.79 -1.79 -1.79
Tax Rate, % -3.4 -3.4 -3.4 -3.4 -3.4 -3.4 -3.4 -3.4 -3.4 -3.4
EBITAT .3 11.4 .4 -23.3 -3.8 -3.3 -3.7 -4.1 -4.6 -5.1
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -13.5 12.5 .0 -17.6 -6.9 -4.1 -4.8 -5.4 -6.0 -6.7
WACC, % 11.22 11.54 11.21 11.54 11.54 11.41 11.41 11.41 11.41 11.41
PV UFCF
SUM PV UFCF -19.4
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -7
Terminal Value -73
Present Terminal Value -42
Enterprise Value -62
Net Debt -2
Equity Value -60
Diluted Shares Outstanding, MM 9
Equity Value Per Share -6.75

What You Will Get

  • Pre-Filled Financial Model: WidePoint Corporation's (WYY) actual data enables precise DCF valuation.
  • Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers specific to (WYY).
  • Instant Calculations: Automatic updates ensure you see results as you make changes for (WYY).
  • Investor-Ready Template: A refined Excel file designed for professional-grade valuation of (WYY).
  • Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts of (WYY).

Key Features

  • Customizable Financial Inputs: Adjust essential metrics such as revenue projections, EBITDA percentages, and capital investments.
  • Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial metrics.
  • High-Precision Accuracy: Leverages WidePoint Corporation’s (WYY) actual financial data for reliable valuation results.
  • Simplified Scenario Analysis: Easily evaluate various assumptions and analyze different outcomes.
  • Efficiency Booster: Streamlines the valuation process, removing the need for intricate model development.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered WidePoint Corporation (WYY) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for WidePoint Corporation’s (WYY) intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator for WidePoint Corporation (WYY)?

  • Designed for Experts: A sophisticated tool utilized by industry analysts, CFOs, and financial consultants.
  • Accurate Data: WidePoint’s historical and projected financials are preloaded for precision.
  • Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
  • Insightful Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
  • User-Friendly: Comprehensive step-by-step guidance simplifies the process.

Who Should Use This Product?

  • Finance Students: Explore financial modeling techniques and apply them with real-time data from WidePoint Corporation (WYY).
  • Academics: Utilize industry-standard models for research or educational purposes related to WidePoint Corporation (WYY).
  • Investors: Validate your investment strategies and evaluate the valuation metrics of WidePoint Corporation (WYY).
  • Analysts: Enhance your analysis with a customizable DCF model tailored for WidePoint Corporation (WYY).
  • Small Business Owners: Understand the valuation practices used for public companies like WidePoint Corporation (WYY).

What the Template Contains

  • Pre-Filled Data: Includes WidePoint Corporation's 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 WidePoint Corporation's 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.