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

So now we're ready to start thinking about incorporating time value

Â

into this analysis.

Â

We've done the whole thing without time value, it looks pretty good to me.

Â

In particular, we verified that the expected value of the project,

Â

that the software computes is the same thing that we compute manually.

Â

So that gives me a warm, fuzzy feelings.

Â

And we want to go on and improve this analysis by incorporating time value.

Â

So why do want to consider time value?

Â

Well the project goes over four years.

Â

As we say the rocc is high, I would say anything

Â

above zero is high and worth considering at 4%.

Â

And so time value, I think, is going to make a difference.

Â

And let's go through and check this out with

Â

time value and see about that, okay.

Â

So how do we want to handle time value?

Â

We need some simple way to compute all of our cash flows for

Â

this project for when a player considering time value.

Â

And there's actually a really simple way to make this happen, okay.

Â

Remember, as we learned in our review chapter and

Â

as you learned with Professor Dan, mathematics of money,

Â

to evaluate the cash flows of any project for

Â

one player when the cash flows are function of time.

Â

Step number one is we want to discount individually all of

Â

those cash flows back to a convenient time, usually t=0.

Â

Once we've got that, all our cash flows for

Â

the project now are on an apples to apples basis and

Â

we can combine them in any way we need to, to evaluate the project.

Â

So that's our next step is to add them up, add,

Â

subtract them, whatever we need to do to help evaluate the project.

Â

Compute NPVs, IRRs et cetera, et cetera.

Â

So that's all we're going to do with the decision tree.

Â

We take every cash flow for the project and get its equivalent at T equals 0 and

Â

then start putting those equivalent numbers into our decision tree.

Â

So if you're mathy and you want a mathematical formula for that,

Â

here is how to do this to get the expected value of the tree with time

Â

value considered, that makes it of course the expected value of the NPV

Â

of the project for one player who is the developer or the sponsor.

Â

Okay, so now with time value, we've got to first of all,

Â

individually get the present value of each cash flow.

Â

So the 40 million that put in to get the property variance,

Â

that happens at t equals 0, so that's going to remain, present value 40 million.

Â

The 60 million, we have to discount back by one year at 40%.

Â

And as you can see here, if I do that, I get 57.69.

Â

I do the same thing with the 200 million here.

Â

And I get 192 and etc, etc,

Â

with my 3 million, I have to discount this back two years.

Â

So I have 300 divided by 1.04 squared gives me 277 million and

Â

change, some more sort of the thing with my 150.

Â

Okay, so now I've got our futures table

Â

with all of our cash flows included here.

Â

And it looks exactly like it did before

Â

except now the numbers I have here

Â

are my equivalence at t equals 0.

Â

So I can add them up, I can subtract them etc,

Â

etc, to help me get NPVs.

Â

All right, so what I do next and I'm going to go ahead and

Â

show you these in the Excel,

Â

is I'm going to replace all the numbers in my tree.

Â

I'm not going to make any other changes except to a place

Â

this numbers with the numbers discounted back to t=0 at 4%,

Â

and we'll see what that does to the tree.

Â

Once again, I'm going to jump to Excel.

Â

I'm going to, I'll just type in the numbers directly here.

Â

So I want to go number by number here for our inputs.

Â

The 40 million we have to put in here to try for

Â

a variance, that happens at t equals 0.

Â

So I'm not going to muck around with that, but

Â

clearly the cell or develop the variance property.

Â

I am going to have to change these guys so,

Â

I'll just look back quickly at my futures

Â

table with the PVs put in 57.69 here.

Â

Okay, and for the present value of amount,

Â

we'd have to put in to develop is 192.

Â

Okay, and what else happens here if there is no market crash we get 300,000.

Â

If there's a market crash, we get 150,000 in those 1,000 units.

Â

Discounting both of those numbers back to their apples to

Â

apples equivalent values at t equals 0, I get 277370.

Â

And I get here, instead of 150,

Â

138680.

Â

Okay, that was easy right?

Â

Pretty straight forward.

Â

And I want to show you a few important things about this.

Â

Okay first of all, the expected value number of the project

Â

has changed radically from $9 million to $383,000 when we

Â

have made this change, okay.

Â

The other thing that's very interesting is that, now our optimum decision,

Â

if we want to maximize the expected value of the NPV of this project,

Â

we should sell the variants property and not bother developing that at all.

Â

So our optimum decision has changed here, okay and so what does that mean?

Â

Well I got to go through and redo all my probabilities now.

Â

Okay, so now what's my probability of getting to the sell

Â

the variance property after we've tried for a variance and it's been approved?

Â

That's going to be equal to what?

Â

Just my 70%, probability of approval.

Â

I'm going to make this one develop with no market crash zero because we're

Â

choosing not to go the developer we're selling various property.

Â

So similar way, develop with market crash.

Â

I'm going to make the probability equal to zero and

Â

I still have a 30% probability from over here of not getting the project approved.

Â

I add up my probabilities, I still have 100%.

Â

I have my expected value, of the now what is this really?

Â

This is expected value of the NPV of

Â

the project, and this is

Â

expected value of the NPV of the project over here.

Â

So the work that we did, confirms what the software is telling us,