Recent Changes

Today

  1. page Assistance Page for Corporate Modelling and Project Finance Modelling edited ... {class pictures.jpg} First, I know for a fact that watching videos and completing an on-line…
    ...
    {class pictures.jpg}
    First, I know for a fact that watching videos and completing an on-line course is nothing at all like an in-person class. When I taught a class for an investment company a year ago, each of the employees had been instructed to watch videos before the class. Within a few minutes everyone recognized that working in-person was completely different than trying to learn with on-line videos and the in-company course was far more effective. Therefore, I hope you will look at my course outlines and consider an in-person course. Please send me an e-mail at edwardbodmer@gmail.com for course outlines. Even if your boss will not allow you to take a course I am interested in your suggestions for future courses and information on how business clubs and practical courses work at different universities.
    ...
    tricky modelling issuesissues.
    {skype.jpg}
    . I
    I and my
    Third, I have learned that in many places watching a video can be a real pain if the internet is slow. That is why I am offering the complete set of videos on a pin drive for a price that is little more than the cost of the pin drive and postage. If you send me your address in an e-mail I will send a high capacity pin drive with a set of the videos.
    Fourth, I have begun to structure videos and files on some subjects as a set of on-line courses. I understand that many others provide on-line on fundamental financial modelling issues. I hope you agree that many of my courses on things like battery analysis, merchant price comparison, flaws in the value driver formula, computing stable capital expenditures, advanced depreciation analysis and others are unique. If you complete the courses you may think you will not receive appropriate credit. I will give you a certificate and your name will go on a special page of the website. While I have not completed the structure for all of the on-line courses as yet, I am in the process of completing a full set. Of course I am extremely interested in how you think I should structure this activity.
    (view changes)
    6:54 pm
  2. page Home edited ... I have written an exciting novel on modelling that you can read at the beach. Here is a link t…
    ...
    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
    ...
    is teaching in-person courses.in-person. You can
    {sell.jpg} 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."
    {Col 1.PNG}
    (view changes)
    10:21 am
  3. page Corporate Finance Models Collection edited ... This model includes a corporate model and a project finance model that I worked on a few years…
    ...
    This model includes a corporate model and a project finance model that I worked on a few years ago. I was very inefficient in making graphs and somewhat crude in making the scenario analysis. The key in this model is analysis of the Karachi Port relative to its competitor named Port Quasim. There is limited movements of goods into and out of Pakistan and both ports are intending to increase the capacity in a dramatic fashion. This new capacity will not go away and must wait a potentially long time until demand catches up with the increases in capacity that come from construction of a large deep water port. This model demonstrates the necessity to evaluate the entire industry and not simply focus on one company. This is particularly true when companies are earning a high return (like hotels earning a high return) and then other companies moving into the industry.
    {KPT Corporate and PF Model.xlsm}
    Timing in Corporate Models and Subtotals that Accumulate Monthly or Quarterly Data
    I did not really know where to put the model that illustrates how to take monthly data and then make it into quarterly, semi-annual or annual data. The thing not to do is to manually put in sub-totals with the sum function. If you do this your model will be clumsy, in-flexible and inaccurate. Instead, you can include separate sheets that summarise the same information as in your detailed analysis, but include flexible sub-totals. You need to establish a counter with the MOD function after starting with a basic period counter. Then use the SUMIF function to add across months or quarters. Finally, use the MATCH (with zero at the end) and the INDEX to put the sheet with sub-totals together. This model demonstrates the importance of setting-up time lines in corporate finance models. The time lines are essential for history versus forecast as well as the flexible sums.
    {Timing with Annual, Quarterly Subtotals.xlsm}

    Other Corporate Models: Evraz (Russia); Sateri (Singapore); Meracorp (Solvenia) and LaFarge
    I have included some other corporate models that we have developed in classes. All of the models begin with historic data and use the key concept of the historic switch. The Evraz is a model of a steel producer in Russia. This model demonstrates a lot of scenario analysis and shows how to build a lot of assumptions and analysis from a few lines of production and volume sales that are in financial reports. The Evraz model also documents issues associated with modelling maintenance capital expenditures and capital expenditures for new development projects that add new capacity. Sateri is a corporate model of a chemical company and includes and analysis of capacity from existing facilities and capacity from new facilities. The capacity allows modelling of alternative capacity utilisation scenarios. The LaFarge model is a comprehensive model that includes sensitivity analysis from reports to investors and other sources. Finally, the Meracorp model is an analysis of a retailer that was having financial difficulties.
    (view changes)
    8:41 am

Thursday, June 22

  1. page Assistance Page for Corporate Modelling and Project Finance Modelling edited ... Now move from the superior banker consultant to GAFAM -- this stands for Google, Apple, Facebo…
    ...
    Now move from the superior banker consultant to GAFAM -- this stands for Google, Apple, Facebook, Amazon and Microsoft. These giant companies provide a whole lot that seems to be free. Google provides search engines, youtube, gmail etc. Facebook seems to give away whatsup and social network things. Microsoft now gives away Power BI, Linkedin and a lot in Skype. Of course these companies are not really giving away much at all. They are getting data and getting paid from big companies. Amazon does charge money, but it keeps competitors out of the market by paying its people low salaries and attaining high volumes. I say this because I am sick of hearing that I am giving too much away; that I am a charity organisation; that I am canabalising products; that people want to pay higher prices for in-person and on-line courses because they think they are getting a better product; and, that people will pay a whole lot for basic courses that have nothing very special. With the exception of Apple, GAFAM do not seem to be founded on these these silly ideas of people being fooled by higher prices; that you can easily sell training without new ideas; cannibalisim etc.
    Of course I have not made my website just for charity. I hope you will consider various different ways to help me out so I continue this work. If you are a student or you work at a company that refuses any training, you can still send me information about different business options. This page describes five products that I offer that are associated with this website -- and how I hope to get paid for my favours. I of course know virtually nobody will even visit this page of the website and instead collect free files and programming approaches. Like other websites I am hoping that a tiny fraction of most of you who are just looking for free stuff will consider some things that could be much more helpful than just downloading files or watching free videos.
    {class pictures.jpg}
    First, I know for a fact that watching videos and completing an on-line course is nothing at all like an in-person class. When I taught a class for an investment company a year ago, each of the employees had been instructed to watch videos before the class. Within a few minutes everyone recognized that working in-person was completely different than trying to learn with on-line videos and the in-company course was far more effective. Therefore, I hope you will look at my course outlines and consider an in-person course. Please send me an e-mail at edwardbodmer@gmail.com for course outlines. Even if your boss will not allow you to take a course I am interested in your suggestions for future courses and information on how business clubs and practical courses work at different universities.
    Second, I have only had a few skype calls where two of us share screens and work through tricky modelling issues
    ...
    Third, I have learned that in many places watching a video can be a real pain if the internet is slow. That is why I am offering the complete set of videos on a pin drive for a price that is little more than the cost of the pin drive and postage. If you send me your address in an e-mail I will send a high capacity pin drive with a set of the videos.
    Fourth, I have begun to structure videos and files on some subjects as a set of on-line courses. I understand that many others provide on-line on fundamental financial modelling issues. I hope you agree that many of my courses on things like battery analysis, merchant price comparison, flaws in the value driver formula, computing stable capital expenditures, advanced depreciation analysis and others are unique. If you complete the courses you may think you will not receive appropriate credit. I will give you a certificate and your name will go on a special page of the website. While I have not completed the structure for all of the on-line courses as yet, I am in the process of completing a full set. Of course I am extremely interested in how you think I should structure this activity.
    {certificate3.jpg}
    Fifth, I am in the process of attempting to market services to your boss and your boss' boss. I think you should receive credit for watching videos and trying to work through excel exercises. If you have an innovative boss he or she should recognise this and give you credit. The service I am selling is to monitor how much work you have done in listening to videos. To make sure you are really listening to the videos you will complete some questions. Depending on how much work you do I will send the results to somebody senior at your company. I have found out that sometimes you are told to learn things yourself or that you receive credit for watching videos and self-teaching in performance reviews. As with all of this stuff, I am very interested in your opinions on how structure the products.
    These products are described below.
    (view changes)
    6:30 pm
  2. file certificate3.jpg uploaded
    6:27 pm
  3. 6:26 pm
  4. page Assistance Page for Corporate Modelling and Project Finance Modelling edited ... Now move from the superior banker consultant to GAFAM -- this stands for Google, Apple, Facebo…
    ...
    Now move from the superior banker consultant to GAFAM -- this stands for Google, Apple, Facebook, Amazon and Microsoft. These giant companies provide a whole lot that seems to be free. Google provides search engines, youtube, gmail etc. Facebook seems to give away whatsup and social network things. Microsoft now gives away Power BI, Linkedin and a lot in Skype. Of course these companies are not really giving away much at all. They are getting data and getting paid from big companies. Amazon does charge money, but it keeps competitors out of the market by paying its people low salaries and attaining high volumes. I say this because I am sick of hearing that I am giving too much away; that I am a charity organisation; that I am canabalising products; that people want to pay higher prices for in-person and on-line courses because they think they are getting a better product; and, that people will pay a whole lot for basic courses that have nothing very special. With the exception of Apple, GAFAM do not seem to be founded on these these silly ideas of people being fooled by higher prices; that you can easily sell training without new ideas; cannibalisim etc.
    Of course I have not made my website just for charity. I hope you will consider various different ways to help me out so I continue this work. If you are a student or you work at a company that refuses any training, you can still send me information about different business options. This page describes five products that I offer that are associated with this website -- and how I hope to get paid for my favours. I of course know virtually nobody will even visit this page of the website and instead collect free files and programming approaches. Like other websites I am hoping that a tiny fraction of most of you who are just looking for free stuff will consider some things that could be much more helpful than just downloading files or watching free videos.
    ...
    in-person class. One example of this is whenWhen I taught
    ...
    investment company wherea year ago, each of
    ...
    with on-line videos.videos and the in-company course was far more effective. Therefore, I
    ...
    tricky modelling issues.issues
    {skype.jpg}
    .
    I and
    ...
    consulting project.
    Third, I have learned that in many places watching a video can be a real pain if the internet is slow. That is why I am offering the complete set of videos on a pin drive for a price that is little more than the cost of the pin drive and postage. If you send me your address in an e-mail I will send a high capacity pin drive with a set of the videos.
    Fourth, I have begun to structure videos and files on some subjects as a set of on-line courses. I understand that many others provide on-line on fundamental financial modelling issues. I hope you agree that many of my courses on things like battery analysis, merchant price comparison, flaws in the value driver formula, computing stable capital expenditures, advanced depreciation analysis and others are unique. If you complete the courses you may think you will not receive appropriate credit. I will give you a certificate and your name will go on a special page of the website. While I have not completed the structure for all of the on-line courses as yet, I am in the process of completing a full set. Of course I am extremely interested in how you think I should structure this activity.
    ...
    My main activity is teaching classes around the world. The ideas I have developed from working with different participants over the years are the real basis for this website. I believe and hope that the courses are fun and interesting and highly interactive, whether they involve modelling, energy analysis or theory.
    Courses Associated with Universities
    ...
    attend these. One person told meI understand that some
    ...
    money, you don't get a refund.still pay it as part of your tuition. I also
    ...
    different perspective aboutthan is typically offered and I can teach you something unique. My problem
    ...
    your professors. If you know of how to get into contact with business clubs or professors, it would be a great help.
    Professional Development Courses
    ...
    current course offerings.offerings and, indeed many of the files and videos on this website. I also
    ...
    nice profit.
    Unique aspects of coures that you will not find elsewhere
    - Understanding the structuring of contracts in project finance through analysis of risks and returns to alternative parties rather than typical back-to-back analysis.
    - Detailed analysis of project finance terms that can lead to competitive bidding including loan tenor, re-financing, letters of credit in lieu of DSRA, use of development fees, equity bridge loans and other factors.
    - Evaluation of alternative methods for computing terminal value from evaluating stable capital expenditures, working capital changes, deferred taxes and ROIC.
    - Understanding flaws in the value driver formula EV = NOPAT x (1-g/ROIC)/(WACC-g) arising from inflation and changing growth problems and how to resolve the problems.
    - Evaluation of risks in credit and equity analysis from review of ROIC and EBITDA in context of surplus capacity, capital intensity, short-run versus long-run marginal cost, demand volatility, obsolescence and changes in consumer tastes.
    - Analysis of the underlying meaning and philosophy of key credit and valuation ratios including DSCR, PLCR, LLCR, ROIC, Project IRR, Debt/EBITDA and others.
    - Quantification of the costs and benefits of M&A transactions using alternative techniques including analysis synergies and premiums, computation of equity IRR, analysis of accretion and dilution in EPS and DCF component valuation.

    2. Skype Calls
    Here are the steps:
    (view changes)
    6:26 pm

More