Home|| Book || Featured PF Models || Featured Corp Models || Featured Acq Models || PF Exercises || Corp Exercises || Download to Excel || Scenario Analysis || Tornado Diagrams || Monte Carlo || Flexible Graphs || Real Estate || Acq Exercises || Macros || Reading PDF || Waterfall Graphs || Circular Ref || Depreciation || Financial Ratio || Value Driver || Renewable || Testimony || Pricing Case Studies ||


book cover.JPG

This website is not supposed to be flashy ... it just has a lot of files about project finance, corporate finance, energy and data analysis and useful excel tools for reading from the internet, reading from PDF files, making efficient graphs and energy analysis.

Send me an e-mail at edwardbodmer@gmail.com to receive a complete set of organized files with a Google Drive link.

If you would like to know about upcoming courses, send me an e-mail to edwardbodmer@gmail.com.

I have a YouTube Channel with lots of videos on modelling: https://www.youtube.com/channel/UC2g_Ih-lK1sa3L_1xHacA8w

I have written an exciting novel on modelling that you can read at the beach. Here is a link to description of my book.

Join our financial modelling community on Linkedin and enter the discussion, ask questions and find out about upcoming events



New Files.JPG

The idea of this website is not to only describe how the build a basic project finance, or merger model. In addition, a lot of advanced concepts are introduced and hopefully some new ideas are presented that will make you think about innovative financial analysis techniques and the associated modelling. When you click on each of the little pictures below you will find a bunch of sample models and links to videos. By clicking on those pictures you can find lesson sets and instructions of how to avoid and biased investment analysis techniques that have become ingrained in financial analysis. If you have looked at the website before and you are mainly interested in recent files, I have added a page that includes the latest files that I have uploaded. I have also re-structured on-line lessons are that are free (I have been told that if I somehow charged money for the courses you would think they are more valuable which is I hope complete rubbish). If you have completed exercises and you want me to verify that you really are a good modeller I will do this for a modest fee and send you an official badge. You will then be registered as a modelling expert which I am sure will result in a promotion or a new job. To be verified, send me an e-mail with the completed lesson set.
Col 1.PNG
Col 1.PNG
Col 1.PNG
Col 1.PNG
Col 1.PNG
Col 1.PNG
Col 1.PNG
Col 1.PNG

Featured Project Finance Model.JPG
Featured Corporate Finance Model.JPG
Featured Acquisition Model.JPG
Excel Utilites.JPG
Scenario.PNG
Dynamic Graphs.JPG
Book 1.PNG
Solar Resouce and Finance.JPG

Project Finance.JPG
Corporate Model.JPG
Acquisition Model.JPG
PDF to Excel.JPG
Monte Carlo Simulation.JPG
Databases and Downloading.JPG
Case Studies.JPG
Wind Resource Analysis.JPG

Advanced Project Finance.JPG

Advanced Valuation Analysis.PNG

Real Estate.PNG
Waterfall Graph.JPG
Tornado Diagrams.JPG
Statistical Analysis.JPG
Slides.JPG
Hydro Resource Analysis.JPG

Circular Reference Page.JPG

Depreciation.JPG

Financial Analysis.PNG
Market Model.JPG
PE Regression.JPG
Data Analysis.PNG
Testimony.PNG
Renewable Analysis.PNG

Technology Comparison.JPG


Merchant.PNG

Dispatch Analysis.JPG
EV to EBITDA.JPG

Value Driver.JPG

DCF Proofs.JPG

Integrated Generation and Distribution Analysis.JPG

The files below have been recently revised and improved; other recently added files are at the bottom of the page. Not many people try these files, but out of the thousands of files on the site, they may be the best. You can read pdf files to excel and create waterfall graphs in seconds and use a bunch of helpful macros.





Email: edwardbodmer@gmail.com
Skype: edward.bodmer
YouTube Channel: https://www.youtube.com/channel/UC2g_Ih-lK1sa3L_1xHacA8w

assistance.png


I am beginning a service where you can ask me to solve a problem such as a difficulty in resolving a circular reference with a user defined function. If you have a problem you would like me to help solve, you can send me an e-mail with the description of your problem. I will then schedule a skype conversation where we can share a screen and I will explain to you how to solve your issue (you will do the analysis on the screen). There would be a charge for the assistance only if your problem is solved.


Go to home