# Excel Finance Class 14: Financial Statement Ratio Analysis – #1 Trick For Ratio Analysis

Skip to content
# Excel Finance Class 14: Financial Statement Ratio Analysis – #1 Trick For Ratio Analysis

##
34 thoughts on “Excel Finance Class 14: Financial Statement Ratio Analysis – #1 Trick For Ratio Analysis”

### Leave a Reply

All About Finance

Forward looking (Finance) use End Balance Sheet FA and Sales for the Year. In Accounting (backward looking) average the beg and end FA numbers and divide by the sales for the year.

very helpful. Thanks a lot.

You are welcome!

That was GREAT!! .. Thanks a lot

Thank you ^^.

@Nazca0509 , your are welcome!

@aaboualy03 , I am glad that you liked it!!!

Hello. Great video. Thanks. Is the link not working anymote?

It is working.

Michael , Finance&ExcelCh03.pdf HandwrittenNotes(pdfFile) link doesn't work ……

Great Teaching !!! thanks in zillions .;-)

The college web site was down. It should be back up now.

people.highline.edu/mgirvin/excelisfun.htm

Excel Finance Class Series section

Try this link:

people.highline.edu/mgirvin/AllClasses/233/233classdocuments/Busn233HomePage.htm

This goes directly to the Highline Busn 233 Class web site

Just what I was looking for! Thank You!!

Don't know who you are but you are the greatest. Thanks for the lessons, they really did wonders in my Excel and Business Finance classes.

You are welcome!

sir ji thankssssssssss

this is really helpful

Great stuff!

its very nice

Hi, thank you so much for these great videos. I am learning a lot. But do you have like monthly progress reporting format in excel ?

Dude. You're amazing. You are the future of online education dude !!

its very help full.

Hello. How do I know which file to download? Thanks in advance

I looked for file Busn233Ch03 via Ctrl + F and it is not available. Is it located under another title?

do you have a link for the Ratio excel? between all 11 chapters, I'm not sure where this particular excel is located

Hello, can I download Excel to figure cash flow ratio? Thank you so much.

Mr. Mike can i get that pdf copy?

Thanks !

I am enjoying finance alot now.

A very good video. Thank you, Mike. This production is from 2010, but I do not think that anything in this area of finance has changed that much. And I think I have seen an update on this topic somewhere in the ExcelIsFun series. Excel for finance is one focused area that I have not covered yet. With all the business operations background that Mike puts into these productions, it is worth studying the subject, if you have no business training background or experience in business reports and operations.

Thank You!!

COMPLETE INFO! In God we trust! How can i thank you?

how can I use ratios to create a bankruptcy prediction model in excel?