From the course: Investment Evaluation
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Evaluation methods - Microsoft Excel Tutorial
From the course: Investment Evaluation
Evaluation methods
- Before we get going with the heavy-hitting techniques, I will say this. There are many ways to evaluate in which direction you should go with an investment. In this course I'm gonna show you the most common ones that are industry-standard and are fairly easy to apply in your own scenarios. If you don't own a business you should still be aware that these mathematical and logical concepts apply to your daily life. As you continue following along, you'll see what I mean. Here's a sneak peek of what's to come in subsequent chapters. The first technique we'll cover is discounted cash flows, which I'll also call DCF from time to time. It basically just uses cash flow projections and discounts them fairly analogous to calculating present value using a discount rate. Although the calculations are complex, the purpose of DCF analysis is simply to estimate the money you've received from an investment and to adjust for the time value of money. If you already understand the concept of the time…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
Components of an investment3m 5s
-
(Locked)
Investments and economic capital4m 4s
-
(Locked)
Types of investments2m 43s
-
(Locked)
Opportunity cost4m 3s
-
(Locked)
Time value of money4m 34s
-
(Locked)
Present, future, and terminal values6m 1s
-
(Locked)
Challenge 1: Determine present, future, and terminal values1m 24s
-
(Locked)
Solution 1: Determine present, future, and terminal values4m 20s
-
(Locked)
Real talk: Investments and opportunity costs5m 29s
-
(Locked)
Evaluation methods2m 28s
-
-
-
-
-