Help!

Name: BorgWarner - February 2025
Availability: InStock
Author: @SimSim

This model simulates the Earnings Yield and Price Change of a stock, which is often sufficient for gauging the possible returns on a stock. Future share-prices are simulated using P/S (Price-To-Sales) ratios which allows for the earnings to be zero or negative. This model only simulates a single period of earnings and share-prices. If you need to simulate multiple periods then use another model instead.

Tutorial Related Models

The Earnings Yield is simulated from the company's future earnings, divided by the current market-cap. Assuming the earnings were to continue every year into the future, and they were to be paid out as dividends, then the earnings yield can be compared to government bond yields, to assess whether the stock would give a sufficient return, considering that the stock is probably more risky than government bonds.

\[ \mathbf{Earnings\ Yield} = \left( \frac{Earnings \cdot (1 - TaxRate\ Dividends)}{Current\ MarketCap\ Adj} + 1 \right)^{1/Year} - 1 \]

The future earnings are simulated from your input distributions for the sales and net profit margin:

\[ Earnings = Sales \cdot Net\ Profit\ Margin \]

The current market-value of all the company's shares is:

\[ Current\ MarketCap = Current\ Share\ Price \cdot Current\ Shares \]

This can be adjusted for excess cash or debt, either in case the company has a lot of cash it does not need in the future, or if the company has too much debt that must be repaid to improve the company's financial health:

\[ Current\ MarketCap\ Adj = Current\ MarketCap - (Excess\ Cash\ or\ Debt - Tax\ Excess\ Cash) \] \[ Tax\ Excess\ Cash = OnlyPos(Excess\ Cash\ or\ Debt) \cdot TaxRate\ Dividends \]

The Price Change of the stock is simulated from the future and current market-cap:

\[ \mathbf{Price\ Change} = \left( \frac{Future\ MarketCap - Tax\ MCapGains}{Current\ MarketCap\ Adj} \right)^{1/Year} - 1 \]

The company's future market-cap is simulated by multiplying your input distributions for the future sales and P/S ratios. If you can perfectly predict these two numbers then you can predict the future market-cap with complete accuracy:

\[ Future\ MarketCap = Sales \cdot P/S\ Ratio \]

The capital gains tax is calculated from the \(Current\ MarketCap\) defined in the Earnings Yield tab:

\[ Tax\ MCapGains = OnlyPos(Future\ MarketCap - Current\ MarketCap) \cdot TaxRate\ CapGains \]

BorgWarner - February 2025 (BWA)

Earnings Yield and Price Change of Stock using P/S Ratios (Model STK‑YLD‑PS)

@SimSim 4 months ago

Current Share-Price

Current Shares

Excess Cash or Debt

Currency

Sales

General

Interpolate

Net Profit Margin

General

Interpolate

2.264% ; 0.02296%
2.332% ; 0.2886%
2.4% ; 0.3583%
2.468% ; 0.3206%
2.536% ; 0.2296%
2.603% ; 0.1317%
2.671% ; 0.06042%
2.739% ; 0.0222%
2.807% ; 0.006529%
2.875% ; 0.001537%
2.942% ; 0.000291%
3.01% ; 0.000055%
3.078% ; 0.000091%
3.146% ; 0.000526%
3.214% ; 0.002585%
3.281% ; 0.01018%
3.349% ; 0.03206%
3.417% ; 0.08088%
3.485% ; 0.1633%
3.553% ; 0.2641%
3.62% ; 0.3425%
3.688% ; 0.3582%
3.756% ; 0.3099%
3.824% ; 0.2443%
3.892% ; 0.2244%
3.959% ; 0.2867%
4.027% ; 0.4222%
4.095% ; 0.5902%
4.163% ; 0.7504%
4.231% ; 0.8895%
4.298% ; 1.018%
4.366% ; 1.14%
4.434% ; 1.233%
4.502% ; 1.254%
4.57% ; 1.182%
4.637% ; 1.047%
4.705% ; 0.9269%
4.773% ; 0.9173%
4.841% ; 1.073%
4.909% ; 1.369%
4.976% ; 1.699%
5.044% ; 1.928%
5.112% ; 1.962%
5.18% ; 1.797%
5.248% ; 1.527%
5.315% ; 1.284%
5.383% ; 1.156%
5.451% ; 1.135%
5.519% ; 1.146%
5.587% ; 1.118%
5.654% ; 1.021%
5.722% ; 0.8597%
5.79% ; 0.6523%
5.858% ; 0.4347%
5.926% ; 0.252%
5.993% ; 0.1389%
6.061% ; 0.1077%
6.129% ; 0.1521%
6.197% ; 0.2513%
6.265% ; 0.3718%
6.332% ; 0.4829%
6.4% ; 0.5862%
6.468% ; 0.7232%
6.536% ; 0.9438%
6.604% ; 1.26%
6.671% ; 1.624%
6.739% ; 1.95%
6.807% ; 2.18%
6.875% ; 2.313%
6.943% ; 2.381%
7.01% ; 2.408%
7.078% ; 2.416%
7.146% ; 2.421%
7.214% ; 2.434%
7.282% ; 2.451%
7.349% ; 2.45%
7.417% ; 2.375%
7.485% ; 2.173%
7.553% ; 1.863%
7.621% ; 1.562%
7.688% ; 1.418%
7.756% ; 1.495%
7.824% ; 1.726%
7.892% ; 1.964%
7.96% ; 2.086%
8.027% ; 2.088%
8.095% ; 2.063%
8.163% ; 2.1%
8.231% ; 2.184%
8.299% ; 2.193%
8.366% ; 2.002%
8.434% ; 1.594%
8.502% ; 1.09%
8.57% ; 0.6586%
8.638% ; 0.4077%
8.705% ; 0.3338%
8.773% ; 0.3526%
8.841% ; 0.3663%
8.909% ; 0.29%
8.977% ; 0.02299%

P/S Ratio

General

Interpolate

0.4286 ; 0.00263%
0.4368 ; 0.04003%
0.445 ; 0.0643%
0.4532 ; 0.09348%
0.4614 ; 0.1504%
0.4696 ; 0.2471%
0.4778 ; 0.3798%
0.4861 ; 0.5461%
0.4943 ; 0.7548%
0.5025 ; 0.9947%
0.5107 ; 1.214%
0.5189 ; 1.362%
0.5271 ; 1.442%
0.5353 ; 1.484%
0.5435 ; 1.494%
0.5517 ; 1.431%
0.5599 ; 1.26%
0.5682 ; 1.008%
0.5764 ; 0.7521%
0.5846 ; 0.5556%
0.5928 ; 0.4282%
0.601 ; 0.3457%
0.6092 ; 0.2891%
0.6174 ; 0.2604%
0.6256 ; 0.2707%
0.6338 ; 0.3207%
0.6421 ; 0.3937%
0.6503 ; 0.4774%
0.6585 ; 0.5881%
0.6667 ; 0.7555%
0.6749 ; 0.9695%
0.6831 ; 1.156%
0.6913 ; 1.23%
0.6995 ; 1.183%
0.7077 ; 1.088%
0.7159 ; 1.031%
0.7242 ; 1.046%
0.7324 ; 1.12%
0.7406 ; 1.236%
0.7488 ; 1.407%
0.757 ; 1.647%
0.7652 ; 1.939%
0.7734 ; 2.241%
0.7816 ; 2.496%
0.7898 ; 2.656%
0.7981 ; 2.726%
0.8063 ; 2.761%
0.8145 ; 2.809%
0.8227 ; 2.852%
0.8309 ; 2.814%
0.8391 ; 2.648%
0.8473 ; 2.403%
0.8555 ; 2.173%
0.8637 ; 2.018%
0.8719 ; 1.953%
0.8802 ; 1.965%
0.8884 ; 2%
0.8966 ; 1.96%
0.9048 ; 1.778%
0.913 ; 1.513%
0.9212 ; 1.307%
0.9294 ; 1.255%
0.9376 ; 1.337%
0.9458 ; 1.453%
0.9541 ; 1.493%
0.9623 ; 1.419%
0.9705 ; 1.294%
0.9787 ; 1.199%
0.9869 ; 1.13%
0.9951 ; 1.024%
1.003 ; 0.8563%
1.012 ; 0.6781%
1.02 ; 0.5661%
1.028 ; 0.5532%
1.036 ; 0.6024%
1.044 ; 0.634%
1.053 ; 0.589%
1.061 ; 0.4741%
1.069 ; 0.3418%
1.077 ; 0.2451%
1.085 ; 0.2103%
1.094 ; 0.2303%
1.102 ; 0.2707%
1.11 ; 0.2999%
1.118 ; 0.3209%
1.126 ; 0.3621%
1.135 ; 0.4317%
1.143 ; 0.4959%
1.151 ; 0.5084%
1.159 ; 0.4547%
1.168 ; 0.3636%
1.176 ; 0.2827%
1.184 ; 0.24%
1.192 ; 0.2244%
1.2 ; 0.205%
1.209 ; 0.1678%
1.217 ; 0.1232%
1.225 ; 0.08417%
1.233 ; 0.04778%
1.241 ; 0.002895%

Year

Constant

Tax-Rate Dividends

Constant

Tax-Rate Cap-Gains

Constant

This model is a BETA-version!

It may not be fully tested and its features may change in the future.
If you have great ideas for improving this model then please contact us.

Help!

Tweak Dist