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

Uoit has recently appointed you to prepare an independent, UOIT has recentl...

UOIT has recently appointed you to prepare an independent consulting report to analyze the university's current financial position and to provide some recommendations for improve

Determine about the sales returns and allowances, Determine about the Sales...

Determine about the Sales returns and allowances Allowance results when a buyer decides to keep defective or damaged goods though at a reduction from the original price.

Acc 206 Week Two Assignment, #Please complete the following 7 exercises bel...

#Please complete the following 7 exercises below in either Excel or a word document (but must be single document). You must show your work where appropriate (leaving the calculatio

An example of a committed fixed cost would be:, An example of a committed f...

An example of a committed fixed cost would be: a) taxes on real estate b) management development programs c) public relations d) advertising programs

Accounting concepts and standards, Any activity which you perform is assist...

Any activity which you perform is assist if you comprise a set of rules to guide your efforts. Moreover, you determine that these rules are of more value to you if they are standar

Financial statement analysis, FINANCIAL STATEMENT ANALYSIS Following th...

FINANCIAL STATEMENT ANALYSIS Following the preparation of the Financial Statements, they are examined by the business for the reason of analyzing the presentation of the compan

Hi, 1. Carmen Santiago works for a number of businesses as a  “consultant...

1. Carmen Santiago works for a number of businesses as a  “consultant.” She has helped design accounting systems,  provided accounting services, and analyzed the financial  s

What is payroll?, Payroll implies with paying your employees (having seeing...

Payroll implies with paying your employees (having seeing that the government gets the monies they require you to withhold from the employees and the payroll taxes they needs you t

Net realizable value , A)Guerrero Company occupied in the following events ...

A)Guerrero Company occupied in the following events during 2012: 1. Began operations by issuing common stock to investors for $40,000 cash 2. Given services to customers on a

Supply & demand, #quesDance fans switch away from dance music to R&B music ...

#quesDance fans switch away from dance music to R&B music AND the price of MP3 players decreases. tion..

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