Possible to tweak the spreadsheet to just pull in the numbers for things like interest expense, Total Debt, Free Cash Flow etc from Google Finance like what has been done for Price, Shares outstanding etc? Anyone knows what are the cell names for these?
For those loss making businesses or those burning their cash piles, you can only use metrics like P/S ratio or Earnings growth to value them. But beware that these businesses can crash n burn anytime, like Endowus, so monitor their cash pile diligently.
Sponsor: Tiger Brokers (free stock) kvli.link/tiger
FREE DCF Spreadsheet: ko-fi.com/s/5a7e8be599
INVESTING
► Interactive Brokers kvli.link/ibkr
► Webull (free stock) kvli.link/webull
► moomoo Futu SG (free stock) kvli.link/moomoo
► Tiger Brokers (free stock) kvli.link/tiger
► uSMART (free stock) kvli.link/usmart
► ProsperUs (free stock) CODE "KELVIN20" kvli.link/prosperus
► POEMS Cash Plus kvli.link/poems
► Saxo kvli.link/saxo
► FSMOne CODE "P0425931" kvli.link/fsmone
► moomoo US (free stocks) kvli.link/moomoous
► Syfe kvli.link/syfe
► StocksCafe kvli.link/stockscafe
ROBOADVISORS
► Endowus (free $20) kvli.link/endowus
► Syfe kvli.link/syfe
► MoneyOwl (free $20) kvli.link/moneyowl
► StashAway (50% off fees) kvli.link/stashaway
► AutoWealth (free $20) CODE "KelvinLearnsInvesting" kvli.link/autowealth
► UOBAM Invest kvli.link/uobaminvest
CRYPTO
► Gemini (free $10) kvli.link/gemini
► KuCoin kvli.link/kucoin
► Crypto.com app (free $25) CODE "kelvinlearnsinvest" kvli.link/cryptoapp
► Crypto.com exchange CODE "kelvinlearnsinvest" kvli.link/cryptoexchange
► Coinhako (20% discount) kvli.link/coinhako
► Coinbase (free $10) kvli.link/coinbase
► Independent Reserve kvli.link/independentreserve
► Tokenize Xchange kvli.link/tokenize
► Ledger kvli.link/ledger
► Trezor kvli.link/trezor
RESEARCH
► Seeking Alpha (offer price) kvli.link/seekingalpha
► Simply Wall St kvli.link/simplywallst
► TradingView kvli.link/tradingview
PAYMENT
► Trust Bank (free $10) CODE "R2MQBA4S" kvli.link/trust
► Instarem Amaze CODE "plTefu" kvli.link/amaze
► CardUp ($30 off) CODE "KELINVEST" kvli.link/cardup
► ipaymy kvli.link/ipaymy
► Revolut kvli.link/revolut
► YouTrip (free $5) kvli.link/youtrip
► BigPay (free $5) CODE "QBHVUHL7HU" kvli.link/bigpay
► Wise (free transfer) kvli.link/wise
► SIA Kris+ (free $5) CODE "T425139" kvli.link/krisplus
► DBS Paylah (free $5) CODE "AHVULE614"
► FavePay (free $1) CODE "FAVETANKEL" kvli.link/fave
LIFESTYLE
► Envato kvli.link/envato
► Ohmyhome kvli.link/ohmyhome
Thanks for the simplified and straightforward way on how to use DCF method Kelvin!
v good and instructional video. Thanks!
Thank you!
Also what if companies cash flow is negative
Thank you Kelvin for making this and having a clear & concise explanation in the video! Appreciate it!
What if the company has no interest expense non operating?
Possible to tweak the spreadsheet to just pull in the numbers for things like interest expense, Total Debt, Free Cash Flow etc from Google Finance like what has been done for Price, Shares outstanding etc? Anyone knows what are the cell names for these?
Is there a website to just tell us whether a stock is overvalue or undervalue?
Hi Kelvin, please do some research on Yieldmax etf such as TSLY since you are holding on to TESLA. Perhaps you could do a video on it.
What if the free cash flow is negative? eg for BN4
For those loss making businesses or those burning their cash piles, you can only use metrics like P/S ratio or Earnings growth to value them. But beware that these businesses can crash n burn anytime, like Endowus, so monitor their cash pile diligently.
Useful excel!🎉❤
Very good video!
Safer to use inflation rate for perpetual growth rate