Discounted Cash Flow (DCF) Analysis Unlevered

Payton Planar Magnetics Ltd. (PAY.BR)

8.15 €

0.00 (0.00%)
All numbers are in Millions, Currency in USD
Stock DCF: - | 8.15 | undervalue

Operating Data

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 33.0445.6238.4343.8743.9848.0252.4257.2462.4968.23
Revenue (%)
EBITDA 7.7814.6311.6912.9911.2713.5614.8116.1717.6519.27
EBITDA (%)
EBIT 6.8513.7210.7112.0910.3812.4713.6114.8616.2217.71
EBIT (%)
Depreciation 0.930.910.980.900.891.101.201.311.431.56
Depreciation (%)

Balance Sheet Data

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Total Cash 24.4530.9333.8444.3838.6340.2243.9147.9552.3557.15
Total Cash (%)
Account Receivables ----------
Account Receivables (%)
Inventories 3.653.283.513.463.774.214.605.025.485.98
Inventories (%)
Accounts Payable 3.091.892.685.054.093.964.334.735.165.63
Accounts Payable (%)
Capital Expenditure -0.56-0.53-0.63-0.67-0.52-0.69-0.75-0.82-0.90-0.98
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 8.15
Beta 0.575
Diluted Shares Outstanding 17.67
Cost of Debt
Tax Rate 17.61
After-tax Cost of Debt -%
Risk-Free Rate
Market Risk Premium
Cost of Equity 5.554
Total Debt -
Total Equity 144.02
Total Capital -
Debt Weighting -
Equity Weighting -
Wacc

Build Up Free Cash

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 33.0445.6238.4343.8743.9848.0252.4257.2462.4968.23
EBITDA 7.7814.6311.6912.9911.2713.5614.8116.1717.6519.27
EBIT 6.8513.7210.7112.0910.3812.4713.6114.8616.2217.71
Tax Rate 18.94%17.07%17.69%18.00%17.61%17.86%17.86%17.86%17.86%17.86%
EBIAT 5.5511.388.819.918.5510.2411.1812.2113.3314.55
Depreciation 0.930.910.980.900.891.101.201.311.431.56
Accounts Receivable ----------
Inventories -0.37-0.230.05-0.31-0.44-0.39-0.42-0.46-0.50
Accounts Payable --1.200.792.38-0.97-0.120.360.400.430.47
Capital Expenditure -0.56-0.53-0.63-0.67-0.52-0.69-0.75-0.82-0.90-0.98
UFCF 5.9310.929.7212.567.6510.0911.6012.6713.8315.10
WACC
PV UFCF -----
SUM PV UFCF -

Terminal Value

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

Intrinsic Value

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