Balancesheet derivation question, Accounting Basics

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

 

Posted Date: 7/26/2012 5:25:44 AM | Location : United States







Related Discussions:- Balancesheet derivation question, Assignment Help, Ask Question on Balancesheet derivation question, Get Answer, Expert's Help, Balancesheet derivation question Discussions

Write discussion on Balancesheet derivation question
Your posts are moderated
Related Questions
Q. Advantage of a pre-inventory sale? Have you still taken advantage of a pre-inventory sale at your favourite retail store Many stores offer bargain prices to decrease the mer

Q. Sales Returns and Allowances account? The Sales Returns and Allowances account is the contra revenue account to Sales that records the selling price of merchandise returned

John is considering the best capital structure for his firm. Suppose there are two capital structures for him to choose from. Structure A would have 7,000 shares of stock and $160,

Determining the physical quantity that should be contained in inventory normally is a simple matter because that amount have of items in the possession of the company. The cost of

Q. What is Inventory? Inventory -- Supply or stock of products and goods that a company has for sale. Amanufacturer may have 3 kinds of inventory: raw materials waiting to be c

Q. Explain about Staff accountant? Let us travel with Tracy as she begins her career at the staff level. At the onset, she works directly under a senior accountant on each of h

using the break-even equations to solve for price and variable cost per unit andromeda company's break-even point is 2,400 units. variable cost per unit is $42; total costs are 6

What is Federal unemployment tax Federal unemployment tax (FUTA) requires the payment of taxes to provide benefits for workers during periods of temporary unemployment. This

Carrying amounts of merchandise materials as well as supplies inventories are generally determined on a moving average cost basis and are stated at the lower of cost or market.

Q. Explain horizontal analyses and using the financial results? The computation of dollar and or percentage changes from one year to the next in an item on financial statements