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

No comments:

Post a Comment