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 I've got here is just a very nicely formatted

Â

version of the decision tree that we just created.

Â

I like to do this just to help ensure that we don't make any mistakes.

Â

So, I actually literally highlight all my input cells with this, sickly pink color.

Â

So that's going to be cash.

Â

We have to put into a project, or we'll get out of a project.

Â

Or, it's going to be a probability, at an event node,

Â

a set of probabilities, always adding up to one and

Â

in blue I have a solution quantity is the software

Â

gives us the expected value of the project.

Â

Assuming we take the decisions that It recommends through through the project,

Â

which which here one means take this branch try for

Â

zoning variants two means take this branch develop the property.

Â

So, if we pursued this project over and over and

Â

over again in the exact the same way in the long run on average

Â

if we make these recommended decisions, we'll come up with 9,000,

Â

also the program gives us the terminal value

Â

cash at the end point of each branch, okay.

Â

But, what we have to compute manually

Â

is what's the probability of getting to that branch, okay?

Â

So the things to remember with that probability of getting to that branch

Â

once again are that if we've got a decision it tells

Â

us don't follow that branch the probability is zero, okay.

Â

If we've got a live branch, okay,

Â

that arises from a recommended decision, how do we get this probability again.

Â

We got 56% is equal to our 80% here times our 70% here and

Â

that's because we can multiply

Â

like that because the probabilities are independent across stages.

Â

And then, down here if we take the sum of the probabilities.

Â

Where better get to a hundred and our expected value is the sum product

Â

of what's in this column with what's on this column as we discuss.

Â

Okay, so I'm going to keep moving on here and

Â

think a little bit now about what the decision tree is telling us, okay.

Â

So, as I said,

Â

at every branch it's telling us at the end on the right hand side.

Â

The net cash we would wind up with by pursuing this

Â

project if we get to that node, okay.

Â

So for example, if we try for

Â

the variants and it gets rejected, we're out 40,000.

Â

Cohesive costs us 40,000.

Â

Now, I'm using thousands units.

Â

Requests us 40,000 thousands of dollars to make that happen.

Â

So that's our terminal cash here.

Â

In this case we get our 60,000 from -40,000,

Â

-200,000 plus 300,000

Â

that gives us our net 60,000.

Â

So, it tells us that It tells us the decisions that

Â

we should make to maximize the expected value of that treaty, okay.

Â

And assuming that we make those decisions it

Â

also tells us, as I just showed,

Â

the probability of ending at any particular branch.

Â

And I've gone over how to compute, for example,

Â

things like our probability of getting 60,000, is 56%.

Â

But let's just jump back up the there and look at that.

Â

What that means is the probability of no crash given approval.

Â

Okay, and we got 56% that's the terminal

Â

node where we got a net of 60,000 and

Â

how'd we get that 56 56% probability of winding up there,

Â

are 80% times, or 70%, okay.

Â

And it gives us, of course,

Â

the expected value of the project, as I said,

Â

which is both computed by the program and

Â

checked by us using some product over here.

Â

Okay, so here's a little bit more on just to remind us all,

Â

make sure we don't make a mistake, how to compute our terminal path probabilities.

Â

So, first thing we want to do is exclude any branches

Â

where the program telling us don't take a decision that leads you to that branch.

Â

So we set their probabilities to 0,

Â

and then we just compute the combined probabilities at every branch.

Â

So again, that probability of getting to our $60,000

Â

terminal cash was the probability of no cash,

Â

given a approval because of our independence of

Â

probabilities across events.

Â

That's the same thing as the probability of no crash and approval and

Â

that of course means that we just multiple the probabilities and we get to 56%.

Â

Also I always wanted to check that all of our probabilities when we had them

Â

up get to 100%, okay?

Â

And then to compute the expected value probability, you never ever want to

Â

just believe this software, we want to compute it ourselves over here.

Â

Up here, and the way to do that is

Â

to take this terminal cash times this probability,

Â

plus this terminal cash times this probability, plus this terminal cash times

Â

this probability, plus this terminal cash times this probability,

Â

plus this terminal cash times this probability which in Excel,

Â

is done with the sum product function, that I've showed you.

Â

And, which in algebraic terms,just looks like this summation, okay.

Â

It's really a dot product summation.

Â

For the less mathematically inclined, among us

Â

Explore our Catalog

Join for free and get personalized recommendations, updates and offers.