Vertical Analysis of an Income Statement in Excel by Chris Menard

[@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

[@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.

[@cherryangel4648]

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

[@ChrisMenardTraining]

You are very welcome

[@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.

[@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!

[@Master_Reven]

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

[@ChrisMenardTraining]

Glad to help

[@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.

[@patriciaikeda2608]

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

[@ChrisMenardTraining]

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

[@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.

[@ezekieljohnson9255]

Watched this before a test and it really helped

[@ChrisMenardTraining]

Thank you!

[@JoseVistoso-c9g]

This was extremely helpful. Thanks for the upload Chris

[@shanknwn6811]

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

[@matthewwitter3656]

Chris you are a godsend.

[@ChrisMenardTraining]

Thanks Matthew.

[@dannyjr4968]

AYE CHRIS LETS GO THIS WAS GONNA TAKE ME HOURS

[@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.

[@D22-c8h]

should i divide by revenue or total revenue?

[@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.

[@montagecentral1379]

Dude you are a legend

[@ChrisMenardTraining]

Thank you!

[@bigpapi6843]

True savior

[@Roy-hp1yy]

helped me out, thank you!

[@Roy-hp1yy]

explained it quickly and easily

[@ChrisMenardTraining]

You're welcome!

[@munenefelix5071]

Good work mate. Thanks

[@ChrisMenardTraining]

You are welcome.

[@andreausa123]

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

[@lazovinceanthony7980]

Thank you very much.

[@ChrisMenardTraining]

You are welcome!

[@theministryofgraceandtruth9308]

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

[@studentinfograficscityuniv955]

thank u so much sir great job

[@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).

[@studentinfograficscityuniv955]

love you sir great wishes for u thank u so much

[@ChrisMenardTraining]

Thank you! I appreciate the positive feedback.

[@Yassi_gorl]

How can i get percentage without using excel?

[@tharindubandara295]

thank you sir

[@ChrisMenardTraining]

Most welcome

[@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.

[@Noa......]

No link to template?

[@lucawinkel5308]

thanks so much bro

[@mdraselrasel5982]

Thanks again,,

[@ChrisMenardTraining]

Always 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.

[@petermessineo2854]

you are a god

[@ChrisMenardTraining]

Thanks, Peter.

[@ivinitmittal]

thanks!

[@ChrisMenardTraining]

Welcome!

[@BC-ri7im]

very helpful thanks

[@ChrisMenardTraining]

Not a problem.

[@alveenoor]

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

[@ibrahimnasir8501]

thanks unk

[@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!

[@spectra7gaming471]

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