Balance Sheet with Financial Ratios - Template in Excel

Reviews
Shared by: Revin
Stats
views:
803
rating:
not rated
reviews:
0
posted:
6/13/2009
language:
English
pages:
0
XYZ Corporation Balance Sheet For the Period Ending [End Date] Current ratio [A/B] Quick ratio [(A-C)/B] Cash ratio [D/B] Working capital [A-B] Debt-to-equity ratio [(G+H)/F] Debt ratio [(G+H)/E] $ - ASSETS Current assets Cash and cash equivalents [D] Short-term investments Accounts receivable Inventories [C] Deferred income taxes Prepaid expenses and other current assets Total current assets [A] Fixed assets Property, plant and equipment at cost Less accumulated depreciation Total fixed assets Other assets Long-term cash investments Equity investments Deferred income taxes Other assets Total other assets Total assets [E] in 000s % of ASSETS LIABILITIES & OWNERS' EQUITY Current liabilities in 000s % of ASSETS $ - Loans payable and current portion long-term debt [H] Accounts payable and accrued expenses Income taxes payable Accrued retirement and profit-sharing contributions - Total current liabilities [B] Other liabilities $ - - $ - Long-term debt [G] Accrued retirement costs Deferred income taxes Deferred credits and other liabilities - $ $ Total other liabilities Total liabilities Total owners' equity [F] Total liabilities + owners' equity $ $ $ $ -

Related docs
Financial Ratio Analysis with Excel Model
Views: 168  |  Downloads: 1
Financial Ratios
Views: 3232  |  Downloads: 410
Balance Sheet with Ratios and Working Capital
Views: 459  |  Downloads: 95
balance sheet template
Views: 443  |  Downloads: 24
balance sheet ratios
Views: 107  |  Downloads: 14
Balance Sheet Ratios
Views: 8  |  Downloads: 3
Balance sheet with financial ratios 1
Views: 308  |  Downloads: 43
Balance sheet ratios
Views: 12  |  Downloads: 9
Financial History and Ratios Template
Views: 25  |  Downloads: 8
Excel Financial Statement Template
Views: 3  |  Downloads: 1
Balance Sheet Template
Views: 5  |  Downloads: 0
premium docs
Other docs by Revin
2009 Best of the Best CPA Firms (Exclude Big 4)
Views: 237  |  Downloads: 4
2009 IFRS in Your Pocket
Views: 653  |  Downloads: 99
2008 IFRS and US GAAP - A Pocket Comparison
Views: 545  |  Downloads: 40
Business Decision - Tax Planning Guide
Views: 78  |  Downloads: 1
2009 Tax Rates
Views: 190  |  Downloads: 2
Olevia LT26HVE and LT26HVX - User Manual
Views: 287  |  Downloads: 6
Expense Report - Template in Excel
Views: 570  |  Downloads: 49
2009 Top 50 Companies For Diversity
Views: 181  |  Downloads: 2