How to prepare the balance sheet

Dear Seniors,

Please help me in preparing the balance sheet From the following information,

prepare the balance sheet

Current Ratio = 1.25

Quick Ratio = 1.25

Stock Turnover Ratio (Based on closing stock) = 9 times

Gross profit ratio 25%

Average Collection Period (in months) 1.5

Ratio of Reserve to capital 0.2

Turnover of Fixed Assets 1.2

Debt-Equity 0.6

Fixed assets to net worth 1.25

Sales of the year Rs. 24,00,000

 

Replies (2)

sales         2400000

gp @ 25%   600000

cogs          1800000

so use stock turnover ratio to get closing stk 200000

use avg collection period to get debtors         300000

use fixed assets turnover ratio to get fixed assets 2000000

use fixed assets to net worth to get net worth         1600000

share capital + reserve= net worth

using this get share capital  1333333 & reserves 266667

use debt equity ratio to get debt 960000 (equity = net worth)

working capital=net worth + debt - fixed assets

so working cap will be 560000

also working cap = current assets - current liabilities

use this  and current ratio to get

current liabilities 2240000 & current assets 2800000

quick assets = current assets - stock =2600000

so using quick ratio we get quick liabilities 2080000

quick liabilities = current liabilities - bank overdraft

so bank over draft =160000

using this u can prepare balance sheet 

balance sheet (vertical form) total= 2560000

 

Well done sheena.... The solution given by u is perfect

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 01 October 2026
Articled Assistant

KPSN & Associates LLP

Chennai

CA Inter

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
08 October 2026
SALES TELECALLER

HIRE NOVA

Lucknow

Graduate (Any)

View Details
Company
ARTICLESHIP 20 October 2026
CA ARTICLE

AMKN & CO

Noida

CA Inter

View Details
Company
06 October 2026
Assistant Manager - Audit and Compliance

Ravi K Jain & Co

Noida

Others

View Details
Company
ARTICLESHIP 17 October 2026
Articled Assistant

RRPM & Associates LLP

Chennai

CA Inter

View Details
Company
10 October 2026
Accounts Associate Level 1

Abic and Mani Chartered Accountants

Kottayam

B.Com

View Details