Friday, June 4, 2010

Firm valuation (Monte Carlos Application)

For Firm valuation I used Monte Carlos Application.

For Monte Carlos Application I generated Random Values By using following macro
Sub montecarlos()
'This macro performed montecarlo simulations'
For rownum = 2 To 301

Range("b9").Value = Cells(rownum, 10).Value
Range("B11").Value = Cells(rownum, 11).Value
Cells(rownum, 13).Value = Range("c85").Value

Next rownum
End Sub
this Method will help to identify the riskiness of the project.
here is the link of complete template :
Monte Carlos Application Download link


  1. very informative post for me as I am always looking for new content that can help me and my knowledge grow better.

  2. Very interesting blog. A lot of blogs I see these days don't really provide anything that attract others, but I'm most definitely interested in this one. Just thought that I would post and let you know.

  3. After reading this informative and effective post. I have good knowledge now to fix this issue and to explain this issue to others.