Computación básica para alumnos secundaria Carlos Fernández Muriano
Search This Blog
Monday, 5 August 2013
Excel: Analysis of profitability
The study of the economic productivity of the company is carried out by determining the results achieved in the various activities carried out, but they may have different interpretations, depending on the variable that is related: active, net assets, sales, etc. .
In Balance Analysis application are considered the following:
- Financial return: ie profits plus interest, in relation to the total resources used.
- Return on equity (ROE)
- Overall profitability: the benefit is related to total resources.
- Share Capital.
- Profit on sales.
- Sales margin.
The results are expressed in percentages and are calculated for four periods or different exercises, with the aim of making comparisons and the progress of the company in the short term.
see Excel sheet:
http://empiezoinformatica.files.wordpress.com/2013/08/analisis_de_balances-12.xlsx
Labels:
Excel,
Profitabily analysis
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment