Components of an investment - Microsoft Excel Video Tutorial | LinkedIn Learning, formerly Lynda.com (2024)

From the course: Investment Evaluation

From the course: Investment Evaluation

Start my 1-month free trial

Components of an investment

- At a surface level, the concept of investment is easy to grasp. An investment is a purchase you make hoping to get a profit later on down the road. That's easy to understand. But there are also several components to an investment. Specifically, time, capital, and profitability. Time is the period that you should expect to hold an investment. You might have heard this referred to as the time horizon. Time horizon can last from seconds for day traders, to years for those taking the longterm approach. The time horizon you have is purely dependent on your situation and your risk tolerance. For example, if you're a 70 year old retiree, your time horizon and risk tolerance are going to be much slower than a 24 year old who's just entered the workforce. The rationale for that is that market trends shift over time but ultimately, if you hold the investment long enough, it'll pay out profitably. As you can imagine, a retiree has a much shorter time window and doesn't wanna see short term losses as the money might be needed sooner. A younger individual can wait out market forces to liquidate later on and still see profit. Of course, age isn't the only reason one may have a short time horizon. Recently I purchased a new home and needed to sell stock to make a down payment. So I too, had a short time in the market. It's an unfortunate situation but we all have to deal with it on occasion. The second component is capital. That's essentially the financial value of assets. You can think of it as monetary funds. It can also refer to tangible items such as plant, property, and equipment. That's pretty easy, right? The only caveat is that in order to be categorized as capital, the goods or money have to continuously provide a service to the business. Whether that's paying salaries, or purchasing assets to create value. So how does this fit in with the investment component? Well, when you invest, you're making capital investment. You're helping a company or product reach its business goals by giving it money. Last but definitely not least, we have profitability. A quick definition of the term answers the question, how much money am I gonna make? Most people would say this is the most important part of an investment. Before you invest in a business or goods or people, you have to ask yourself if the investment will result in a profit. Always optimize your investment to have the highest ROI or Return On Investment possible. Again, only three basic components. But investing is a lot more nuanced. However, keep in mind, if you're making business decisions regarding investment, be sure to think about how much time the investment needs to see a return, how much capital you're gonna use in the investment that you can potentially use for other things, and what kind of profit you expect to see when you get the return.

Contents

    • Welcome 1m 57s
    • Course requirements and structure 1m 26s
    • Components of an investment 3m 5s
    • Investments and economic capital 4m 4s
    • Types of investments 2m 43s
    • Opportunity cost 4m 3s
    • Time value of money 4m 34s
    • Present, future, and terminal values 6m 1s
    • Challenge 1: Determine present, future, and terminal values 1m 24s
    • Solution 1: Determine present, future, and terminal values 4m 20s
    • Real talk: Investments and opportunity costs 5m 29s
    • Evaluation methods 2m 28s
    • What is DCF? 1m 45s
    • Solve for DCF 5m 31s
    • Challenge 2: Calculate DCF over 30 years 59s
    • Solution 2: Calculate DCF over 30 years 3m 49s
    • Pros and cons of DCF 1m 18s
    • Real talk: Discounted cash flows 4m 35s
    • The net present value equation 2m 55s
    • NPV using tables 3m 36s
    • Challenge 3: Calculate NPV using table values 1m 23s
    • Solution 3: Calculate NPV using table values 1m 39s
    • A fully worked out example 4m 38s
    • NPV using a Microsoft Excel formula 1m 48s
    • Challenge 4: Calculate NPV using Microsoft Excel 42s
    • Solution 4: Calculate NPV using Microsoft Excel 1m 31s
    • Pros and cons of NPV 1m 32s
    • Real talk: Net present value 4m 56s
    • What is IRR? 1m 47s
    • IRR calculation the long way 3m 10s
    • The case of no IRR 1m 47s
    • The case of multiple IRRs 5m 10s
    • IRR using the Microsoft Excel formula 6m 24s
    • Challenge 5: Calculate NPV and IRR 1m 3s
    • Solution 5: Calculate NPV and IRR 3m 37s
    • Pros and cons of IRR 1m 26s
    • Payback period 2m 15s
    • Payback period in Microsoft Excel 2m 31s
    • Challenge 6: Choose a project based on NPV, IRR, and payback period 33s
    • Solution 6: Choose a project based on NPV, IRR, and payback period 4m 53s
    • Real talk: IRR and payback period 4m 49s
    • Next steps 56s
Components of an investment - Microsoft Excel Video Tutorial | LinkedIn Learning, formerly Lynda.com (2024)
Top Articles
Latest Posts
Article information

Author: Corie Satterfield

Last Updated:

Views: 6334

Rating: 4.1 / 5 (42 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Corie Satterfield

Birthday: 1992-08-19

Address: 850 Benjamin Bridge, Dickinsonchester, CO 68572-0542

Phone: +26813599986666

Job: Sales Manager

Hobby: Table tennis, Soapmaking, Flower arranging, amateur radio, Rock climbing, scrapbook, Horseback riding

Introduction: My name is Corie Satterfield, I am a fancy, perfect, spotless, quaint, fantastic, funny, lucky person who loves writing and wants to share my knowledge and understanding with you.