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!



SG BusLeh mobile app
SG BusLeh - the best bus app - available on iPhone and Android


SGX Stocks Android App - check share prices
SGX Stocks [Android] App - check latest share prices on the go


SGX Stocks for iPad - check latest Singapore share prices
SGX Stocks [iPad] app
| SGX Stocks [iPhone] app
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
Career as Teacher ( 1 2 3... Last Page)
2,009 Replies, 1,358,209 Views
How is life as a doctor in... ( 1 2 3... Last Page)
1,006 Replies, 802,419 Views
Compare civil service salary ( 1 2 3... Last Page)
8,913 Replies, 5,119,997 Views
MINDEF DXO (All FAQ on it) ( 1 2 3... Last Page)
2,854 Replies, 1,723,656 Views
SPF (Direct-Entry Inspector)
8 Replies, 759 Views
ST Electronics ( 1 2 3... Last Page)
371 Replies, 165,547 Views
SIM-UOL fresh grad starting pay ( 1 2 3... Last Page)
2,547 Replies, 1,213,288 Views
DBS Graduate Associate Program ( 1 2 3... Last Page)
609 Replies, 306,429 Views
GovTech career grade ( 1 2 3... Last Page)
83 Replies, 104,586 Views
aerospace engineer (rolls royce) ( 1 2 3... Last Page)
36 Replies, 57,144 Views
is it crazy to give up a 100k P.A... ( 1 2 3)
25 Replies, 20,356 Views
Shell TDP ( 1 2 3... Last Page)
142 Replies, 42,291 Views
OCBC Graduate Talent Programme... ( 1 2 3... Last Page)
148 Replies, 50,158 Views
Schneider Electric - EGP (Grad... ( 1 2 3... Last Page)
33 Replies, 12,591 Views
Job offer from Apple ( 1 2 3... Last Page)
290 Replies, 48,359 Views
Singtel Management Associate... ( 1 2 3... Last Page)
114 Replies, 74,940 Views
Exxon Mobil Equipment tech or... ( 1 2 3... Last Page)
1,688 Replies, 478,316 Views
Constituency Manager (People... ( 1 2 3... Last Page)
810 Replies, 411,395 Views
DBS Management Associate Program... ( 1 2 3... Last Page)
1,138 Replies, 195,354 Views
Career advice
0 Replies, 125 Views
UOB Management Associate Program ( 1 2 3... Last Page)
238 Replies, 148,607 Views
anyone working at NCS ? ( 1 2 3... Last Page)
333 Replies, 254,214 Views
OCBC Young Bankers Programme ( 1 2 3... Last Page)
95 Replies, 70,193 Views
Govtech bonus ( 1 2 3)
27 Replies, 11,434 Views
Civil/Public Sector -... ( 1 2 3... Last Page)
384 Replies, 194,006 Views
Lawyer Salary ( 1 2 3... Last Page)
4,843 Replies, 2,067,482 Views
Monetary Authority of Singapore...
1 Replies, 343 Views
AML/Compliance/KYC professionals... ( 1 2 3... Last Page)
1,368 Replies, 532,917 Views
Factual Local Bank Salaries - DBS... ( 1 2 3... Last Page)
36 Replies, 41,980 Views
NCS Salary range and Promotion...
2 Replies, 592 Views
Powered by vBadvanced CMPS v3.2.2



All times are GMT +8. The time now is 11:28 AM.


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