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

Suppose you want to have $5, Suppose you want to have $5,000 saved at the e...

Suppose you want to have $5,000 saved at the end of five years. The bank will pay 2% interest on your money. How much would you have to deposit today to have the $5,000 you want

Acct, Gwinnett Park Co. reported net income of $506,600 for its fiscal year...

Gwinnett Park Co. reported net income of $506,600 for its fiscal year ended September 30, 2014 . At the beginning of that year, 150,000 shares of common stock were outstanding. On

Concepts of accounting, Q. Concepts of accounting? - The major underlyi...

Q. Concepts of accounting? - The major underlying assumptions or else concepts of accounting are (a) business entity (b) going concern (continuity) (c) money measurement (d) st

Meaning of social accounting, Question Social accounting is a way of ca...

Question Social accounting is a way of calculating and reporting on an organisation's ethical and social performance. It is principally concerned with offering a complementary

Describe the functions and limitations of accounting, 1. Describe the follo...

1. Describe the following with detailed example: i. Wealth Maximization ii. Profit maximization 2. Describe the functions and limitations of accounting. 3. Prepare a deta

What is cyclic reporting, Q. What is Cyclic reporting? Cyclic reporting...

Q. What is Cyclic reporting? Cyclic reporting and the matching principle necessitate the preparation of adjusting entries. Adjusting entries are journal entries prepared at the

Word problem, a 50 petty cash fund has cash of 20 and valid receipts for 40...

a 50 petty cash fund has cash of 20 and valid receipts for 40. The entry to replenish the fund would include a

How the payment mechanism work. explain, The open items of an account can o...

The open items of an account can only be cleared once you post an identical offsetting amount to the account. In other words, the balance of the items assigned to every other must

What were the equivalent units for conversion costs, Cargin Company uses th...

Cargin Company uses the FIFO method in its process costing system. The Assembly Department started the month with 15,000 units in its beginning work in process inventory that were

Responsibility in oracle applications, Users cannot access the simultaneous...

Users cannot access the simultaneous programs ( just like Forms) until unless the program is attached to a responsibility by a ?Request Group?. Therefore the responsibilities give

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