Accounting Unplugged


How to Use Financial Statements and Ratios

Posted in 2. Double Entry Transactions,5. Financial Statements,6. Operations by Erin Lawlor on the September 24th, 2008

<< Accounting System Structure – Quick Reference

This post talks about how to make use of the information in Financial Statements.  Those statements are really the results of past operations.  It is important to use this information to be proactive and look to the future to predict results and to set goals, expectations and budgets based on the evidence provided from the past.

Time analysis is the most important tool you will use in analyzing your Financial Statements.  It is essential in managing and securing resources because it can quickly pinpoint changes that indicate errors or fraud as well as the unexpected changes that might require adjustments to cash planning and/or operations.

The first Statement to look at is the Comparison Trial Balance.  This Statement is very important, it shows the amounts posted to each account month by month complete with totals at the end.  The month to month analysis is extremely important for verifying your numbers before you start with ratio analysis.

You can either show all accounts on this Statement or you can limit it to Income Statement Accounts. I choose to include both types of Accounts so I can track the changes in Financial Position provided by the Balance Sheet Accounts.

I’ve added a few entries to the Comparison Trial Balance Report from posts # 7 and 9.   You can see that the monthly changes in Rent Expense for Oct and Nov will catch your attention.

Account Description Jun Jul Aug Sept Oct Nov Dec Total
1000 Checking -$3,000 $-3,000 $-3,000 -$3,000 -$3,000 -$3,000 -$3,000 $-21,000
2000 Accounts Payable $0 $0 $0 $0 -$3,000 $3,000 $0.
7000 Rent $3,000 $3,000 $3,000 $3,000 $6,000 $0 $3000 $21,000
Totals $0 $0 $0 $0 $0 $0 $0 $0

**This example starts with June because of space limitations here.  The additional entries for all months except September are not included in the Income Statement or Balance Sheet, I’ve only added them here for illustration.

Let’s start with Financial Ratios by looking at the Income Statement and its ratios.

Income Statement:

The Income Statement gives you a good overview of your Expenses in relation to your Revenue.  It can also help to pinpoint potential problems.

As the dollar value of Sales changes, the dollar values of Costs of Goods and Expenses should also change.   By tracking the changes in dollar values in terms of percentages of sales, you can more easily evaluate whether changes in dollar amounts are reasonable.

The percentages are based on a Percentage of Sales.  So, Gross Profit Margin = Gross Margin/Sales, Net Profit Margin = Net Income(Profit)/Sales etc.

Know your percentages. Watch your trends over time, both as they accumulate throughout the fiscal year, and as they compare month to month and year to year. Percentages can also be compared to industry ratio standards to measure your results against others in your industry.

Some expenses like wages and payroll taxes, or general office expenses are more meaningful when grouped together to find a percentage of the group rather than as a single line item.

This is the Income Statement that developed through the progressive post entries.

Income Statement % of Sales
Sales $50,000
Cost of Goods Sold $0 0%
————
Gross Margin $50,000 100% Gross Profit Margin %
Rent $3,000 6%
Office Supplies $150
Subscriptions $300
Utilities $125
Fuel $275
Repairs & Maintenance $500
Credit Card Interest $50
———–
Operating Expenses $4,400 9%
———–
Operating Income $45,600 91% Operating Profit Margin %
Other Revenues and Expenses $0
Net Income $45,600 91% Net Profit Margin %

This is a very limited Income Statement Example built from very few entries, but even with the information available, it gives useful information.  There is also obviously a problem with this Income Statement, it has no Cost of Goods Sold to relate to Sales.  In this case, we’re either missing information or we’re violating the Revenue Principle and recording Sales before they’ve been earned.  (Pinpointed Problem)

Gross Margin is also called Gross Profit or even Gross Profit Margin and the terms Income and Profit are also often used interchangeably.  Just be consistent in your terminology so that users will not be wondering if there is a difference in meaning if you use a different term.

**Comparing your business against other businesses in your industry is called Benchmarking.  There are a number of free or fee based benchmarking services online.

Remember that the Income Statement is a Yearly Statement, all its accounts are reset to zero at the end of each year and the difference (Net Income) is transferred to the Equity section of the Balance Sheet as either Retained Earnings (for Corporations) or as Owners Capital (for all other types of entities).

Balance Sheet Ratios:

The Balance Sheet gives you a good overview of your financial position at any point in time.  The Balance Sheet is not a Yearly Statement, it is a cumulative statement whose accounts retain their balances from the beginning to the end of the entity.

All Assets and Liabilities on the Balance Sheet should contribute to increasing the value of the entity.  If they are not contributing, they might need to be liquidated.

The “Current” sections of the Balance Sheet are important to keep track of because it will be Current Assets which will pay off Current Liabilities, you want to make sure you have at least as many Current Assets as Current Liabilities.  The items in the Current Sections are considered to be the most liquid, that is, they are the most likely to be able to convert to cash at (or close to) their stated value.

Two Assets to pay particular attention to are Accounts Receivable and Inventory.  Receivables are an essential tool in doing business, they finance purchases for your customers but it is important to watch their aging and balances to make sure you are not extending credit to customers who are unable to pay.  Watch Inventory turnover to make sure you that your inventory is selling and that you are not carrying obsolete or otherwise unsellable items.

Purchases that your Vendors finance for you are liabilities called Payables.  Payables and other Liabilities are essential for financing current operations and growth but keep close track of their related interest and fees to make sure their costs do not exceed their benefits.

Balance Sheet
Assets
Current Assets
1000 Checking Account $44,350
Fixed Assets
1500 Office Equipment $1,300
1520 Office Furniture $1,650
————
Total Fixed Assets $2,950
————
Total Assets $47,300
Liabilities and Equity
Current Liabilities
2000 Accounts Payable $1,700
————
Total Liabilities $1,700
Equity
Net Income $45,600
————
Total Liabilities and Equity $47,300

Some important financial ratios to keep track of are:

Current Ratio which is Current Assets/Current Liabilities this ratio should always be at least 1

Quick Ratio = Current Assets – Inventory/Current Liabilities this ratio removes Inventory from Current Assets because Inventory is usually the least liquid of the Current Assets.

The next ratios are approximations, they give you a good idea about what they are measuring.  They are general enough to give you an idea about where to look for trouble items but they are not specific enough to be fool proof.

Inventory Turnover = Sales/Inventories this ratio gives you a rough idea of how many times your inventory is sold and restocked.  Of course, it does not specifically identify inventory items so there may be items that are not selling but it does tell you how well your sales are covering your costs.

Days Sales Outstanding = Receivables/(Sales/360) this ratio gives you a number that represents aging of your receivables.  If your terms are net 30 days and this ratio gives you a number of 45 or more, then it is a good indicator that you should watch your collections carefully.

Fixed Asset Turnover = Sales/Net Fixed Assets (Fixed Assets – Accumulated Depreciation) this ratio provides an idea of how effectively your Fixed assets are contributing to operations.   This ratio can be slightly misleading because Assets are carried at book value rather than market value which might scew this ratio depending on the age of the Assets.

Total Assets Turnover = Sales/Total Assets this ratio provides an idea of how effectively your total assets contribute to operations and increases in entity value.  Although this ratio will have the same problems as the Fixed Asset Turnover ratio both of these ratios are still important to recognize and watch for trends.

As I said at the beginning of this post, know your percentages (ratios) watch them carefully.  You should use them to your advantage for predictions, corrections and budgets for your current and future operations and policies.

© 2008 – 2010 Erin Lawlor

<< Accounting System Structure – Quick Reference

**disclaimer: All information posted on this blog is from my own experience and training. The guidelines I present are general and in my experience, standard practice. I do not write with authority from any Accounting Standards Boards.

Comments Off on How to Use Financial Statements and Ratios

Double Entry Accounting – Transactions – 2 of 2

Posted in 2. Double Entry Transactions by Erin Lawlor on the August 28th, 2008

<< Double Entry Accounting – Basics >>Chart of Accounts – Basics

In these examples, we will continue to focus on the descriptions and the amounts of financial transactions so we will be making entries in a 3 column grid where the left column is for descriptions and the two remaining columns are numeric and are for debits and credits.

Since we’re focusing on only three aspects of the transaction, the three questions that must be answered for each financial transaction in double entry are:

  1. What is the value of the transaction in terms of dollars (how much money changed hands)?
  2. Where did the money go – What was gained or paid for by the exchange?
  3. Where did the money come from – what is the source of the money in this exchange?

The amounts that are associated with question 2 are always entered in the debit (left numeric) column and the amounts associated with question 3 are always entered in the credit (right numeric) column.

Money is not always directly involved in a transaction.  Sometimes the transaction involves a trade or sometimes it involves a money substitute, a promise of future money transfers – as with credit card purchases – but something of value is always exchanged for something else of value in a financial transaction.

In the previous post, the transaction was very simple and money was involved, there was a $3,000 rent charge that was paid in full from the checking account.

Description Debit Credit
Rent $3,000
Checking Account $3,000

What about in the case of a credit card statement where there are many different types of charges made to one credit card.

Answer 1 :            Total Charge on Statement = 2,500
Answer 2a:           Office Supplies
Answer 2b:           Fuel
Answer 2c:           Tires
Answer 2d:           Subscriptions
Answer 2e:           Printer
Answer 3 :            Credit Card

In this case, since there are multiple answers for question 2, the descriptions and the amounts related to each separate part of the answer are listed on separate lines but the total amount associated with Question 2 and with Question 3 will always be equal.

Description Debit Credit
Office Supplies $300
Fuel $275
Repairs & Maintenance (Tires) $500
Subscriptions (Trade Magazines) $125
Printer $1,300
Credit Card Payable $2,500
———- ———-
Totals: $2,500 $2,500

——

Sometimes the promise of future money is not a debt to be paid by you but a debt to be collected by you as in the case of a sale where you bill the customer.

  • Answer 1:  50,000   (The amount of the transaction)
  • Answer 2:  Accounts Receivable  (What was gained?  In this case the gain was a short term promise to pay.)
  • Answer 3:  Sales (Where did the money come from?  What is the source of the money?)
Description Debit Credit
Accounts Receivable $50,000
Sales $50,000

*for readability: traditionally, debits entries are listed above credit entries and the description for the credit entries are traditionally indented.

Double Entry requires a minimum of two lines, or accounts, to fully describe a financial transaction.  In cases where there are multiple answers to one of the questions, the term Double Entry can seem like an inaccurate description but Double Entry does Not refer to the number of lines or accounts required to record the transaction.  It refers to the left/right entries where the full amount of the transaction must be entered in the debit column and again in the credit column – double entry – regardless of the number of lines required to fully describe the transaction.  The philosophy of Double Entry is a balanced financial picture requiring that both the Uses and Sources of funds be recorded.  Debits, Credits and Accounts are just part of the Structure that helps to ensure that balance.

This post completes the most important concepts of double entry accounting transactions. Once transactions are posted, the Chart of Accounts helps to organize and summarize them.  The next post, explains the basics of the Chart of Accounts.

© 2008 – 2010 Erin Lawlor

Next Up: >>Chart of Accounts – Basics

<< Double Entry Accounting – Basics

**disclaimer:  All information posted on this blog is from my own experience and training.  The guidelines I present are general and in my experience, standard practice.  I do not write with authority from any Accounting Standards Boards.

Double Entry Accounting – Transaction Basics

Posted in 2. Double Entry Transactions by Erin Lawlor on the August 27th, 2008

<< Accounting Overview >>Double Entry Accounting – More Transactions

The Double Entry System has endured since at least the 12th century because it is a simple, consistent and reliable system of gathering and organizing information and producing financial reports for financial management and for tax and reporting purposes.

The first task of the system is to gather balanced data from financial transactions – to record both what was gained or paid for and the source of funds.  Financial transactions are exchanges of things of value. Even if money is not part of the exchange, a dollar value must be used to represent the exchange.  Since a dollar value must represent the value of each exchange, I’ll often use the terms “money” or “funds” when referring to the value of each financial transaction.

In this post, I’ll explain the method of collecting and posting financial data in the Double Entry Accounting System.  The entire Double Entry System is built around the concept of balance, recording both the Use and the Source of funds.  Once the Double Entry concept is understood, the whole system of data collection, organization and summary is easily understood.  This method is standard and works the same way each time, no exceptions.

There are three basic questions that must be answered for the double entry accounting transactions, they are:

  • Question 1. How much money changed hands? What is the value of this exchange?
  • Question 2: How was the money used?  What was either gained or paid for by this exchange?
  • Question 3: Where did the money come from? What is the source of the money in this exchange?

Example:

  • Answer 1: 3,000.00
  • Answer 2: Rent
  • Answer 3: Checking Account

The answers for each of these questions are recorded in a journal that has a grid format. The columns of the grid collect a variety of information but for the purpose of this discussion, we’ll use three columns. One column for descriptions and two numeric columns for amounts. The left numeric column is called the “debit” column and the right numeric column is called the “credit” column.

The descriptions that answer questions 2 and 3 are always entered on separate lines to the left of the two numeric columns.

The amount associated with question 2 is entered on the same line as its description and it is always answered in the left (debit) numeric column. The amount associated with question 3 is entered on the same line as its description and it is always answered in the right (credit) numeric column.

Description Debit Credit
Rent $3,000
Checking Account $3,000

You see that the amount from question one is entered twice (double entry), once in the Debit Column and once in the Credit Column.  If you have answered all three questions for each transaction and both columns always add up to the same number, your books are in balance. This brings us to the most basic rule of accounting.

Rule # 1: Total Debits = Total Credits

To recap: Accounting requires that for each financial transaction, the basic questions of how much money is involved, where the money went and where the money came from are answered.

In order to ensure that these questions are always answered for each transaction, the Double Entry System is used.  The Double Entry Transaction System is a multi-line, two numeric columned system. The left numeric, or “debit” column is always the “where did the money go – what was gained or paid for” column and the right numeric, or “credit” column is always the “where did the money come from – what is the source of money” column. The total of one column must always equal the total of the other.

Double Entry does Not refer to the number of Accounts or Lines required to record a transaction.  Double Entry refers to Debits and Credits (two sides = double).  If you have fully described both the Use and the Source of Funds, you have accomplished the objectives of Double Entry.

© 2008 – 2010 Erin Lawlor

Next up: >>Double Entry Accounting – More Transactions

<< Accounting Overview

**disclaimer:  All information posted on this blog is from my own experience and training.  The guidelines I present are general and in my experience, standard practice.  I do not write with authority from any Accounting Standards Boards.