Stock analysis and valuation model - Salary.sg Forums
Salary.sg Forums  

Go Back   Salary.sg Forums > The Salary.sg Discussion Forums: > Investments and Net Worth

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




Stock analysis and valuation model

Reply
 
Thread Tools
  #1 (permalink)  
Old 11-01-2020, 05:42 PM
Junior Member
 
Join Date: Jan 2020
Posts: 1
fanhui3 is on a distinguished road
Default 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

Reply With Quote
  #2 (permalink)  
Old 11-01-2020, 08:50 PM
Unregistered
Guest
 
Posts: n/a
Default

Congratulations!

Reply With Quote
Reply

Bookmarks

« Previous Thread | Next Thread »
Thread Tools

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
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
NUS MSc. ISE or GDip System Analysis Deunique Education and Personal Growth 1 21-10-2017 08:14 PM
where can i buy nintendo stock? raigan Investments and Net Worth 3 18-10-2016 12:27 PM
Question abt banking/stock/currency zetoroz Investments and Net Worth 3 02-04-2010 08:40 PM
Property Analysis Reports Reporter Investments and Net Worth 3 11-07-2009 12:54 AM
Singapore's Growth Model Needs Rethinking Salary.sg Investments and Net Worth 10 19-03-2009 06:00 PM

» 30 Recent Threads
DBS Graduate Associate Program ( 1 2 3... Last Page)
609 Replies, 306,098 Views
Compare civil service salary ( 1 2 3... Last Page)
8,912 Replies, 5,118,344 Views
ST Electronics ( 1 2 3... Last Page)
370 Replies, 165,238 Views
SPF (Direct-Entry Inspector)
7 Replies, 650 Views
MINDEF DXO (All FAQ on it) ( 1 2 3... Last Page)
2,850 Replies, 1,722,823 Views
GovTech career grade ( 1 2 3... Last Page)
83 Replies, 104,329 Views
aerospace engineer (rolls royce) ( 1 2 3... Last Page)
36 Replies, 57,058 Views
is it crazy to give up a 100k P.A... ( 1 2 3)
25 Replies, 20,210 Views
Shell TDP ( 1 2 3... Last Page)
142 Replies, 42,218 Views
OCBC Graduate Talent Programme... ( 1 2 3... Last Page)
148 Replies, 49,994 Views
Career as Teacher ( 1 2 3... Last Page)
2,008 Replies, 1,356,937 Views
Schneider Electric - EGP (Grad... ( 1 2 3... Last Page)
33 Replies, 12,502 Views
Job offer from Apple ( 1 2 3... Last Page)
290 Replies, 48,187 Views
Singtel Management Associate... ( 1 2 3... Last Page)
114 Replies, 74,838 Views
Exxon Mobil Equipment tech or... ( 1 2 3... Last Page)
1,688 Replies, 478,129 Views
SIM-UOL fresh grad starting pay ( 1 2 3... Last Page)
2,546 Replies, 1,212,586 Views
Constituency Manager (People... ( 1 2 3... Last Page)
810 Replies, 411,240 Views
DBS Management Associate Program... ( 1 2 3... Last Page)
1,138 Replies, 195,124 Views
Career advice
0 Replies, 89 Views
UOB Management Associate Program ( 1 2 3... Last Page)
238 Replies, 148,514 Views
anyone working at NCS ? ( 1 2 3... Last Page)
333 Replies, 254,055 Views
OCBC Young Bankers Programme ( 1 2 3... Last Page)
95 Replies, 70,157 Views
Govtech bonus ( 1 2 3)
27 Replies, 11,390 Views
Civil/Public Sector -... ( 1 2 3... Last Page)
384 Replies, 193,903 Views
Lawyer Salary ( 1 2 3... Last Page)
4,843 Replies, 2,065,662 Views
Monetary Authority of Singapore...
1 Replies, 335 Views
AML/Compliance/KYC professionals... ( 1 2 3... Last Page)
1,368 Replies, 532,710 Views
Factual Local Bank Salaries - DBS... ( 1 2 3... Last Page)
36 Replies, 41,883 Views
NCS Salary range and Promotion...
2 Replies, 574 Views
Senior Lab officer @ IMRE
9 Replies, 4,187 Views
Powered by vBadvanced CMPS v3.2.2



All times are GMT +8. The time now is 06:13 AM.


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