Loading...

Discounted Cash Flow (DCF) Analysis Unlevered


Vanguard Total Stock Market

Vanguard Total Stock Market (VTI)

Operating Data

Year
A/P
Revenue
Revenue (%)
EBITDA
EBITDA (%)
EBIT
EBIT (%)
Depreciation
Depreciation (%)

Balance Sheet Data

Year
A/P
Total Cash
Total Cash (%)
Account Receivables
Account Receivables (%)
Inventories
Inventories (%)
Accounts Payable
Accounts Payable (%)
Capital Expenditure
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 157.66
Diluted Shares Outstanding -
Cost of Debt
Tax Rate -
After-tax Cost of Debt -
Risk-Free Rate
Market Risk Premium
Cost of Equity 10.62
Total Debt -
Total Equity -
Total Capital -
Debt Weighting -
Equity Weighting -
Wacc

Build Up Free Cash

Year
A/P
Revenue
EBITDA
EBIT
Tax Rate
EBIAT
Depreciation
Accounts Receivable
Inventories
Accounts Payable
Capital Expenditure
UFCF
WACC
PV UFCF
SUM PV UFCF

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) -
Free cash flow (t + 1) -
Terminal Value -
Present Value of Terminal Value -

Intrinsic Value

Enterprise Value -
Net Debt -
Equity Value -
Shares Outstanding -
Equity Value Per Share -