Consultant and Workshop Leader
BioProf. Bodmer provides courses in Financial Modelling, Project Finance, Corporate Finance and Valuation, Mergers & Acquisitions, Renewable Energy, Independent Power and Electricity Pricing.He has been involved in formulating government policy related to electricity deregulation; he has prepared models and analyses for many clients around the world.Author of 'Corporate and Project Finance Modeling, Theory and Practice' (Wiley Finance)He was also a professor at the University of Texas.
TagsWebsite
Prof. Ed Bodmer's Channel: methods and tools
Commodity Price Risk and Monte Carlo Simulation - Project Finance Excel Model
A commodity price risk model with Monte Carlo simulation within a project finance excel model.263 remove_red_eyeDiscussfreeTax Equity Analysis Excel Model for U.S. Renewable Energy Projects
Excel model for renewable energy projects with analysis of tax equity.240 remove_red_eyeDiscussfreeIllustration of different valuation and merger techniques
Detailed excel model analysing the details of the Cadbury/Kraft merger219 remove_red_eyeDiscussfreeScenario Analysis - Using Macros
Excel Files to show you how to do Scenario Analysis using Macros.296 remove_red_eyeDiscussfreeAmazon's Corporate Excel Model
This Excel model is an efficient tool for practicing A-Z modelling.56 remove_red_eyeDiscussfreeHow to combine two standalone excel models to create a Merger Model
Video and 2 Excel files that help you know how to combine two models and create a merger model.125 remove_red_eyeDiscussfreeHow to Create a Country Economic Database from FRED
This is an effective file for constructing an economic database of countries' statistics.32 remove_red_eyeDiscussfreeHow to Conduct a Retail Rate Analysis of Batteries and Solar
This is an efficient tool for performing an evaluation of the market structure of electricity and battery prices.60 remove_red_eyeDiscussfreeHow to Create a Database of Stock Prices, Commodity Prices, Stock Price Indices and Economic Data.
This tool helps the user to create a database of stock and economic metrics, accompanied by a step-by-step method.New!DiscussfreeOff Shore Wind Project Finance Excel Model
Detailed excel model for tracking and projecting the finances of your off shore wind investments.729 remove_red_eyeDiscussfreeHydro Excel Model - with Commodity Price Risk and Monte Carlo Simulation
Financial model for hydro investments including commodity price risk and monte carlo simulation412 remove_red_eyeDiscussfreeSaudi Cement Financial Model
This model shows that you can make a reasonable simple model from the data in TAWDAL508 remove_red_eyeDiscussfreeMultiple Currency Analysis and Development Analysis in Solar Plant Excel Model
Excel model for multiple currency and development analysis of your solar plant projects159 remove_red_eyeDiscussfreeQuarterly Leveraged Buyout LBO Model
An LBO model illustrating a number of detailed analytical techniques to construct an acquisition LBO model with history886 remove_red_eyeDiscussfreeMongolia Mining Case Model
A Credit Analysis Model with Variation from Commodity Prices and Evaluation of Downside Case Variables533 remove_red_eyeDiscussfreeTollway Project Finance Excel Model
Toll roads generate revenue on a user-pay system - this model will help you plan the finances of your tollway projects126 remove_red_eyeDiscussfreeSolar Rooftop Excel Model
Detailed an in-depth model for tracking your solar rooftop finances465 remove_red_eyeDiscussfreeM&A Analysis Bank Excel Model
Detailed excel financial model for mergers and acquisitions.463 remove_red_eyeDiscussfreeFinancial Model for Ports with Alternative Scenarios for Shipment Growth and Danger of Surplus Capacity
This is an incredibly detailed financial model for your port and shipping projects.130 remove_red_eyeDiscussfreeOn Shore Wind Excel Model
Detailed financial model for your on shore wind investments256 remove_red_eyeDiscussfreeRenewable Project Finance and Price Bidding Analysis Excel Models
This tool contains two excel files on renewable project finance and price bidding analysis.399 remove_red_eyeDiscussfreeSolar Annual Model
The file uses a simple project finance model to illustrate programming associate with a flip structure666 remove_red_eyeDiscussfreeSolar Project Finance Model
Understand the effects of financing costs on the required price of a solar project finance model.795 remove_red_eye3 chat_bubblefreeBridge between Equity value and Enterprise value - Illustration Model
This Excel model illustrates bridge between equity value and enterprise value.160 remove_red_eyeDiscussfreeHow to use history in making an acquisition analysis
An extensive excel tool for acquisition analysis, and how to use history when making an acquisition analysis.69 remove_red_eyeDiscussfreeHotel Project Finance Model
Extensive financial model for your hotel projects and investments.598 remove_red_eyeDiscussfreeReal Estate Excel Model
Comprehensive excel model for tracking and projecting the finances of your real estate investments.422 remove_red_eyeDiscussfreeLBO Excel Model - with Capital Structure Analysis
Advanced financial model for Leveraged Buyout with analysis of the capital structure.145 remove_red_eyeDiscussfreeIndependent Power Producer (IPP) Excel Model
Extensive and detailed Excel Model for Independent Power Producers474 remove_red_eyeDiscussfreeCredit Analysis Excel Model of Project Finance with Methane/Diesel Plant
How to use a model for evaluating credit analysis within project finance.156 remove_red_eyeDiscussfreeFinancial Model Structuring and Formatting Assistant
This excel workbook includes different macros and shortcuts.180 remove_red_eyeDiscussfreeShip Project Finance Model of Dry Dock Days and Margins
An example of a ship project finance model of dry dock days and margins.119 remove_red_eyeDiscussfreeMerger Model - Consolidation of Two Companies
Financial Model for a business merger focussing on the consolidation of two companies.216 remove_red_eyeDiscussfreeScenario Analysis - Adding Master Scenario Page to Any Model
9 Excel files that show you how to ad a master scenario page to any model.126 remove_red_eyeDiscussfreeMerger analysis of an Acquisition of Retail Shops
3 Excel files to demonstrate the merger analysis of an acquisition of retail shops.116 remove_red_eyeDiscussfreeBridge from Enterprise Value to Equity Value Excel Model
Excel file to demonstrate the bridge from enterprise value to equity value.78 remove_red_eyeDiscussfreeHow to Resolve Circular References in Project Finance Models
This innovative model provides a resolution for circular referencing.42 remove_red_eyeDiscussfreeFailed Tribune LBO - Financial Excel Model
A comprehensive, detailed example of a failed LBO model.42 remove_red_eyeDiscussfreeHow to use Read PDF
This is a tool that will help to use Excel files with macros that allow you to convert files from PDF to Excel.25 remove_red_eyeDiscussfreeHow to Use the Scenario Reporter
This effective scenario reporter is accompanied by a clear and easy-to-follow PDF guide and YouTube Tutorial.17 remove_red_eyeDiscussfreeHow to Compile a Comprehensive Financial Database
These models and accompanying PDF and YouTube guides are exhaustive tools for downloading a comprehensive database.New!DiscussfreeHow to use an Interest Rate Database
This is an Interest Rate Database with accompanying resources and a detailed guide to help you analyse interest rates.New!DiscussfreeHow to use and implement the Interpolate-Lookup function
This is a detailed guide on how to use and implement the Interpolate-Lookup function.13 remove_red_eyeDiscussfree
Eloquens Member
I am a principal in its registered investment advisory in Durham North Carolina. Over the last 20 years, it has become evident to me through working with certain clients that I have intuitive abilities and finance. Recently I obtained a Master’s in Finance from Northeastern University in Boston. I’m currently in the process of shifting my career towards real estate analysis which will probably involve commercial real estate sales. Of a recently developed relationship, I am focusing on the hospitality/hotel lodging industry. This will also involve credit financing as well as reselling loan notes and mortgages. Ultimately, I anticipate raising capital for a hospitality property fund.
Currently, I am spending around 30 hours a week studying hotel finance and the hospitality industry. This is in addition to my responsibilities in my financial advising partnership; to be completely candid, after 30 years these duties and responsibilities have become rather mundane and boring.
Because I am truly committed to this professional transition, I am willing to pay for coaching. Compared to other professionals that I have viewed online, you appear to have the knowledge, skills, and experience that I am looking for.
Are you open to exploring this further?
The easiest contact information for me is:
Cell: 919-302-2649
Email: Rick.adams@adamschetwood.com
Thanks
Rick