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 16, 2018, 11:02 pm ad1c9bdddf
Word file contains balance sheet of Range Company.
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.
Cash and equivalents $193
Accounts and notes receivable ?
Total current assets ?
Property and equipment, net 1,238
Intangible assets, net ?
Notes and other receivables, net 738
Total non-current assets ?
Total assets ?
Liabilities and Shareholders' Equity
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 ?
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