A Structured Approach to Financial Valuation Modelling
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Valuation Models for all main asset classes (including Cryptocurrency)Description
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
**********************************************************************************************************
Requirements
- Requirements
- Microsoft Excel 10. and a willingness to learn - I will teach you as much as you want to learn.
- There is just so much in this course. Such great value and totally practical for the working environment. YOU NEED THIS COURSE TO GET YOU AHEAD OF THE GAME.
Esoteric Trading Solutions
4.5 Raiting
Financial Modeling and Valuation: Complete Beginner to Pro
- 3.7
-
![]()
![]()
![]()
![]()
![]()
The Most Comprehensive Step-by-Step Guide to Creating Financial Models from Scratch - From Complete Beginner to Pro Here’s What You Get in This Course:...
Advanced Financial Modeling and Valuation
- 3.8
-
![]()
![]()
![]()
![]()
![]()
Learn how to build your first financial models in Excel from scratch. In this course, you will learn 1. Introduction 2....
CFA Corporate Finance Level 2
- 3.7
-
![]()
![]()
![]()
![]()
![]()
Learn CFA Corporate Finance Level 2 Syllabus with more illustrations and case studies Welcome to Corporate Finance CFA Level 2 Course....
A Structured Approach to Financial Valuation Modelling
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Valuation Models for all main asset classes (including Cryptocurrency) Learn how to use Excel the way Financial Market Practitioners use Excel in the real world of Financial Markets and Finance....
