Live Chat Support

Tuesday, July 15, 2014


Abella Company
Income Statement
For the year ending December 31
2013 2012 2010
Revenues    45,000.00    35,500.00    37,900.00
Operating Expenses
Salaries    15,000.00    13,400.00    10,500.00
Maintenance and Repairs      6,000.00      7,500.00      4,300.00
Rental Expense      7,000.00      7,000.00      7,000.00
Depreciation      3,500.00      3,500.00      3,500.00
Gasoline      4,300.00      3,950.00      2,460.00
Total    35,800.00    35,350.00    27,760.00
Gross Profit      9,200.00          150.00    10,140.00
Admin. Expenses      3,700.00      3,150.00      2,800.00
Interest      2,800.00      2,650.00      2,200.00
Total      6,500.00      5,800.00      5,000.00
Net Income / (Loss)      2,700.00    (5,650.00)      5,140.00
Requirements:
1. Compute for the gross margin ratio for each years and comment on the trend.
2. Make a recommendation on how could Abella Company can improve earnings.


Common Size Analysis
For the year ending December 31
2013 2012 2011
$ % $ % $ %
Revenues          45,000 100.00%          35,500 100.00%      37,900 100.00%
Operating Expenses
Salaries          15,000 33.33%          13,400 37.75%      10,500 27.70%
Maintenance and Repairs            6,000 13.33%            7,500 21.13%        4,300 11.35%
Rental Expense            7,000 15.56%            7,000 19.72%        7,000 18.47%
Depreciation            3,500 7.78%            3,500 9.86%        3,500 9.23%
Gasoline            4,300 9.56%            3,950 11.13%        2,460 6.49%
Total          35,800 79.56%          35,350 99.58%      27,760 73.25%
Gross Profit            9,200 20.44%                150 0.42%      10,140 26.75%
Admin. Expenses            3,700 8.22%            3,150 8.87%        2,800 7.39%
Interest            2,800 6.22%            2,650 7.46%        2,200 5.80%
Total            6,500 14.44%            5,800 16.34%        5,000 13.19%
Net Income / (Loss)            2,700 6.00%          (5,650) -15.92%        5,140 13.56%
2013 2012 2011
Gross Margin Ratio 20.44% 0.42% 26.75%
Net Margin Ratio 6.00% -15.92% 13.56%
Abella Company
Trend Analysis
For the year ending December 31
Variance/ Trend
2013 2012 2011 2013 2012
Revenues    45,000.00    35,500.00    37,900.00 18.73% -6.33%
Operating Expenses
Salaries    15,000.00    13,400.00    10,500.00 42.86% 27.62%
Maintenance and Repairs      6,000.00      7,500.00      4,300.00 39.53% 74.42%
Rental Expense      7,000.00      7,000.00      7,000.00 0.00% 0.00%
Depreciation      3,500.00      3,500.00      3,500.00 0.00% 0.00%
Gasoline      4,300.00      3,950.00      2,460.00 74.80% 60.57%
Total    35,800.00    35,350.00    27,760.00 28.96% 27.34%
Gross Profit      9,200.00          150.00    10,140.00 -9.27% -98.52%
Admin. Expenses      3,700.00      3,150.00      2,800.00 32.14% 12.50%
Interest      2,800.00      2,650.00      2,200.00 27.27% 20.45%
Total      6,500.00      5,800.00      5,000.00 30.00% 16.00%
Net Income / (Loss)      2,700.00    (5,650.00)      5,140.00 -47.47% -209.92%

Interpretation
In making a comparative analysis, management can use two methods to evaluate the performance of the business. These are the common-size or vertical method, which evaluates the relationship or impact of each financial component to one another, and the trend or horizontal analysis, which determine how each component changes over a period. Both of these methods helps the management assess the flow of the business and develop a strategic plan for improvement.

Using the comparative income statement of Abella Company, we perform the vertical and horizontal analysis. The figure reflects Abella’s inconsistency in terms of profitability. In 2011 and 2013, the company managed to earn positive amount but in 2012, the result of operation is net loss. The net margin ratios for the three years are as follows, 13.56%, -15.92%, and 6%. Abella seems to have a problem in 2012 wherein their sales dropped by 6.33% compared to 2011 sales, while operating expenses increases in big margin. Although the company managed to post a net income in 2013, it is still a downward trend as compared to 2011 result of operation.
Recommendation

Looking at the breakdown of all the expenses incurred by Abella for the past three years, most of the cost came from the salaries, rental, and maintenance. These three components comprises more than 60% of the total expenses, thus, most of the revenues were used to pay them. Although the rental cost does not change, there were a significant change in the amount of salaries and maintenance for the year 2012 and 2013. The company’s expenses are constantly increasing while the sales remain flat.


Therefore, the management needs to revisit the component of the salaries and the maintenance expenses. The change in the operating salaries should reflect in the earnings or sales volume the company has. In addition, the company must check if there is a need to buy new facilities rather than having them repaired. New equipment will contribute better in sales generation rather than fixing old machines that requires added expenses.

No comments:

Post a Comment