Excel Formulas a quick list
Jaimi Dowdell, IRE
Heres a brief cheat sheet for some of the formulas youll use often in Microsoft Excel. Use this
spreadsheet below to refer to for examples and remember: If in
In this module, we are going to introduce you to the forward contract and also
how to use the no arbitrage principal to price forward contracts.
A forward contract gives the buyer the right and also the obligation to purchase
In this module, we're going to introduce you to interest rates, present values,
and how present values are implied by the no arbitrage principles, and also,
introduce you to the idea of fixed income instruments.
An amount A, inv
00:00:00,000 -> 00:00:00,520
00:00:00,520 -> 00:00:03,130
So in our two examples, we've seen cases
00:00:03,130 -> 00:00:05,860
where companies wanted to reduce the amount of complexity
00:00:05,860 -> 00:00:07,976
by usually reducing the number o
In this module, we are going to introduce you to the floating rate bonds, how to
use the new arbitrage principle, to price floating rate bonds, and also to the
term structure of interest rates.
In this module, we are going to pr
OK, what were the key points from this lesson?
Well, after recapping the earlier courses,
we introduced the concept of how reality
can impact supply chains.
And we'll spend the rest of this course fleshing
this idea out further.
But then we also introduce
In this module, we're going to give you a brief overview of the entire course of Financial
Engineering and Risk Management. We'll introduce the ideas of financial markets, financial
products, what do financial markets and financial products do for yo
00:00:00,000 -> 00:00:00,630
00:00:00,630 -> 00:00:02,400
In practice, things are not always
00:00:02,400 -> 00:00:05,096
as simple or straightforward as we'd like them to be.
00:00:05,096 -> 00:00:07,470
The insights from all the models we've lea
00:00:00,000 -> 00:00:00,499
00:00:00,499 -> 00:00:03,640
So what drives complexity in supply chains?
00:00:03,640 -> 00:00:06,480
Well, we can identify five big drivers of complexity
00:00:06,480 -> 00:00:09,300
for any system, not just supply ch
00:00:00,000 -> 00:00:00,640
00:00:00,640 -> 00:00:01,140
00:00:01,140 -> 00:00:02,590
Let's look at another example.
00:00:02,590 -> 00:00:04,670
This one will come from Hewlett-Packard.
00:00:04,670 -> 00:00:09,440
So this comes from an ex