Monte Carlo Simulation - NPV example
To Download the XLS file: xluis.gumroad.com/l/montecarlo
Also review: Sensitivity Analysis - Two Variable Data Table • Sensitivity Analysis ...
Recommended Books at Amazon:
Building Winning Algorithmic Trading Systems, + Website: A Trader's Journey From Data Mining to Monte Carlo Simulation to Live Trading (Wiley Trading) amzn.to/2DAxOyZ
Explorations in Monte Carlo Methods (Undergraduate Texts in Mathematics) amzn.to/2TfBCe2
Follow me at
LINKED IN: / luisolano
FACEBOOK: / luisolanoms
Monte Carlo Simulation in NET PRESENT VALUE (NPV)
Let me know your comments, Thanks......
Пікірлер: 776
Thank you sooo much!! I had to do a NPV analysis for my university assignment and you helped me sooo much..Thank you for attaching the template as well :D Life saver!
Thanks for the spreadsheet Mr. Luis. It is a great tool in learning how to build a monte carlo simulation.
Many thanks Luis for this great video and for sharing the file. Very insightful! Def one of the best explanatory videos on this topic on KZread.
Brilliant video, thank you Luis so much for sharing and for sending the file over quickly! Absolute legend!
Hi Luis. A truly amazing and relevant example for many folks who do this type of analysis for various projects. Thanks again for creating this video and spreadsheet and helping non-financial folks get a step closer to understanding the financial world better!
Short vid, informative and to the point. Best you can ask for. Thanks Luis
This is an excellent video. Luis. We have a lot to learn from you! Keep posting these awesome tutorials please. Gracias y un fuerte abrazo hermano!
Thanks for the spreadsheet. I received it short after I sent you the email. Its very good for me to practice my Monte Carlo simulation
Thanks for sending the model Luis; I appreciate your sharing it.
Hi Luis, many thanks for the spreadsheet - well received and very useful!
This could be exactly what I needed, thank you Luis!
Thank you much Mr. Olano!!! Thank you for best Monte Carlo Simulaion ever!!!!!!
Hi Luis, thank you for the sending the spreadsheet and for such a quick response.
Thank you Luis! Excellent video and you are very generous for sharing this tool.
thanks a lot Luis. I received your Workbook, helped a lot! Keep up the good work!
I think this is VERY nice example of Monte-Carlo analysis and EPV calculation. Thank you
Thank you for sending me the file Luis. Good work! Best wishes to you, Ricardo
Sent the E-mail and got the sheet in less than 24 hours...great guy and great content.
Thank you so much Mr.Olano for sending me the file! You are a saviour!
Hi Luis, Thanks for sending the excel file and spreading the knowledge. You are prompt, an awesome guy, just like your simulation :)
Thanks, Mr. Olano, this was a very helpful guide!
Definitly, a very useful work, thank Luis in advance
Very clearly explained, Thank you Luis..
Thanks @luis. Great video and thank you so much for sending me the spreadsheet.
Thanks for sharing the template and answering my question. Good day.
Thank you very much Luis for sending the excel file, it is very much appreciated
Thanks for the file Luis. You're a legend
Thank you very for this amasing example of Monte Carlo implementation
Absolutely great. Very thankful for providing the download link. All the best from Germany!
@divaldinomendes8708
10 ай бұрын
Hi, could you please send me the download link? Thanks in advance.
Thanks a lot for your help. I have received the spreadsheet. Your video is very helpful.
Great video, very clear and complete..thank you sir
Short and sweet, easy to comprehend..thanks
Thanks for the spreadsheet and video Luis.
excellent video, very helpful and thanks for sending the file as well. very kind of you!
Fantastic. Super video. Thank you!
Hi Luis, I received your spreadsheet. Thank you so much!
Thank you, Luis, for the file! Appreciate it!
Thanks for the excel file, Luis... It's really helpful...
Thank you for sharing the spreadsheet, Luis! Everything is working as intended :)
@divaldinomendes8708
10 ай бұрын
Hi, could you please send me the download link? Thanks in advance
Thanks a lot Luis, file received, this is really helpful
Thanks a lot for sending me the file and for your swift response! Your video is amazing !!
@divaldinomendes8708
10 ай бұрын
Hi, could you please send me the download link? Thanks in advance.
Great video Luis
Excellent video! Thank you!
Received with thanks, This is really awesome work.
Thanks a lot for your kind support. I have received the excel file. The file is very good. Thanks a lot.
Thank you for the file Luis. It was very helpfull!
I have received the file, THANK YOU Luis ! it will be very helpful to me. Saludos!
Thanks a lot Mr. Olano for your kind support, I have received the excel sheet. Regards
@phuliphongmap5180
5 жыл бұрын
Mohamed Heeraab Can I get the excel sir: truonghungtinh@gmail.com. Thanks in advanced.
Hi. Thank you very much for sharing this video. It is a great help in my work.
Thank you so much Luis. I've received the file. I'm student live in thailand.
Awesome Sauce! Thank you sir for the great video!
@pedalforthelife
7 жыл бұрын
You are welcome James!
Thanks Luis, for the file. It was a great help
Hi Luis - I received the excel file. Many thanks for this. I really appreciate.
Brilliant.... Thanks for sharing
I wish to thank you so much for your explanation
Wow! Really impressed with the quality of this spread sheet! Thanks Mr. Luis.
@pedalforthelife
6 жыл бұрын
Thank you Josh .... let me know if you will need the file
@reginalinda3225
4 жыл бұрын
@@pedalforthelife I need, can you please send to me? reginafranco_96@hotmail.com
@pedalforthelife
4 жыл бұрын
@@reginalinda3225 i have sent you the file .......... best regards!
@archardjuniorkweyamba1303
2 жыл бұрын
Can you please send me the file ?
I have received the file. Thank you LUIS!
thanks for your kind lecture and you gave the original files thorught internet and I could got it today. thanks again for your sharing cool knowledgement
Thank you very much Luis. I've received the file. Thanks
Very interesting. Thank you!
@motebmarei1742
6 жыл бұрын
Hello, Would you please send me the excel file on: eng.marei2014@hotmail.com
Hi Luis, thanks for this, I received the file, very helpful. Thanks
Thank you for the file Luis
Thank you very much indeed for sharing!!!
Thank you so much Mr. Luis , I have received the file!
Luis, thank you for sharing. I've got your spread sheet!
Thanks for sending the excelsheet it will be very helpfull for me!!!
Luis, nice video!
Great work!!!
Very good and useful . Thanks!!!
Thanks for sending the file!
hai Luis, this is a very good video... tq for sharing
Hi Luis, interesting video. I am new to Monte Carlo simulations so forgive my naivety. Two questions. 1) why did you set the 1000 trials based off of your NPV value? This value was already calculated by random number generation. You are therefor basing your trial 1000 simulations based off a single random simulation, this is why the distribution left skewed. Does this not provide inaccurate results? 2) This doesn't tell us anything other than given enough trials your NPV calculation would naturally converge to the statistical distribution that we would normally see on a normal bell curve. As there's only one variable, growth rate, could we not just look up the different levels of probability based on normal distribution and multiply it by growth rate and come up with generally the same results in much less work? This seems a classic way to over complicate a very simple issue.
Un millon de gracias
Thank you so much Mr. Luis , I have received the file
Received by email! Thanks a lot!!
Hi Luis! What kind of restrictions can I add to this type of model?
well done mate! good work :)
Hi Luis. I've received file, thanks you so much.
Hi Luis, I have received your file, thanks for your great help. M-C Simulation is an excellent application for the Pulp and Paper investment analysis Thank you again for your great video and excel file ~
@pedalforthelife
9 жыл бұрын
Hi Niu: You are welcome!
Luis. Thanks for the file. Is very good
many thanks sir..I've already received it
Thanks for sharing the template
I received your file. Thanks Luis
Thanks, spreadsheet received!
Thank You for the video Mr. Luis, it very useful. What if both benefits and cost for the project are random numbers (exp. costs are with uniform distribution, and benefits are with with normal distribution)? How do I change this table for that kind of case?
Thank you Great video
Hi Luis, thank you for sharing this video, it was very interesting. Would you mind also sharing the file?
Thank you very much
Thanks Luis, I got the file. I appreciate the assistance
@zeriguineyacine4333
9 жыл бұрын
Oluwaseun Oyekola please can you send me the file zeriguineyacine@gmail.com
Hello, great video! Thank you. Why does you average NPV only take into account cells B42:B141?? Are you not using the whole sample?
@pedalforthelife
7 жыл бұрын
At the 'Monte Carlo Simulation Results' table ( Cell B36 Formula) , NPV Mean = AVERAGE(B42:B1041) ..... i.e. the AVERAGE of the 1,000 interactions and calculations from the above NPV model ( NPV calculated 1,000 times on each interaction of the spread sheet) .... all these parameters belong to the RED graph : NPV Normal Distribution ........
Thanks for the document Luis Olano.
Hello, thank you for the excel file!
Luis. Thanks for sending the file. The only thing I added was the Probability of NPV < 0: normdist(npv, npv mean, npv standard deviation,0) and added and NPV distribution graph to test again for the prob. of negative NPVs. Wondering what your thoughts are about this. Please share. Saludos cordiales.
@archardjuniorkweyamba1303
2 жыл бұрын
Please send me the file bro ?
I liked it alot!
Thank you for the help i got the sheet....
I've received the file.Thank youuu!
@reginalinda3225
4 жыл бұрын
can you send to me?
Brilliant video. Please how do you solve for discounted cash flow for say 10 years when you have only uncertain inputs in a question? I hope i get a reply :(
This is brillant. This is old but not getting old, still famous! -:) I also sent you an email.. :-)
@loiclux
7 жыл бұрын
got it thanks!!
@pedalforthelife
7 жыл бұрын
Thank you Loic!
Thank you Dear Luis. could plz explain the relationship between Z and probability (rand() or p).
@pedalforthelife
4 жыл бұрын
If we call NORMINV(p, mu, sigma), Excel computes Mean + sigma*NORMSINV(p) ... where z = NORMSINV(p)
thanks, well received
@paulshin6182
7 жыл бұрын
Can you forward the spreadsheet to pshindhs@gmail.com? Thank you in advance