Trial Balance and Adjustments

Describe and analyse the role of accounting information in a business context.

Analyse a set of financial statements including balance sheet, profit and loss accounts and cash flow statements.

Demonstrate the relationship between accounting data and financial planning and resource allocation decisions. 

1 a. Trial balance is an accounting report which contains the balance of all the general ledger accounts of an organization. It is generated at the end of the accounting period using the ledgers. The debit contains all the assets and the expenses while the credit side contains liabilities equities and revenue earned by the company. The balances which are to be debited are listed in the debit column while the balances which are to be credited is listed in the credit column. The total of debit column in the trial balance should be equal to the total of credit column in the trial balance.

After preparing the unadjusted trial balance, the final adjusted trial balance is made by taking into account all the entries which were either wrongly entered or missed while making the trial balance. In the given question, the adjustment entries were made for

Closing inventory

Depreciation of both Equipment and Motor vehicles

Prepayment of Rent

Accrual of Telephone bill

Heat and lighting expense

Accrual of tax

The trial balance and adjustment entries are given below:

B. Income statement also called profit and loss statement is one of the most important financial statements. It is important as it tells about the profitability of the company. The Income statement contains the sources of revenue of the company and the various expenses involved in conducting the business. It tell about the business if it is able to generate profit or not and if the investors should invest in the company. The income statement can be divided into operating part and non operating part. The operating part contains the revenue, expense, which are involved due to daily activities of the business. The non operating part contains expense which does not involve daily activities.

Income statement using the adjusted trial balance is given below:

Thus from the income statement in can be seen that the Profit earned by the company is 16350.

C. Balance Sheet of the company is one of the most important financial statements used by the investors. It represents the financial condition of the company on a specified date. It contains the assets and liabilities owned by the company and the amount invested by the shareholders. Also the balance sheet holds the accounting equation Assets = Liabilities + Shareholder Equity

Income Statement and Profitability Analysis

The assets are the documented in the top of balance sheet and is arranged in the order of liquidity with the most liquid assets first. The assets contain current assets and non current assets. The current assets are either cash or cash equivalent which can be converted to cash in less than a year. It consists of cash, prepaid expense, account receivables and inventory.  The non current assets take longer time to convert to cash (more than a year). It consists of equipment, long term investment and intangible assets.

The liabilities of the company are the amount the company owes to various account holders. It contains current liabilities and non current liabilities. The current liabilities of the company have to be paid by the company in less than a year. The non current liabilities of the company have to be paid by the company in a longer time (more than a year).

The shareholder equity is the last part of the balance sheet. The money invested by the shareholders for running the business is called shareholder equity. It contains the money invested while starting the business and the retained earning which is the profit earned by the company and reinvested in the business. The equity of the company helps in understanding if the business is financed by the owners or the company has taken a debt to finance its business. If the debt taken by the company is low, then the risk of the company is lower as the company will have to not have to pay back to the investors immediately and can reinvest the money earned for the growth of the company. If the debt taken by the company is high then the risk of the company is higher as the company will have to pay back to the debtors at the end of the period.

The Balance Sheet of the company for 2016 is prepared using the adjusted trial balance

2: For the ratio analysis, the two UK’s main airline companies I have chosen from the list provided are British Airways and Ryan Air.

The annual reports of the two companies (British Airways and Ryan Air) were downloaded for the year 2013, 2014, and 2015.

The main aim of the business is to generate profits for its shareholders. The capability of a company to make profits is called Profitability of the company. The income earned by the company is through the sales of goods and services by the business. The company has to incur expense to generate this revenue in the business. Profits are calculated by removing all the expenses incurred in the business from the revenue earned. The profitability ratios help in finding if the business of the company is able to earn profits. The profitability ratios calculated for the two companies are Net Profit Margin and Return on Assets

Balance Sheet and Financial Condition Analysis

Net Profit Margin: The Net Profit Margin is defined as the profit earned by the company per unit of sales revenue earned. It is given by Net Profit/ Sales. If the company is able to generate more profits per unit of sales then the Net Profit Margin is higher. Thus the company will be able to pay for its expenses easily from the revenue earned. (Profit Margin Ratio)

For the company Ryan Air,

For the year 2013,

The net profit = € 569.3 M

The total revenue from sales = € 4884 M

Thus Net Profit Margin = 569.3/ 4884 = 11.66 %

For the year 2014,

The net profit = € 522.8 M

The total revenue from sales = € 5036.7 M

Thus Net Profit Margin = 522.8/ 5036.7 = 10.38 %

For the year 2015,

The net profit = € 866.7 M

The total revenue from sales = € 5654 M

Thus Net Profit Margin = 866.7/ 5654 = 15.33 %

The Profit Margin of Ryan Air has increased since 2013. Thus the company is performing well which is sign of growth of the company.

For the company British Airways,

For the year 2013,

The net profit = £ 281 M

The total revenue from sales = £ 11421 M

Thus Net Profit Margin = 281/ 11421 = 2.46 %

For the year 2014,

The net profit = £ 702M

The total revenue from sales = £ 11719 M

Thus Net Profit Margin = 702/ 11719 = 5.99 %

For the year 2015,

The net profit = £ 2508 M

The total revenue from sales = £ 11333 M

Thus Net Profit Margin = 2508/ 11333 = 22.13 %

The Profit Margin of British Airways has increased by more than 10 times since the year 2013. Thus the company is performing well which is sign of growth of the company.

Return on Assets: Return on Assets is defined as the profit earned by the company for the investment in the assets. It is given by Net Profit/ Average Assets. If the Return on Assets is high then the company is able to utilize its assets efficiently. (Return on Assets Ratio – ROA)

For the company Ryan Air,

For the year 2013,

Return on Assets = 569.3/ [(9001 + 8943)/ 2] = 6.35%

For the year 2014,

Return on Assets = 522.8/ [(8943 + 8812.1)/ 2] = 5.89%

For the year 2015,

Ratio Analysis of British Airways and Ryanair

Return on Assets = 866.7/ [(8812.1 + 12185.4)/ 2] = 8.26%

The return on assets for Ryan Air has increased since the year 2013. Thus the company has used its assets efficiently.

For the company British Airways,

For the year 2013,

Return on Assets = 281/ [(11136 + 11921)/ 2] = 2.44 %

For the year 2014,

Return on Assets = 702/ [(11921 + 13426)/ 2] = 5.54 %

For the year 2015,

Return on Assets = 2508/ [(13426 + 15376)/ 2] = 17.42 %

The return on assets for British Airways has increased by more than 8 times since the year 2013. Thus the company has used its assets very efficiently.

Liquidity Ratio: Liquidity Ratio of a company helps in determining if the company will be able to pay its short and long term debt using the current assets it has. The liquidity ratios calculated for the two companies are Current Ratio and Cash Ratio

Current Ratio: The current ratio of a company is its ability to pay its current liabilities using the current assets owned by the company. It is calculated as current assets/ current liabilities. (Current Ratio)

For the company Ryan Air,

For the year 2013,

Current Assets = € 3763.6 M

Current Liabilities = € 1911.7 M

Thus current ratio = 3763.6/ 1911.7 = 1.97

For the year 2014,

Current Assets = € 3444.3 M

Current Liabilities = € 2274.5 M

Thus current ratio = 3444.3/ 2274.5 = 1.51

For the year 2015,

Current Assets = € 5742 M

Current Liabilities = € 3346 M

Thus current ratio = 5742/ 3346 = 1.71

The current ratio for Ryan Air has decreased since the year 2013. Hence the company will not be able to cover its current debt as easily as before.

For the company British Airways,

For the year 2013,

Current Assets = £ 2915 M

Current Liabilities = £ 4627 M

Thus current ratio = 2915/ 4627 = 0.63

For the year 2014,

Current Assets = £ 3583 M

Current Liabilities = £ 5502 M

Thus current ratio = 3583/ 5508 = 0.65

For the year 2015,

Current Assets = £ 3400 M

Current Liabilities = £ 5700 M

Thus current ratio = 3400/ 5700 = 0.59

The current ratio for British Airways has declined since the year 2013. Hence the company will not be able to cover its current debt as easily as before.

Cash ratio: The cash ratio of a company is its ability to pay its current liabilities using the cash owned by the company. It is calculated as cash/ current liabilities.

For the company Ryan Air,

For the year 2013,

Cash ratio = 1240.9/ 1911.7 = 0.65

For the year 2014,

Cash ratio = 1730.1/ 2274.5 = 0.76

For the year 2015,

Cash ratio = 1184.6/ 3346 = 0.35

The cash ratio for Ryan Air has decreased since the year 2013. Hence the company will not be able to cover its current debt as easily as before and the cash of the company has reduced significantly.

For the company British Airways,

In the year 2013,

Cash ratio = 1850/ 4627 = 0.40

In the year 2014,

Cash ratio = 2523/ 5502 = 0.45

In the year 2015,

Cash ratio = 2047/ 5700 = 0.36

The cash ratio for British Airways has decreased since the year 2013. Hence the company will not be able to cover its current debt as easily as before.

Efficiency ratios:

The efficiency ratio helps in finding if the company can use its resources efficiently to generate profits. The two efficiency ratio calculated for the two companies are Total Assets Turnover ratio and Equity Turnover ratio.

Total Assets Turnover ratio: It helps in finding how efficiently the company can use its assets to generate sales. It is given by the net sales/ Average total assets (Asset Turnover Ratio)

For the company Ryan Air,

For the year 2013,

Total Assets turnover ratio = 4884/ [(9001 + 8943)/ 2] = 0.54

For the year 2014,

Total Assets turnover ratio = 5036.7/ [(8943 + 8812.1)/ 2] = 0.57

For the year 2015,

Total Assets turnover ratio = 5654/ [(8812.1 + 12185.4)/ 2] = 0.54

The Total Assets Turnover ratio for Ryan Air has not changed effectively since the year 2013.

For the company British Airways,

In the year 2013,

Total Assets turnover ratio = 11421/ [(11136 + 11921)/ 2] = 0.99

In the year 2014,

Total Assets turnover ratio = 11719/ [(11921 + 13426)/ 2] = 0.92

In the year 2015,

Total Assets turnover ratio = 11333/ [(13426 + 15376)/ 2] = 0.79

The Total Assets turnover ratio for British Airways has decreased since the year 2013.

Equity turnover ratio: It helps in finding how efficiently the company can use investment by owners to generate sales. It is given by the net sales/ Average equity.

For the company Ryan Air,

For the year 2013,

Equity turnover ratio = 4884/ [(3306.7 + 3272.6)/ 2] = 1.48

For the year 2014,

Equity turnover ratio = 5036.7/ [(3272.6 + 3285.8)/ 2] = 1.54

For the year 2015,

Equity turnover ratio = 5654/ [(3285.8 + 4035.1)/ 2] = 1.54

The Equity turnover ratio for Ryan Air has increased since the year 2013.

For the company British Airways,

For the year 2013,

Equity turnover ratio = 11421/ [(2255 + 868)/ 2] = 7.31

 For the year 2014,

Total Assets turnover ratio = 11719/ [(2255 +1900)/ 2] = 5.64

For the year 2015,

Total Assets turnover ratio = 11333/ [(1900+ 4398)/ 2] = 3.59

The Equity turnover ratio for British Airways has decreased by since 2013.

Thus from the above analysis it can be concluded that the performance of British airways is better than Ryan air.

References

Averkamp, H. (n.d.). What is a trial balance? Retrieved on August 6, 2016 from https://www.accountingcoach.com/blog/what-is-a-trial-balance

Investopedia. (2013). Income Statement. Retrieved on August 6, 2016 from https://www.investopedia.com/terms/i/incomestatement.asp

Investopedia. (n.d.). Balance Sheet. Retrieved from https://www.investopedia.com/terms/b/balancesheet.asp

White Claire. (2015). Why are efficiency ratios important to investors. Retrieved from https://www.investopedia.com/ask/answers/032615/why-are-efficiency-ratios-important-investors.asp

Chand, S. (2015). Ratio Analysis: Meaning, Classification and Limitation of Ratio Analysis. Retrieved 30 July, 2016, from https://www.yourarticlelibrary.com/financial-management/ratio-analysis-meaning-classification-and-limitation-of-ratio-analysis/29418

Investopedia. (n.d.). Profitability Ratios. Retrieved from https://www.investopedia.com/terms/p/profitabilityratios.asp

MyAccountingCourse. (n.d.). Efficiency Ratios. Retrieved from https://www.myaccountingcourse.com/financial-ratios/efficiency-ratios

MyAccountingCourse. (n.d.). Liquidity Ratios. Retrieved from https://www.myaccountingcourse.com/financial-ratios/liquidity-ratios