Assistance+Page+for+Corporate+Modelling+and+Project+Finance+Modelling

When I was a banker many years ago, one of the few seminars on general banking that made an impression on me was from a consultant who described the traits of a good banker. The consultant was apparently paid a lot of money to follow around people who had been defined as superior bankers by their management. The consultant found that these really top bankers did a few common things. I recall two of the traits. First, the superior bankers made those little task lists and followed them up, so what. Second, the bankers did favours for their clients. Then, after they did the favor, they did something more important. They collected on those favours. In this page, I am asking to get re-paid for some of the favours I may have done for you (maybe not). I am not necessarily asking for money -- information on how business clubs work at your university or how you HR department works is also very important to me.

Now move from the superior banker consultant story 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 whatsapp 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 from you and then using the data to get 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 that will be good for both of us. 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 is very valuable to me. This page describes five products that I offer that are associated with this website -- and how I hope to get paid for my favours through providing something of value to you. 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.



**First**, I know for an absolute 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 by their boss 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. I and my clients who have tried this skype thing have found these surprisingly useful in different ways. In working on skype where we share screens I can prepare some of the modelling myself and then discuss the results on skype or we can look at your model and try to fix things like circular references. I can tell you that having a skype call where we share the screen and work through files is scads better than an old fashion 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 other companies provide on-line on fundamental financial modelling issues and give you a certificate. I doubt that having some kind of general certificate is very valuable to you anymore. My product for on-line courses is different. If you say you have a certificate in economic analysis of batteries, you will be different. I hope you agree that many of my courses on things like merchant price comparison, flaws in the value driver formula, computing stable capital expenditures, advanced depreciation analysis, downloading stock prices from the internet and others are unique and advanced. If you take the time to watch some of my videos you deserve a lot of credit. I am worried and I lose sleep thinking about you watching videos and not receiving appropriate credit for this time you take (when you could watch a video about political stuff or psychology for example). My product proposal is to give you a certificate for your work watching videos 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. Please send me an e-mail with your suggestions. I am really interested.

**Fifth**, I am in the process of attempting to market services to your boss and/or your boss' boss. As I explained above, 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 have to complete some simple questions. Depending on how much work you do I will send the results to somebody senior at your company. For this product I will also make customised videos and courses depending on the preferences of your institution. See how GAFAM works -- I really want to get paid by some big company rather than by you as an individual. 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.

= Products that are a Real Bargain = = = = 1. Courses at Universities and for Professionals =

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 **

I understand that universities now encourage practical courses and even pay students to attend these. I understand that some universities include a provision for you to sign up for practical courses and if you don't use the money, you still pay it as part of your tuition. I also understand that universities will sometimes your classes invite guest lecturers. I am extremely interested in coming to universities or working for business and investment clubs at your universities. I think I can give you a different perspective than is typically offered and I can teach you something unique. My problem is that I need your help. in finding you business clubs and meeting 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 **

I know that you have thousands of options for professional development courses these days. Over the past 20 years I have taught professional development classes that form the basis for my current course offerings and, indeed many of the files and videos on this website. I also realise how much the courses have to charge to cover their marketing costs, cover the costs of cancelled courses and make a nice profit.


 * Unique aspects of coures that you will not find elsewhere **

- Resolving circular references in corporate and project finance models with user-defined functions rather than copy and paste macros or the excel iteration button.

- Efficient programming of cash flow waterfalls in project finance and acquisition models that include cash flow sweeps, cash traps, potential for default and minimum cash balance accounts.

- Development of equations in project finance models that simulate different sculpting techniques along with complex elements of financing structures.

- Construction of financial models with complexities including multiple currencies, portfolios of assets, alternative financing structures and particular tax equity structures.

- Modelling complex operating analysis in corporate and project finance models that reflects risks of surplus capacity and political risk.

- Demonstration of how to use selected macros and functions in financial models for efficiently reading financial statements, interpolating data, reading from PDF files, formatting spread sheets and efficiently copying and repeating data

- Understanding of how to make elegant models with structured time lines, easy to understand flexible formulas, structured components that separate financing and operating components, and creative ways for auditing model mechanics.

- Reading from internet with VBA programs

- Efficiently reading financial statements using user-defined functions

- 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:

1. Send me an e-mail to edwardbodmer@gmail.com describing your problem or your request. 2. If you want or need a Non Disclosure Agreement signed, I have a simple NDA that you can sign with an on-line signature or you can send me yours. 3. I will let you know if I can solve the problem with you and we will schedule a Skype phone call. 4. To reserve a time, there is a charge of USD 100. If the problem is solved, the charge is USD 200 for the first hour of conversation on skype and USD 100 for subsequent hours. 5. To make a reservation, click on on the button below.

= 3. Pin Drive with Organised Videos =

If your internet is painfully slow I can send you a high capacity pin drive with a set of the videos. We have begun downloading many of the videos and if you are interested in a particular set or all of the videos, please send me an e-mail at edwardbodmer@gmail.com. I will then copy videos on to a pin drive and send the pin drive to you. Of course it may take a little while to get to you. To cover the cost of the pin drive and the cost of the postage I am charging USD 50 for this.

= 4. Certificate for Detailed On-Line Lessons =

Here is how this idea works. General certificates are not very valuable to you anymore. To differentiate yourself it would be better to have a certificate in something like reading stock prices from google finance to excel or computing carrying charges using different inflation rates, decommission costs and tax rates. When you put this on your CV or discuss this in an annual review people may not even know what you are talking about -- even better. To prove that you are really good at this I am making a separate page on my website. On this page I will put you name and I will test whether you can really do the complex stuff. I emphasise on the webpage that this is not some silly rubbish where I put up your name just because you pay me. Instead, I describe the kind of questions that you must answer and that you have to be serious about the subject.

I understand that you do not want to spend days on these completing questions after watching videos and then work with excel sheets (I know you are busy and have a life). With a few exceptions (like the rooftop video course) I will focus on a few videos, make sure you understand the concepts with excel work and verify this with some questions. Then you receive a certificate, a badge and most importantly recognition of your work on the this website.

So, here is the process:

1. You sign up for the course (a list of the courses is presented below)

2. You receive a package (pdf file) that explains the process and contains the questions

3. You watch the videos, download the excel files and look at the questions.

4. You send me answers to the questions and your excel work.

5. One of my associates or I review your work (manually) and check if you master the subject.

6. If your work is adequate, we send you a certificate, otherwise we ask you to try again.

7. After success, we put your name on the page associated with the subject in question.

= = = 5. Company-wide Verification of Videos and Work on Lessons =

I am in the process of attempting to market a business product. I think innovative companies you should give you credit for watching videos and trying to work through excel exercises. When you sign up for this service we will monitor how much work you have done in listening to videos and answering questions about the videos.

The results will be sent to somebody senior at your company. For this product I will also make customised videos and courses depending on the preferences of your institution. As with all of this stuff, I am very interested in your opinions on how structure the products.

5. To make a reservation, click on on the button below.
=Email: edwardbodmer@gmail.com = Skype: edward.bodmer YouTube Channel: @https://www.youtube.com/channel/UC2g_Ih-lK1sa3L_1xHacA8w

[[image:edbodmer/New Files.JPG width="142" height="153" link="edbodmer/New Files"]]
== 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.// ==