Part of the x3y community

Using Amortization Spreadsheets to Make Big Money

Amortization spreadsheets can be intimidating when viewed from a distance, but once they are understood, they can be very useful. A good amortization spreadsheet or amortization schedule or table as they are also known, can be helpful in saving you money by informing you which mortgage offer is best for you. They can also help you to plan a strategy to pay off your mortgage ahead of time by adding a relatively small amount to your monthly payment.

Doing this will free up investment capital so you can make money, a lot of money. In fact, right now you will learn how to build amortization spreadsheets. Then you’ll see how to use them to pay off your mortgage quickly and then parlay those savings into big-time money.

What to enter into an amortization calculator

Most amortization spreadsheets are simple to construct when you are using a good online amortization calculator website. All you need to do is input the total amount of the mortgage, the interest rate and the length of the mortgage. Some amortization calculators ask for the length in years, others ask for it in months, for instance, 360 months instead of 30 years.

After you click the calculate button you’ll see your amortization spreadsheet. You will notice each month’s payment is broken down into two parts, interest and principal. You’ll also notice the interest part of the payment; at least in the early part of the mortgage, will be by far, the higher number. This is because each of these early payments consists of much more interest than principal. It is this dynamic we’re going to use to save a lot of money.

An example in big money saving

This method will work with any mortgage, but for our purposes, we’ll use these fictitious numbers. We have a mortgage of $225,000. The interest rate is 7.25%, and the length of the mortgage is 30 years. When we enter these numbers into our amortization calculator, we find the monthly payment to be $1,534.90.

When we look at the first payment on our spreadsheet, we see that out of this $1,534.90, $175.53 goes toward principal and $1,359.30 to interest. When we look at the second payment we see, $176.59 will go toward principal and $1,358.31 will go toward interest.

If we pay the second payment’s principal part, $176.59 upfront, or at the same time as the first payment, we will save the $1,358.31 in interest. Why do we save all this money? Because after we make our first payment, we will have a balance remaining on the mortgage of $224,824.48. The difference between how much interest we pay for borrowing this amount of money for 359 months and 358 months is $1,358.31. So, by paying $176.59 with the first month’s payment, we will now be on time to pay this mortgage in full in 358 months instead of 359. Yes, this is amazing!

Now, if we go on down the line paying the principal amount of the next payment due, ahead of time each month. We will be saving the corresponding much higher interest charges.

It does get a little more expensive.

As time goes on, the principal payments get higher and the interest gets lower. Still, after two years, the 24th payment, the principal is only $201.61, and after six years, the 72nd payment the principal is still $269.20.

If we stopped paying our principal payments ahead at this time, we will have knocked three years off of the time it would take to pay our mortgage off in full. This would happen because we would have paid three years on time and three years ahead of time.

Payoff a 30-year mortgage in 15 years

What if we want to pay off the mortgage in 15 years? Here’s the secret. Go to the 180th payment. Here, you’ll see that principal part of the payment is $515.93. If we add this amount onto each of our payments from the first payment of our mortgage to the 180th payment of our mortgage, the mortgage would be paid in full in 180 payments, or 15 years.

$515.93 may seem like a lot to pay upfront, but even if you were to take the principal part of payment number 55, $243.00, and add it on to each payment, you would have your mortgage paid more than 10 years sooner.

Summing it up, you can use this as an approximate formula: On a 30 year mortgage, add to each payment, the amount equal to the principal part of payment number 180 and you will have the mortgage paid in 15 years. Or, add to each payment, the amount equal to the principal part of payment number 55 and you will have the mortgage paid in 20 years. While this formula doesn’t work perfectly for interest rates over 10%, for interest rates around 7%, it is fairly accurate. Now, let’s see how to turn that savings into wealth.

Invest the savings

You could, of course become a real estate investor, but for simplicity sakes, let’s just say you invested $1,534.90 each month in a managed fund that returns 10% yearly. After 10 years you would have $318,127.75. Also, don’t forget you would have a house, which would be paid in full. I’d say you’re pretty close to being rich and it all started with learning how to use your amortization spreadsheet.

By: Edward Lathrop

Tags: , , , , , , ,
Posted in Finance · January 30th, 2010 · Comments (0)

Mortgage Rates Predictions – What the Charts Are Telling Us

Mortgage rates have a lot to do with how well the economy is performing. When mortgage rates go up, people can no longer afford to invest money in new properties. This, of course, brings a slow down to the building trade and it also means less money will be flowing through the economy.

On the other hand, when mortgage rates go down, more people are able to buy homes. The further down rates fall, the lower the income needed to buy homes. When homes are being bought, the building trade flourishes and this stimulates the economy in many ways.

Remember high interest rates?

It’s been 20 years since we’ve seen double-digit mortgage interest rates. Going back to the late ’70s and early ’80s, double-digit mortgage rates were the norm. It wasn’t until about 1985 after the Reagan administration had put an end to stagflation and the misery index that haunted the Carter years, that mortgage rates found buoyancy at around 7%.

Since that time, mortgage rates have fluctuated between 9% and about 5.5%. All in all, it has been a long stable interest rate environment that we have enjoyed over these past years.

Higher or lower?

Now, the question is where do interest rates go from here. By reading the charts, we will attempt to predict their future movement, just as if we were reading the commodities charts to get a handle on which way the price of soybeans were headed. Then, we’re going to make a prediction about another commodity that is sure to be shocking!

At this time, it is wise to make a disclaimer. First, no one can truly predict the future and second, any world event can change what the future looks like now in a heartbeat. Also, you can’t overlook the fact these unforeseen world events can happen out of the blue. With that behind us, let’s take a look at charts.

The past 18 years

Throughout the ’90s, interest rates on 30-year fixed mortgages ranged between 9% and 7%. At the time George W. Bush took office, the average 30-year mortgage rate was 8.75 %. From here, it eased downward steadily through the first George W. Bush term. It actually hit a low of 4.75% in late 2003. Here, interest rates ranged between 6.5% and about 5.5% for the next 3 years. This was an uncommonly stable interest rate environment and it was one of the reasons the housing market became red hot, and yes, overbought.

In 2006, the trend broke above 5.5% to about 6.5%, but rates never went any higher. Now, the interest rates are hovering around six percent and trending downward.

Reading the charts

The technical trader, that is, one who trades commodities by reading charts, would certainly believe interest rates, since they are heading downward, would have to once again test the low of 4.75%. It will be important to see if a double bottom is made at 4.75%. If this bottom is made, interest rates will go up.

Because of underlying fundamentals of the market, for instance the Fed trying to lower interest rates to stimulate the housing market, it seems much more likely interest rates will break through the 4.75% low once they arrive there. If they do, a new downward trend will be on the way. Just how much lower interest rates could get, is anybody’s guess. However, it certainly isn’t out of the question we could see 4% 30-year fixed mortgage rates sometime before this downward trend ends.

4%!

Historically speaking, 4% is a very low interest rate, but at this time it truly looks like we are much more apt to see 4% than a higher number, like 7%. So, for what it’s worth, this is my prediction. We will see the interest rate on a fixed 30-year mortgage somewhere down around 4% before an inflationary aspect of the economy takes over.

Where you think this inflationary aspect will come from? Well, here is another prediction and you may find it more astounding than the first one!

The impossible dream

It’s all over for the crude oil rally. Crude oil is overbought! There is no reason for crude oil to be trading above $100 a barrel. Like the tech stock boom of the ’90s and the housing market bubble of a couple years ago, it is a rally that cannot be sustained forever!

It’s anybody’s guess as to what the true market value of crude oil is right now. However, to think it is somewhere between $50 and $60 a barrel would be logical. However, when prices fall they tend to go through the true market value before they float back up to it.

If this crude oil market bubble burst follows the same modus operandi normal market bubble bursts follow, I can’t see why it is impossible to see $35 a barrel crude oil again; at least for a little while.

What would this mean for the price of gas? Maybe $1.49 a gallon? Well this may seem totally out of whack with what we’re hearing constantly coming from our news reports day and night, don’t think it can’t happen.

Back to reality

Certainly, there will be a time when $100 will not be too high a price for a barrel of crude oil. There will come a time when $3.50 is not too much for a gallon of gas. However, the charts are telling us that time is not here yet.

So, cheap gas, like the JFK, Ronald Reagan and George W. Bush tax cuts will stimulate the economy, and like the Bill Clinton Tariff agreements, it will make the cost of living lower which will make more goods affordable to the public. These things, though healthy for the economy, will bring on some inflation and this will break the interest rate downtrend.

I know these predictions seem pretty goofy and maybe they are! Still, my strategy is to believe they will happen and if they don’t, at least I’ll be happy believing them for now. Then again, if they do happen, we’ll all be happy!

By: Edward Lathrop

Tags: , , , , , , ,
Posted in Real Estate · January 21st, 2010 · Comments (0)

Bad Credit Used Car Loans

Bad credit used car loans are amounts of money dispensed to a person who wants to buy a used car, but has a bad or non-existent credit history with which to back up the loan. Are you looking for the perfect car, but you know you can’t afford a new one? Even if you were able to secure approval for a car loan, you know you will not be able to afford the monthly amortization and you believe that the rates are simply too high.

Even if you have a bad credit history for being unable to pay off your credit cards in the past, or you passed your mortgage dues, or even if you’ve filed for bankruptcy, it is still not impossible for you to get approved on a loan for a car. If you believe that you do not have enough money to afford a brand new car, but you know you still need one, you might as well settle for a used car instead. A bad credit history will not cause you problems in terms of getting a loan approved because cars can easily be used as collateral for your loan. Besides, you can easily find financial institutions that focus on helping people with financial disabilities get loans without much trouble. From these companies, you can get flexible loan terms with low annual percentage rates. Most of these financial institutions offer free online consultations with a loan calculator on their sites to help you compute for your loan and how much it would cost you every month.

By: Jimmy Sturo

Tags: , , , , , , ,
Posted in Finance · January 13th, 2010 · Comments (0)

Mortgage Calculator to Calculate a Mortgage For Best Results

What you need if you are looking to buy a house or a real estate property is a mortgage calculator and a loan calculator. These tools can help you understand and provide you the basic cost associated with your mortgage loan payments. To calculate a mortgage means you need these tools to be able to analyze and determine how much mortgage can I afford. Mortgage calculator to calculate a mortgage is the essential tool that can provide answers to your house hunting processes, estimates, questions and queries.

Home loan hunting and the process you have to through can be a daunting job especially if you are a first time home buyer. It will not be easy because there are so many factors you have to deal with. Things like how much can I borrow for a mortgage. The calculations of the projected monthly payments and different interest rates are not easy to accomplish especially if it is done manually or by hand mathematically. But now you do not have to deal with manual calculations because of online mortgage calculators.

There are so many types of mortgage calculator ranging from the simple one like a simple mortgage calculator or a rent versus hone buying calculator. Another is one that will calculate how much can I afford or will calculate how much can I borrow. These types of queries and questions that you may need answers can be done through these tools. To calculate a mortgage is much easier now than ever. With several online mortgage calculators available and free to use from the internet, I bet you will not have a problem with your estimates and calculations.
These are the only tools available online to calculate your home loan queries. If you are interested in the amortization schedule, there are tools that can calculate how much you will be paying monthly. Not only that there is a mortgage refinance calculators if you need to make some calculations about refinancing you current home loan. So there is no shortage of tools available at your finger tips if you ever decide to research on the possibilities and projections you need for your finances.

You may not have heard about these but you have to understand that there is almost any type of calculator online that you can utilize. Things like; qualification, simple savings, mortgage payment, basic mortgage payment, balloon calculator, prepayment calculator, Canadian calculator and mortgage duration calculator. All these tools can be find on the internet and you can freely use them. But just a word of caution, make sure to read the website term of use so that you will not be in trouble.

The main reason that you will need a mortgage calculator to calculate a mortgage is to determine whether it makes sense for you to buy a house or continue to rent. So whether you are purchasing a new house or want to refinance, a mortgage calculator to calculate a mortgage is what you need to know how much can I borrow for a mortgage.

By: Juling Gabas

Tags: , , , , , , ,
Posted in Finance · January 8th, 2010 · Comments (0)