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

Show approximation of periodicity, Q. Show Approximation of periodicity? ...

Q. Show Approximation of periodicity? Approximation and judgment because of periodicity To offer periodic financial information accountants must often estimate expected uncolle

A department transferred 7, A department transferred 7,000 units to the fin...

A department transferred 7,000 units to the finished goods storeroom during a month. There was no beginning work in process inventory, but 500 units were still in process at the

Excess payment to supplier, What process for excess payment to supplier I w...

What process for excess payment to supplier I would like know without adjusting invoice that means how supplier will send back surplus amount how do in oracle apps?          Ans

What is accounting system, Q. What is accounting system? Accrual basis,...

Q. What is accounting system? Accrual basis, system, or method -- an accounting system which records revenues andexpenses at the time when transaction takes place,not at the ti

.ratios, why would a bank be interested in the investment ratios of its cus...

why would a bank be interested in the investment ratios of its customer firms..

Advantages and disadvantages of fifo, Advantages and disadvantages of FIFO ...

Advantages and disadvantages of FIFO The FIFO method has four main advantages (a) it is easy to apply (b) the assumed flow of costs corresponds with the normal physical flow o

Illustrate the structure of brain, Illustrate the structure of brain Br...

Illustrate the structure of brain Brain is capable of changing its structure in numerous ways. Synapses become stronger and denser. Tiny blood vessels increase in size and numb

Hello, Hello, I'm having trouble understanding Direct Cost, Overhead Cost a...

Hello, I'm having trouble understanding Direct Cost, Overhead Cost and Indirect Cost. ***Also Period cost and Product cost. please can anyone explain it and give examples for eac

Please use the following information to answer questions, Please use the fo...

Please use the following information to answer questions 4-5: Cash $10,000 Accounts Payable $7,000 Accounts Receivable $6,400 Mortgage Payable $65,000 Supplies $1,500 Long-

Explain about accrual basis and periodicity, Q. Explain about Accrual basis...

Q. Explain about Accrual basis and periodicity? Accrual basis and periodicity demonstrated that financial statements more accurately reflect the financial status and 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