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 adjustments for deferred items, Q. Show Adjustments for deferred items...

Q. Show Adjustments for deferred items? This segment discusses the two types of adjustments for deferred items asset/expense adjustments and liability/revenue adjustments. In t

Completing the accounting cycle, Q. Completing the accounting cycle? Su...

Q. Completing the accounting cycle? Subsequent to studying this chapter you should be able to - Recapitulate the steps in the accounting cycle. - Organize a work sheet fo

Prepare the company''s bank reconciliation, Honolulu Cookie Company provide...

Honolulu Cookie Company provides the following information in order for you to prepare the company's bank reconciliation: Balance per company

History of accounng, application/realization in history of accounting

application/realization in history of accounting

What do you mean by contingent liabilities, Q. What do you mean by Continge...

Q. What do you mean by Contingent liabilities? Contingent liabilities -- liabilities which are not recorded on a company's financial reports though whichmight become due. If a

CIS 180, Start in cell E3. Complete the series of substitution values rangi...

Start in cell E3. Complete the series of substitution values ranging from 5 to 15 at increments of 1, vertically down column E.

Measurement of expense, The measurement of expense Accountants measure larg...

The measurement of expense Accountants measure largely assets used in operating a business by their historical costs. Consequently they measure a depreciation expense resulting fro

State unemployment tax, State unemployment tax This is referred to as S...

State unemployment tax This is referred to as SUTA (State Unemployment Tax Act). The taxes are paid to the state in which employer conducts business. This rate varies from stat

Antidilution of ownership, Antidilution of Ownership The right of an i...

Antidilution of Ownership The right of an investor is to continue the same percentage ownership of an organizations main stock in the event that the organization issues more s

Equity segment of a corporate balance sheet, Q. Equity segment of a corpora...

Q. Equity segment of a corporate balance sheet? The stockholders' equity segment of a corporate balance sheet can become more complex as you will see later in the text. But the

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages