Vertical Analysis of an Income Statement in Excel by Chris Menard

A vertical analysis is used to show the relative sizes of the different accounts on a financial statement.
www.chrismenardtraining.teachable.com
www.chrismenardtraining.com
Target audience:
Accounting students
MBA students
department managers
business people
Finance students
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtra...
○ Screenshots - Snagit - chrismenardtra...
○ UA-cam keyword search - TubeBuddy - www.tubebuddy....
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[@012shanonrevels]

Omg! Finally, someone that makes sense. Teachers, please learn from this man and stop telling students to just figure it out from your book! That took less than five minutes omg!

[@ChrisMenardTraining]

Thanks, Shanon. Great comment and I appreciate it.

[@senecacs]

You just saved my night & taught me to complete a project in under 6 mins.. God bless your work Mr. Menard

[@ChrisMenardTraining]

Thank you!

[@danielwitzel8669]

Thank you, this just saved me a whole bunch of time on my accounting project.

[@ChrisMenardTraining]

Thanks Daniel

[@cherryangel4648]

💖Thank you so much,Sir.This is really helpful for my homework.From: Philippines 🇵🇭 (Asian)

[@ChrisMenardTraining]

You are very welcome

[@patriciaikeda2608]

Thank you! My accounting class made this much more confusing then needed

[@ChrisMenardTraining]

They usually do. :-) Good luck with your studies.

[@karenwallace3981]

OMG, THANK YOU!!! The only class I ever failed was Acct203 and I am having to retake it now and this video just saved me hours of work. I absolutely love the fast and ease of this video. I am definitely subscribing to your video and saving it to my favorites.

[@ChrisMenardTraining]

You're welcome! Thank you, Karen.

[@jazzyjazxxx]

Thank you, Thank you a billion times your video was easy to understand for my accounting class homework , that at first didn’t understand but you explain it so well now I just finished.

[@ChrisMenardTraining]

You're very welcome!

[@Master_Reven]

Thank you my homework is due in less than 2 hours and this is coming in clutch.

[@ChrisMenardTraining]

Glad to help

[@sergioorozco3335]

After all this years you still helping people just like me, thank you kind Chris!! you're a lifesaver.

[@ChrisMenardTraining]

Thank you! That is a great compliment.

[@nabilahdfah5827]

thank you so much, you just get me out from the confusion that i had for a few days

[@ChrisMenardTraining]

Glad I could help!

[@ezekieljohnson9255]

Watched this before a test and it really helped

[@ChrisMenardTraining]

Thank you!

[@Averagegamerguyyy]

Wow excel is truly amazing I wish they showed us how to do accounting in excel like this. Very helpful and thanks a lot.

[@ChrisMenardTraining]

Thank you.

[@shankarr8018]

Thank you very much. Your method is so easy and saved me a lot of time, trying to do the analysis.. !

[@ChrisMenardTraining]

You are welcome!

[@tess8786]

thank you so much!!!!!!! you will never believe how much you helped me!!!!!

[@ChrisMenardTraining]

Thank you.

[@bahar770]

Thank you. Would it be possible to do a 10 years of comparison study of Financial Statement of a high rise building in Excel? Please help with temp let if possible.

[@bigpapi6843]

True savior

[@user-eq2mp5dp7c]

should i divide by revenue or total revenue?

[@montagecentral1379]

Dude you are a legend

[@ChrisMenardTraining]

Thank you!

[@matthewwitter3656]

Chris you are a godsend.

[@ChrisMenardTraining]

Thanks Matthew.

[@shanknwn6811]

Thank you so much! This has definitely helped me in my accounting subject. Done subscribing!

[@dannyjr4968]

AYE CHRIS LETS GO THIS WAS GONNA TAKE ME HOURS

[@user-lp9gf4mr3l]

This was extremely helpful. Thanks for the upload Chris

[@andreausa123]

Dear Sir , could you pls show us how to create a chart for this statement?

[@katies6401]

Thanks for the video, I can hear your cute doggie shaking his collar in the background :)

[@ChrisMenardTraining]

Katie, that is true. Funny you heard that.

[@Roy-hp1yy]

helped me out, thank you!

[@Roy-hp1yy]

explained it quickly and easily

[@ChrisMenardTraining]

You're welcome!

[@petermessineo2854]

you are a god

[@ChrisMenardTraining]

Thanks, Peter.

[@tharindubandara295]

thank you sir

[@ChrisMenardTraining]

Most welcome

[@mdraselrasel5982]

Thanks again,,

[@ChrisMenardTraining]

Always welcome

[@lucawinkel5308]

thanks so much bro

[@najamusman2095]

Sir. Can you make video on how we do index analysis of income and balance sheet

[@ChrisMenardTraining]

I'll add it to my video list. It will probably be three to four weeks before I can get to it, but it is a great idea for a video. Thank you.

[@lazovinceanthony7980]

Thank you very much.

[@ChrisMenardTraining]

You are welcome!

[@munenefelix5071]

Good work mate. Thanks

[@ChrisMenardTraining]

You are welcome.

[@acedelarosa6127]

Should I use the total sales revenue to be my base amount instead of sales?

[@ChrisMenardTraining]

Good point. I believe you should take Gross Sales and subtract returns and subtract discounts. That leaves you with Net Sales. The Net Sales would be your base and that should be 100%. See if this screen shot helps. chrismenardtraining.com/wp-content/uploads/2018/03/Net-Sales.jpg

[@acedelarosa6127]

Chris Menard thanks sir appreciate it.

[@Yassi_gorl]

How can i get percentage without using excel?

[@studentinfograficscityuniv955]

thank u so much sir great job

[@ivinitmittal]

thanks!

[@ChrisMenardTraining]

Welcome!

[@theministryofgraceandtruth9308]

Hi
How do I download to excel ? Please let me know

[@alveenoor]

love you kaka - alvee & shuvo iba bba 30, 6 June 2023

[@studentinfograficscityuniv955]

love you sir great wishes for u thank u so much

[@ChrisMenardTraining]

Thank you! I appreciate the positive feedback.

[@Letythree21]

Thank you. Helped me start and complete my homework!

[@ChrisMenardTraining]

Glad to help. I'll have a horizonal analysis (aka trend analysis) out later this week).

[@ibrahimnasir8501]

thanks unk

[@BC-ri7im]

very helpful thanks

[@ChrisMenardTraining]

Not a problem.

[@spectra7gaming471]

Oh yeah not at the college of dupage accounting what is this actually microsoft excel

[@HarpManOfPerth]

knowledge without a good explanation is a waste if you are doing teaching because many people have the knowledge but they don't know hoe to explain or make it interesting!