[FABM2] Lesson 039 - Financial Statements Analysis (Horizontal and Vertical with MS Excel)

Hi! This is Sir Chua's Accounting Lessons PH.
_________________________________________________________
FUNDAMENTALS OF ACCOUNTANCY, BUSINESS, AND MANAGEMENT 2
_________________________________________________________
Lesson 039
Analysis of Financial Statements 1:
Horizontal and Vertical Analysis with MS Excel
_________________________________________________________
Freebie:
MS Excel Exercise - FS Analysis
drive.google.c...
_________________________________________________________
Kevin Troy M. Chua, CPA
*Certified Public Accountant, October 2014
*BS Accountancy
*Master in Accountancy (CE Pending)
*NC-III Bookkeeping, TESDA
*Content Developer for Accountancy - Course Hero
*Accounting and Finance Lecturer
*Formerly from PwC - Isla Lipana & Co. and SM
_________________________________________________________
For comments and suggestions, you may put them down respectfully in the comments section below.
_________________________________________________________
For speakership invites, please do not hesitate to shoot an email at [e-mail]
_________________________________________________________
TO GOD BE ALL THE GLORY, HONOR, AND PRAISE FOREVERMORE!

[@user-cc4ew8qt4v]

Because of your videos, sir. Chua i passed my FABM 2 with an average 95. I'm so happy kasi dahil sainyo i learned to analyze transactions and you've changed my perspective in this subject that it's not all about computation, but interpretation also.

[@ysabelleandrie]

Waaahhhh hope all

[@princessestacio9689]

My boss told me to prepare a Financial Analysis of the company and this was my first job. I've no idea how to do it but this video helps me a lot!! Thank you. Continue making a video. Worth of subscribing ❤

[@akosioshie06]

Thank you po sir! :) I'm in my second year college now taking up BS Accountancy at dito ko lang po mas naintindihan at nalaman yung gamit nung nacompute naming amounts sa bawat FS na ginagawa po namin. Thank you po Godbless :)

[@ryancoloma727]

Ang laking factor nung sa boses siiir. Kahit nag pho phone ako while listening, naiintidihan ko pa rin lahat. Keep it up po, salamaat.

[@nysabigcas8259]

SIRRR ACCOUNTING LIFE SEEMS BEARABLE WITH YOUR LESSONS! HUHUHU MAY GOD BLESS YOU,, THANK YOU SIR

[@jeweljoie]

hope that u can make tutorials for income taxation and accounting for special transactions, sir chua 😊

[@jimalyncalustre5628]

thank you sir chua and for our instructor who recommend to watch your videos, thank you and bless you sir😊❤️

[@christinedamayo303]

Sir thank God that I found your UA-cam channel it really helped me a lot...

[@solmeranojohnpatricke.1617]

Happy to found this yt channel. Nakakahabol nako sa mga di ko masyadong maintindihan. Thank you so much sa efforts and passion nyo Sir Chua❤️

[@jenisasumaylo2286]

Thank you sir chua! Sobrang saya ko po na na hanap ko yung channel niyo, ang galing niyo pong mag discuss 😊

[@juliusabueva3303]

Thanks sir. I’m a first year BSA student and this UA-cam channel really helps me a lot. marami akong natutunan.Ito naging sandalan ko simula nag simula class ko. ❤️

[@vanessapatag580]

Hi po, mahirap po ba mag BSA? huhu plaaning to take that course, but..

[@villagelynespanola3101]

Thank you po ..mas naintindihan pa po namin ung pag explain nyu...lalo na po ngaung modular namin....malaki po talaga ang naitulong nyu.... I hope more knowledge that we can get in ur UA-cam channel sir chua....

[@robertuy5309]

Amazing Professor Tutor Sir Chua, Wow, you're an excellent tutor, you made Accounting easy to understand. You're an asset in the Philippines. Your videos motivate us to learn Accounting and review once we forgot it. Thank you so much. God bless. .... happy happy happy enjoying learning while watching your videos because of that i already liked, shared, subscribed and no escaped moments in all your ads. Mwahhh heart heart heart...

[@irishcamilleveracruz1263]

Thank you so much po, Sir Chua! Very informative po, it really helps me to understand our lessons❤️ God bless youu, Sir! 🤍

[@alyssalogronio6616]

Thank you so much sir chua ang galing niyo po magturo ang bilis ko po maanalyze !!Godbless po!♥️♥️

[@kathleenguillermo4715]

Salamat po sir. naintindihan ko na po siya lalo na po sa paggamit ng excel. Salamat po talaga.

[@jalli600]

Sir, thank you very much for your lectures. They've been really my weapon in facing the challenges of being an BSMA student..you inspire me po to pursue taking this path so much that shifting courses stays as a choice to me, for the meantime being.

[@lorenzojax6554]

You all prolly dont give a shit but does anybody know a method to log back into an instagram account?
I somehow forgot my login password. I appreciate any tricks you can offer me

[@ajmedinavlog7699]

super agree..very helpful..sana po pagpatuloy niyo pa po ang mga videos..

[@rosetoquero6870]

Hi sir good morning...im rose toquero from la,libertad Negros oriental...sir yong tutorial nato yong chanel mo simula noong naghanap ako ng tutor...god bless you sir...ang laking tulong po to sakin....god bless po...

[@annalyquijado3367]

Hello sir Daghang salamat for your video ❣️❤️ Nakatulong talaga sya sa report ko. God bless you always sir 🥰☺️

[@enzodapan5016]

Thank You Sir, you just neatly summarized yung nasa book po namin.

[@jmramos2371]

Sobrang saya nga po mag excel sir HAHAHAHA thank you po!❤

[@ajoyce7166]

Ang galing Siiir. Recommend ko po ito sa mga ABM students 🥰

[@user-di6mh9pc5x]

Very well explained Sir!! thank you so much po Sir its a big help po sa akin. God bless you po!!

[@applecamara3147]

Thank you Sir chua, for your lectures. I learned a lot po thank you❤️

[@Glitch_Playz_official]

I got 99 grades in fabm thank you sir i always watch you

[@crudeyeoja4192]

Thank you po Sir Chua. Very helpful and informative po itong video niyo.

[@danielcassion1889]

Thank you po Sir! I understand you well than my teacher! thank you so much

[@aaronpaularongat6731]

Galing mo sir Kahit po hindi ako accounting major medyo nakakasunod po ako kasi magaling ka magpaliwanag

[@banieljulianamarie2952]

so today im cramming due to typhoon Ulysses kasi bhie tinangay din ata ng baha utak ko haha kidding aside, pero sobra dali ko natuto dahil sayo sir huhu thank you po!! keep safe ❤️

[@janlexserrano1616]

concise but very comprehensible, thank you very much ho!!!

[@sheee404]

super thanky dito sir! God bless po. Mas nakakaintindi ako dito hihi

[@leikaporal982]

Thank you so much sir, napaka useful. God bless, ang galingggg ❤❤❤

[@stressednekuuu]

Thank you for this, Sir! I can understand with this so easily!👍🏻

[@caememe]

this is my first video of yours that i've watched sir. subscribed kagad! thank you so much po 🙏

[@reviannerexelc.cornista1770]

Thankyou po sir! Makikicontest po kami and this a great help po! I love those real life situations and jokes/hugot niyooo. Hindi po kayo nakakaboring magturo and mabilis maintindihan. I'm not really the type of person who comments on videos but you're superb po! PAAMPON!! Charot po hahahha

[@christianermis2448]

Maraming salamat po andami ko po natutunan. Godbless po.

[@degumagerson9223]

Thankyou po sir!!! masasagutan ko na activity 6 ko HAHA

[@deaofrecio9568]

Sir, salamat po sa pagtuturo... Mabuhay po kayo! 😊

[@joycekim999]

New subscriber here. Thanks to our adviser for recommending this channel and thank you sir Chua for this lesson. :D

[@erniedevega8028]

Kudos to you sir Chua. Very well explained.

[@teapunny]

생님!! 한국말 너무 잘해요!!! * o *
존경스러워요! 리스펙트 xD
It's currently midnight and I love how an hour passes by like a breeze when I'm watching your videos! It doesn't make me sleepy at all. :O
Maraming salamat po

[@sirchuasaccountinglessonsp3030]

Teapunny 안녕! 감사드립니다!!!

[@CathAarbilo]

thankyouuu po , at last nagets ko din bago mag periodic exam .

[@jenster358]

Thank you sir!!! Yung teacher kase Namin walang tinuro Tas nagpapagawa neto haha

[@maryannlazona3402]

thankyou bigtime sir!! sobrang nakakatulong

[@Kenny-dl4sf]

Thank you so much Sir Chua! Pa shoutout po next vid. UwU

[@michellejanegrafil2986]

Sir chua, hope that i will meet you in actual para mapasalamatan kopo kayo sa personal, Personally I don’t idolize anyone but your my favorite person 😀

[@artsyjaja1989]

Thank you so muchhhh po dito.Super helpful🥺❤️❤️❤️

[@user-kr5id3fg9i]

Thank you so much po sir!

[@carlmarxheinricht.satorre1574]

Thank you so much Sir God bless you po and your family

[@joedielynfelipe2627]

Mas naiintindihan ko pa pag nanonood ako dito sir kesa sa online class :

[@seankareemgaray1345]

Thank you po sir ☺️ exam po Namin bukas malaking tulong ka po☺️ salamat Ng marami

[@cedricktormon9066]

Hindi po accountancy tinatake ko Industrial Engineering need kong matutunan ito kasi ito na sunod na lesson namin maraming salamat po

[@heasookim5120]

thank you sir! may recitation kami bukas huhu wish me luck 😆

[@janryembog2868]

NAPAKA LINAW PO THANKYOUUUUUU!!

[@VanessaOrcio]

Thank you po sir chua i learn a lot po

[@zjenowrenemanalo710]

Myghad thank you sir! 🥺

[@conradocruz206]

Sir my name is apple. Naiiyak ako kasi mas naiintindihan ko po yung pag eexplain nyo kesa sa prof ko actually ang nakakaintindi lang sa prof ko is yung may background learning na ngayon magegets ko na sya😭😭😭 ty po ng marami

[@josangloria2111]

New subscriber here! Very clear and well-explained thank you so much sir. Looking for more videos :))

[@billionabegailg.5149]

Thank you po ☺️

[@raymondgood1458]

Super helpful.. Salamat po sir..

[@markhehehehehehe5502]

Ang sweet sweet nyo Kaso walang label :(( sir gusto ko Lang matuto why Naman ganon joke hahahaha great video sir ! Matututo ka na may hugot pa hahaha

[@kumarbibek2139]

Very nice sir

[@jericho8972]

hala sirr thankk youuuuu po mas naintindihan ko to♥️

[@bossingmgrtv]

Wow! Sir Chua good day, I viewed your FS Analysis as very easy and helpful. I salute you, you made an accounting to non-accounting very easy. Now, I understand how the accountant does things to make things easy for the mngt to do decisions and future action plans. Again, I salute you. You are now my Idol ...Ayos, I will subscribe to you and follow all your lessons. 🥰

[@christinevillamor6353]

Sir chuaaaaaa this isn't related to your lesson po pero I just wanna ask some advice for incoming college like me whose taking BS in Accountancy. What books should I buy and read po? For advance reading purposes and review at the same time na din po.
Ps. Sa mga nakakaalam na rin diyan pashare🙂

[@kylaschoolpurposes5434]

Thank you so much, Sir!

[@baron0968]

Thank you for this, it helps a lot. ^_^

[@jenelynsalinel5282]

tysm sir!

[@xryztalarravelamanalac3659]

Thank youuü pooo ❤❤❤

[@carlomagnoabuel]

Ang ganda ng explanation. Salamat po. Ask ko lang meron din po bang Horizontal Analysis sa Cash Flow Statement? Salamat po

[@jennieferslash5013]

Thank you for this, SIR!!! Tanong lang po, pwede po ba gawan ng Horizontal and Vertical Analysis yung statement of changes in equity?

[@roselierfacturan7697]

Good morning sir...im rose toquero...from la,libertad...

[@maryclairegonzales1028]

Thank you so much sir

[@kristinehernandez4852]

Thank you 😊 💕

[@kharlamaebujactin8482]

very helpful thankyouuuuu

[@Rendigitals]

Thank you sir may answer na ko sa activity namen heheh

[@pleaseremindmetostudy2806]

Thank you!

[@bayefabia4306]

hello, may content po ba kayo ng Comprehensive income (horizontal and vertical analysis)

[@leamaypoloan2073]

Hohoho! Bat ang dali dito anyway thanks po💕

[@watsonswarrior677]

Sana ganito nalang discussion kapag virtual class namin😭

[@sheilamariegasatan3684]

Thank you sir! mas magaling ka pa sa prof kong puro kwento habang nagtuturo AHAHAHAAH

[@ricardlozano9482]

thankyou po sir

[@rheajeanyorong9958]

Thanks sir 😊

[@bebzlifestyle4044]

good morning po, newbie here.
salamat po sir.
pwde po ba mag request, ipakita mu rin yung accounting partnership lalo na yung sa mga reciprocal part.
anyways, bsba po ako at nahihirapan ako ngayon kasi modular po yung class namin.

[@romeolicarte7740]

Thank you! Easier understanding! 😀

[@DuncanNyakundi2023]

Thank you for the videos....... which language are you mixing with???

[@vincentpaulfulmaran8736]

sir ano pa po ba yung mga methods in FS analysis that we will encounter in Collage?

[@HarveySarmiento1111]

THANK YOU PO

[@yessnoo4651]

sir my problem is the question is having non current asset that having a property plant equipment (net) is that gonna compute with the total asset?

[@alvaroallanjay4262]

Sir Chua, ask ko lang po if applicable po ba ung vertical and horizontal analysis sa Cash flow statement?

[@ingkieabm]

how do i interpret the analysis po sir?

[@error20wonnie]

Sir hello po, can I ask a question? Ung first example nyo po ba sa horizontal analysis ayun na po ung example po for financial position? Thankyoupo. If someone wanted to answer thankyouudinnnpo.

[@azucenacurreljane4866]

Hi po, possible po ba na maka compute ng more than 100% sa horizontal and vertical analysis? TIA po.

[@thrianna7236]

Good day, sir! I just wanna ask. Paano if more than 2 years po yung binigay na transaction (2016, 2017, 2018, 2019 and 2020) yung 2016 po ba is leave as blank nalang since wala po siyang prior year?

[@CedPH]

ok lang po ba kahit may 6 decimal places sa percent? bago sumakto sa hinahanap na peso. sa case kopo kasi pag kunware 72% lang nilagay di siya tumutugma sa kinalbasan current year - last year? pero nung triny ko x0.72.... tumugma po tama pa rin poba iyon?

[@user-in1ks4jv1p]

Hello po ask ko lang po sana if ito po ba yung pwede i title dito "Horizontal and vertical analysis solving ratio" meron na din po ba sa video yung solving ratio diba po??

[@trixiealiangan7522]

good day po, how to get the ratio of 2020 to 2019 in Horizontal Analysis? advance thank you for your feedback ✨

[@briananhaw7381]

sir good morning po may tanong po ako hehe what if mas malaki yung amount change kaysa sa base year sa pag divide po?

[@Seamanlife80]

Sa 34:07 pano po naging total ni net sales na 100, Nalabas saken 95.2 ayos lng po yon?