# Price Earning Ratio

[finance

]
Most people know price earning ratio (P/E ratio or PE) and use it a way of value whether the stock is over-valued or not.

\[PE=\frac{company\ market\ cap}{earning}=\frac{price\ per\ share}{earning\ per\ share}\]This number tells you how many years are required to earn your investment back (via earning) For example, usually \(PE\approx 15\) is a standard for a fair value company. However, PE doesn’t consider the growth of company or the cost of your money.

The cost of money considers having x money now is more valuable than having the same amount of money in the future. The could result from the currency inflation, or you could invest this money in some almost safe way (e.g., US treasury anual return is about 1% now and was 4% before) and get more money back in the future.

# Price Earning Ratio for Growth Company

Let us consider this value for a growth company. Let assume the anual growth rate is x and cost of your money is y. We also starts with assumption that x and y is constant, which is unlikely to be true in real life.

To be able to profit from investment in T years, we should have:

\[(1+y)^t\leq\sum_{t=1}^T{\frac{1}{PE}(1+x)^t}\]where PE is the PE of the invested company now. That means

\[PE\leq\sum_{t=1}^T{(\frac{1+x}{1+y})^T}=\frac{1-(\frac{1+x}{1+y})^T}{1-\frac{1+x}{1+y}}\]Here we consider some examples here. Here I use US treasury bond long term anual return for y (4%) and gross profit year over year growth for x.

Company | Current PE | Growth x | Years Required | Value |
---|---|---|---|---|

Amazon | 94 | 30% | 14.3 | Fair |

Apple | 35.67 | 10% | 19.9 | Slightly Over |

Tesla | 1334 | 50% | 17 | Fair |

Again, I have assumed the company’s gross profit grows constantly in those years, which is unlikely to be true.

Here is the code

```
def year_of_return(PE, x, y=0.01):
ratio = (1 + x) / (1 + y)
if 1 + PE * (ratio - 1) <= 0.0:
return math.inf
return math.log(1 + PE * (ratio - 1)) / math.log(ratio)
```

# How Low Interest Rate Affects Valuation

People have observed the PE for the stocked market has increased significantly since 2020. To my understanding, this is because the low interest rate reduces the cost of your money (y). Let us check how it affects using the equation above with y=1%.

Company | Current PE | Growth x | Years Required (y=4%) | Years Required (y=1%) |
---|---|---|---|---|

Amazon | 94 | 30% | 14.3 | 13.2 |

Apple | 35.67 | 10% | 19.9 | 16.8 |

Tesla | 1334 | 50% | 17 | 16 |

Obviously, as the cost of your money reduced from 4.4% to 1%, the number of years required to get your investment back get reduced.

We could compute what will be the starting PE for fair value (assuming T=15).

Company | Growth x | Actual PE | Fair Value PE for y=1% | Fair Value PE fory=4% |
---|---|---|---|---|

Amazon | 30% | 94 | 150 | 109 |

Apple | 10% | 35.67 | 29 | 22 |

Tesla | 50% | 1334 | 775 | 547 |

It also indicates fair-value PE ratio is affected more by the intereste rate for the higher growth company than the lower growth company.

Here is the code

```
import math
def pe_from_return(x, t=15, y=0.01):
ratio = (1 + x) / (1 + y)
return (ratio ** t - 1) / (ratio - 1)
```

# How Growth Rate Affects Valuation

Similar we could compute the required years for return over different growth rate. Here we assume y=1%:

Growth x\Year Required for PE | 15 | 50 | 100 | 1000 |
---|---|---|---|---|

0% | 16.2 | 68.7 | 463.8 | Inf |

10% | 9.9 | 19.9 | 26.9 | 52.7 |

20% | 7.8 | 13.6 | 17.3 | 30.4 |

30% | 6.6 | 10.8 | 13.4 | 22.4 |

40% | 5.9 | 9.2 | 11.3 | 18.2 |

50% | 5.3 | 8.2 | 9.9 | 15.6 |

100% | 4.0 | 5.7 | 6.7 | 10.1 |

150% | 3.5 | 4.8 | 5.5 | 8.1 |

200% | 3.1 | 4.2 | 4.9 | 7.0 |

Or y =4.4%.

Growth x\Year Required for PE | 15 | 50 | 100 | 1000 |
---|---|---|---|---|

0% | 23.2 | inf | inf | inf |

10% | 11.3 | 24.9 | 35.4 | 76.6 |

20% | 8.4 | 15.3 | 19.9 | 36.0 |

30% | 7.0 | 11.8 | 14.8 | 25.1 |

40% | 6.2 | 9.9 | 12.1 | 19.9 |

50% | 5.6 | 8.6 | 10.5 | 16.8 |

100% | 4.1 | 5.9 | 7.0 | 10.5 |

150% | 3.5 | 4.9 | 5.7 | 8.3 |

200% | 3.2 | 4.3 | 5.0 | 7.1 |

This table shows how important the growth rate. Again constant growth rate is assumed hered and it is unlikely to be true.

# Reference

- Valuation via Total Discounted Cash Flow
- I got the growth rate and PE for those companies from MacroTrends