How to Make Balance Sheet from Accounting Ratios

Accounting ratios have deep relationship with balance sheet. There are lots of accounting ratios which are calculated with the help balance sheet's assets and liabilities. So, there is no any difficulty to calculate assets and liabilities on result values of accounting ratios. If we succeed to make balance sheet from accounting ratios, we can understand the structure of balance sheet and utilization of ratios for making it. Following are its main steps:

1st. To Calculate Missing Figure of Assets or Liabilities by Using  Accounting Ratios Formula


It is you logic, how will you reach to your required balance sheet item. For example. You need to calculate total creditor. This is current liability of balance sheet. First of all check which accounting ratio values are given. Analyze it.

a)  For example, you are given GP ratio and gross profit. On this basis, you will calculate sales and cost of goods sold. Indirectly, it will be helpful to you to reach the figure of purchases because cost of goods sold formula is dependent on opening stock, purchase and closing stock figures. Any one figure can easily be calculated.

b) Debtor collection period and creditor collection period are used for calculating the figure of sundry debtors and sundry creditors.

c) Capital turnover ratio and fixed assets turnover ratio will be helpful for calculating value of capital and fixed assets.

2nd. To Remember All the items of Balance Sheet 

You should also remember all the items of balance sheet. Some items may easily be calculated by putting the value of all previous calculated items.

3rd. To Practice with Some Examples 

You should study more and more practical examples which will be helpful to gain the knowledge of this. We are giving one example relating to this.

From the following detail, make out the balance sheet with as many details as possible:

1. Stock velocity = 6
2. Capital turnover ratio = 2
3. Fixed Assets Turnover = 4
4. Gross Profit Turnover = 20%
5. Debtor Velocity = 2 months
6. Creditors Velocity = 73 days
The gross profit was Rs. 60000. Reserve and surplus amounted to Rs. 20000.
Closing Stock was Rs. 5000
in excess of opening stock.

Solution:

1. Calculate sales


Gross profit ratio = Gross Profit / Sales X 100
Since G / P ratio is 20% and gross profit is Rs. 60000, sales are :
20 / 100 = 60000 / sales
20 sales = 60000 X 100
sales = 60000 X 100 / 20 = Rs. 3,00,000

2. Calculation of Purchases :


Purchases = Cost of goods sold + closing stock - opening stock
As G/ P ratio is 20%, so cost of goods is 100- 20 or say 80% .
Cost of goods sold = 300000 X 80 /100
= Rs. 240000
Purchase = 240000 + 5000 (As closing stock is Rs. 5000 more than the opening
stock)

3. Calculation of Stock:


Stock Turnover Ratio = Cost of goods sold / Average stock
6 = 240000 / average stock
6 average stock = 240000
average stock = 240000/ 6
average stock = 40000
average stock = opening stock + closing stock / 2
( Since closing stock is Rs. 5000 more )
or 40000 = 2 op. stock + 5000 / 2
or 80000 - 5000 = 2 op. stock
or opening stock = 75000 / 2 = Rs. 37500
Closing Stock = opening stock + 5000
= 37500 + 5000 = Rs. 42500

4. Calculation of Debtors :


Debtors Velocity = Total Debtors / Credit Sales X No. of months
or 2 = Total debtors / 300000 X 12 ( calculated in months)
Or
Total Debtors = 2 X 300000 / 12
Total Debtors = Rs. 50,000

5. Calculation of Creditors :


Creditors Velocity = Total Creditors / Credit Purchase X No. of Working days

73 = total creditors / 245000 X 365
73 X 245000 / 365 = total creditors
Total creditors = Rs. 49000

6. Calculation of Capital


Capital Turnover Ratio = Cost of Goods Sold / Capital
2 =  240000 / capital
capital = 240000 / 2 = 120000
Alternatively,
In case capital is taken to mean net worth, then net worth = Rs. 120000.
Or Share Capital + Reserve and Surplus = Rs. 120000
Share capital + 20000 = 120000
Share capital = 120000 - 20000 = 100000

7. Calculation of Fixed Assets


Fixed Assets Turnover Ratio = Cost of Goods Sold / Fixed Assets
Or 4 X Fixed Assets = 240000
Fixed Assets = 240000 / 4 = 60000

 Liabilities  Amount  Assets  Amount
Capital (6)
Reserve and Surplus (given)
Creditors (5)





















100000
20000
49000









Fixed Assets ( 7)
Closing Stock (3)
Debtors (4)
Cash ( Balancing figure)


















60000
42500
50000
16500








169000 169000

COMMENTS

Comments on this Website
.
Share above Content to Your Friends



Name

access account accountant Accounting accounting definitions accounting ebook Accounting education accounting procedure accounting process outsourcing Accounting Software advance advertising africa Amalgamation amendments announcements Annuity assets audit auditing Australia B.Com. balance sheet bank Bank reconciliation banking basic accounting BBA benefits best bill black money blog bloggers book keeping bookkeeping Branch Accounting - full tutorial budget Budget variance business businessman CA calculator canada capital capital budgeting career cash cash book cash flow statement Chiense children china class coaching coins college commerce commerce students company computer computer accounting conference Contact vinod kumar corporate accounting cost cost accounting cost center cost centre CPA credit credit card cs currency data Debit and credit debit cards debt debtor degree depletion depreciation documents dollar domain Downloads Dubai e-accounting earning education Education Loans email employee EPF ERP euromoney examination excel excise duty expenses facebook factor of loan fans feature fifo FII fiji finacle finance Financial financial accounting fire insurance flickr flow forensic forex formula france fraud free fun function fund GAAP GDP gdr germany gold goodwill goodwill accounting google google apps google apps google base google buzz google calendar Google docs google finance google fusion tables google talk govt. GST guide health Hindi Hindi Language history holding company How to treat FBT in Tally 9 HRA ICAI ICAWI ICICI Bank IFRS income income statement Income Tax India indian railway Indonesia inflation inflation accounting infographics information inspiration insurance insurance accounting interest international Internet Introduction of Tally 9 inventory investment invoice IT Japan Job costing journal entries Kalculate keyboard kindle kuwait laptop law LBT learning lease lecture ledger leducation Leverage Analysis liabilities lifo linkedin loan logical point loss loss of profit M.Com. m.phil malaysia management accounting manual accounting manufacturing account market marketing mastercard material MBA MCA media migration mobile money ms word ms. excel multi currency in tally 9 Multicurrency Accounting mutual fund national security new and sacrifice ratio new york times new zealand news NGO nonprofit-accounting North Georgia Mountains NPV NSE odbc office oman online application online accounting otcei pakistan parents pay pal pdf pie chart pie chart of income pnb podcast ppf presentation price privacy policy prize money prof. vinod kumar profit profit and loss account project management provision purchase puzzles quickbooks Quote quotes quotes of svtuition rating agency ratio analysis RBI readers real estate rectification of errors remote control reports reserves responsibility accounting retirement revenue Revenue reserves review risk rupees salary sale saudi arabia saving sbi scholarship school SEBI security service tax share share trading Shares shri lanka singapore sms social accounting society solution South Africa stock stock exchange structure student students study subsidiary company svtuition swiss bank tally tally 9 Tally 7.2 Tally 9 Tally.ERP 9 tanzania tax Tax Accounting TDS teacher teaching technology test testimonial testimonials thailand tips trading trading on equity transaction trend trial balance tuition twitter UAE UGC - NET Commerce UK United Arab Emirates university usa valuation VAT Video Voucher and vouching wikipedia working capital youtube
false
ltr
item
Accounting Education: How to Make Balance Sheet from Accounting Ratios
How to Make Balance Sheet from Accounting Ratios
http://2.bp.blogspot.com/-lvs4R5lsUrA/Tw2G0ByX6pI/AAAAAAAAHOI/qURPg1RiNgE/s200/bs.PNG
http://2.bp.blogspot.com/-lvs4R5lsUrA/Tw2G0ByX6pI/AAAAAAAAHOI/qURPg1RiNgE/s72-c/bs.PNG
Accounting Education
http://www.svtuition.org/2012/01/how-to-make-balance-sheet-from.html
http://www.svtuition.org/
http://www.svtuition.org/
http://www.svtuition.org/2012/01/how-to-make-balance-sheet-from.html
true
2410664366776677676
UTF-8
Not found any lecture VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES Lectures View All RECOMMENDED FOR YOU Category ARCHIVE SEARCH ALL Lectures Not found any lecture match with your request, please help to write it and send it to our email at vinod@svtuition.org for making this website free accounting and finance encyclopedia. Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock