I confess that Monte Carlo methods confused and to a certain extent intimidated me for a long time. It was…
The two most common measures applied to proposed projects (for everything from expansion to replacing old equipment) are net present…
ARIMA models require some study and application to thoroughly understand. The rewards are well worth it though, if you master…
I’ve heard technical analysis explained and described the following ways: “TA is the analyst attempting to read the mind of…
VaR, or Value at Risk is another one of many concepts in finance that sounds much more intimidating to some…
Risk adjusted returns of investments and variance analysis used in corporate finance and accounting will both depend on understanding some…
Arguably the simplest approach towards generating normal distributions using pseudo-random numbers is through a combination of RAND and Norm.S.Inv. Norm.S.Inv…
When it comes to Excel, the phrase “there’s more than one way to skin a cat” applies in almost every…
Excel can be used to return pseudo random numbers using the RAND function. This function has no arguments, and simple…
A Time-Value of Money Arguably the most fundamental concept in finance is that of a “time-value of money”, where the…