Balance Sheet Template Xls
[Company Name]Balance Sheet
Total current assets 11,874 -
Fixed (Long-Term) Assets
Long-term investments 1,208
Property, plant, and equipment 15,340
(Less accumulated depreciation) (2,200)
Total fixed assets 14,348 -
Deferred income tax
Total Other Assets - -
Total Assets 26,222 -
Liabilities and Owner's Equity
Accounts payable 8,060
Income taxes payable 3,145
Accrued salaries and wages
Current portion of long-term debt
Total current liabilities 11,205 -
Long-term debt 3,450
Deferred income tax
Total long-term liabilities 3,450 -
Owner's investment 7,178
Retained earnings 4,389
Total owner's equity 11,567 -
Total Liabilities and Owner's Equity 26,222 -
Common Financial Ratios
Debt Ratio (Total Liabilities / Total Assets)
Current Ratio (Current Assets / Current Liabilities)
Working Capital (Current Assets - Current Liabilities)
Assets-to-Equity Ratio (Total Assets / Owner's Equity)
Debt-to-Equity Ratio (Total Liabilities / Owner's Equity)
© 2011 Vertex42 LLC. All rights reserved.
Not for Resale or Public Sharing
Limited Private Sharing
This template is considered a copyrighted work under the Unites States and other copyright laws
and is the property of Vertex42 LLC. The items listed below are additional points to help clarify how
you may use this template.
You may make archival copies and customize this template only for your personal use or use
within your company or organization and not for resale or public sharing.
attribution, or other proprietary notices or marks within this template.
This template and any customized or modified version of this template may NOT be sold,
distributed, published to an online gallery, hosted on a website, or placed on a public server.
Provided that you observe the above terms, you may share your edited version of this template
*privately* with those specific people who **require** access to it within your immediate family,
organization, or company.
* "Privately" means only accessible to those few people who you expressively give permission to
view or edit your file. It is your responsibility to ensure that adequate security measures are used so
that your file is not available to the public.
** Examples of acceptable private sharing with people who "require access" may include (a)
sharing a budget spreadsheet with a spouse, (b) sharing a project schedule with your project team,
or (c) sharing a timesheet with your employee or manager.
See the following page on Vertex42.com for the complete license agreement and examples of
other allowed uses:
This template is provided for informational or educational use only and is not intended to be relied
on as medical, financial, legal, or other professional advice.
Vertex42 LLC makes no guarantee or representations about this template, or the accuracy or
completeness of the content contained within this template.
Vertex42 LLC encourages you to seek the aid of a qualified professional before making decisions
regarding health, financial, or legal issues.