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??
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 ^^.
Nazca0509 4 weeks ago
@Nazca0509 , your are welcome!
ExcelIsFun 4 weeks ago
That was GREAT!! .. Thanks a lot
aaboualy03 7 months ago
@aaboualy03 , I am glad that you liked it!!!
ExcelIsFun 4 weeks ago
very helpful. Thanks a lot.
hanajierong 8 months ago
You are welcome!
ExcelIsFun 8 months ago
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??
chiatboon 11 months ago
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.
ExcelIsFun 11 months ago