Foot Locker / Hist.Data / Zero Real Growth

Present Value of Stock using Terminal Values (Model PV‑STK‑TV)

@SimSim 3 months ago 5 Views

This model simulates the Present Value (PV) of a company to long-term shareholders, where the excess cash and all future earnings are assumed to be paid out as dividends. The model also simulates the Net Present Value (NPV) and NPV Ratio.

This model does NOT simulate future share-prices. Instead the simulated earnings for the final year are assumed to grow forever so they are used to calculate Terminal Values. If you want to simulate future share-prices, then you should use another model instead.

Docs Related Models

Keywords: DEMO FL

  • Earnings are simulated from historical Net Profit Margin (2004-2023) x recent sales (2021-2023).
  • Zero real growth.
  • Discount rate from historical S&P 500 5-7 year REAL avg. ann. returns (1971-2017) + 5% risk-premium.

2024-06-10T19:52:41.469338 image/svg+xml Matplotlib v3.8.4, https://matplotlib.org/ 8.6% 8.8% 9% 9.2% 9.4% Discount Rate -5% -2.5% 0% 2.5% 5% Terminal Growth -5% -2.5% 0% 2.5% 5% Tax-Rate Dividends
This plot shows the probability distributions that are common for all simulation years.
2024-06-10T19:52:42.329705 image/svg+xml Matplotlib v3.8.4, https://matplotlib.org/ 0 500m 1b Year 1 Earnings Year 2 (Same as previous) Earnings
This plot shows the probability distributions for individual simulation years.
2024-06-10T19:52:34.429756 image/svg+xml Matplotlib v3.8.4, https://matplotlib.org/ -25 0 25 50 75 100 125 Present Value - Per Share (USD) SimSim.Run - Jun 10-2024 (UTC) Foot Locker / Hist.Data / Zero Real Growth Present Value of Stock using Terminal Values (Model PV-STK-TV) Prob Loss: 18% Normal Mean 50.4 / Std 28 Kernel Density Estimate (KDE)
  • This histogram shows the simulated Present Value.
  • Out of 500k simulation trials 100% had valid results. Outliers >10.0 IQR are removed.
2024-06-10T19:52:35.785569 image/svg+xml Matplotlib v3.8.4, https://matplotlib.org/ -50 -25 0 25 50 75 100 Net Present Value - Per Share (USD) SimSim.Run - Jun 10-2024 (UTC) Foot Locker / Hist.Data / Zero Real Growth Present Value of Stock using Terminal Values (Model PV-STK-TV) Prob Loss: 18% Normal Mean 24.4 / Std 28 Kernel Density Estimate (KDE)
  • This histogram shows the simulated Net Present Value, when the current share-price is USD 26.
  • Out of 500k simulation trials 100% had valid results. Outliers >10.0 IQR are removed.
2024-06-10T19:52:37.268319 image/svg+xml Matplotlib v3.8.4, https://matplotlib.org/ -200% -100% 0% 100% 200% 300% 400% Net Present Value Ratio SimSim.Run - Jun 10-2024 (UTC) Foot Locker / Hist.Data / Zero Real Growth Present Value of Stock using Terminal Values (Model PV-STK-TV) Prob Loss: 18% Normal Mean 93.7% / Std 110% Kernel Density Estimate (KDE)
  • This histogram shows the simulated Net Present Value Ratio, when the current share-price is USD 26.
  • Out of 500k simulation trials 100% had valid results. Outliers >10.0 IQR are removed.
2024-06-10T19:52:39.151884 image/svg+xml Matplotlib v3.8.4, https://matplotlib.org/ 15 20 25 30 35 Current Share-Price -60 -40 -20 0 20 40 60 80 100 Net Present Value - Per Share (USD) SimSim.Run - Jun 10-2024 (UTC) Foot Locker / Hist.Data / Zero Real Growth Present Value of Stock using Terminal Values (Model PV-STK-TV) Prob Loss: 18%
  • This 2D histogram shows how different share-prices would impact the Net Present Value.
  • Out of 500k simulation trials 100% had valid results. Outliers >10.0 IQR are removed.
  • The x-axis shows a range of share-prices around the current share-price of USD 26, which is marked as a dashed blue line.
  • The red box at the bottom shows the probability of loss if the current share-price is USD 26.
2024-06-10T19:52:40.246894 image/svg+xml Matplotlib v3.8.4, https://matplotlib.org/ 15 20 25 30 35 Current Share-Price -200% 0% 200% 400% 600% 800% Net Present Value Ratio SimSim.Run - Jun 10-2024 (UTC) Foot Locker / Hist.Data / Zero Real Growth Present Value of Stock using Terminal Values (Model PV-STK-TV) Prob Loss: 18%
  • This 2D histogram shows how different share-prices would impact the Net Present Value Ratio.
  • Out of 500k simulation trials 100% had valid results. Outliers >10.0 IQR are removed.
  • The x-axis shows a range of share-prices around the current share-price of USD 26, which is marked as a dashed blue line.
  • The red box at the bottom shows the probability of loss if the current share-price is USD 26.