MonteGrid | Tutorials | Share a model

Share a model

Send the model to colleagues with or without MonteGrid.

  1. 1What the workbook contains

    The workbook contains the definitions: assumptions as MC_ distribution functions, forecasts as MC_OUTPUT, correlation groups in MC_STATIC, and correlation matrices as blocks of cells. MonteGrid stores the run settings and the results.

    To start here, download the finished model:

    capital-budgeting.xlsx

    capital-budgeting
    HomeInsertDrawPage LayoutFormulasDataReviewViewAutomateMonteGrid
    DefineAssumption DefineForecast ClearDefinition DefineCorrelation ImportDefinitions
    Run Stop RunSettings
    CreateReport ExtractData OpenMonteGrid
    Help License
    B5 =MC_TRIANG(420,450,470,MC_STATIC(450,"Unit Price",""))
    ABCDEFGHIJKLM
    1 InputValueUnit
    2 Capital cost120.0$M
    3 Year 1 volume200.0thousand units
    4 Volume growth per year3.0%%
    5 Unit price, year 1450.0$
    6 Price change per year-1.0%%
    7 Variable cost per unit250.0$
    8 Fixed cost per year18.0$M
    9 Tax rate25.0%%
    10 Discount rate9.0%%
    11 Plant life10years
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    AboutInputsCash FlowSummary
    ReadyAccessibility: Good to go
    The unit price formula.
    capital-budgeting
    HomeInsertDrawPage LayoutFormulasDataReviewViewAutomateMonteGrid
    DefineAssumption DefineForecast ClearDefinition DefineCorrelation ImportDefinitions
    Run Stop RunSettings
    CreateReport ExtractData OpenMonteGrid
    B5 =MC_TRIANG(420,450,470,MC_STATIC(450,"Unit Price",""))
    ABCDEF
    1 InputValueUnit
    2 Capital cost120.0$M
    3 Year 1 volume200.0thousand units
    4 Volume growth per year3.0%%
    5 Unit price, year 1450.0$
    6 Price change per year-1.0%%
    7 Variable cost per unit250.0$
    8 Fixed cost per year18.0$M
    9 Tax rate25.0%%
    10 Discount rate9.0%%
    11 Plant life10years
    12
    13
    14
    15
    16
    17
    18
    AboutInputsCash FlowSummary
    ReadyAccessibility: Good to go
  2. 2Colleagues with MonteGrid

    Send the workbook and the run settings. With the same model, settings and seed, MonteGrid gives the same results. For this model: 10,000 trials, seed 20260802, Monte Carlo sampling.

  3. 3Colleagues without MonteGrid

    The MC_ functions are defined in the MonteGrid add-in. Without it, Excel shows #NAME? in the defined cells and errors in the cells that depend on them. Send the MC Report workbook instead. It contains no MC_ functions.

    Note: Workbooks downloaded from asunder.co also define the MC_ functions as LAMBDA names, so Microsoft 365 shows their base case without MonteGrid. MonteGrid removes these names when it first runs the workbook.

    capital-budgeting
    HomeInsertDrawPage LayoutFormulasDataReviewViewAutomateMonteGrid
    DefineAssumption DefineForecast ClearDefinition DefineCorrelation ImportDefinitions
    Run Stop RunSettings
    CreateReport ExtractData OpenMonteGrid
    Help License
    B5 =MC_TRIANG(420,450,470,MC_STATIC(450,"Unit Price",""))
    ABCDEFGHIJKLM
    1 InputValueUnit
    2 Capital cost#NAME?$M
    3 Year 1 volume#NAME?thousand units
    4 Volume growth per year#NAME?%
    5 Unit price, year 1#NAME?$
    6 Price change per year-1.0%%
    7 Variable cost per unit#NAME?$
    8 Fixed cost per year#NAME?$M
    9 Tax rate25.0%%
    10 Discount rate9.0%%
    11 Plant life10years
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    AboutInputsCash FlowSummary
    ReadyAccessibility: Good to go
    The workbook without MonteGrid.
    capital-budgeting
    HomeInsertDrawPage LayoutFormulasDataReviewViewAutomateMonteGrid
    DefineAssumption DefineForecast ClearDefinition DefineCorrelation ImportDefinitions
    Run Stop RunSettings
    CreateReport ExtractData OpenMonteGrid
    B5 =MC_TRIANG(420,450,470,MC_STATIC(450,"Unit Price",""))
    ABCDEF
    1 InputValueUnit
    2 Capital cost#NAME?$M
    3 Year 1 volume#NAME?thousand units
    4 Volume growth per year#NAME?%
    5 Unit price, year 1#NAME?$
    6 Price change per year-1.0%%
    7 Variable cost per unit#NAME?$
    8 Fixed cost per year#NAME?$M
    9 Tax rate25.0%%
    10 Discount rate9.0%%
    11 Plant life10years
    12
    13
    14
    15
    16
    17
    18
    AboutInputsCash FlowSummary
    ReadyAccessibility: Good to go

All tutorials