PART A: Calculation of Ratios

  1. Profitability

  1. Financial Stability

  1. Liquidity

  1. Solvency

  1. Management Effectiveness and Procedures

PART B: Analysis of Ratios

1.0 Introduction

        This report has been prepared for Barnaby Trading regarding the business performance analysis for 3 consecutive years from 2003 to 2005. It has been prepared after analyzing the balance sheet and income statement of all three years. Ratios have been derived from these statements in relation to the profitability, financial stability, management effectiveness and procedures of the business.

        These ratios are helpful as it summarize large quantity of data and accounting users to make qualitative judgment about a business financial performance. Using the ratios, we will be able to evaluate how profitable is the business, is the business capable to finance its purchases and expenses, how is the assets being used to generate revenue to the business and much more. The financial performance of the business will be examined using the ratios and then recommendations will be made.

2.0 Profitability

        Profitability is the utmost priority of any business ventures regardless of their nature of business. It is measured with income and expenses. Income is revenue generated from the activities of the business. Expenses are derived from the cost incurred in the operational of the business. Computing profitability is essential in measuring the success of the business. A business which is highly profitable will ensure that the business will still be operational and ensure its owners high returns.

2.1 Gross Profit Margin

        The gross profit margin represents the capacity of the business to generate sufficient profit to cover operating expenses. A higher percentage indicates that the business is in a good financial position and able to earn a reasonable net profit as well as giving a decent return to investors. The formula is as shown below:

        Gross Profit Margin = Gross Profit × 100%

                                           Net Sales

        

        The gross profit margin has shown a significant increase from 40.0% in 2003 to 45.0% in 2004. The rising trend indicates that the business is doing well. Net sales have been increasing steadily from $92000 in 2003 to $98000 in 2004. There is a direct relationship between net sales and gross profit; however gross profit is also determined by the cost of sales. As such the cost of sales has been decreasing from $55200 in 2003 to $53900 in 2004. Thus, gross profit has been rising fairly well from $36800 in 2003 to $44100 in 2004.

        However, the gross profit margin in the year 2005 has fallen to 42.5%. This is due to the fall in net sales from $98000 in the year 2004 to $94000 in the year 2005. Furthermore, the cost of sales has gradually increased from $53900 in 2004 to $54050 in 2005. This has resulted in the fall in gross profit as well to a mere $39950 in 2005.

2.2 Expense Ratio

        The expense ratio is particularly beneficial when the business plans to analyze the variety of expense items to take control actions. It is measured as a percentage of sales rather than in dollar terms. The lower the expense ratio the better as lowering the expense will increase the business profit. The formula is as shown below:

        Expense Ratio = Total Expenses × 100%

                                     Net Sales

        

        The expense ratio has reduced from 34.8% in 2003 to 34.7% in 2004. Although the percentage differs by a mere 0.01%, this indicates that the business performance is improving. Total expenses have increased in 2004 and has cushioned by the drastic rise in the business net sales. Thus, this has lowered the expense ratio.

        In 2005, the expense ratio was 37.2%. Although, total expense had risen, the rising trend of the expense ratio is due to the drastic fall in net sales. As such, both falls in net sales as well as rise in total expenses has contributed to the rise in the expense ratio. If this trend continues, the business needs to take precautionary measurements to reform the expense practice.

2.3 Net Profit Margin

        The net profit margin shows exactly how the business is performing. This will also indicate the business’ control over revenue and expense. This is in contrast of the earlier calculation of gross profit margin as net profit margin also takes into account the total expenses. A business will aim to get a high net profit margin as low ratio implies that there is less possibility of getting profit and require the business to make investigation on expense control methods, pricing practices and also selling techniques.

Net profit margin = _Net profit_ × 100%

                                    Net sales

Join now!

        

        In 2003, the net profit margin was 5.22% and has increased tremendously to 10.31% in 2004. This is due to the huge rise in net profit. The rise in net sales has also contributed as it has cushioned the effect of the rise in total expenses.

        The net profit margin has reduced significantly from 10.31% in 2004 to 5.27% in 2005. There was a significant fall in net profit and was due to the increase in total expenses particularly the increase in wages expenses. The fall in net sales has also contributed the fall in the ...

This is a preview of the whole essay