Archive for the ‘balloon loan calculator’ Category

Excel Finance Trick #4: PMT function & Balloon payment

June 14, 2010 - 9:53 pm No Comments

See how to use the PMT function & a Balloon payment. When you have to make Period payments on a loan contract and a lump sum payment at the end of the contract, you can use this trick to calculate your PMT amount!

In This Series learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions that can make your financing tasks much easier in Excel. See how to use the PMT function in the standard way, but also see how to use it while incorporating a Balloon payment or a delayed payment. Lean how to translate a Nominal interest rate into an Effective Interest rate. Learn how to calculate how long it takes to pay off a credit card balance. Lean how to calculate the Effect Rate on a Payday loan. And many more financing Tricks!!

The Excel Finance Tricks 1-17 will show an assortment of Excel Financing Tricks!

Formula

Duration : 0:3:27

(more…)

Technorati Tags: , , , , , , , , , , , ,

Excel Finance Trick 11: How Long Pay Off Credit Card Balance

June 14, 2010 - 9:52 pm 6 Comments

See how to calculate HOW LONG IT TAKES TO PAY OFF A CREDIT CARD BALANCE using the NPER function.

When you make only the minimum payment on a credit card, it takes a long time to pay off the balance. How long? Use the NPER function to find out how long it will take to pay off the credit card balance.

Solve for how many total periods there are.

In This Series learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions that can make your financing tasks much easier in Excel. See how to use the PMT function in the standard way, but also see how to use it while incorporating a Balloon payment or a delayed payment. Lean how to translate a Nominal interest rate into an Effective Interest rate. Learn how to calculate how long it takes to pay off a credit card balance. Lean how to calculate the Effect Rate on a Payday loan. And many more financing Tricks!!
The Excel Finance Tricks 1-17 will show an assortment of Excel Financing Tricks!

Excel Formula

Duration : 0:3:15

(more…)

Technorati Tags: , , , , , , , , , , , , , , , ,

Excel Finance Trick 9: Daily Interest But Monthly Deposits?!

June 14, 2010 - 9:52 pm No Comments

When your savings plans pays interest 365 days in a year and you make monthly deposits, use the NOMINAL and EFFECT functions first before using the FV function to calculate what the savings plan will be worth at maturity.

How do you calculate Future Value when you make monthly deposits but daily interest is paid? Use the NOMINAL and EFFECT functions first before using the FV function!

Nominal Rate APR Rate Annual Percentage Rate Effective Annual Rate.

In This Series learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions that can make your financing tasks much easier in Excel. See how to use the PMT function in the standard way, but also see how to use it while incorporating a Balloon payment or a delayed payment. Lean how to translate a Nominal interest rate into an Effective Interest rate. Learn how to calculate how long it takes to pay off a credit card balance. Lean how to calculate the Effect Rate on a Payday loan. And many more financing Tricks!!

The Excel Finance Tricks 1-17 will show an assortment of Excel Financing Tricks!

Formula

Duration : 0:4:23

(more…)

Technorati Tags: , , , , , , , , , , , , , ,

How to Stay in Your Home Mortgage Free For a Very Long Time – Techniques They Don’t Want You to Know

June 14, 2010 - 9:52 pm No Comments

Visit http://Mortgage-bad-credit.us for free mortgage calculators and mortgage rates..

Almost anyone can get a mortgage so unless you have unbelievably bad credit you will have no problem getting a mortgage for your new home. If you have a few blemishes on your credit report you will still be able to get a home mortgage loan. You can find mortgages online and offline that can hook you up with a great mortgage no matter what your credit looks like.

If you have poor credit what you will have to find is a good subprime lender. If your credit score is under 620 you will have to get a subprime mortgage. You will find yourself in this category if you usually pay your bills late, the later you pay them the worse your credit score is going to be as a result. When you are talking to lenders about getting a mortgage they will not actually use the word subprime but that is what the mortgage will be. They have stopped using these sorts of words because they tend to scare customers away.

Getting a home mortgage loan is simple if you have excellent credit and even if you shop around you will not find that the rate vary that much. But if you do have bad credit then shopping around is a must. Rates can be very different from lender to lender. The reason for this is because all of these subprime lenders will decide what kind of risk you pose in a different manner. So if you have a low credit score then you absolutely have to shop around for the best possible rate.

The interest rate on a subprime loan is higher than that on a prime mortgage loan. Before a lender will give you a rate on a mortgage they will have to do risk assessment on you. This means that they will do what is called risk based pricing to come to a final rate for your loan. SO while your interest rate is higher from these lenders just how much higher will depend on several different factors. Such as the amount of down payment that you have, the size of the loan, your credit score and report and even the amount of money you have to pay each month towards your other debts.

You could also have to face some penalties if you decide to pay off the loan early. So down the road and your credit has improved if you then want to refinance the loan you will be hit with hefty fines. These loans may also have balloon payments. With a balloon payment you will have to pay the entire loan amount after only a few years all at one time. If you cannot do this you will then be forced to get a new loan to cover the first. And some loans will even have a combination of the above.

There are many shifty lenders out there that will take advantage of subprime borrowers. They will use the fact that you cannot get a good loan from some other lender against you in order to make more money off of you. Some common ways that these lenders act in a predatory manner are by having unbelievably high interest rates and fees. Some of these lenders will even lie to customers like you and tell them that their credit score is much worse than it really is in order to keep them from trying to get a better loan somewhere else.

Another predatory act is to try to get customers to refinance on a regular basis. They will tell you that you will be saving money but in actuality all you are doing is paying them more money in closing and other costly fees. They then rolled these new fees into the amount that you owe. Some lenders even go so far as to give home loans to people that they know will not be able to pay them off. By doing this they can then foreclose on the home and sell it off for their own profit.

Before you meet with any lenders you need to find your own credit score. This will keep you from being mislead by lenders. Then do some serious mortgage shopping in order to find the lowest possible interest rte. This is the way to save on your home mortgage.

Duration : 0:2:33

(more…)

Technorati Tags: , , , , , , , , , , , , , , , , , , , , , , ,

Highline Excel Class 47: PMT function 5 Examples

June 14, 2010 - 9:52 pm No Comments

See 5 examples for the PMT function:
1.Monthly loan payment at the end of each month from the borrowers point of view
2.Monthly loan payment at the beginning of each month from the borrowers point of view
3.Monthly loan payment at the end of each month from the lenders point of view
4.Monthly loan payment at the end of each month from the borrowers point of view with a Balloon payment during the last period
5.Quarterly payment for a loan when payments are delayed during first year.
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Duration : 0:14:8

(more…)

Technorati Tags: , , , , , , , , , , , , , ,

If I borrow 51,500 from someone at6% interest,make payments of 400/mo ,for 2yrs, what is my balloon payment?

June 14, 2010 - 9:51 pm 2 Comments

What is a good loan calculator to do this type of calc?

That will depend upon the loan period used in calculating the amortization schedule.

If the loan payments were based on a 30 year amortiziation schedule, the scheduled payments would be $308.77. If you paid $400.00 per month, the balance at the end of 2 years would be $47,875.98 and that would be your baloon payment.

If the loan period were less than about 17.5 years, the balance would actually grow as you would not be paying enough to cover the minimum principal and interest.

I used Excel to calculate this. Google around for loan calculators; there are scads of them on the net.

Can somebody give me a clue on my mortgage payments?

June 14, 2010 - 9:51 pm 6 Comments

I bought my first home about 8 months ago. I had no down payment and ended up getting two separate loans.

The first was $114,000 @ 6.75% 30 year fixed.

The second was for $38,000 @ 9.436% 15 year balloon.

Monthly payment on the first is: $1014.12
Monthly payment on the second is: $316.05

I can pay this. Its far from ideal but I’m paying only slightly more per month than I would for an apartment. I thought I might be able to refinance before too long but then too many people making $35K bought $350K houses and I’m thinking the chances of my doing that right now are slim especially since I’ve paid down next to no principle at this point.

Let’s leave the atrocious 9+% one alone for a minute. I know there are insurance fees and real estate taxes built into mortgage payments but I’m plugging $114K and 6.5% over 30 years into the generic calculators online and not getting anywhere near what I’m paying. Any help?
Was supposed to be 6.75% used for calculations…typo.

I get 739.40 for principal and interest. That would make the taxes and insurance about 274.72. Does that sound about right?

I don’t know why you would be using 6.5 as the rate if it is 6.75.

You are right. It would cost too much to refinance at this point even if you could. It would be years before you would actually be saving money.

I would focus on paying down the 2nd. The rate on the 1st is not that bad. If you add abut $80/month to the payments on the 2nd, you will pay it off in 15 years. If you could pay $500/month on it, you could pay it off in less than 10 years.

I hope this helps.

WoWGreen computer work from home earn money through internet