Basic Portfolio Analysis

The Portfolio Mix model uses Monte Carlo simulation to determine the different possible returns on a stock portfolio given uncertain returns on individual stocks. It has 8 stocks available for the user, who can change its weight, current yield and the distribution of the Future Return, choosing from a Triangular or a PERT. The model also lets the user to define correlations and after running a simulation, to obtain a future return report, plus additional descriptive statistic reports for each stock. Entry level model applied to the financial world.