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

 Citibank Cash Back Card - up to $350 cash back* - Click to Apply Now 
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 Bus Timing App
SG Bus Timing App - the best bus app - available on iPhone


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
where can i buy nintendo stock? raigan Investments and Net Worth 6 08-07-2020 05:05 PM
NUS MSc. ISE or GDip System Analysis Deunique Education and Personal Growth 1 21-10-2017 07:14 PM
Question abt banking/stock/currency zetoroz Investments and Net Worth 3 02-04-2010 07:40 PM
Property Analysis Reports Reporter Investments and Net Worth 3 10-07-2009 11:54 PM
Singapore's Growth Model Needs Rethinking Salary.sg Investments and Net Worth 10 19-03-2009 05:00 PM

» 30 Recent Threads
DBS Management Associate Program... ( 1 2 3... Last Page)
1,796 Replies, 274,124 Views
Lawyer Salary ( 1 2 3... Last Page)
7,648 Replies, 2,621,795 Views
How much do you earn and save? ( 1 2 3... Last Page)
106 Replies, 14,827 Views
Roles in accenture singapore ( 1 2 3... Last Page)
392 Replies, 251,693 Views
How is life as a doctor in... ( 1 2 3... Last Page)
1,297 Replies, 909,925 Views
Compare civil service salary ( 1 2 3... Last Page)
10,120 Replies, 5,593,365 Views
Civil Svc/ Statboard - Typical... ( 1 2 3... Last Page)
2,197 Replies, 973,700 Views
Anyone jobless for a long time... ( 1 2 3... Last Page)
2,918 Replies, 1,087,160 Views
Mortgage Specialist Role.
2 Replies, 1,478 Views
Anyone being hired during covid... ( 1 2 3)
26 Replies, 2,269 Views
Possible to earn passive income... ( 1 2)
18 Replies, 4,341 Views
Factual Local Bank Salaries - DBS... ( 1 2 3... Last Page)
165 Replies, 77,575 Views
Anyone work for Casino (RWS/MBS) ?... ( 1 2)
12 Replies, 8,808 Views
SIM-UOL fresh grad starting pay ( 1 2 3... Last Page)
3,066 Replies, 1,287,210 Views
Career as Teacher ( 1 2 3... Last Page)
2,671 Replies, 1,610,800 Views
ST Electronics ( 1 2 3... Last Page)
690 Replies, 212,678 Views
What's the graduate officer... ( 1 2 3... Last Page)
56 Replies, 13,482 Views
Tax ( 1 2)
15 Replies, 3,684 Views
Mid-Year Civil Servant Bonus 2019 ( 1 2 3... Last Page)
1,635 Replies, 784,801 Views
anyone working at NCS ? ( 1 2 3... Last Page)
396 Replies, 288,466 Views
Submitting My Resume To ST... ( 1 2 3)
23 Replies, 22,549 Views
Job offer from Apple ( 1 2 3... Last Page)
462 Replies, 88,429 Views
Sign On After 30? ( 1 2 3... Last Page)
34 Replies, 3,110 Views
Queries about Cpib application ( 1 2 3... Last Page)
1,091 Replies, 501,095 Views
MINDEF DXO (All FAQ on it) ( 1 2 3... Last Page)
3,298 Replies, 1,911,090 Views
Ceca
2 Replies, 304 Views
Changi Airport Group ( 1 2 3... Last Page)
378 Replies, 335,240 Views
Feeling helpless, need advice... ( 1 2)
11 Replies, 1,029 Views
Anyone working in NTU... ( 1 2 3... Last Page)
91 Replies, 93,152 Views
AML/Compliance/KYC professionals... ( 1 2 3... Last Page)
1,380 Replies, 565,532 Views
Powered by vBadvanced CMPS v3.2.2



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


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