.gif)
IE Investment ClubOur resource base is a great way to get up to speed with your investment knowledge! Here you will also find useful content for your investing activities. Our goal is to help, so if you have any questions or issues for the content below, don’t hesitate to contact us.
On this page you will find:
The activities within this file have been designed for our secondevent. Feel free to use it and share it!
To edit the inputs, hit ‘file’ on the upper left corner, and ‘make copy’.
The activities within this file have been designed for our first event. Feel free to use it and share it!
To edit the inputs, hit ‘file’ on the upper left corner, and ‘make copy’.
This Discounted Cash Flow model is very basic, requires a few inputs, and is great for beginners. It is quick and simple to use, which saves time and draws a vague yet solid idea about the intrinsic value of a company.
This short valuation takes a look at the biggest companies in the semiconductor industry (Nvidia, AMD & Intel) to derive their intrinsic value, found in the Discounted Cash Flow sheet.
This valuation and the model behind it are basic, hence helpful for beginners.
This exercise shows the relationship between expected return and expected standard deviation. On this file, you will be able to play with the weights of each asset in order to build your portfolio. What you will see is how the return and risk (standard deviation) of your portfolio change as you weigh in more or less risky assets.
This exercise shows the relationship between financial metrics of a company. It seeks to answer the following question: among these companies, is a high PE Ratio justified by a high EPS CAGR? If yes, the correlation will be strong, and vice versa.
Using this file is simple, just input the values in the blue cells. It is suggested to play around with the formulas so that you understand how it works and you can then build your own.
This DCF Model example from JPMorgan (Virtual Internship material) is a great insight into how DCF models can get complicated. In essence, however, the model and its calculations are very simple, it is simply jammed with numbers as the forecast period is longer than usual. It is easy to use, simply modify the assumptions and key inputs in order to get it to work. Try to use this model as an example, and work with it to create your own model for your own valuation!
This program is more advanced. By taking in 4 stocks, it generates 10’000 different portfolios and outputs
This program is practical because it gives you the weights for each stock (for the outputted portfolios) so that you can build your own.
This script collects data for x stocks for x days to produce the percentage return a stock has generated over a certain period of time. It outputs bar charts, as well as an excel file with the returns. This is very useful for stock valuations. It is simple, fast and easy to use.
Ever wondered how risky a certain stock is? With this program, you can find out. For x stocks, it finds the standard deviation over a certain period. As you may know, risk = standard deviation. The output is an excel file and a chart. This program is also very useful, fast, and easy to use.
This script is very simple. It collects the data for x days for x stocks and produces a simple, neat chart. You can put as many stocks as you want. The data is normalized, meaning that every stock starts from the ‘same’ price, making it easier to compare respective performance.
Calle de María de Molina, 31, 28006 Madrid, Spain
Email : investing_sg.club@ie.edu
