The final course of the specialization expands the knowledge of a construction project manager to include an understanding of economics and the mathematics of money, an essential component of every construction project. Topics covered include the time value of money, the definition and calculation of the types of interest rates, and the importance of Cash Flow Diagrams.

From the lesson

Financial Plans for Development Projects

Professor Anthony Webster provides an in-depth look at designing and building commercial real estate by looking at financial plans. The module ends with a deep dive into decision tree analysis.

Instructor, Department of Civil Engineering and Engineering Mechanics, Columbia University Director of Research and Founder, Global Leaders in Construction Management

Okay, so what do we need to be able to

Â

formulate an analysis and a decision tree form?

Â

At our decision nodes, as I said before,

Â

we're going to need mutually exclusive decisions.

Â

And at our Event Nodes okay.

Â

We're going to need mutually-exclusive scenarios,

Â

either we awarded the contract or not, that type of thing.

Â

We've got to consider all possible scenarios.

Â

And of course of who are considering all possible scenarios,

Â

the sum of the probabilities for

Â

each scenario has to add to a 100% or one, okay?

Â

And across our stages along the time.

Â

Access here, Time or Stage

Â

access here.

Â

The probability is need to be independent.

Â

So, let's see how that looks here.

Â

Okay with here is another in this.

Â

It's a different simple analysis here, but what I want to show you here is that for

Â

any decision tree as we move along the time or stage access,

Â

the probabilities need to be independent.

Â

So what that means in this case,

Â

we're looking in this case at whether or not, we should buy a high-yield bond.

Â

We've got a 73.5% chance that there's going to

Â

be a market crash while we own this bond and

Â

a 26.52% chance that,

Â

sorry that we have seven days 3.5% chance that we wont have a market crash.

Â

While were holding responding we have 26.5% crash left.

Â

Percent chance that might be a market crash.

Â

Then when we go on, in time, we're saying,

Â

if the market is okay, we have about a 79% chance that the company

Â

which issued the bond will default, but that means a 21% chance,

Â

roughly, that the company won't default.

Â

And so, what we mean here by probabilities

Â

independent Is that these are independent okay.

Â

Okay and what we mean by our scenario's

Â

being mutually exclusive on the Y-axis

Â

here is any time that we have an event known.

Â

Only mutually exclusive things can happen.

Â

Either the market is going to be okay, or it's going to crash.

Â

We're going to consider both, and the probabilities for

Â

all of them have to add up to 100%.

Â

Same thing here, either the company is showing the bond,

Â

is going to default, or they're not.

Â

Here's no default, and here's default.

Â

So, they have to be mutually exclusive scenarios and they have to of

Â

course we have to consider everything so the probabilities have to add up to 100%.

Â

Few more definitions we're going to need to know to make this happen okay.

Â

The project expected value we're going to call EVP.

Â

I've been throwing that around without defining it carefully.

Â

This is the expected value of the net cash flows

Â

when moving through the tree considering only each optimal choice,

Â

each recommended choice through the tree, okay.

Â

And what's an optimal choice at a branch node?

Â

That's going to be, as I said, the choice or

Â

the branch with the highest expected value for the project.

Â

[COUGH] Okay.

Â

So how do we go ahead and solve a decision tree problem?

Â

It's always good to, whenever you're doing any real world financial project,

Â

define a risk reward policy for this project.

Â

And I'll talk about that a little more later when we get into our example.

Â

Then you want to build, one way or another a futures table.

Â

I've got a certain way of doing it, but

Â

all it really is just thinking about what could happen during the project.

Â

What the probabilities are, what all the decisions are.

Â

Or that we have to make because that's what you're going to have to put in those

Â

input to your Decision Tree, okay.

Â

Then we're going to build a Decision Tree using

Â

that Futures Table data and then we're going to solve.

Â

For all of our unknowns and

Â

we're going to start doing this without consideration of time value.

Â

And that's the equivalent to in our Maddox

Â

of money and the chapter, my review chapter for you on this.

Â

That would be considering that opportunity costs of capital is equal to zero.

Â

That's the way it works out.

Â

That's the same way it's equivalent to and gives us the same answers.

Â

Just saying we're not considering time value.

Â

At all, okay.

Â

Next, we're going to go back, so we'll solve that whole thing with,

Â

we're going to solve Of this whole thing, without considering the time value.

Â

And then next, that's going to help us debug technically

Â

the decision tree, make sure everything.

Â

Works good while we're keeping it simple, right.

Â

And once we feel like it's debugged it's working well in that stuff we're going to

Â

go back and consider the tree with time power view,okay.And

Â

to do that what are we going to have Have to do, we have cash flows in the trees

Â

that are going to happen a year from now, two years from now.

Â

We're going to have to take the present value of all of those, and

Â

once we take the present value of all of our cash flows,

Â

discount them back to their equivalent at t equals 0 or right now,

Â

that's going to give us, instead of what we call the expected value of the project

Â

That's going to give us the expected net present value of the project,

Â

which is awesome, that's what we want in a time value world.

Â

And of course to do this,

Â

to discount back, we're going to need to know our opportunity cost of capital.

Â

Next we're going to apply our risk reward policy and typically

Â

that's going to have a target that we're shooting for and a downside limit.

Â

So we say we want to maximize the expected value of this project But

Â

we want to make sure that no matter what happens we don't loose more than $ 50

Â

million, that would be her downside criteria that type of thing so

Â

we apply both of those, and then we can make our decision.

Â

Do we want to go ahead with this yes or no?

Â

And then finally always good with something like this to consider

Â

the limitations of the model, the fancier we get with

Â

financial models the more simplifying assumptions we have to make and

Â

it's very important that we're aware of what those assumptions are.

Â

Because that tells us where the model may not apply,

Â

where we may not use this model or

Â

where if we're not careful, we may erroneously try to use this model.

Â

So we'll look at that too in the context of an example.Okay,

Â

and here again I have the last Instead of my self-serving,