Question

From the following Balance Sheets of X Ltd. as at 31st March, 2016 and 2015, prepare a common size Balance Sheet.
$\begin{array}{ccccc}\text{Particulars}& & \text{Note}& \text{Amount (Rs)}& \text{Amount (Rs)}\\ & & \text{No.}& 31-3-2016& 31-3-2015\\ \text{1. Equity and Liabilities}& & & & \\ \text{(1) Shareholders' Funds}& & & & \\ \text{(a) Share Capital}& & & 80,00,000& 60,00,000\\ \text{(b) Reserves and Surplus}& & & 12,00,000& 8,00,000\\ \text{(2) Non-current liabilities}& & & & \\ \text{Long term borrowings}& & & 24,00,000& 20,00,000\\ \text{(3) Current liability : Trade Payables}& & & 4,00,000& 12,00,000\\ & \text{Total}& & 1,20,00,000& 1,00,00,000\\ \text{II. Assets}& & & & \\ \text{(1) Non-current Assets}& & & & \\ \text{Fixed Assets}& & & & \\ \text{(a) Tangible}& & & 80,00,000& 60,00,000\\ \text{(b) Intangible}& & & 4,00,000& 12,00,000\\ \text{(2) Current Assets}& & & & \\ \text{(a) Inventories}& & & 24,00,000& 20,00,000\\ \text{(b) Cash and cash equivalents}& & & 12,00,000& 8,00,000\\ & \text{Total}& & 1,20,00,000& 1,00,00,000\end{array}$

Answer 1

COMMON-SIZE BALANCE SHEET FOR X LTD

as on 31st March, 2015 and 2016

$\begin{array}{cccccc}& \text{Particulars}& \text{Absolute}& \text{Amount}& \text{Percentage of}& \text{Balance Sheet Total}\\ & & \text{31 Mar., 2015}& \text{31 Mar., 2016}& \text{31 Mar., 2015}& \text{31 Mar., 2016}\\ \text{I.}& \text{Equity and Liabilities}& & & & \\ & \text{1. Shareholder's Fund}& & & & \\ & \text{(a) Share capital}& 60,00,000& 80,00,000& 60.00& 66.67\\ & \text{(b) Reserve and Surplus}& 8,00,000& 12,00,000& 8.00& 10.00\\ & \text{2. Non-current Liablities}& & & & \\ & \text{Long-term Borrowings}& 20,00,000& 24,00,000& 20.00& 20.00\\ & \text{3. Current Liabilities}& & & & \\ & \text{Trade Payables}& 12,00,000& 4,00,000& 12.00& 3.33\\ & \text{Total}& 1,00,00,000& 1,20,00,000& 100.00& 100.00\\ \text{II.}& \text{Assets}& & & & \\ & \text{1. Non-current Assets}& & & & \\ & \text{Fixed Assets}& & & & \\ & \text{(a) Tangible}& 60,00,000& 80,00,000& 60.00& 66.67\\ & \text{(b) Intangible}& 14,00,000& 4,00,000& 12.00& 3.33\\ & \text{2.Current Assets}& & & & \\ & \text{(a) Inventories}& 20,00,000& 24,00,000& 20.00& 20.00\\ & \text{(b) Cash}\&\text{Cash Equivalents}& 8,00,000& 14,00,000& 8.00& 10.00\\ & \text{Total}& 1,00,00,000& 1,20,00,000& 100.00& 100.00\end{array}$