A Structured Approach to Financial Modelling Valuations.

Asset Classes and Valuation Models

• Learn how to use Excel the way Financial Market Practitioners use Excel in the real world of Financial Markets and Finance.
• This course has Degree quality content and resources.
• This is a course for anyone looking to enter the world of Financial Markets and Cryptocurrencies or a person that wants a very detailed course in Finance.
• It gives your real work skills on how to use Excel within Financial markets – what you need to know now.
• Learn how to apply and build different valuation models for different Asset Classes.
• In this course we go through High Finance Math to teach you how to set up spreadsheets and what goes into a professional valuation for Financial Assets.
• We go through valuation models for the following asset classes: Equities, Debt, Foreign Exchange, Property, Business and Cryptocurrencies (BTC, ETH & XRP etc).
• We go through what valuation models are appropriate and why.
• We teach you Excel skills such as how to set up the following: ( Note: all models are explained)
  • Discounted Cash Flow model
  • How to calculate Terminal Value
  • How to calculate a Cash Flow into infinity
  • How to calculate a Bond
  • How to calculate fair value for Interest rates using Regression
  • How to calculate fair value for Interest rates using Monte Carlo Simulation Model
  • How to calculate fair value for Foreign Exchange rates  using Regression
  • How to calculate fair value for Foreign Exchange rates using Monte Carlo Simulation Model
  • How to Interpolate Interest rates
  • How to calculate missing interest rates
  • What interest rates to use for proper valuations ( there are many type of interest rates)
  • Calculate the Internal rate of return
  • How to do VLook up tables in Excel
  • How to do HLook up tables in Excel
  • With Excel you can increase your efficiency for the speed of preparing advance data analysis
  • Learn how to create Excel filters, replace complicated IF statements, MIN, MAX, CORREL, Data analytical tools such as SOLVER, SUMPRODUCT, Financial Math, ARRAYS, VB Script, and Charts.
  • How to run IF statements
  • How to calculate Financial ratios for Shares and what they mean
  • Financial ratio calculations
  • Statistical calculations and analysis
  • All the important things to get you up to speed in Excel- how to run macros, statistics, Lookups, formulaes, calculations and lots more.
  • Also we explain all formulas and calculations and explain what they mean
  • How to run a Zero curve and decide whether Fixed Interest is expensive or cheap
  • How to run Macros
  • How to create a Zero Curve excel spreadsheet
  • How to build relative value spreadsheet for bonds
• Calculate the value of XRP Crypto Asset using two valuation models
• Looking at the pros & cons of at least 12 different valuation models in different Asset Classes
• Which input, factors and components are important for valuation
• What Valuation models are to be used for specific assets and why
• Practical exercises
• Quizzes
• Resources
• Questions and Answers
• Excel spreadsheets made available
• Excel formulae included

********************************************************************************************************

ALL EXPLAINED IN GREAT DETAIL

**********************************************************************************************************

PLUS THERE ARE PLENTY OF:  1.QUIZZES  2.EXERCISES  3. ASSIGNMENTS  and 4. EXCEL MODELLING – WHICH WE GRADE YOU AND GIVE IMPORTANT FEED BACK FOR YOUR NEXT WORK ASSIGNMENT.

**********************************************************************************************************

IF YOU WANT THAT HIGH PAYING FINANCE JOB THEN THIS COURSE IS A MUST:

• It gets you up the learning curve fast against 1000’s of other people going for the job
• Practical experience from Market Practitioners – we have between us over 70 years experience in FINANCIAL MARKETS INCLUDING CRYPTOCURRENCIES – ( front office, middle office and back office experience).

YOU NEED THIS COURSE TO GET AHEAD OF THE COMPETITION

• BE MORE COMPETITIVE THAN OTHERS GOING FOR THAT FINANCIAL POSITION INTERVIEW
• KNOW HOW TO VALUE FINANCIAL ASSETS
• VALUATIONS ARE ESSENTIAL IN FINANCE NO MATTER WHAT JOB YOU HAVE
• EXCEL IS ESSENTIAL IN THE WORK PLACE AND FOR PERSONAL USE
• ADVANCE YOUR CAREER AND KNOWLEDGE
• COMPETITION IS EVERY WHERE AND IT IS GLOBAL
• BE AHEAD OF THE CURVE
• KNOW YOUR STUFF
• KNOWLEDGE IS POWER
• GAIN A COMPETITIVE ADVANTAGE OVER YOUR PEERS

**********************************************************************************************************

OR IF YOU JUST WANT TO KNOW ABOUT FINANCE THIS COURSE IS A MUST

THE COMPETITION IS GLOBAL FOR HIGH EMPLOYMENT OPPORTUNITIES IN FINANCE

THIS COURSE IS A MUST – YOU NEED THIS COURSE

” GET A HEAD OF THE GAME WITH A COMPETITIVE ADVANTAGE”

THIS IS A VERY IN-DEPTH DETAILED COURSE ON UDEMY FOR THIS SUBJECT

**********************************************************************************************************