Preparation of Income Statement and Balance Sheet with the help of Financial Ratios

Share Accounting Article below:

Sometimes examination questions may require the candidates to prepare financial statements with the help of a given set of financial ratios. In these cases at least one item is given in monetary terms and is used as the starting point in the process of preparing financial statements. The process begins with the identification and use of that ratio which includes the given numerical item and then proceeds with the numerical values of item given in the question and new item calculated by interpolating the figures of the first ratio.

Solved Example 1:

The following ratios relate to a sole proprietorship Bestworth Deals for the year ending 31 March 2015.

(i) Inventory turnover = 6 times

(ii) Trade receivables collection period = 2 months

(iii) Trade payables payment period = 73 days

(iv) Gross profit ratio (as a percentage of sales) = 20.0%

(v) Gross profit = $60000

(vi) Profit for the year as a percentage of sales = 6.3%

(vii) Non-current assets turnover = 5 times

(viii) Current ratio = 2.1:1

Required:

Prepare an income statement and balance sheet in as much details as possible.

Solution:

Bestworth Products 

Income Statement for the year ended 31 March 2015

income statement with ratios

Bestworth Deals 

Balance Sheet as at 30 June 2015

balance sheet with ratios

Workings Example 1:

sales

 average inventory

average inventory calculation

non-current asset turnover ratio calculation

trade receivables collection period calculation

trade payables payment period calculation

 current ratio calculation

Solved Example 2:

The following information is related to Muaz Ahmad for the year ending 31 December 2015:

(i) Inventory turn over rate (based on closing stock/inventory) = 1.25 times

(ii) Trade receivables turn over rate (days) = 180 days

(iii) Trade payables turnover rate (days) = 144 days

(iv) Gross profit ratio = 25.0% of sales

(v) Administration expenses = 9.0% of sales

(vi) Distribution expenses = 6.0% of sales

(vii) Interest on 10% loan = ?

(viii) Net profit ratio = 5.0% of sales

(ix) Return on total assets = 5.0%

(x) Non-current assets turnover = 1.25 times

(xi) Current ratio = 2.5:1

(xii) Sales (all on credit) = $100000

Required:

Prepare an income statement for the year ending 31 December 2015 and a balance sheet at that date in as much detail as possible.

You may also assume that there are 360 days in a year.

Solution:

Muaz Ahmad

Income statement for the year ended 31 December 2015

example 2 - income statement

Muaz Ahmad

Balance sheet as at 31 December 2015

balance sheet with ratios 2

Workings Example 2:

w.1 - example2

w.2-example2

w.3-example2

w.4-example2

w.5-example2

w.6-example2

w.7-example2