For those thinking this is revolutionary, it’s a method that has long been used in your standard excel spreadsheet for valuing companies, it’s called Monte Carlo analysis.
And it is prone to many of the flaws of a DCF/NPV approach - that is, it is dependent on the assumptions made.
Not to diminish OP’s work but for those not familiar, there is a simple name/explanation
Comments
For those thinking this is revolutionary, it’s a method that has long been used in your standard excel spreadsheet for valuing companies, it’s called Monte Carlo analysis.
And it is prone to many of the flaws of a DCF/NPV approach - that is, it is dependent on the assumptions made.
Not to diminish OP’s work but for those not familiar, there is a simple name/explanation