Home

. || . ** Project Finance ** .. || . ** Corporate Finance ** .. || .. ** Databases ** .. || .. ** Risk ** .. || .. ** Energy Analysis ** .. || .. ** Excel Utilities ** .. || .. ** Writings ** .. || media type="custom" key="29524243" align="right" = This website is now obsolete because of being extinguished by horrible wikispaces. Please go to http://edbodmer.com for a much improved website. =


 * A Bunch of Financial Models, Excel Utilities, Video References, Discussion of Finance Theory and Cases **
 * To receive a set of organised files, email me at edwardbodmer@gmail.com (no charge).
 * My passion is teaching in-person. [|Press Here for a Link to Website with Course Outlines]
 * Videos on modelling: @https://www.youtube.com/channel/UC2g_Ih-lK1sa3L_1xHacA8w
 * Read my exciting 643 page novel on modelling -- [|link to description of my book.]
 * Become part of our community on[| Linkedin]
 * Read a description of my services - on-line courses, personal calls and other products.

= =


 * = [[image:edbodmer/Featured Project Finance Model.JPG width="166" height="144" link="edbodmer/Comprehensive Solar Model"]] ||= [[image:edbodmer/Featured Corporate Finance Model.JPG width="164" height="153" link="edbodmer/Corporate Finance Model with Stable Ratios for Working Capital, Capital Expenditures, Deferred taxes and Other Items"]] ||= [[image:edbodmer/Featured Acquisition Model.JPG width="172" height="158" link="edbodmer/Featured Acquisition Model"]] ||= [[image:Generic Macros.JPG width="171" height="150" link="Macros for Financial Models"]] ||= [[image:edbodmer/Scenario.PNG width="165" height="153" link="edbodmer/scenario analysis"]] ||= [[image:Graph Box.PNG width="165" height="135" link="Flexible Graphs"]] ||= [[image:edbodmer/Book 1.PNG width="166" height="155" link="edbodmer/Valuation Mirage"]] ||= =[[image:edbodmer/Solar Window.JPG width="171" height="153" link="solar resource analysis"]]= ||


 * [[image:Project Finance.JPG width="165" height="137" link="edbodmer/Project Finance Exercises"]] || [[image:edbodmer/Corporate Model.JPG width="165" height="156" link="edbodmer/Corporate Finance Model Exercises"]] || [[image:edbodmer/Acquisition Model.JPG width="172" height="142" link="edbodmer/M&A Exercises"]] || [[image:edbodmer/PDF to Excel.JPG width="166" height="133" link="edbodmer/PDF to Excel"]] || [[image:Monte Carlo Simulation.JPG width="166" height="145" link="Risk Analysis Templates"]] || [[image:Databases.PNG width="167" height="167" link="Download Webpages or Files to Excel"]] || [[image:edbodmer/Case Studies.JPG width="164" height="133" link="edbodmer/Case Studies"]] || [[image:Wind Resource Analysis.JPG width="169" height="138" link="edbodmer/Wind Resource Assessment"]] ||


 * =[[image:edbodmer/Advanced Project Finance.JPG width="167" height="140" link="edbodmer/Project Finance Structuring"]]= || =[[image:edbodmer/Advanced Valuation Analysis.PNG width="161" height="136" align="left" link="edbodmer/EV to Equity Bridge"]]= || [[image:edbodmer/Real Estate.PNG width="170" height="139" link="edbodmer/REAL ESTATE MODELS"]] || [[image:edbodmer/Waterfall Graph.JPG width="166" height="138" link="edbodmer/Waterfall Graph"]] || [[image:edbodmer/Tornado Diagrams.JPG width="169" height="151" link="Tornado Diagrams"]] || =[[image:edbodmer/Merchant.PNG width="169" height="144" align="left" link="edbodmer/Merchant Electricity Analysis"]]= || [[image:edbodmer/Slides.JPG width="164" height="144" link="edbodmer/slides"]] || [[image:edbodmer/Hydro Resource Analysis.JPG width="168" height="137" link="edbodmer/Hydro Resource Analysis"]] ||


 * [[image:edbodmer/Circular Reference Page.JPG width="165" height="146" link="edbodmer/CIRCULAR REFERENCES"]] || =[[image:edbodmer/Depreciation.JPG width="163" height="147" link="edbodmer/Depreciation"]]= || [[image:edbodmer/Financial Analysis.PNG width="166" height="120" link="Financial Ratio and Credit Analysis"]] || =[[image:Technology Comparison.JPG width="174" height="132" align="left" link="edbodmer/Technology Comparison"]]= || [[image:Options.JPG width="166" height="146" link="Real Option Models"]] || [[image:edbodmer/Stocks.JPG width="173" height="173" link="Stock Price Analysis"]] || [[image:edbodmer/Testimony.PNG width="166" height="156" link="edbodmer/Testimony"]] || [[image:edbodmer/Battery.JPG width="169" height="156" link="Battery and Storage Analysis"]] ||


 * [[image:edbodmer/Dynamic Goal Seek.JPG width="165" height="147" link="User Defined Functions"]] || [[image:edbodmer/Cost of Capital Analysis.JPG width="166" height="153" link="cost of capital and wacc"]] || [[image:edbodmer/Excel Functions.JPG width="164" height="151" link="excel functions"]] || [[image:Dispatch Analysis.JPG width="178" height="150" link="edbodmer/price analysis"]] || [[image:edbodmer/Data Analysis.JPG width="165" height="154" link="Data Analysis"]] || [[image:Statistical Analysis Window.JPG width="177" height="148" link="Statistical Analysis for Finance and Budgeting"]] || =[[image:edbodmer/Market Model.JPG width="166" height="124" link="edbodmer/dispatch model"]]= || [[image:edbodmer/LCOE.JPG width="165" height="157" link="Integrated Electricity Analysis"]] ||

**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.**
 * [[image:Col 1.PNG width="165" height="86"]] || [[image:Col 2.PNG width="159" height="87"]] || [[image:M&A.PNG width="175" height="90"]] || [[image:col 4.PNG width="174" height="102"]] || =[[image:edbodmer/Scenario Title.PNG width="169" height="102"]]= || [[image:Col 6.PNG width="178" height="108"]] || [[image:col 7.PNG width="162" height="115"]] || [[image:Col 8.PNG width="158" height="103"]] ||



The 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." aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa