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 Buy for my team

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
    • (Locked) Investments and economic capital 4m 4s
    • (Locked) Types of investments 2m 43s
    • (Locked) Opportunity cost 4m 3s
    • (Locked) Time value of money 4m 34s
    • (Locked) Present, future, and terminal values 6m 1s
    • (Locked) Challenge 1: Determine present, future, and terminal values 1m 24s
    • (Locked) Solution 1: Determine present, future, and terminal values 4m 20s
    • (Locked) Real talk: Investments and opportunity costs 5m 29s
    • (Locked) Evaluation methods 2m 28s
    • What is DCF? 1m 45s
    • (Locked) Solve for DCF 5m 31s
    • (Locked) Challenge 2: Calculate DCF over 30 years 59s
    • (Locked) Solution 2: Calculate DCF over 30 years 3m 49s
    • (Locked) Pros and cons of DCF 1m 18s
    • (Locked) Real talk: Discounted cash flows 4m 35s
    • The net present value equation 2m 55s
    • (Locked) NPV using tables 3m 36s
    • (Locked) Challenge 3: Calculate NPV using table values 1m 23s
    • (Locked) Solution 3: Calculate NPV using table values 1m 39s
    • (Locked) A fully worked out example 4m 38s
    • (Locked) NPV using a Microsoft Excel formula 1m 48s
    • (Locked) Challenge 4: Calculate NPV using Microsoft Excel 42s
    • (Locked) Solution 4: Calculate NPV using Microsoft Excel 1m 31s
    • (Locked) Pros and cons of NPV 1m 32s
    • (Locked) Real talk: Net present value 4m 56s
    • (Locked) What is IRR? 1m 47s
    • (Locked) IRR calculation the long way 3m 10s
    • (Locked) The case of no IRR 1m 47s
    • (Locked) The case of multiple IRRs 5m 10s
    • (Locked) IRR using the Microsoft Excel formula 6m 24s
    • (Locked) Challenge 5: Calculate NPV and IRR 1m 3s
    • (Locked) Solution 5: Calculate NPV and IRR 3m 37s
    • (Locked) Pros and cons of IRR 1m 26s
    • (Locked) Payback period 2m 15s
    • (Locked) Payback period in Microsoft Excel 2m 31s
    • (Locked) Challenge 6: Choose a project based on NPV, IRR, and payback period 33s
    • (Locked) Solution 6: Choose a project based on NPV, IRR, and payback period 4m 53s
    • (Locked) Real talk: IRR and payback period 4m 49s
    • (Locked) Next steps 56s
Components of an investment - Microsoft Excel Video Tutorial | LinkedIn Learning, formerly Lynda.com (2024)
Top Articles
U2F & Adaptive MFA: Are They the Same? | OneLogin
How Much Is RV Insurance?
Katie Pavlich Bikini Photos
Gamevault Agent
Hocus Pocus Showtimes Near Harkins Theatres Yuma Palms 14
Free Atm For Emerald Card Near Me
Craigslist Mexico Cancun
Hendersonville (Tennessee) – Travel guide at Wikivoyage
Doby's Funeral Home Obituaries
Vardis Olive Garden (Georgioupolis, Kreta) ✈️ inkl. Flug buchen
Select Truck Greensboro
Things To Do In Atlanta Tomorrow Night
Non Sequitur
How To Cut Eelgrass Grounded
Pac Man Deviantart
Alexander Funeral Home Gallatin Obituaries
Craigslist In Flagstaff
Shasta County Most Wanted 2022
Energy Healing Conference Utah
Testberichte zu E-Bikes & Fahrrädern von PROPHETE.
Aaa Saugus Ma Appointment
Geometry Review Quiz 5 Answer Key
Walgreens Alma School And Dynamite
Bible Gateway passage: Revelation 3 - New Living Translation
Yisd Home Access Center
Home
Shadbase Get Out Of Jail
Gina Wilson Angle Addition Postulate
Celina Powell Lil Meech Video: A Controversial Encounter Shakes Social Media - Video Reddit Trend
Walmart Pharmacy Near Me Open
A Christmas Horse - Alison Senxation
Ou Football Brainiacs
Access a Shared Resource | Computing for Arts + Sciences
Pixel Combat Unblocked
Cvs Sport Physicals
Mercedes W204 Belt Diagram
Rogold Extension
'Conan Exiles' 3.0 Guide: How To Unlock Spells And Sorcery
Teenbeautyfitness
Weekly Math Review Q4 3
Facebook Marketplace Marrero La
Nobodyhome.tv Reddit
Topos De Bolos Engraçados
Gregory (Five Nights at Freddy's)
Grand Valley State University Library Hours
Holzer Athena Portal
Hampton In And Suites Near Me
Stoughton Commuter Rail Schedule
Bedbathandbeyond Flemington Nj
Free Carnival-themed Google Slides & PowerPoint templates
Otter Bustr
Selly Medaline
Latest Posts
Article information

Author: Jonah Leffler

Last Updated:

Views: 5475

Rating: 4.4 / 5 (65 voted)

Reviews: 80% of readers found this page helpful

Author information

Name: Jonah Leffler

Birthday: 1997-10-27

Address: 8987 Kieth Ports, Luettgenland, CT 54657-9808

Phone: +2611128251586

Job: Mining Supervisor

Hobby: Worldbuilding, Electronics, Amateur radio, Skiing, Cycling, Jogging, Taxidermy

Introduction: My name is Jonah Leffler, I am a determined, faithful, outstanding, inexpensive, cheerful, determined, smiling person who loves writing and wants to share my knowledge and understanding with you.