Python in Audit - Revenue Forecasting Using Monte Carlo Simulation
Originally published: 08/12/2020 10:57
Publication number: ELQ-79848-1
View all versions & Certificate

Python in Audit - Revenue Forecasting Using Monte Carlo Simulation

A working paper to develop revenue expectation using Monte Carlo

The template work paper aims to help auditors to develop revenue expectation using Monte Carlo Simulation. Auditors generally use excel for documenting numerical work papers, so creating Monte Carlo simulation for a large number of simulations (say 1 million) is little cumbersome if done in excel. This is where the power of Python comes in handy. Once code is developed it is just a matter of a click to develop the most complicated method in finance.

Attached is the code in IPython format which is a jupyter notebook.

Read your file and provide your desired revenue column in the code and click Run All Cells

You will be provided with visualisation in the form of graph and expected numbers of the likelihood of revenue.

If you don't know how and where to run jupyter notebook file use any cloud-based jupyter notes such as google Colab to run the file.

All required libraries are imported however is the libraries are not installed please use pip install to install them first before importing them.

The detail explanation of the code and how to run the file is provided in the youtube video so please refer for details.

Disclaimer :
The code is provided for the educational purpose the author will not accept any liabilities express or implied for any adverse consequences financial or non-financial.

This Best Practice includes
1 Python code file in jupyter note book

Rizwan Ahmed Surhio offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

To improve the audit quality

If python libraries are working as expected.

5.0 / 5 (10 votes)

please wait...