Explore BrainMass

Ratio analysis :Balance sheet

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Complete the following balance sheet for the Range Company using the following information:

Debt to Assets = 60 percent
Quick Ratio = 1.1
Asset Turnover = 5x
Fixed Asset Turnover = 12.037x
Current Ratio = 2
Average Collection Period = 16.837 days

Cash Current Liabilities ______
Receivables ________ Bonds Payable ______
Inventory ________ Total Liabilities ______
Total Current Assets ________ Net Worth ______
Plant and Equipment ________ Total Liabilities and Net Worth ______
Total Assets $325,000

Assume all sales are on credit and a 360-day year.

© BrainMass Inc. brainmass.com October 25, 2018, 12:51 am ad1c9bdddf

Solution Summary

Word file contains balance sheet of Range Company.

See Also This Related BrainMass Solution

Using Ratio Analysis to Complete a Balance Sheet

The following balance sheet information (in $ millions) comes from the Annual Report to Shareholders of Marriott International Inc. for the 2006 fiscal year.
Certain amounts have been replaced with question marks to test your understanding of balance sheets. In addition, you are provided with the following
information from an analysis of Marriott's financial position at the same date:
Current ratio = 1.3140364; Acid-test ratio = 0.519429; Debt-to-equity ratio = 2.280367.
Note: Quick assets consist of Cash and equivalents, and Accounts and notes receivables in this example.

Compute the missing amounts (rounded to the nearest $ in millions) in the Marriott balance sheet.

Current assets
Cash and equivalents $193
Accounts and notes receivable ?
Inventory ?
Other 796
Total current assets ?
Property and equipment, net 1,238
Intangible assets, net ?
Investments 402
Notes and other receivables, net 738
Other 1,400
Total non-current assets ?
Total assets ?

Liabilities and Shareholders' Equity
Current liabilities
Accounts payable $658
Accrued payroll and benefits 615
Other payables and accruals 1,249
Total current liabilities $2,522
Long-term debt ?
Other long-term liabilities 1,630
Total long-term liabilities ?
Total liabilities ?
Shareholders' equity
Class A common stock $ 5
Additional paid-in capital 3,617
Retained earnings 2,860
Treasury stock and other (3,864)
Total shareholders' equity $2,618
Total liabilities and shareholders' equity $8,588

View Full Posting Details