Wrong Reference in 'Monte Carlo Valuation'!N15
janmayer opened this issue · 0 comments
janmayer commented
In the file Tesla 2025 Valuation Extract for Github_3.18.21.xlsx, Sheet Monte Carlo Valuation, Cell N15, the formula is
=('Monte Carlo Inputs'!D43-'Monte Carlo Inputs'!C43)/2+'Monte Carlo Inputs'!C43
which is the "Tesla platform cut in China".
However, this value is used in Cell H15, with values from row 14 of the input sheet ('Monte Carlo Inputs'!D14 etc.), and is about the "% of cars sold into human driven ride-hail network in 2025".
The formula should probably be:
=('Monte Carlo Inputs'!D14-'Monte Carlo Inputs'!C14)/2+'Monte Carlo Inputs'!C14