Financial modelling excel courses

... are estimated and how decisions based on property models are actually made. The exceptional and consistent delegate feedback we regularly receive has ensured that the world’s largest property companies run the Analyst course year after year... Learn about: Real Estate, Date series, Cash Flow...

... on application of recent models to price convertibles based on Monte Carlo techniques. Exercises and pricing models are implemented using Excel functions and macros and participants will be able to take away all worked examples. This course is also available remotely via LFS Live... Learn about: Sensitivity Analysis, Cocos Bond, MS Excel...

.... Participants will then complete a merger model by modelling and valuing synergies and assessing the benefits of each of the different financing options available. There will be an emphasis on sourcing historic data, estimating key forecast ratios and forecasting integrated income statements, balance sheets... Learn about: Financing Matrix, Sensitivity Analysis, Share Transactions...

...Learn more about one of the most popular sectors of financial services. This training course aims to equip delegates with an advanced and integrated understanding of the financial industry. Suitable for: Analysts, Associates, Executives, Managers. This course helps participants get on the front... Learn about: Corporate Financing, Financial Training, Corporate Finance...

... or finance is sufficient as all relevant financial concepts are covered in class. With the introduction of Argus Enterprise, there have been substantial changes from Argus DCF. Even if you’re an experienced user of DCF, you will benefit from this class... Learn about: Real Estate, Comparing Value, Cash Flow...

... Stock selection and asset allocation - Brinson Fachler and Brinson Beebower Hood models Why forwards can drastically change an attribution analysis... Learn about: Microsoft Excel, Asset Allocation, Money Markets...

... an understanding of the options in sourcing finance and role and importance of effective financial planning and the maintenance of records to ensure the success of an enterprise... Learn about: Business model, Enterprise Sustainability, Financial Training...

.... On the course, and as a key learning tool, participants work in Excel with real project finance models. The course is conducted in a work shop format, with the emphasis... Learn about: Financial Planning, Business Finance, Accounting and Finance...

...Real Estate Financial Modelling School is an intensive week meticulously designed to teach the best practices to create flexible and robust cash flows in Excel. This school combines three of our courses: Real Estate Analyst Real Estate Investor Real Estate Modelling Masterclass... Learn about: Real Estate, Cash Flow, Real Estate Investor...

... techniques are practiced through Excel with add ins developed specifically for these applications. All math and statistical concepts are taught through practical applications in Excel, thus avoiding complex theoretical notations and formulas... Learn about: Financial Institutions, IT risk, Capital Risk...

... operating income. We will teach you how to value and evaluate investments in properties and analyze the results. On the third and fourth day, you will know how to model and analyze development projects using cash flow and residual methods. It will show you how to interpret and compare alternative... Learn about: Retail & leisure, Financial Modelling, Structure calculations...

... problems and review solutions for issues such as building illiquid volatility surfaces, hedging tail events and dealing with more exotic products. Workshops make extensive use of Excel models to illustrate real life situations. All the relevant quantitative techniques are discussed; however complex maths... Learn about: Stochastic Vol, Quant analysts, Options Trading...

... insight into the financial health of any company. It will also provide the financial modelling know-how to help you build your skills as an Analyst. Last, but not least, the skills learnt on this course will equip you to negotiate any corporate finance transaction from a position of strength... Learn about: Investment Banking, Financial Planning, Corporate Valuation...

... structures - Barriers - Lock In - Cliquet - Lookback Hi Score - Power - Twin Twin Auto cancellable options Equity Default Swaps Workshop (Excel): Design... Learn about: Gap risk, Risk Management, Hybrid products...

...Learn how to visualise your real estate investment model in Excel. Visualisations help your proposal stand out, but did you know they can also help you find insights otherwise obscured by sheets of data. This unique course will show you how to effectively communicate Real Estate return metrics... Learn about: Cash Flow, MS Excel, Deal Auditors...

... are well understood, derivatives will have no more secrets. The content covered in this programme applies to options traded in equity, currency, commodity and rates markets. Exercises are implemented using Excel VBA, which participants can take away... Learn about: Vega matrix, IT risk, Market skew...

... catalog. You can explore and use the many products available to help understand consumers and watersheds. You will see various construction designs and operation strategies. You will be presented with the financial modeling of retail property assets and you will understand about sustainability regulations... Learn about: Industry Advocacy, Anchor Tenants, Case Studies...

... and additional exercises and models implemented using Excel functions and macros. Ask for more information through Emagister's website and an assessor will get in touch with... Learn about: OIS discounting, IT risk, Credit Risk...

... the quantitative analysis of any retail portfolio. The course can be done on its own and, like in all our courses of financial models, is based on Excel and the data is guided from the beginning. This course will benefit many people such as: real estate professionals who want to update their knowledge... Learn about: MS Excel, Shopping Centre Design, Retail Quilts...

...Focusing on the most topical issues, this course will teach you all the techniques available and how to apply them in practice, using Excel... Learn about: Capital Budgeting, Banking Investment, Financial Modelling...