Monte Carlo EBITDA Excel Simulator
  • Monte Carlo EBITDA Excel Simulator
  • Monte Carlo EBITDA Excel Simulator
  • Monte Carlo EBITDA Excel Simulator
  • Monte Carlo EBITDA Excel Simulator
Originally published: 20/03/2019 15:11
Publication number: ELQ-86882-1
View all versions & Certificate
certified

Monte Carlo EBITDA Excel Simulator

EBITDA & PD Simulator - Monte Carlo - in Microsoft Excel for you to use

Description
This is a Monte Carlo simulator model which replicates a 5.000-observations sample of the EBITDA variable based on some inputs for production level, variable and fixed costs.

To run this model the user has to fill-in the input cells (yellow) in the first sheet of this excel file (Production Installed Capacity, Capacity Factor, Price per Unit Sold, Variable Costs Per Unit Sold, Fixed Costs, Nominal Debt Amount, Repayment, Interest Rate).

As soon as the model's input cells are set, the tool automatically replicates (simulates) a sample of the EBITDA variable, based on the Monte Carlo method.

Given the model's statistical results of the EBITDA simulated density function, it calculates the Probability of Default for some specific assumptions of debt (amount, duration, interest rate).

Users of this file should be aware of the following:
- the model may not provide an appropriate degree of assurance for all possible uses of it.
- the model may not have been subject to independent testing and where it has been tested, this may not provide an appropriate degree of assurance for all possible uses of the Model.
- recipients of this model use it entirely at their own risk and, no responsibility is taken by the developer.

This business tool includes
1 xlsx file

Dimitris Kourpatsos offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Reviews


keyboard_arrow_leftkeyboard_arrow_right

Any questions on Monte Carlo EBITDA Excel Simulator?

The user community and author are here to help. Go ahead!

please wait...