Foot Locker / Hist.Data / Zero Real Growth
Share Buyback vs. Dividend using P/S Ratios (Model SB‑DIV‑PS)
@SimSim 4 months ago 15 Views
This model simulates the gain/loss to long-term shareholders from making a single share buyback, compared to making a dividend payout for the same amount of money. All future earnings are assumed to be paid out as dividends.
This model simulates the future share-prices using P/S (Price-To-Sales) ratios so the earnings can be zero or negative.
Keywords: DEMO FL
- Earnings = Sales (2021-2023) x Net Profit Margin (2004-2023).
- Zero real growth.
- Discount rate from historical S&P 500 5-7 year REAL avg. ann. returns (1971-2017) + 5% risk-premium.
- P/S ratio (2004-2023)
- This plot shows the probability distributions that are common for all simulation years.
- The P/S scale is multiplied with the simulated P/S ratio after the share buyback. This can be used to model a change in investor sentiment towards the stock after the buyback. When the scale is 100% it has no effect. When the scale is below 100% it lowers the P/S ratio after the share buyback, and when it is above 100% it raises the P/S ratio after the buyback.
- The discount rate is used along with the tax-rates for dividends and capital gains in the calculation of present values.
- This plot shows the probability distributions for individual simulation years.
- The dashed blue lines show the median P/S ratios calculated from the simulated Sales in each year, and the current Market-Cap (current share-price X number of shares) minus the Excess Cash. This lets you easily see if there is likely going to be a future loss or gain from re-valuation of the stock's P/S ratio.
- This violin-plot shows the Return on Intrinsic Value (ROIV) for investment periods between 1-10 years, when making a share buyback now for USD 100m at the current share-price of USD 26, as opposed to using the same amount of money to make a dividend payout now.
- Out of 100k simulation trials 100% had valid results. Outliers >10.0 IQR are removed.
- ROIV is invalid when the intrinsic value is zero or negative. ROB also works in those cases.
- If there are losses in some simulations, then the red boxes on the bottom show the probability of loss for each future year.
- This violin-plot shows the Return on Buyback (ROB) for investment periods between 1-10 years, when making a share buyback now for USD 100m at the current share-price of USD 26, as opposed to using the same amount of money to make a dividend payout now.
- Out of 100k simulation trials 100% had valid results. Outliers >10.0 IQR are removed.
- If there are losses in some simulations, then the red boxes on the bottom show the probability of loss for each future year.
- This 2D histogram shows how different share-prices at the time of the share buyback would impact the Return on Intrinsic Value (ROIV) for all investment periods between 1-10 years, when making a share buyback for USD 100m, as opposed to making a dividend payout for the same amount.
- Out of 100k simulation trials 100% had valid results. Outliers >10.0 IQR are removed.
- ROIV is invalid when the intrinsic value is zero or negative. ROB also works in those cases.
- 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 a share buyback is made now at the current share-price of USD 26, when considering all investment periods between 1-10 years.
- This 2D histogram shows how different share-prices at the time of the share buyback would impact the Return on Buyback (ROB) for all investment periods between 1-10 years, when making a share buyback for USD 100m, as opposed to making a dividend payout for the same amount.
- Out of 100k 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 a share buyback is made now at the current share-price of USD 26, when considering all investment periods between 1-10 years.
{"constant": "2.2065%", "interpolate": false, "normal_mean": "2.2065%", "normal_std": "0.69035%", "selected": "user_data", "uniform_hi": "3.55%", "uniform_lo": "-4.8261%", "user_data": "-4.7842% ; 0.001%\n-4.7004% ; 0%\n-4.1141% ; 0%\n-4.0303% ; 0.001%\n-3.9466% ; 0%\n-3.5278% ; 0%\n-3.444% ; 0.001%\n-3.3603% ; 0.001%\n-3.2765% ; 0.001%\n-3.1927% ; 0.002%\n-3.109% ; 0%\n-3.0252% ; 0.001%\n-2.9414% ; 0.001%\n-2.8577% ; 0.004%\n-2.7739% ; 0%\n-2.6902% ; 0.005%\n-2.6064% ; 0.001%\n-2.5226% ; 0.002%\n-2.4389% ; 0%\n-2.3551% ; 0.002%\n-2.2714% ; 0.005%\n-2.1876% ; 0.005%\n-2.1038% ; 0.004%\n-2.0201% ; 0.004%\n-1.9363% ; 0.008%\n-1.8526% ; 0.007%\n-1.7688% ; 0.006%\n-1.685% ; 0.012%\n-1.6013% ; 0.013%\n-1.5175% ; 0.005%\n-1.4337% ; 0.017%\n-1.35% ; 0.012%\n-1.2662% ; 0.021%\n-1.1825% ; 0.022%\n-1.0987% ; 0.022%\n-1.0149% ; 0.02%\n-0.93118% ; 0.029%\n-0.84742% ; 0.029%\n-0.76366% ; 0.034%\n-0.6799% ; 0.053%\n-0.59613% ; 0.05%\n-0.51237% ; 0.055%\n-0.42861% ; 0.057%\n-0.34485% ; 0.073%\n-0.26109% ; 0.078%\n-0.17733% ; 0.089%\n-0.093568% ; 0.13%\n-0.009807% ; 0.129%\n0.073955% ; 0.173%\n0.15772% ; 0.187%\n0.24148% ; 0.198%\n0.32524% ; 0.219%\n0.409% ; 0.294%\n0.49276% ; 0.328%\n0.57652% ; 0.402%\n0.66028% ; 0.474%\n0.74404% ; 0.565%\n0.8278% ; 0.675%\n0.91157% ; 0.774%\n0.99533% ; 0.868%\n1.0791% ; 1.029%\n1.1628% ; 1.144%\n1.2466% ; 1.322%\n1.3304% ; 1.517%\n1.4141% ; 1.704%\n1.4979% ; 1.971%\n1.5817% ; 2.206%\n1.6654% ; 2.51%\n1.7492% ; 2.834%\n1.8329% ; 3.256%\n1.9167% ; 3.54%\n2.0005% ; 4.108%\n2.0842% ; 4.464%\n2.168% ; 5.077%\n2.2517% ; 5.371%\n2.3355% ; 5.625%\n2.4193% ; 5.893%\n2.503% ; 6.015%\n2.5868% ; 5.654%\n2.6705% ; 5.424%\n2.7543% ; 4.729%\n2.8381% ; 4.293%\n2.9218% ; 3.643%\n3.0056% ; 3.203%\n3.0894% ; 2.725%\n3.1731% ; 2.309%\n3.2569% ; 1.509%\n3.3406% ; 0.61%\n3.4244% ; 0.133%\n3.5082% ; 0.013%\n"}
{"constant": "2.2065%", "interpolate": true, "normal_mean": "2.2065%", "normal_std": "0.69035%", "selected": "user_data", "uniform_hi": "3.55%", "uniform_lo": "-4.8261%", "user_data": "-5.002% ; 0%\n-4.9141% ; 0.000435%\n-4.8261% ; 0.001197%\n-4.7381% ; 0.000435%\n-4.6501% ; 0%\n-3.1543% ; 0%\n-3.0663% ; 0.001062%\n-2.9783% ; 0.001565%\n-2.8903% ; 0.00314%\n-2.8023% ; 0.002284%\n-2.7143% ; 0.002935%\n-2.6264% ; 0.003455%\n-2.5384% ; 0.002479%\n-2.4504% ; 0.001297%\n-2.3624% ; 0.003913%\n-2.2744% ; 0.00693%\n-2.1864% ; 0.008526%\n-2.0984% ; 0.004225%\n-2.0104% ; 0.002187%\n-1.9225% ; 0.005871%\n-1.8345% ; 0.004842%\n-1.7465% ; 0.009123%\n-1.6585% ; 0.0126%\n-1.5705% ; 0.009363%\n-1.4825% ; 0.01512%\n-1.3945% ; 0.01751%\n-1.3065% ; 0.01382%\n-1.2185% ; 0.01711%\n-1.1306% ; 0.02145%\n-1.0426% ; 0.02759%\n-0.95458% ; 0.03407%\n-0.86659% ; 0.03421%\n-0.7786% ; 0.02702%\n-0.69061% ; 0.04087%\n-0.60262% ; 0.0496%\n-0.51463% ; 0.04383%\n-0.42665% ; 0.05236%\n-0.33866% ; 0.07308%\n-0.25067% ; 0.07863%\n-0.16268% ; 0.1047%\n-0.074692% ; 0.1369%\n0.013296% ; 0.1432%\n0.10128% ; 0.173%\n0.18927% ; 0.2044%\n0.27726% ; 0.2425%\n0.36525% ; 0.2824%\n0.45324% ; 0.3102%\n0.54123% ; 0.372%\n0.62922% ; 0.4779%\n0.7172% ; 0.5773%\n0.80519% ; 0.694%\n0.89318% ; 0.7798%\n0.98117% ; 0.8913%\n1.0692% ; 1.083%\n1.1571% ; 1.173%\n1.2451% ; 1.363%\n1.3331% ; 1.608%\n1.4211% ; 1.837%\n1.5091% ; 2.086%\n1.5971% ; 2.373%\n1.6851% ; 2.629%\n1.7731% ; 2.964%\n1.8611% ; 3.389%\n1.949% ; 3.929%\n2.037% ; 4.487%\n2.125% ; 5.026%\n2.213% ; 5.584%\n2.301% ; 5.871%\n2.389% ; 6.082%\n2.477% ; 6.235%\n2.565% ; 6.038%\n2.653% ; 5.798%\n2.7409% ; 5.174%\n2.8289% ; 4.524%\n2.9169% ; 3.908%\n3.0049% ; 3.472%\n3.0929% ; 2.877%\n3.1809% ; 2.21%\n3.2689% ; 1.492%\n3.3569% ; 0.6146%\n3.4448% ; 0.1342%\n3.5328% ; 0.0151%\n3.6208% ; 0.000541%\n3.7088% ; 0%\n"}
{"constant": "138.81%", "interpolate": false, "normal_mean": "138.81%", "normal_std": "79.524%", "selected": "user_data", "uniform_hi": "552.73%", "uniform_lo": "-55.605%", "user_data": "-52.563% ; 0.002%\n-46.48% ; 0.006%\n-40.396% ; 0.014%\n-34.313% ; 0.034%\n-28.229% ; 0.059%\n-22.146% ; 0.102%\n-16.063% ; 0.152%\n-9.9792% ; 0.219%\n-3.8958% ; 0.314%\n2.1876% ; 0.473%\n8.271% ; 0.563%\n14.354% ; 0.787%\n20.438% ; 1.062%\n26.521% ; 1.326%\n32.604% ; 1.52%\n38.688% ; 1.73%\n44.771% ; 1.963%\n50.855% ; 2.181%\n56.938% ; 2.391%\n63.021% ; 2.508%\n69.105% ; 2.775%\n75.188% ; 2.947%\n81.272% ; 3.006%\n87.355% ; 3.123%\n93.438% ; 3.318%\n99.522% ; 3.367%\n105.61% ; 3.421%\n111.69% ; 3.555%\n117.77% ; 3.452%\n123.86% ; 3.409%\n129.94% ; 3.233%\n136.02% ; 3.247%\n142.11% ; 3.094%\n148.19% ; 3.058%\n154.27% ; 2.82%\n160.36% ; 2.652%\n166.44% ; 2.497%\n172.52% ; 2.299%\n178.61% ; 2.162%\n184.69% ; 2.037%\n190.77% ; 1.744%\n196.86% ; 1.665%\n202.94% ; 1.566%\n209.02% ; 1.443%\n215.11% ; 1.359%\n221.19% ; 1.237%\n227.27% ; 1.109%\n233.36% ; 1.017%\n239.44% ; 0.96%\n245.52% ; 0.894%\n251.61% ; 0.841%\n257.69% ; 0.779%\n263.77% ; 0.694%\n269.86% ; 0.717%\n275.94% ; 0.658%\n282.02% ; 0.596%\n288.11% ; 0.524%\n294.19% ; 0.511%\n300.27% ; 0.518%\n306.36% ; 0.456%\n312.44% ; 0.405%\n318.52% ; 0.412%\n324.61% ; 0.387%\n330.69% ; 0.37%\n336.77% ; 0.304%\n342.86% ; 0.258%\n348.94% ; 0.259%\n355.02% ; 0.231%\n361.11% ; 0.197%\n367.19% ; 0.174%\n373.27% ; 0.141%\n379.36% ; 0.117%\n385.44% ; 0.089%\n391.52% ; 0.088%\n397.61% ; 0.083%\n403.69% ; 0.066%\n409.77% ; 0.055%\n415.86% ; 0.039%\n421.94% ; 0.027%\n428.02% ; 0.027%\n434.11% ; 0.021%\n440.19% ; 0.022%\n446.27% ; 0.018%\n452.36% ; 0.014%\n458.44% ; 0.007%\n464.52% ; 0.003%\n470.61% ; 0.006%\n476.69% ; 0.001%\n482.77% ; 0.006%\n488.86% ; 0.003%\n494.94% ; 0.001%\n501.03% ; 0%\n513.19% ; 0%\n519.28% ; 0.001%\n525.36% ; 0%\n531.44% ; 0%\n537.53% ; 0.001%\n543.61% ; 0%\n549.69% ; 0.001%\n"}
{"constant": "138.81%", "interpolate": true, "normal_mean": "138.81%", "normal_std": "79.524%", "selected": "user_data", "uniform_hi": "552.73%", "uniform_lo": "-55.605%", "user_data": "-63.773% ; 0%\n-57.418% ; 0.000821%\n-51.062% ; 0.002874%\n-44.706% ; 0.006622%\n-38.35% ; 0.01735%\n-31.995% ; 0.04009%\n-25.639% ; 0.07997%\n-19.283% ; 0.1355%\n-12.927% ; 0.2046%\n-6.5716% ; 0.297%\n-0.21584% ; 0.4076%\n6.1399% ; 0.5573%\n12.496% ; 0.7546%\n18.851% ; 1.011%\n25.207% ; 1.295%\n31.563% ; 1.553%\n37.919% ; 1.779%\n44.274% ; 1.996%\n50.63% ; 2.252%\n56.986% ; 2.488%\n63.342% ; 2.683%\n69.697% ; 2.885%\n76.053% ; 3.048%\n82.409% ; 3.218%\n88.765% ; 3.376%\n95.12% ; 3.511%\n101.48% ; 3.591%\n107.83% ; 3.604%\n114.19% ; 3.606%\n120.54% ; 3.562%\n126.9% ; 3.475%\n133.25% ; 3.41%\n139.61% ; 3.314%\n145.97% ; 3.207%\n152.32% ; 3.042%\n158.68% ; 2.854%\n165.03% ; 2.618%\n171.39% ; 2.402%\n177.74% ; 2.231%\n184.1% ; 2.048%\n190.46% ; 1.847%\n196.81% ; 1.683%\n203.17% ; 1.581%\n209.52% ; 1.49%\n215.88% ; 1.378%\n222.24% ; 1.265%\n228.59% ; 1.14%\n234.95% ; 1.035%\n241.3% ; 0.9663%\n247.66% ; 0.9077%\n254.01% ; 0.8596%\n260.37% ; 0.8132%\n266.73% ; 0.7753%\n273.08% ; 0.7271%\n279.44% ; 0.6639%\n285.79% ; 0.594%\n292.15% ; 0.5463%\n298.5% ; 0.5295%\n304.86% ; 0.5159%\n311.22% ; 0.4907%\n317.57% ; 0.4488%\n323.93% ; 0.4209%\n330.28% ; 0.3758%\n336.64% ; 0.3288%\n342.99% ; 0.29%\n349.35% ; 0.272%\n355.71% ; 0.2515%\n362.06% ; 0.2127%\n368.42% ; 0.1722%\n374.77% ; 0.1377%\n381.13% ; 0.1159%\n387.48% ; 0.1017%\n393.84% ; 0.08717%\n400.2% ; 0.08156%\n406.55% ; 0.06874%\n412.91% ; 0.05314%\n419.26% ; 0.03955%\n425.62% ; 0.03274%\n431.97% ; 0.03163%\n438.33% ; 0.02682%\n444.69% ; 0.02068%\n451.04% ; 0.01459%\n457.4% ; 0.007626%\n463.75% ; 0.006079%\n470.11% ; 0.00543%\n476.46% ; 0.005613%\n482.82% ; 0.004928%\n489.18% ; 0.00417%\n495.53% ; 0.002083%\n501.89% ; 0.000599%\n508.24% ; 0.000311%\n514.6% ; 0.000652%\n520.96% ; 0.00068%\n527.31% ; 0.000789%\n533.67% ; 0.00068%\n540.02% ; 0.000731%\n546.38% ; 0.00086%\n552.73% ; 0.000707%\n559.09% ; 0.00055%\n565.45% ; 0%\n"}