Balancesheet derivation question, Accounting Basics

Assignment Help:

Assignment Comments –  Debt-to-assets ratio: 50%

Current Ratio: 1.8x
Total assets turnover: 1.5x      
Days sales outstanding: 36.5 days*
Gross profit margin on sale: (Sales – Cost of goods sold)/Sales = 25%
Inventory turnover ratio: 5                                                     

Balance Sheet

Cash                                                                                                            Accounts payable
 
Accounts receivable                                                                        Long-term debt                                                     `60,000
 
Inventories                                                                                          Common stock
 
Fixed assets                                                                                          Retained earnings                                    97,500                                   
 
Total assets                                                      $300,000                  Total liabilities and equity     
 
Sales                                                                                                            Cost of goods sold

 

 

Input Values

 

Total assets

300000

retained earnings

97500

Long term debt

60000

Debt to asset ratio

50%

current ratio

1.8

total asset to turnover ratio

1.5

days sales oustanding ratio

36.5

Gross Profit Margin ratio

0.25

Inventory to turnover ratio

5

 

 

Derived values

 

Fixed Asset

120000

Current Asset

180000

Therefore current liability

100000

Therefore turnover

200000

therefore debtors/credit sales

20000

Therefor gross profit

50000

Cost of goods sold

150000

Therefor Inventory

30000

 

 

 

Balance sheet

as on.......

for the

year ending...........

 

 

 

 

 

 

 

 

 

Liabilities

Amt

Amt

Amt

Asset

Amt

Amt

 

 

 

 

 

 

 

Capital

 

 

 

Fixed asset

120000

120000

Common stock

 

42500

42500

Current asset

 

 

Cl.Retained earnings

 

 

 

debtors/account receivable

20000

 

Op. ret.earnings

47500

 

 

Inventories

30000

 

Gross profit

50000

97500

97500

Other current asset

130000

180000

Long Term Debt

 

60000

60000

 

 

 

Current Liability

 

 

 

 

 

 

Account receivable

 

100000

100000

 

 

 

 

 

 

 

 

 

 

Total

 

 

300000

Total

 

300000

 


Related Discussions:- Balancesheet derivation question

Ledger, Ledger is said to be the principal book entry and the transactions ...

Ledger is said to be the principal book entry and the transactions can even be directly entered into the ledger account.” Elaborate and explain why journal is necessary.

Adjustments, 2 deprecation on equipment is calculated at 10% per annum on c...

2 deprecation on equipment is calculated at 10% per annum on cost price new equipment for R400 was purchased on 1 December 2012 and has been recorded

At the end of the current year, At the end of the current year, $19,900 of ...

At the end of the current year, $19,900 of fees have been earned but not billed to clients. • a. What is the adjustment to record the accrued fees? Indicate each account affecte

Solved questoin of account, want a question of general jouranal , t account...

want a question of general jouranal , t account ,traial balance , income statement and balance sheet

Rectification of error, dividend received rs 100was posted to debit to divi...

dividend received rs 100was posted to debit to dividend account. the rectification entry n will be what?

How to treat entry , Assume we had given tour advance to party how to treat...

Assume we had given tour advance to party how to treat entry and which head have to given expenditure? Ans) Cash/Bank a/c DR To Party(name)a/c (Advance Paid For Tour)

What is effective collection?, Its depends on the credit period of the comp...

Its depends on the credit period of the company i.e. A company credit period 30 days 85 of the debtors collection should be recovered with in credit period. We can say the Effectiv

Partnership act, If partners do not draw up a partnership agreement, the pr...

If partners do not draw up a partnership agreement, the provisions of the Partnership Act apply on which statement is true like a provision of the Partnership Act? A Interest on

Balance sheet concepts, THE BALANCE SHEET CONCEPTS According to Howard,...

THE BALANCE SHEET CONCEPTS According to Howard, a Balance Sheet might be definite as - 'a statement which reports the principles owned by the enterprise and the assert of the c

Fiscal year, A time of 12 consecutive months used by an organization to acc...

A time of 12 consecutive months used by an organization to account for and report the results of its operations.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd