20 lines
1.4 KiB
Markdown
20 lines
1.4 KiB
Markdown
# 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.
|
|
|
|
## Usage
|
|
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.
|
|
|
|
# Structure
|
|
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.
|