Liabilities (1)

Liabilities are essentially debts. They can be:
current (short term): due & payable within 1 year
long-term: due & payable in over 1 year

The most common liabilities are:
Accounts Payable: for routine expenses and inventory purchased on credit

Notes Payable: short- or long-term loans from banks or other lenders

Accrued Expenses: various current expenses, accrued to prepare financial statements; these can include accounts such as interest payable, taxes payable, wages payable, and other similar accruals at the end of the year.

Mortgage Notes: long term borrowing to purchase major assets; the assets purchased are also pledged as collateral

Bonds Payable: corporation general debt; bonds of major corporations can be purchased on a public stock exchange; bonds pay interest on a regular basis, usually twice a year; bonds may have maturity dates from 5 to 30 years, or any other time frame selected by the company and acceptable by lenders.

Liabilities often have to be estimated at balance sheet date, so we can prepare financial statements.

Amortization table
An amortization table is a calculation involving interest and regular payments, or reductions, in an account or debt. Costs can be amortized over several years, using an amortization table. They are usually prepared to show the progress of loan payments, especially in long-term mortgage loans. If you have a home loan, you will probably get an amortization table from your bank, showing how your payments are divided among interest, principle and other fees (escrow).

Amortization tables are relatively easy to prepare. The use of computer spreadsheet programs makes creating these tables a very simple task. One "template" can be created and used over and over for different amounts, interest rates and time frames.

Interest calculation
Interest applies to many liabilities. Notes, bonds and mortgages all involve interest.

Interest is the fee you pay for the use of someone else's money. The calculation is always the same.

Interest = Principle X Annual Interest Rate X Time (portion of a year)

Interest Rates are always expressed in annual terms. For instance, 12% interest means 12% per year, or 1% (1/12) per month.

The Time factor is always in relation to a year, so it maintains the correct relationship with annual interest rates. One month's time factor would be 1/12. Three months' would be 3/12, 7 months would be 7/12, etc.

Sometimes interest agreements are expressed in a number of days. We usually use a 360 day year to make the calculation easier, and more rounded. This goes back to the days before modern calculators and computers, when we used pencil and paper to calculate interest. Example: 30 day note uses 30/360 time factor.

Using Amortization Tables
Amortization is an accounting method used to spread costs or payments over a period of time, based on a few basic concepts: Time, Principal (money or cost), and Interest Rate. Amortizing a loan balance uses all three of these to reduce a loan balance to zero over a number of years. This might apply to a home mortgage or automobile loan. It might also apply to an automobile or equipment lease.

Interest is always expressed as an annual Rate, so your interest calculation must always have a Time factor. For instance, one year's interest on $100 at 12% (annual rate) is

$100 x 12% = $12 annual interest [on your calculator 100 * .12 = 12]

If you make a home or car loan payment every month, you would not want to pay a year's worth of interest on each monthy payment, would you? (this is not a trick question ;-) Of course, you would only want to pay one month's interest each month. So we have to add a Time factor to the annual interest calculation above. In this case there are 12 months in a year, to calculate one month's interest we would use 1/12 as a Time factor.

$100 x 12% x 1/12 = $1 monthly interest [100 * .12 / 12 * 1= 1]

If you wanted to calculate interest for 2 months you would use 2/12:

$100 x 12% x 2/12 = $2 interest [100 * .12 / 12 * 2 = 2]

The monthly payment amount stays the same each month, and is divided between interest expense and principal reduction. As the principal goes down, so does the interest expense. Eventually the principal amount is zero, perhaps over 5 years for a car loan, or 25 years for a home mortgage.

Let's say you buy a new home with a $100,000 mortgage, spread over 25 years, at 8% interest. How much is your payment going to be, and how much interest will you pay over the life of the loan if you make all the payments on time? Here's a good website you can visit to answer this type of question.

http://www.interest.com/calculators

I used their calculator to answer this question, and create an amortization table. It took about 10 seconds. Your monthly payment would be $771.82 and your total interest over the life of the loan (25 years) would be $131,542.40. In total your $100,000 loan would cost you $231, 542.40 -- that's over twice the amount of money you originally borrowed, in fact you would pay back 2.3 times your original loan amount.

Many borrowers reduce their overall interest expense by making extra principal payments on their loans whenever possible. Look at an amortization table you will see that most of the monthly payment goes to Interest and only a small portion goes to Principal Reduction. [If you have not done so yet, use the calculator link, and enter the amounts shown above, then generate an amortization table and look at it.]

At the end of month 1, you would have paid $771.82 ($666.67 interest and $105.15 principal). This reduces your principal balance to $99,894.85. If you were to make all the first 12 payments on time you would have paid $9,261.84 ($7952.69 interest and $1309.15 principal.) At the end of 12 months the loan balance would be $98,690.85. Now, follow closely at this point.

Principal balance after month 1	$99,894.85
Principal balance after month 12	$98,690.85
Difference	$1,204.00
Month 1 payment	$771.82
Total payment	$1975.82

If I pay and extra $1204 principal in month 1, it will reduce my principal balance and move me down the amortization table to where I would be after 12 months. I would avoid paying the amortized interest for months 2 - 12, a savings of $7286.02 over the life of the loan.

In other words, paying an extra $1204 principal saved me $7286 in interest. It would also reduce my total loan payments by 1 year, because I moved down 12 months on the amortization table.

An alternative: Let's say you can't afford to pay that much extra principal each month. If you move down the amortization table one extra month, and pay just that amount of extra principal, you would cut your total interest (about) in half, and cut the loan payoff time in half. In this example you would reduce the loan from 25 years to 12.5 years, and reduce your total interest from $131,542.40 to (about) $65,771.20 - a huge savings!!

CAVEAT: You must still make monthly loan payments, even if you pay off some principal early. So you should incorporate extra principal reduction strategies into your overall cashflow budget. But the earlier you reduce your principal, the better.

Using a spreadsheet, you can quickly create an amortization table for any principal amount, interest rate, payment amount or time factor. With a spreadsheet you can quickly see how different interest rates and payment schedules can effect your personal finances. You can use it for credit cards as well. The same concepts apply.