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)

FAQs

What is the best Excel training course? ›

Although, here are some best Online Excel Classes of 2022 according to Investopedia's website Best Overall: Microsoft Excel Class for Beginner to Advanced Learners Best for Businesses: Excel Skills for Business Certification Best for Beginners: Introduction to Data Analysis Using Excel Best for Microsoft Integration: ...

How to learn MS Excel for free? ›

Free Excel lessons
  1. Understanding the Need for Excel Data Validation. 5min video.
  2. Quick Access Toolbar. 5min video.
  3. Area Charts. 11min video.
  4. SLICERS: Insert a Slicer. 4min video.
  5. Power Pivots vs. “ Normal” Pivots in Excel. 3min video.
  6. Working with the Data Analysis ToolPak. 3min video.
  7. VLOOKUP: Excel Tutorial. 5min video.

What is MS Excel's answer? ›

Excel is a spreadsheet program from Microsoft and a component of its Office product group for business applications.

Where can I take a Microsoft Excel class? ›

In summary, here are 10 of our most popular microsoft excel courses
  • Introduction to Microsoft Excel: Coursera Project Network.
  • Using Basic Formulas and Functions in Microsoft Excel: Coursera Project Network.
  • Work Smarter with Microsoft Excel: Microsoft.
  • Excel Basics for Data Analysis: IBM.

What is the quickest way to learn Excel? ›

If you're new to Excel, an introductory course can help get you up to speed quickly on Excel basics. Online Excel courses may explore how to set up an Excel sheet, perform basic calculations, use formulas, and create data visualizations with charts and graphs.

Which is the best Excel course for beginners? ›

In summary, here are 10 of our most popular microsoft excel courses
  • Everyday Excel: University of Colorado Boulder.
  • Excel Skills for Business: Macquarie University.
  • Google Data Analytics: Google.
  • Microsoft Power BI Data Analyst: Microsoft.
  • Preparing Data for Analysis with Microsoft Excel: Microsoft.

Can I teach myself Microsoft Excel? ›

You can learn Excel on your own

One of the best ways to learn the essentials is by importing sample data into Excel and experimenting.

Can you teach yourself to use Excel? ›

You can teach yourself everything from the most basic Excel functions to complex programming using readily available or free online resources. You can take online university courses in Excel or take advantage of the many online tutorials and downloadable course guides.

What is the best place to learn Excel for free? ›

  • 12 Best Free Websites to learn Microsoft Excel. Dr. ...
  • Microsoft Excel Help Centre. Microsoft Excel Help Centre is Microsoft official website that has tutorials and training videos.
  • Chandoo.org. ...
  • TrumpEXCEL. ...
  • Udemy. ...
  • My Great Learning. ...
  • Simplilearn. ...
  • W3Schools.
Nov 8, 2022

What is vlookup in Excel? ›

VLOOKUP stands for 'Vertical Lookup'. It is a function that makes Excel search for a certain value in a column (the so called 'table array'), in order to return a value from a different column in the same row.

How to use Excel step by step? ›

Enter your data
  1. Click an empty cell. For example, cell A1 on a new sheet. Cells are referenced by their location in the row and column on the sheet, so cell A1 is in the first row of column A.
  2. Type text or a number in the cell.
  3. Press Enter or Tab to move to the next cell.

What is MS Excel in one sentence? ›

Microsoft Excel is a spreadsheet program consisting of cells organized by lettered columns and numbered rows. This grid pattern allows for easy data manipulation and conversion of data into mathematical formulas.

How long does it take to learn Excel completely? ›

It takes most Excel users approximately 18-20 hours to fully learn this spreadsheet application. However, this number depends on several factors. Keep reading to learn about how you can study Excel and find resources to help speed the process along.

How many days it will take to learn Excel? ›

This question is subjective in nature as it depends on your grasping capability, but, on an average 12-14 hours well-curated course does the trick. Of course, your learning has to continue on a self-paced level as Advanced Excel is all about practical applicability; the more you practice, the more you perfect it.

What's the best online Excel course? ›

Compare Excel Courses
CoursePriceNo. of Lessons
Best Overall: Udemy's Excel From Beginner to Advanced$125 (or free with $21 per month Udemy subscription)4
Best for Businesses: Macquarie's Excel Skills for BusinessFree with $59 per month Coursera subscription4
4 more rows

Which advanced Excel course is best? ›

  • Henry Harvin. ...
  • Introduction to Data Analysis using Excel (Rice University) ...
  • Microsoft Excel – Basic and Advanced (Go skills) ...
  • Master Microsoft Excel Macros and Excel VBA-Udemy. ...
  • Online Excel Classes-Trump Excel. ...
  • Data Visualization with Advanced Excel (PwC-Coursera) ...
  • Free Excel Tutorial (Excel Easy)
Dec 29, 2023

Is Microsoft Excel course worth it? ›

Training in Microsoft Excel should help anyone's resume stand out for job searching, armed with knowledge in data analysis, data manipulation, and functions with an efficient method for transforming information.

Is Excel training worth it? ›

Yes, Microsoft Excel Certification is beneficial across various fields beyond finance and data analysis, including marketing, project management, education, and healthcare, where Excel's data organization, analysis, and visualization capabilities can be leveraged to enhance efficiency and decision-making.

Top Articles
Latest Posts
Article information

Author: Cheryll Lueilwitz

Last Updated:

Views: 6123

Rating: 4.3 / 5 (74 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Cheryll Lueilwitz

Birthday: 1997-12-23

Address: 4653 O'Kon Hill, Lake Juanstad, AR 65469

Phone: +494124489301

Job: Marketing Representative

Hobby: Reading, Ice skating, Foraging, BASE jumping, Hiking, Skateboarding, Kayaking

Introduction: My name is Cheryll Lueilwitz, I am a sparkling, clean, super, lucky, joyous, outstanding, lucky person who loves writing and wants to share my knowledge and understanding with you.