Stock analysis and valuation model - Forums Forums  

Go Back Forums > The 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

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.

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
  #2 (permalink)  
Old 11-01-2020, 08:50 PM
Posts: n/a


Reply With Quote


« 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 Investments and Net Worth 10 19-03-2009 06:00 PM

» 30 Recent Threads
Queries about Cpib application ( 1 2 3... Last Page)
1,064 Replies, 471,063 Views
OCBC Graduate Talent Programme... ( 1 2 3... Last Page)
158 Replies, 51,432 Views
DBS Management Associate Program... ( 1 2 3... Last Page)
1,139 Replies, 196,373 Views
Constituency Manager (People... ( 1 2 3... Last Page)
812 Replies, 412,005 Views
Q: Big4 - Yearly salary increment ( 1 2 3... Last Page)
866 Replies, 694,580 Views
MINDEF DXO (All FAQ on it) ( 1 2 3... Last Page)
2,860 Replies, 1,726,585 Views
Job search for returning...
0 Replies, 97 Views
Working at Changi Business Park
5 Replies, 271 Views
Whats your net worth ( 1 2 3... Last Page)
2,687 Replies, 750,087 Views
Schneider Electric - EGP (Grad... ( 1 2 3... Last Page)
36 Replies, 12,949 Views
DBS Graduate Associate Program ( 1 2 3... Last Page)
611 Replies, 307,403 Views
AML/Compliance/KYC professionals... ( 1 2 3... Last Page)
1,369 Replies, 533,661 Views
Exxon Mobil Equipment tech or... ( 1 2 3... Last Page)
1,689 Replies, 479,152 Views
Met a girl from dating app
1 Replies, 232 Views
Shell TDP ( 1 2 3... Last Page)
146 Replies, 42,664 Views
Lawyer Salary ( 1 2 3... Last Page)
4,845 Replies, 2,072,597 Views
Gap year, Sabbatical
4 Replies, 259 Views
Compare civil service salary ( 1 2 3... Last Page)
8,916 Replies, 5,126,476 Views
UOB Management Associate Program ( 1 2 3... Last Page)
240 Replies, 149,122 Views
OCBC Young Bankers Programme ( 1 2 3... Last Page)
96 Replies, 70,406 Views
Career switches - job options and... ( 1 2)
12 Replies, 1,975 Views
What course should I undertake?
3 Replies, 2,074 Views
is it crazy to give up a 100k P.A... ( 1 2 3)
26 Replies, 20,857 Views
Career as Teacher ( 1 2 3... Last Page)
2,010 Replies, 1,361,568 Views
How is life as a doctor in... ( 1 2 3... Last Page)
1,007 Replies, 804,290 Views
SPF (Direct-Entry Inspector)
8 Replies, 889 Views
ST Electronics ( 1 2 3... Last Page)
371 Replies, 166,110 Views
SIM-UOL fresh grad starting pay ( 1 2 3... Last Page)
2,547 Replies, 1,214,453 Views
GovTech career grade ( 1 2 3... Last Page)
83 Replies, 105,102 Views
Powered by vBadvanced CMPS v3.2.2

All times are GMT +8. The time now is 03:48 PM.

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