Balance Sheet Excel
The Balance Sheet is laid out in a particular fashion that reflects one of the most basic precepts of accounting: Assets = Liabilities + Owners Equity or A=L+C Since we are dealing with an equation one side must ultimately and always equal the other side (think back to high school algebra!) Therefore the total dollar amount is always the same for each side i.e. total assets will always equal the total of liabilities + capital (or equity). Stated differently the left and right sides of a balance sheet are always in balance. Some balance sheets will have assets at the top and liabilities and capital at the bottom...no matter...A will always = L + C. Assets are the things your business owns that have some monetary value.
It tells how the business is put together what its principal resources are and where any potential dangers lie. Like any portrait it is incomplete in that it only shows one fleeting moment in time and therefore is most useful in conjunction with the income statement and by comparing several balance sheets over a period of time. Ahh this is where the real story begins to unfold! The clever entrepreneur becomes the Sherlock Holmes of the balance sheet and astutely looks for trends over time and checks ratios and balances to see which direction the company is headed in and to look for any potential to cut costs or perform more efficiently.
Most Popular This Week
Before the disaster the only thing that had any importance was whether a potential buyer of anything could afford to make the payments on whatever he was buying assuming he made 120% of his stated income. The most outrageous symptom was that people would take appreciating home equity and borrow against it to buy depreciating assets and consumer goods. They overbooked their budgets and now they have gutted their balance sheet. The resulting loss of home values is the disaster we have now where people have either a zero or minus Net Worth. The other aspect is that we are now wiser. For the good of our society and our financial infrastructure we had better be. Going forward we must pay attention to our Balance Sheets and recognize that is where the gold is.
When financial statements are put together the balance sheet will most commonly be the first page in the review. Within the year end statement you will also need to have the cash flow income and note statements. Once all of this is prepared you can then begin completing the balance sheet. The category you will need to work with first when completing balance sheet accounting are the assets. First you will list the current assets which will include prepaid expenses inventory cash investments of short term and receivables due. Then you will need to list the investments which will be any investments that are contracted for longer than one year. The next subtitle will be fixed assets which include equipment and property. If you have any other assets that do not fit into the previous categories you can create a subtitle for all other assets. You will then need to total all of these figures and combine them into a total. Once you list your assets you will then to create a category called liabilities. Within your current liabilities you will need to list interest due within the year income taxes and accounts payable. After this you will need to display your long term liabilities. This will be anything you are paying out longer than one year and then again total it all up.