Vertical Analysis of an Income Statement in Excel by Chris Menard
HTML-код
- Опубликовано: 5 окт 2024
- 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...
○ RUclips 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! - Хобби
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!
Thanks, Shanon. Great comment and I appreciate it.
You just saved my night & taught me to complete a project in under 6 mins.. God bless your work Mr. Menard
Thank you!
Thank you, this just saved me a whole bunch of time on my accounting project.
Thanks Daniel
💖Thank you so much,Sir.This is really helpful for my homework.From: Philippines 🇵🇭 (Asian)
You are very welcome
After all this years you still helping people just like me, thank you kind Chris!! you're a lifesaver.
Thank you! That is a great compliment.
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.
You're welcome! Thank you, Karen.
Thank you! My accounting class made this much more confusing then needed
They usually do. :-) Good luck with your studies.
thank you so much, you just get me out from the confusion that i had for a few days
Glad I could help!
Thank you my homework is due in less than 2 hours and this is coming in clutch.
Glad to help
Watched this before a test and it really helped
Thank you!
Wow excel is truly amazing I wish they showed us how to do accounting in excel like this. Very helpful and thanks a lot.
Thank you.
Thank you very much. Your method is so easy and saved me a lot of time, trying to do the analysis.. !
You are welcome!
thank you so much!!!!!!! you will never believe how much you helped me!!!!!
Thank you.
Thank you so much! This has definitely helped me in my accounting subject. Done subscribing!
This was extremely helpful. Thanks for the upload Chris
Chris you are a godsend.
Thanks Matthew.
AYE CHRIS LETS GO THIS WAS GONNA TAKE ME HOURS
Dude you are a legend
Thank you!
True savior
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.
You're very welcome!
helped me out, thank you!
explained it quickly and easily
You're welcome!
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.
Thank you. Helped me start and complete my homework!
Glad to help. I'll have a horizonal analysis (aka trend analysis) out later this week).
Good work mate. Thanks
You are welcome.
Thanks for the video, I can hear your cute doggie shaking his collar in the background :)
Katie, that is true. Funny you heard that.
thank u so much sir great job
thank you sir
Most welcome
Thank you very much.
You are welcome!
thanks so much bro
love you sir great wishes for u thank u so much
Thank you! I appreciate the positive feedback.
Thanks again,,
Always welcome
should i divide by revenue or total revenue?
Sir. Can you make video on how we do index analysis of income and balance sheet
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.
thanks!
Welcome!
you are a god
Thanks, Peter.
very helpful thanks
Not a problem.
Dear Sir , could you pls show us how to create a chart for this statement?
Should I use the total sales revenue to be my base amount instead of sales?
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
Chris Menard thanks sir appreciate it.
love you kaka - alvee & shuvo iba bba 30, 6 June 2023
No link to template?
How can i get percentage without using excel?
thanks unk
Hi
How do I download to excel ? Please let me know
Oh yeah not at the college of dupage accounting what is this actually microsoft excel
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!