Monte Carlo Financial Model in Excel
Budget: $30 – $250 USD
I need an expert in Excel and Visual Basic to create a Monte Carlo simulation for a 30-year financial model. I have already created the basic 30-year financial model (attached Excel). I need to be able to run it thousands of times for the Monte Carlo simulation and analyze the results. I would like one Excel workbook that has both the model and the ability to run the Monte Carlo simulation. I need to be able to change the inputs and re-run it.
Key Requirements:
- Design an Excel spreadsheet that can run a Monte Carlo analysis.
- Utilize Visual Basic to enhance the spreadsheet functionality.
- Perform a statistical analysis on the results of the simulation.
Ideal Skills:
- Proficiency in Excel and Visual Basic.
- Strong understanding of financial modeling and Monte Carlo simulations.
- Ability to perform and interpret statistical analyses.
The Monte Carlo simulation should run the model X number of times (probably at least 10,000) and output the Final Asset Value at Year 30 in a separate sheet. An then a third sheet should then automatically provide standard statistical analysis (graphs, mean, median, standard deviation, other useful metrics).
Key Requirements:
- Design an Excel spreadsheet that can run a Monte Carlo analysis.
- Utilize Visual Basic to enhance the spreadsheet functionality.
- Perform a statistical analysis on the results of the simulation.
Ideal Skills:
- Proficiency in Excel and Visual Basic.
- Strong understanding of financial modeling and Monte Carlo simulations.
- Ability to perform and interpret statistical analyses.
The Monte Carlo simulation should run the model X number of times (probably at least 10,000) and output the Final Asset Value at Year 30 in a separate sheet. An then a third sheet should then automatically provide standard statistical analysis (graphs, mean, median, standard deviation, other useful metrics).