In this lecture, walk through an example to see how different investments generate different NPVs.Â
- All right, now let's see how the NPV…and the concept of the discount rate…is applied in an Excel format…so that you can get a better understanding…of these concepts.…So let's look at the first one right here.…First you've got to download this file.…This file is part of the file here that you can download,…and just go to the NPV worksheet here.…You can ignore the other ones for now…'cause we're going to use this file again later…to look at the internal rate of return.…All right, this first part here is the one future payment.…
All right, if we have a future payment,…let's say of $1000 coming in five years,…and it's discounted at 10%,…what is its net present value today?…So we see here that it calculated at 621.…So if I click on this right here,…we see the formula.…The formula is saying it is equal to the future payment…divided by one plus the discount rate,…which is raised to the power of five years.…
And if you change any of the assumptions here,…so let's say if you increase the value in the future,…then this will increase.…
Author
Released
11/30/2018Note: This course uses data and example properties from the United States, but the concepts taught and tools provided are just as useful for any market.
- Determining if real estate investment is right for you
- Choosing a market and a property
- Using financing
- Strategies for first-time investors
- Real estate market cycles
- Valuing a property
- Analyzing your market
- How leverage impacts investments
- Real estate investment case studies
Skill Level Appropriate for all
Duration
Views
Related Courses
-
Excel: Analyzing and Visualizing Cash Flows
with Curt Frye1h 16m Intermediate -
Learning Real Estate Photography
with Scott Hargis3h 21m Beginner -
Investment Evaluation
with Yash Patel2h 4m Intermediate -
Managing Your Personal Investments
with Jane Barratt1h 31m Appropriate for all
-
Introduction
-
Start here3m 29s
-
-
1. Case Study: Joe's First Investment
-
Why invest in real estate?6m 38s
-
Meet Joe2m 47s
-
-
2. The Many Ways to Invest in Real Estate
-
3. Real Estate Market Cycles
-
The recovery phase8m 18s
-
The expansion phase4m 25s
-
The hypersupply phase4m 20s
-
The recession phase5m 57s
-
The next bust?7m 18s
-
4. How to Value a Property
-
5. Understanding Your Market
-
Where to get the data5m 32s
-
Regional analysis18m 2s
-
Neighborhood analysis9m 33s
-
Competitive analysis14m 41s
-
-
6. What Makes a Good Investment?
-
Discount rate2m 42s
-
NPV demonstration7m 34s
-
IRR demonstration4m 24s
-
How to use the measures6m 3s
-
NPV vs. IRR4m 51s
-
Measures of return summary7m 49s
-
7. Understanding Leverage
-
The amortization calculator3m 57s
-
Debt leverage summary4m 41s
-
8. Case Study: Rental Income Property Analysis
-
Market research, part 116m 32s
-
Market research, part 27m 8s
-
Conclusion
-
Congratulations1m 29s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: NPV demonstration