Amortization information

Loan Amortization Tables

Probably the most important investment that any one is ever likely to make in their lives is when they take out a mortgage to purchase a home. However in order for you to work out just what the right sort of mortgage is for you, you will need to calculate just how much you can afford. One of the most important things you need to be concerned with when taking out any sort of mortgage is what the rate of interest will be. Although there are various ways in which a person can actually work out what the interest rate is going to be on their mortgage most of the banks will calculate theirs according to a loan amortization table. Amortization is the number of years on which the loan has been taken out for in order for you to repay it fully.

Below we provide you with three of the different types of loan amortization tables that are used.

1. Equal Capital – This particular calculation system will show the monthly payments which are equal as well as the total payment to the bank which changes and the repayments which decrease as the term of the loan heads towards its expiry date.

2. Spitzer Amortization Table – This is probably the most optimal repayment method. With this type of loan the monthly payment you make is fixed and this is due on account to the capital and interest changing during the repayment period. Unfortunately there is a common misconception among many people who think that during the first year of this type of loan being taken out you will pay most or all of the interest on the loan.

3. Bolit Amortization Table – This particular method is where the payments are made on the interest and not on the principal loan and it is only after a given period that you will then begin to pay off the amount of the loan that was originally taken out.

Unfortunately there are many risks associated with loan amortization tables and these are the linking risk, the rising consumer price index, the rising prime risk, the exchange rate changing risk and a fluctuating interest rate risk. But if you are able to define the risk involved then you will have a better understanding of how each component has been cause and so by using the right sorts of tool it can then be neutralized.

Formula for working out interest

Interest is a fee paid for the use of someone else’s money. Interest is calculated on several formulas, but the most important one that you need to know, if you’re borrowing money, or have money in a savings account, is the Rule of 72.

Before we get to the Rule of 72, we’re going to define some terms. An interest rate is the percentage of the original amount of money that’s added to the balance (or charged to your account) each year. So, if you borrow 100 dollars at 5% interest, at the end of 1 year, you’ll owe 100 times 1.05 = 105 dollars. If you borrowed the money and paid it back over 2 years, you’d owe 100 time 1.05 times 1.05 = $110.25. As you can see, compound interest adds up pretty quickly!

When you take out a loan with a specified payment term (Say, 100 dollars, paid back in 2 years, at 5% interest), you’ll be making a payment each month for two years (24 payments total) with the sum equaling the 110.25 we derived earlier. That comes out to 110.25 divided by 24, or $4.59 per month.

Which brings us to the Rule of 72. Stated very simply, the Rule of 72 is a short hand way of doing compound interest. To find out how many years it will take for an loan’s interest to double the amount borrowed, divide 72 by the number of points of interest rate. For example, at 5% interest, you’d have 72/5, which is 14.4 – if you took 14.4 years to pay off that initial loan of 100 dollars, you’d end up paying a total of 200 dollars to your lendor.

Now, when you take out a certificate of deposit, or just put money in your savings account, the formula for interest works in your favor – to find out how long it will take your initial investment to double, divide 72 by your interest rate, and that’ll let you know what to expect. (This rule of 72 also illustrates why 401(k) with their employer matching funds, are such a good deal. When you contribute to your 401(k), your employer puts the same amount of money in – effectively doubling your investment instantly. With most annualized stocks averaging 8%, and most bonds hovering around 3-4%, you can see, by the Rule of 72, how much of a benefit that will be!)

The last thing to think about when you’re thinking about formulas for interest is inflation. To find out how much your nest egg is really growing by, subtract the inflation rate from your interest rate, then apply it to the Rule of 72. Thus, with inflation rates of around 3%, and investments getting about 8%, the net rate of increase is 8 minus 3 equals 5%, and 72 divided by 5 is about 14 to 15 years.

Get Me Out of Debt!

Why is it Important to Curb Debt

In these financially troubling times, you are not alone if you are wishing that someone would come along and, somehow answer your question of how to get me out of debt. Large debts, poor credit and high interest rates are stressful and demoralizing and not the way you should have to live.

When you first begin a get me out of debt plan, it will be hard. The key is to imagine what your future will be like without all those worries, those harassing phone calls, or the denied purchases. Then think about all the opportunities you see or want and the freedom and ability to take advantage of them.

Creating a working budget is the initial step you can take toward implementing your get me out of debt plan. Your budget will help you to stay on track and avoid piling on more debt. It should guide your spending and show you what to expect in the short-term and long term. If you haven’t tried keeping track of your spending, begin today.

In order to know how much to budget for each of your expenses, you will need to track your spending for at least a month. And don’t forget, the “get me out of debt” plan must also include budgeted amounts for infrequent and less regular expenses such as car maintenance, entertainment, savings, and gifts. You will have to estimate your monthly spending in these areas.

Your budget will tell you how much money is available to put toward your goal of getting out of debt for good. In addition to what you’re already paying, any extra money in your budget will also go toward paying down your debt. Tackle the smallest debts first, and once they are erased you’ll feel more inspired to pay off the bigger debts you face.

Getting out of debt will not be easy. Even with a good “get me out of debt” plan you will still have to work hard at it, make sacrifices and be determined to follow through. But, if you keep your eye on the prize of being debt-free at last, the temporary hardships won’t seem so bad. Just keep focused on the gold at the end of the rainbow and you will surely succeed.

Getting your carefully planned budget in place is your highest priority for your get me out of debt plan because that is your road map to success. It will tell you what bills need to be paid and when to pay. Your plan will give you confidence and as your debt diminishes, you will start to anticipate your approaching freedom.

Prepare an amortization schedule for a three year…?

Prepare an amortization schedule for a three year loan of ,000. The interest rate is 9% per year, and the loan calls for equal annual payments.

How much interest is paid over the life of the loan? (use a financial calculator)
(Also, develop the amortization schedule using Excel spread sheet)


Friends of Amortization Fast

My negative amortization loan?

I have a negative am loan which i was tricked into getting by my broker but thats another story, anyways my wife loves this home and i do not want to sell it but im afraid i wont be able to afford it if i were to refinance at the current rate, i have 2 more years before i can refinance without a penalty and i currently have about 90k in equity. What can i or should i do?? whats a great loan that’s out there that can help me out until i can better stabilize myself economically, my wife is going to school and works part time so i cannot afford a higher payment now, she should finish school in about 1 1/2 years and might be better off financially then. What is a good loan that can help me out and have a low payment and not negatively amortize??


Friends of Amortization Fast

How do you calculate Amortization?

Ok so I have to do an amortization table by hand now I know how to use the TVM solver on my calculator…but what do you do after that? So you have to future value the interest and everything but then how do you use it to fill the table? Im sorry if this question seems juvenille but I would really appreciate some help. Thank you :)


Related Blogs

how can i calculate amortization on the BA II Plus calculator?

You have just taken out an installment loan for
0,000. Assume that the loan will be repaid in 12
equal monthly installments of ,456 and that the
first payment will be due one month from today.
How much of your third monthly payment will go
toward the repayment of principal?
a.,757.22 b. ,359.12
c. ,212.50 d. ,925.88
e.,333.33


Related Blogs

where is the best site to get a loan amortization table?

A table of rates to help me calculate the amortization on my own.


Related Blogs

Need an amortization calculator?

I’m looking to calculate when my loan will finish (paying above the minimum payment) rather than how much i will be paying. I just need the name of what this would be called. any help is appreciated.

Thanks in advance


Related Blogs

Where I can I find an advanced loan amortization calculator?

I need a loan amortization calculator or spreadsheet that will allow me to input graduated payments (ex. 12 months @ followed by 36 months @ 0 etc). I’m trying to chart and graph a payment schedule for my student loans. The online calculators I’ve found only let you input one set of payments.


Related Blogs