222

$show=home

Welcome to Accounting Education

The Accounting University with 3400+ Accounting contents as study material which can watch, read and learn anyone, anywhere.

Start your studies

$show=home

Journal Entries $type=three$count=6$author=hide$comment=hide$label=hide$date=hide$show=home$s=0

Balance Sheet $type=three$count=6$author=hide$comment=hide$label=hide$date=hide$show=home$s=0

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

: 2
  1. Hi,i would like to know the concept behind when calculating fixed asset turnover do we really use cost of goods sold or sales/fixed assets
    waiting for your clarification

    ReplyDelete
  2. tomorrow is my internal exams of mcom 2nd year and this type of problem will come for 12 marks plz help me

    ReplyDelete
In comment, you can give your feedback, reviews, ideas for improving content or ask question relating to written content.

 


Name

access,2,account,86,accountant,95,Accounting,683,accounting definitions,99,accounting ebook,3,Accounting education,85,Accounting Education Ads Help,1,accounting procedure,2,accounting process outsourcing,2,Accounting Software,52,advance,3,advertising,6,africa,7,Amalgamation,6,amendments,16,Amortization,1,announcements,62,Annuity,2,assets,53,audit,47,auditing,41,Australia,2,B.Com.,22,balance sheet,87,bank,111,Bank reconciliation,12,banking,33,basic accounting,110,BBA,1,benefits,13,best,50,bill,12,black money,3,blog,12,bloggers,7,book keeping,4,bookkeeping,3,Branch Accounting - full tutorial,8,budget,35,Budget variance,13,business,65,businessman,9,CA,30,calculator,4,canada,3,capital,72,capital budgeting,27,career,21,cash,40,cash book,8,cash flow statement,11,Chiense,1,children,13,china,6,class,3,coaching,2,coins,2,college,6,commerce,10,commerce students,7,company,36,computer,9,computer accounting,1,conference,4,Contact vinod kumar,1,Control Your Spending,27,corporate accounting,69,cost,160,cost accounting,195,cost center,8,cost centre,1,CPA,2,credit,18,credit card,11,cs,10,currency,35,data,11,Debit and credit,17,debit cards,1,debt,62,debtor,21,degree,6,depletion,2,depreciation,38,Diwali Messages,12,documents,4,dollar,5,domain,3,Downloads,3,Dubai,1,e-accounting,17,earning,17,education,246,Education Loans,6,email,15,employee,4,EPF,2,ERP,7,euromoney,1,examination,7,excel,17,excise duty,6,expenses,65,facebook,7,factor of loan,1,fans,2,feature,32,fifo,5,FII,4,fiji,1,finacle,1,finance,823,Finance Journal Entries,6,Financial,134,financial accounting,147,Financial Statements,4,fire insurance,3,flickr,2,flow,4,forensic,4,forex,21,formula,8,france,1,fraud,6,free,2,fun,34,function,1,fund,48,GAAP,36,GDP,1,gdr,5,germany,1,gold,7,goodwill,4,goodwill accounting,3,google,34,google apps,3,google apps,1,google base,1,google buzz,1,google calendar,1,Google docs,38,google finance,3,google fusion tables,1,google talk,5,govt.,5,GST,33,guide,85,health,6,Hindi,2,Hindi Language,3,history,3,holding company,3,How to treat FBT in Tally 9,1,HRA,3,ICAI,11,ICAWI,3,ICICI Bank,1,IFRS,11,income,17,income statement,19,Income Tax,7,India,57,indian railway,1,Indonesia,1,inflation,4,inflation accounting,3,infographics,8,information,7,inspiration,176,insurance,14,insurance accounting,2,Intangible,3,interest,26,international,7,Internet,40,Introduction of Tally 9,1,inventory,41,investment,135,investment in Shares,6,invoice,3,IT,1,Japan,1,Job costing,4,journal entries,143,Journal Entries eBook Help,4,Kalculate,1,keyboard,3,kuwait,2,laptop,2,law,4,LBT,1,learning,36,lease,5,lecture,11,ledger,17,leducation,1,Leverage Analysis,7,liabilities,16,lifo,3,linkedin,1,loan,74,logical point,1,loss,5,loss of profit,1,M.Com.,5,m.phil,2,malaysia,3,management accounting,129,manual accounting,4,manufacturing account,1,market,11,marketing,3,mastercard,2,material,13,MBA,14,MCA,1,media,4,migration,2,mobile,9,money,61,ms word,3,ms. excel,14,multi currency in tally 9,1,Multicurrency Accounting,3,mutual fund,30,national security,1,new and sacrifice ratio,1,new york times,1,new zealand,1,news,1,NGO,5,nonprofit-accounting,6,North Georgia Mountains,1,Notification,1,NPV,17,NSE,1,odbc,2,office,10,oman,1,online application,2,online accounting,11,Online Accounting Course,5,otcei,1,pakistan,3,parents,3,Partnership,1,pay pal,3,pdf,4,Personal Finance,6,pie chart,1,pie chart of income,2,pnb,5,podcast,1,ppf,1,presentation,10,price,7,privacy policy,2,prof. vinod kumar,13,profit,24,profit and loss account,12,project management,11,provision,14,purchase,9,puzzles,2,quickbooks,2,Quote,22,quotes,42,quotes of svtuition,1,rating agency,2,ratio analysis,34,RBI,7,readers,13,real estate,13,rectification of errors,11,remote control,2,reports,10,reserves,8,responsibility accounting,4,retirement,2,revenue,3,Revenue reserves,2,review,7,risk,11,rupees,9,salary,5,sale,12,SAP,3,saudi arabia,1,saving,19,sbi,9,scholarship,2,school,1,SEBI,13,security,30,service tax,23,share,20,share trading,15,Shares,16,shri lanka,3,singapore,2,sms,6,social accounting,7,society,5,solution,219,South Africa,1,stock,24,stock exchange,22,structure,6,student,39,students,70,study,21,subsidiary company,2,svtuition,14,swiss bank,2,tally,100,tally 9,8,Tally 7.2,8,Tally 9,42,Tally.ERP 9,59,TallyPrime,1,tanzania,2,tax,94,Tax Accounting,30,TDS,15,teacher,62,teaching,112,technology,33,test,40,testimonial,15,testimonials,15,thailand,1,tips,60,trading,5,trading on equity,2,transaction,7,trend,12,trial balance,14,truthfulness,1,tuition,3,twitter,10,UAE,5,UGC - NET Commerce,13,UK,11,United Arab Emirates,1,university,9,usa,25,valuation,9,VAT,22,Video,36,Voucher and vouching,4,Wealth,8,wikipedia,25,working capital,29,youtube,14,
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
https://www.svtuition.org/2012/01/how-to-make-balance-sheet-from.html
https://www.svtuition.org/
https://www.svtuition.org/
https://www.svtuition.org/2012/01/how-to-make-balance-sheet-from.html
true
2410664366776677676
UTF-8
Loaded All Posts Not found any posts VIEW ALL Reply Cancel reply Delete By Home PAGES Contents View All RELATED CONTENTS FOR YOUR LEARNING Topic ARCHIVE SEARCH ALL POSTS Not found any post match with your request 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 PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy