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