Excel
Demo http://www.youtube.com/watch?v=32qsDgfstTk
Multiple PV Multiple CF
Example http://www.youtube.com/watch?v=em9dJ0H-jMA
Excel Functions http://www.youtube.com/watch?v=hHNsmWij2ZI&feature=youtu.be
FV Schedule
function https://youtu.be/mqAMoIHtj3I
Expected Return and
Variance in Excel https://www.youtube.com/watch?v=76lzVhLHp2M
Computing Beta in
Excel https://www.youtube.com/watch?v=td8COGk5ifc
Multiple Regression and
Analysis https://www.youtube.com/watch?v=XGK9KjXXDb0
Bond Valuation – Price
Function in Excel https://youtu.be/I3r_jtgz-qQ
Tbill
Calculations in Excel https://youtu.be/nuqVPiskd2Q
XNPV and XIRR Functions
in Excel https://youtu.be/oyicBRpF8YI
SumProduct
Function https://youtu.be/M01upuDfs8s
NPV and IRR in
Excel https://youtu.be/JK61WVNRJn8
Portfolio Risk and
Return in Excel https://youtu.be/vaNlzkxg1Ao
Minimum Variance
Portfolio in Excel https://youtu.be/63kUk-DpC6c
Using Solver to Find
Minimum Variance Portfolio in Excel https://youtu.be/5eIr46SBAI4
Maximizing Sharpe Ratio
Using Solver in Excel https://youtu.be/dqWTIQgbQkU
Portfolio Optimization
in Excel https://youtu.be/hHw58796fRY
Two Approaches for
Computing Portfolio Variance in Excel https://youtu.be/VTfbkwFJdY4
Covariance and
Correlation in Excel https://youtu.be/KBEmOMqKxPM
Constructing a Variance/Covariance
Matrix in Excel https://youtu.be/iZHcNvQ0gJI
Ipmt
and Ppmt Functions in Excel https://youtu.be/dmdaKEJgnhY
Creating a Stock
Portfolio in Excel https://youtu.be/4IIf8q7SOEk
Historical Stock Prices
in Excel 365 https://youtu.be/1T2AZGZfL-o
Historical Exchange
Rate Data in Excel https://youtu.be/y0By3DmdwB4
Forecasting in
Excel https://youtu.be/XEVrHVBiuD0
Importing Data from the
Web into Excel https://youtu.be/u4bN4z9aDTo
Getting Currency Quotes
in Excel 365 https://youtu.be/hq_IzGBCh2Q
Computing Value at Risk
in Excel https://youtu.be/Zsa2Z5mKhxE
Computing Alpha and
Beta in Excel https://youtu.be/0Tb6LG8eg44
Fama
French Three Factor Model https://youtu.be/wQ1InWtnRS8
Monte Carlo Simulation
– Retirement Savings https://youtu.be/RV1Y3bHDPdk
Monte Carlo Simulation –
Capital Budgeting https://youtu.be/7ZXMbTsdads
Monte Carlo Simulation
– Value at Risk https://youtu.be/aPh3mZSe56Q
Put and Call Payoffs in
Excel https://youtu.be/FQqu9ldVZNM
Call Bull Spread Payoff
in Excel https://youtu.be/XQswLDCHpSs
Put Bear Spread Payoff
in Excel https://youtu.be/Y4t9jw8a1kQ
Straddle Payoff in
Excel https://youtu.be/hvXnzw6v6ZA
Strip and Strap Payoff
in Excel https://youtu.be/yVh6lXeburA
Butterfly Spread Payoff
in Excel https://youtu.be/NyqJpXjVmjc
Long Stock vs Call
Option Payoff in Excel https://youtu.be/Ibd0FaNKdM8
Short Sale vs Put
Option Payoff in Excel https://youtu.be/Zydkjw1LRSA
Synthetic Call Payoff
in Excel https://youtu.be/Y-uso1lE0Bg
Synthetic Put Payoff in
Excel https://youtu.be/32xEMoBbggo
Visualizing Utility in
Excel https://youtu.be/lO_Jqk_Ty3Y
Depreciation in
Excel https://youtu.be/ZoVpFKBtDPg
Return
to top of page
|