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
very informative post for me as I am always looking for new content that can help me and my knowledge grow better.
ReplyDeleteVery 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.
ReplyDeleteAfter reading this informative and effective post. I have good knowledge now to fix this issue and to explain this issue to others.
ReplyDelete