Excel Finance Class 14: Financial Statement Ratio Analysis - #1 Trick For Ratio Analysis
Loading...
Loading...
12,455
Loading...
Uploader Comments (ExcelIsFun)
see all
All Comments (8)
-
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.
-
thank you, your vid is really useful. But I have some questions... I was wondering how do I calculate the average ratios of say... fixed assets to sales? Do I just find the ratio for each year in the balance sheet... say 2000 and 2001 and 2002 and then add those, divide by 3??
Loading...
11:23
Excel Finance Class 15: Common Sized Financial Statementsby ExcelIsFun4,029 views- 14:10
Excel Finance Class 16: Liquidity, Current Ratio and How Current Ratio Can Be Manipulatedby ExcelIsFun5,364 views
- 6:15
Excel Finance Class 13: Banks, Fundamental Problem With Banks, & The Big Shortby ExcelIsFun2,784 views
- 13:11
Excel Finance Class 12: Cash Flow Advantage To Debt & Average and Marginal Tax Ratesby ExcelIsFun3,740 views
- 46:24
Excel Finance Class 08: Intro To Corporate Financial Managementby ExcelIsFun7,845 views
- 1:28:41
2/15/11: Financial Modeling/Managementby UCBerkeleyHaas4,920 views
- 34:47
Excel Finance Class 09: Balance Sheet, Working Capital, Liquidity, Debt, Equity, Market Valueby ExcelIsFun10,577 views
- 38:26
Excel Finance Class 11: Finance Cash Flow From Accounting Informationby ExcelIsFun11,791 views
- 21:35
Excel Finance Class 10: Income Statement, Non Cash Depreciation Expense, Matching Principalby ExcelIsFun5,419 views
- 14:49
Excel Finance Class 01: Intro To Excel 2007 & 2010by ExcelIsFun16,024 views
- 1:06:46
HMP 607 - 20. Financial Analysis and Planningby openmichigan9,337 views
- 20:39
Excel Finance Class 02: Getting Started with Formulas, Functions, Formula Inputs and Cell Referencesby ExcelIsFun8,989 views
- 24:50
Excel Finance Class 03: Math Operators and Order of Operationsby ExcelIsFun5,399 views
- 12:18
Financial Ratio Analysis Part Iby JPHarrisDBA2,090 views
- 31:21
Understanding Financial Statements Part-1by ignousoms17,709 views
- 10:12
Financial Analyst & Business Analyst Training Programby puresvideo6,341 views
- 50:12
Ratio Analysisby ignousoet28,879 views
- 5:46
1 - The Four Core Financial Statementsby larrywalther18,560 views
- 5:50
Excel Finance Class 30: Future Value For Interest Paid Daily, But Deposits Made Monthlyby ExcelIsFun1,685 views
- 14:54
Excel Finance Class 60: Basics Of Financial Marketsby ExcelIsFun1,470 views
Thank you ^^.
Nazca0509 3 weeks ago
@Nazca0509 , your are welcome!
ExcelIsFun 3 weeks ago
That was GREAT!! .. Thanks a lot
aaboualy03 7 months ago
@aaboualy03 , I am glad that you liked it!!!
ExcelIsFun 3 weeks ago
very helpful. Thanks a lot.
hanajierong 8 months ago
You are welcome!
ExcelIsFun 8 months ago