|| 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.JPGThe idea of this website is not to only describe how the build a basic project finance, or merger model. There are also a lot of advanced concepts related to both finance theory and modelling techniques that I think are different from the standard way of thinking. My hope is that some of the ideas will make you think about innovative financial analysis techniques and the associated modelling. You can find a bunch of sample models and links to videos by clicking on the little pictures below. You can also get access to lesson sets and instructions of how to avoid many inaccurate 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 that you can find by clicking on the "Update" picture at the bottom of the page. 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). But if you have completed lesson sets and you want me to verify and prove to the whole world (including your boss) that you really are a good modeller I will do this for a modest fee and send you an official certificate and badge. You will then be registered as a modelling expert on a special page of this website 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. You can see how this and other products work by clicking on the adjacent page that I have named "Products that are a real bargain."

Col 1.PNG
Col 2.PNG
M&A.PNG
col 4.PNG

Scenario Title.PNG

Col 6.PNG
col 7.PNG
Col 8.PNG

Featured Project Finance Model.JPG
Featured Corporate Finance Model.JPG
Featured Acquisition Model.JPG
Generic Macros.PNG
Scenario.PNG
Graph Box.PNG
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.PNG
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
Lookup.PNG
Scenario Report.PNG
Data Analysis.PNG
Testimony.PNG
Renewable Analysis.PNG

Technology Comparison.JPG

Cost of Capital.PNG

Options Page.PNG

Dispatch Analysis.JPG
EV to EBITDA.JPG

Market Model.JPG

Merchant.PNG

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.