Salary.sg Forums - Reply to Topic
Salary.sg Forums  

Go Back   Salary.sg Forums > The Salary.sg Discussion Forums: > Investments and Net Worth > Stock analysis and valuation model

Investments and Net Worth Talk all about money making exploits, shares, property, building net worth and retirement matters




Salary.sg Forums

Thread: Stock analysis and valuation model Reply to Thread
Your Username: Click here to log in
Human Verification To prove you are a human and not a computer program that spams, please check the box below and answer any further questions if prompted.

Title:
  
Message:
Post Icons
You may choose an icon for your message from the following list:
 

Additional Options
Miscellaneous Options

Topic Review (Newest First)
11-01-2020 08:50 PM
Unregistered Congratulations!
11-01-2020 05:42 PM
fanhui3
Stock analysis and valuation model

I have built a model to make analyzing a stock easier for me. It puts a companyís performance for me into perspective by visualizing the data and ratios from past 10 yearsí financial reports. It even calculates the intrinsic values using various valuation models. It is all done within just 3mins from data mining to production of the report. I have share a sample for Apple (AAPL) at the end of this post. Could you let me know what you think?

Before I have created this model from a BI software, I faced these pain points when researching on stocks:

Analyzing a stock used to be a tedious and cognitive draining process at the quantitative level. To understand the companyís track record, I often had to look at the financial statements (Income statement, balance sheet and cash flow statements) from past 10 years. Very often, I find myself cross-analyzing the different reports and across publications of different years to grasp the state the company. A smart investor would compile the 10-year data or find a website that provides it to make your analysis easier. Even so, the real work has only just started. I used to find myself spending hours calculating the various ratios (current ratio, debt to equity ratio, etc.) as they were not provided. Also. I used to mentally visualize and infer information from the number mentally. Frankly, I donít enjoy this process.

When looking for bargain stocks, I used to ponder over the intrinsic value of the stock I love and had pour my money into an over-valued stock. What use is the concept of margin of safety when you donít even know its intrinsic value, right? After learning the application of the valuation models, I find myself taking hours to calculate the intrinsic values as it involves extraction of pertinent numbers from financial sites and financial reports, calculations, and double checking my math. Thankfully, I have now automated the math in the model.

https://www.dropbox.com/s/ge6788zpzu...Apple.pdf?dl=0

Posting Rules
You may not post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off




All times are GMT +8. The time now is 02:12 PM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.3.2