equity loan payments – home

March 30, 2011

Breaking Loan Payments Into Principal and Interest Components

Stephen Nelson asked:




Microsoft Excel can help you down a loan payment into its principal and interest components. Excel’s IPMT function lets you calculate the interest component of a loan payment. And Excel’s PPMT function lets you calculate the principal component of a payment.

Using the IPMT Function to Calculate Payment Interest

The IPMT function calculates the interest portion of a payment given its interest rate, the
period, the term (or number of payments), present value (or loan balance), future value (or
balloon payment), and, optionally, the type-of-annuity switch. If you set the type-ofannuity
switch to 1, Excel assumes payments occur at the beginning of the period, following
the annuity due convention. If you set the annuity switch to 0 or you omit the argument,
Excel assumes payments occur at the end of the period following the ordinary annuity
convention.

The function uses the following syntax:

IPMT (rate, period, nper, pv, fv, type)

For example, to calculate the period interest rate for the 54th payment on a 30-year, $150,000
mortgage charging 8% annual interest, you use the following formula:

=IPMT(.08/12,54,30*12,150000,0,0)

The function returns the value -957.51. Notice that to convert the 8% annual interest to a
period interest, the formula divides the annual interest rate by 12. Notice, too, that to convert
the 30-year term to a term in months, the formula multiplies 30 by 12. The function returns the interest payment amount as a negative value because it reflects a cash outflow you pay.

NOTE If you set the pv argument to -150000, you indicate that you’re loaning money. In this case, the function returns 957.51, a positive value, showing that the interest payment amount is a positive cash inflow.

Using the PPMT Function to Calculate Payment Principal

The PPMT function calculates the principal portion of a payment given its interest rate,
the period, the term (or number of payments), present value (or loan balance), future value
(or balloon payment), and, optionally, the type-of-annuity switch. If you set the type-of-annuity
switch to 1, Excel assumes payments occur at the beginning of the period, following
the annuity due convention. If you set the annuity switch to 0 or you omit the argument,
Excel assumes payments occur at the end of the period following the ordinary annuity
convention.
The function uses the following syntax:

PPMT (rate, period, nper, pv, fv, type)

For example, to calculate the period principal payment for the 54th payment on a 30-year,
$150,000 mortgage charging 8% annual interest, you use the following formula:

=PPMT (.08/12,54,30*12,150000,0,0)

The function returns the value -143.13. Notice that to convert the 8% annual interest to a
period interest, the formula divides the annual interest rate by 12. Notice, too, that to convert
the 30-year term to a term in months, the formula multiplies 30 by 12. The function returns the principal payment amount as a negative value because it reflects a cash outflow you pay.

NOTE: If you set the pv argument to -150000, you indicate that you’re actually loaning money.
And in this case, the function returns 143.13, a positive value, showing that the principal payment amount is a positive cash inflow.

Julio

March 28, 2011

How to Calculate Car Loan Payments

Bryan Burbank asked:




When searching for a new car loan it is good to use a online loan calculator to figure out how much you will be paying for your auto loan. the best part about using these calculators is that they are free and they help know what you can afford. This is a tool that you need to use to find out what your payments are going to be.

First you want to search online for a free auto loan calculator. This will help you figure out how much your payments will be each month so you know which car you can afford. This is great information to know so that you will not be surprised each month by a payment that is more than you can afford. There are many calculators available to you so find the one that is easiest to use.

Next you need to find the best interest rate that you can because over the life of the loan you can save a lot of money when you find a low interest rate option. Just a point lower can save you a lot of money over the life of the loan and you need to take advantage of this.

Finally you must know that most car loans are secured loans and with this type of loan you will be able to secure a low interest rate. You can refinance the car if the rate of interest goes down so make sure that you keep track of the prime rate of interest.

Miguel

March 22, 2011

Negotiate an Equity Loan Modification Before Default

Bradley Marmer asked:




There seems to be very few people that have not been touched by the economic downturn of the United States economy. The unemployment rate has reached its highest point in decades, leaving many families wondering how they will make their next mortgage payment.

There is plenty of news coverage about how to receive help if a person is in foreclosure but what about those that are heading towards default? Does a person have to wait until they start missing payments to get help? The simple answer is no. The answer may be an equity loan modification.

First, what is equity loan modification? This is a renegotiation between the lender and the borrower when there is little or no equity in a home. A person can simply refinance when they have a large portion of their principal paid off but this is not the case for most people whose home values have dropped over the past year or two. It may be possible for a person to renegotiate a lower payment through a better interest rate, a longer loan period or even a reduction in the principal. These factors may help a person that is struggling to make their payment.

A person does not have to wait until they are in default to apply for an equity loan modification. Instead, the lender can be notified at any point that the homeowner is heading toward default. A lender would actually prefer that a person does not wait until they can no longer make the payment. This ensures that the lender will still continue receiving a payment as they renegotiate the loan. It may also make the lender more willing to consider a modification of the loan. A homeowner who is trying to correct a situation before it escalates appears more responsible and less of a risk for defaulting on the renegotiation.

There are many different circumstances that a lender considers legitimate reason for a homeowner to be heading towards default. This may include circumstances such as the loss of a job by the primary income earner or a hospital stay that includes enormous medical bills. A lender may consider these situations to only be extenuating circumstances that will eventually be overcome by the homeowner. Lenders are not just throwing around money at whomever is having a difficult time making their payment. Instead, they are offering equity loan modification to individuals that still appear to be a credible risk.

In an effort to stimulate the housing market, the federal government has allocated $75 billion to promote the equity loan modification process. This is an incentive that benefits both the lender and the borrower. Lenders receive a bonus for every loan modification that they process and the borrower receives monetary help for making timely payments to the lender.

Renegotiating a loan can be a very difficult process for a homeowner to take on by themselves. A person facing default would be wise to enlist the services of a company that already deals with this type of loan modification. These companies are equipped to handle the negotiations with a lender and are capable of negotiating a better deal than the homeowner. It will also help give the homeowner some peace of mind knowing that there is someone fighting on his side.

Cathy

March 18, 2011

Home Loan Equity Payment Calculator

Trivesh Hans asked:




One of the things that more people are learning to do is use the equity in there home to improve things in their lives. People will many times make mistakes concerning the equity of their home, meaning they do not have an accurate figure. Unlike some homes, a houses value will grow with the years, which means that more equity will be available for the house. Through using a home equity payment calculator, you will be able to determine what equity is available for your home, how much of an equity loan payment you can afford, and how long it will take you to pay the loan off. All of this goes to say that using a home loan equity payment calculator has been a vital part obtaining a home equity loan. With lower interest rates, more people are considering getting a line of equity credit based on their home’s value. The main thing though is getting the right home equity loan that fit’s their needs.

The most important thing that you need to remember is that a home equity line is a loan and if payment is not made, you could lose your home. This is why using a home loan equity payment calculator is very important. Most people use home equity loans for various reasons, which include improving the values of their homes or buying something that they have always wanted. The most important thing about home equity loans is the ability to pay back the loan. This is why a home equity payment calculator has become something that more people are using. Everyone loves to
know what something is going to cost him or her before buying it. Using a home loan equity payment calculator will allow you to be able to figure out the cost and affordability of the equity loan.

As more people update their homes and look for ways to save on taxes; and these people should consider using a home equity loan payment calculator. . Interest rates are at low, which means that home equity loans are on the rise. Getting the most for your dollar is still something we all strive for, just as the lowest payment is something that we also want. Once you can figure out how much your home is worth then a home loan equity payment calculator is even much more effective. Having these numbers can make it easier for people to make decisions in there lives. Sometimes, if the numbers aren’t what your looking for, there are other options for you. Paying down your loan is something that can also help you get the loan you are looking for. This is something that the home loan equity payment calculator can help you look at. Information and numbers are important. By being able to see different payments at different levels will be very useful.

Home equity lines of credit continue to be one of the more popular credit choices for many consumers. Many people have paid down there loans on there homes, so equity loans are easier for them to get. As the Internet has grown, so has our desire for information and tools to use. A home loan equity payment calculator continues to be something that people are using to see where they stand as far as future loans and what they may cost.

Ricardo

March 17, 2011

Home Equity Loan Modification Tips

John Recmonoit asked:




Dealing with property loans can be very stressful especially if you find yourself falling behind in payments. What are some of the ways in which you can manage the situation and get back on your feet and which is the best? You could choose to re-finance your mortgage. That is basically taking out a second loan to be able to cover the first one. Or you could choose home equity loan modification.

The second loan that you take out might have lower interest rates than the first one and a longer payment period. Ultimately at the end of the day you will be end up paying more than you had intended. Refinancing an existing loan is not a sound option for someone already facing financial problems.

You could opt to take up a home equity loan. A home equity loan will give you an amount that is equal to the difference between the current market value of your home and the balance that you still owe. The problem is even with this you still might not be able to afford the monthly payments. Instead of a home equity loan modification you might find a mortgage loan modification more preferable.

The difference is with a mortgage loan modification the conditions of your payment plan are re-negotiated to be able to meet the amount that you are able to pay per month. With this deal you do not carry the burden of a new loan. You just simply get the initial terms of your loan revised.

What makes it better than home equity loan modification is that it will avoid you incurring further debt. It works by getting your interest rate reduced, or a reduction in the principal balance that you owe. Find out from the agencies that offer this service what terms they are able to offer you and the ones you qualify for.

Lester
Older Posts »

Powered by WordPress
mortage loan | tablet computer store ipad kindle | virtual meeting | mortgage loans