You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Dustin Smith 385ee2117f removed old files after gitignore update 9 months ago
html fixed code bug 9 months ago
notebooks removed old files after gitignore update 9 months ago
.gitignore updated gitignore 9 months ago updated README 9 months ago

Capital Budgeting with Monte Carlo Simulation

Many times I look for capital budgeting templates with Monte Carlo simulations it will require me to use Excel with the add on. Unfortunately, I neither have access to Windows nor do I plan on installing Excel on my Mac. I struggled to easily do this using Google Sheets or Numbers on Mac. It may be possible to do, but the time dedication to figure this out would be too much when I can simple build a template to use in Python.


In the Python notebook, I lay out a scenario where a business is looking to move from an on premise cluster to cloud. In this example, I use Google Cloud and Databricks cost. Please consult with your cloud vendor about any discounts to get accurate data points as well as modifying the line items to represent your business.

Also, you are not limited to using a cloud migration process to use this template. Feel free update it as you see fit for whatever your organization may be looking into whether it is standing up a new factory, cost savings of data compression, introducing a new widget into the market place, etc.


In this repo, I have a notebooks and html directory. If you want to peruse the example without launching Python, just open the html file locally and review it on your web browser. Once you are ready to play around with the current example or create your own, open the notebook and take it for a spin.