Explore
For Enterprise
Join for Free
Log In

Гуманитарные науки и искусства
Бизнес
Компьютерные науки
Наука о данных
Информационные технологии
здоровье
Математика и логика
Личное развитие
Естественные и технические науки
Социальные науки
Изучение языков
Степени
Сертификаты

Полный обзор Coursera

Обзор
Поиск
Для организаций
Войти
Присоединиться бесплатно

"Net Present Value" DCF Method for Project Evaluation

Loading...

Construction Finance

Колумбийский университет

4.7 (оценок: 428) | Зарегистрировано учащихся: 10K

Курс 4 из 4 — Управление строительством Специализация

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.

Просмотреть программу курса

Получаемые навыки

Financial Modeling, Project, Finance, Real Estate

Рецензии

4.7 (оценок: 428)

5 stars
341 ratings
4 stars
72 ratings
3 stars
12 ratings
1 star
3 ratings

SG

Mar 15, 2017

Very nice course, Just the Excel sheet of Professor Anthony Webster is a big question mark, where we can get this file so we can follow up with him during the class

BO

Aug 20, 2018

Excellent course led by esteemed people with many years of experience in the industry. Very practical and thorough survey of concepts and tools in the industry.

Из урока

Real Estate Finance for Development Projects

Professor Anthony Webster introduces real estate finance providing an overview of the real estate project lifecycle, a discussion on zoning code parameters, and examples of estimating the sales price of a property.

Framework for "Discounted Cash Flow" (DCF) Analysis10:14

"Net Present Value" DCF Method for Project Evaluation15:23

Net Present Value (NPV) Examples4:19

"Internal Rate of Return" (IRR) Method for Project Evaluation12:26

NPV and IRR Analysis with Excel11:33

Changing and Comparing Compounding Periods10:15

Преподаватели

Ibrahim Odeh, Ph.D., MBA
Instructor, Department of Civil Engineering and Engineering Mechanics, Columbia University

Текст видео

So let's start off with the Net Present Value method.

First of all, what do we mean by Net Present Value?

Net Present Value is simply all of the projects

cash flows for one player, inflows and

outflows, as normalized back to T = 0 or T0.

So mathematically we'd say that net present value or

NPV is equal to the sum of present values of all the projects' cash flows,

including anything we receive or pay out at any time, okay?

So getting more mathematical here using summation notation.

We'd say MPV, the double equal sign means defined to be,

is defined to be the sum of all of the cashflows.

But before we sum them up, I just want to emphasize here,

each one has to be normalized back to or discounted back to

T equals zero.

And note that the index i here for the cashflow starts at zero, not one.

This includes all the cash flows for one player, or for one project.

So, that's our definition of Net Present Value, and now we're going to have

to learn what's called the Net Present Value Method, and

to get there let's say a few more things about it.

So the NPV method says, if we want to put it in words,

if all the project's time normalized cash

flows are greater than zero, we're going to make money on this project, okay?

If not, we won't.

So we, we bring them all back to this apples to apples basis, and

add them all up, and if that sum is positive, we're going to make money.

And if it's not, we're not going to, okay.

So the NPV evaluation method is going to work extraordinarily simply, like this.

The NPV evaluation method simply says we're going to invest in a project, we're

going to go forward with a project, we're going to execute a project if and only if,

that's not a typo, that stands for if and only if, the potential project's

net present value for us, one player at a time, is greater than zero.

So that's it.

Pretty straightforward.

Okay, so now we need to spend a little bit of time on what Cash Flows and

Discount Rates we should be considering for use in the NPV Method okay.

We want to consider in general the risks,

that include risk-free risk,

that sounds like an oxymoron.

That's really the risk of US treasuries and there is some risk there right?

Inflation and other things like that are built into there even

though we call it risk, call it risk-free risk, industry or market risks,

And then Project-Specific.

And then finally of course time,

the longer any project goes on the riskier it gets,

because the harder it is to understand what's going to be happening with

any precision the further we go out into the future timewise.

So we want to consider all four of these risks.

And in general with the NPV method, most people work things out this way.

They include the project-specific risks in the cash flows.

And another good way to think of project

specific risk is stupid manager risk.

So these are risks that have nothing to do with the industry or the market,

or the macro-economy of the US, or anywhere else in the world.

These are risks by someone executing the project making bad decisions.

So here's just a very simple example.

If we're looking at a project, if everything goes perfect,

we're going to get $10 out of this project,

that'll be cash flow coming in to us.

And we believe we've done a lot of work on that and

there're 95% probability that that's the way this project is going to go.

However, if the manager screws up this project

we're only going to get $5 out of this this project and happily,

we think there's only a 5% probability of that coming our way.

So how do we deal with this project's specific risk?

Well, we take a weighted average and we'd say that

the cash flow at time one that we're going to use is 95% things going

well plus the 5% of things going badly or 9.75.

So that's just one very simple example of how we

could handle project specific risk or stupid manager risk, okay?

The next thing we want to think about is what

discount rate or we give the second here and

in the discount rates we want to include

Are risk free risk.

And our industry or market or market

And we're going to use for that what we call

our Opportunity Cost of Capital discount rate, okay?

And we note that as ROCC, and it's also called

sometimes a market discount rate and it's also denoted as SRM.

It means the same thing.

Different folks use different subscripts, but

opportunity cost of capital is equal to market discount rate, RM.

Okay, so now let's go ahead and plug these quantities into our MPV formula and

when we do that, we have something that looks like this.

Now the NPV of a project for one player is going to be,

again a time, the sum the of individual time-normalized

cash flows where we have our project risk taking

care of in the cash flows discounted by our

opportunity cost of capital which includes

our risk-free risk, and our market-risk.

All right, so with opportunity cost of capital, it's probably good

to get a slightly better handle on what exactly we mean by this.

How could we compute it?

Where does it come from?

So for a given project, we define opportunity cost of capital as

the known discount rate or interest rate.

Again, same thing mathematically.

Interest rate if we're going forward in time,

discount rate if we're going back in time.

So the known interest rate or discount rate for a diversified set of alternative

investments or projects with similar market or industry risks.

And again, sometimes we call this RM instead of ROCC.

All right, so how should this opportunity class of capital be computed?

First big thing to note here is there is no consensus on this.

There have been on going wars within finance and

economics on how best to compute this since the concept first arose.

There are several methods in common usage,

two methods are presented in the appendix to this chapter.

And of course, warning, gratuitous and self serving plug,

in my Introduction to Business Finance text,

which is available at appliedfinance.flickrocket.com.

Okay.

No matter how it's computed, we don't have time here to

spend time going over different methods of computing.

[COUGH] Excuse me.

Opportunity cost of capital.

But no matter how it's computed, it has two important properties.

Let's remember first what it is, double equal sign,

this always means defined to be, to be our opportunity cost and capital.

Defined to be the known interest rate for

diversified set of alternative investments with similar market or

industry risks to the project we're considering at hand, okay?

So with that in our pocket, that definition,

two things become fairly obvious if you think about it.

First, we can make investments with a return of our opportunity cost of capital

at any time by adding to this position, this diversified set of alternative

investments, with some more industry risks, okay?

So that implies that [COUGH] the opportunity cost of capital

is going to be the rate of return, the interest rate or

discount rate we'd forgo by pursuing a new opportunity in our investment milieu.

In this case, our investment milieu is developing

multifamily rental properties and selling them.

Okay?

Second thing about the opportunity cost of capital is that

the opportunity cost of capital, of course,

increases with the riskiness of our investment mission.

So, for example, if someone's mission is to invest in Treasury securities,

which are considered the safest debt securities in the world by many people,

not everyone, but most people.

The opportunity cost of capital for

an investor like that is going to be less than the opportunity cost of capital for

someone whose mission in life is to invest in sub-prime mortgages, for example.

Subprime mortgages are, by definition, very risky mortgages.

Okay, so now we're ready to get back to, now we knew everything we need to know

to jump back into the NPV project evaluation method.

So here's a reminder of the formula.

The net present value of a project for one player is simply

the algebraic sum of every stinkin' cash flow for

this project for that player, which has been before adding up,

which has been discounted back to T equals zero,

or if you want to think about it in other way,

discounted back to T equals zero using what?

Using the opportunity cost of capital.

And what cash flows are we talking about again?

Cash flows that have been risk adjusted for project specific risk or

what we call sometimes, what I call sometimes stupid manager risk.

Okay, so now we've got two important things about the NPV formula itself.

One is that the net present value of opportunity cost investments,

that diversified portfolio or observable stuff that we could have

invested in alternately that gave us our opportunity cost of capital.

The NPV from investing in more of that diversified portfolio

of stuff fin our investment milieu, it's always going to equal 0.

And what I have in gray here is an explanation and proof,

explanation for and proof of that.

The information in gray, I'm not going to cover.

You're welcome to look at it.

It's in my textbook if you're interested and

you can certainly check it out, but

we're just going to accept this on face value here.

Second thing that we're going to accept is that if we

find investments that are in our investment milieu,

again, for a firm like CAG, if we find projects,

remember project, the synonym for investment.

If we find development projects for multifamily rental

buildings that we can put together that we feel will have an NPV greater than zero

after we estimated all the cash quotes for the project, we should go ahead.

We should go ahead because that's going to do better for

us than putting the money we could invest in this

project in our opportunity cost of capital investments.

All right, so that gives us a great rule for applying the NPV formula,

which is, invest in a potential project if the NPV is greater than zero.

Don't invest if the NPV is less than zero.

Ознакомьтесь с нашим каталогом

Присоединяйтесь бесплатно и получайте персонализированные рекомендации, обновления и предложения.

Coursera делает лучшее в мире образование доступным каждому, предлагая онлайн-курсы от ведущих университетов и организаций.

© Coursera Inc., 2019 Все права защищены.

Загрузить из App Store

Загрузить в Google Play

Coursera
О проекте
Руководство
Карьера
Каталог
Сертификаты
Сертификаты MasterTrack™
Степени
Для организаций
Для правительственных организаций

Сообщество
Learners
Partners
Developers
Beta Testers
Translators

На связи
Блог
Facebook
LinkedIn
Twitter
Instagram
YouTube
Технический блог

Еще
Условия
Конфиденциальность
Помощь
Доступность
Пресса
Контакты
Справочник
Филиалы