Computación básica para alumnos secundaria Carlos Fernández Muriano
Search This Blog
Sunday, 4 August 2013
Excel: Balance sheet analysis and results
Accounting as a system of information processing reaches its full potential in the analysis of balance sheet and income statement, because it allows a number of techniques used to diagnose the economic situation of the company and from it to make good decisions by both the internal address as by external stakeholders affected by the progress of the company.
Balance analysis can be performed from multiple points of view, for example: Legal, fiscal, labor, property, financial, economic, trade, economy, etc.. And can be used numerous techniques: Comparison, percentages, ratios, index numbers, etc..
The Excel application following is an update and adaptation to Spanish accounting system on one previously published in this blog. Executed application are introduced to the pooled data of the balance sheet and income statement data sheet, resulting in other leaves, a simplified analysis, because it uses a small number of ratios, financial position, profitability, and management of the company. This is done using techniques percentages, ratios and their graphic representation, with the possibility to compare four periods simultánemente.
http://empiezoinformatica.files.wordpress.com/2013/08/analisis_de_balances2.xlsx
Labels:
Accounting,
balance sheets,
Excel
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment