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
XDC Wallets
Lumosity vs. Elevate: Battle of the brain-training apps
Www.mytotalrewards/Rtx
Will Byers X Male Reader
Riverrun Rv Park Middletown Photos
Compare Foods Wilson Nc
Television Archive News Search Service
Lifebridge Healthstream
Missing 2023 Showtimes Near Cinemark West Springfield 15 And Xd
Rabbits Foot Osrs
Botanist Workbench Rs3
Pitt Authorized User
Pbr Wisconsin Baseball
Tamilblasters 2023
Which Is A Popular Southern Hemisphere Destination Microsoft Rewards
2135 Royalton Road Columbia Station Oh 44028
Reddit Wisconsin Badgers Leaked
Chile Crunch Original
Nene25 Sports
Viha Email Login
Louisiana Sportsman Classifieds Guns
Q33 Bus Schedule Pdf
Rams vs. Lions highlights: Detroit defeats Los Angeles 26-20 in overtime thriller
Schedule 360 Albertsons
Craigslist Prescott Az Free Stuff
Hyvee Workday
Jeff Now Phone Number
Lakers Game Summary
Ezel Detailing
Dulce
Craigs List Tallahassee
Gran Turismo Showtimes Near Marcus Renaissance Cinema
Unable to receive sms verification codes
Greyson Alexander Thorn
Frequently Asked Questions - Hy-Vee PERKS
Rogold Extension
South Florida residents must earn more than $100,000 to avoid being 'rent burdened'
Mrstryst
Cherry Spa Madison
8 Ball Pool Unblocked Cool Math Games
Invalleerkracht [Gratis] voorbeelden van sollicitatiebrieven & expert tips
Registrar Lls
National Weather Service Richmond Va
Swsnj Warehousing Inc
The Average Amount of Calories in a Poke Bowl | Grubby's Poke
Sherwin Source Intranet
Aurora Southeast Recreation Center And Fieldhouse Reviews
Gander Mountain Mastercard Login
Bf273-11K-Cl
Minecraft Enchantment Calculator - calculattor.com
Olay Holiday Gift Rebate.com
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.