|| 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 (i.e. content).

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

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

My passion is teaching in-person. You can find information on up-coming courses by clicking on the Products picture just below and to the left. Press Here for a Link ot Website with Course Outlines

sell.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. Each of links that are associated with the pictures has excel files and associated videos that explain the various concepts. You can also get access to lesson sets and instructions of how to avoid many inaccurate and biased investment analysis techniques that have become far too ingrained in financial analysis. If you are beginning analysis in project or corporate finance analysis, I suggest that you start at the top left pictures below and try some of the exercises that are labelled A-Z. I support this website by providing in-person courses which I am trying to promote. 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. 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. You can see how this and other products work by clicking on the adjacent page named "Products and Services."

Col 1.PNG
Col 2.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.JPG
Graph Box.PNG
Book 1.PNG

Solar Window.JPG

Project Finance.JPG
Corporate Model.JPG
Acquisition Model.JPG
PDF to Excel.JPG
Monte Carlo Simulation.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


Hydro Resource Analysis.JPG

Circular Reference Page.JPG


Financial Analysis.PNG

Technology Comparison.JPG


Dynamic Goal Seek.JPG
Cost of Capital Analysis.JPG
Excel Functions.JPG
Dispatch Analysis.JPG
Data Analysis.JPG
Statistical Analysis Window.JPG

Market Model.JPG


he 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


New Files.JPG

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.