Pay Home Loan
 

Extra Payments Formula For Mortgage On Excel?

can anyone discern me how to calculate extra payments on mortgage on excel, is there a formula

Thanks


Answer: Can you purify your question a bit more? Are you seeking to calculate when your mortgage will be paid off by paying down uncommonly or something?

If so, in order to do that you will need to give the interest rate, number of payments to

 
 

What Is The Step By Step Formula For Figuring Mortgage Payments?



Answer: What is a route by step formula?

 
 

What Is The Formula For Finding Payments On A Mortgage?

I am stressful to find the monthly payments on a 15 year fixed mortgage. the interest rate is 5.65% and the leading role is $60,000. I really need the formula to find this becuse I am going to switch the years and rate to find a payment i can make.


Answer: Here use this together yahoo offers it.. you can plug the information in and it will give you the payment automatically. You can gambol with the rate, or the terms (# of months).. Don't think of when you are planning on figuring out your monthly payment

 
 

Need Help With Making Sense Of This Mortgage Monthly Payment Formula Cause Never Seen It Before?

PMT= P x (APR/n) / 1- (1+ APR/n)^ -nY

I identify Y stands for the year, but how many years do I multiply by if the months are 180 (for 15 years) or 360 (for 30 years)? And how do I find the APR? Thanks in get ahead!

 
 

How Do I Add A Formula To Calculate For Adding Mortgage Insurance?

I have created a unpretentious mortgage calculator which will work out the mortgage payments for a specific loan to value (5%, 10%, 15% down etc) and it will add mortgage protection and calculate the income required. How do i add a formula which will


Answer: In the us mortgage protection will change with the amount financed and how much above the 80% the loan is. The tricky part in putting this in a computer though is that it will also change some with different loan programs. Basically what I am difficult

Related Topics:

Mortgage Tax Insurance Calculator
Mortgage Schedule Calculator
Mortgage Realtor

 

Re: Mortgage payment calculations formula

drummer116 questions answered on Mortgage payments

Loan Modification While on a Second Mortgage – How Does it Work ...

One of the tougher challenges fa those frustrating to ready for advance modifications is when the homeowner has a aid mortgage. Most lenders are perturbed with the first mortgage and pay dwarf if any publicity to a number two mortgage. If a chattels goes into foreclosure, the first mortgage holder gets the proceeds of the gear if sold at auction. The proceeds go towards the preponderance owed as well as fees and costs associated with the foreclosure. If (and it’s a autocratic big if) any hard cash is pink over, then the sponsor mortgage holder is entitled to it. Mostly that’s not the for fear of the fact and the alternative mortgage gets wiped out. In an striving to helper those who detain a promote mortgage, the administration has a new plan called the Secondarily Lien Program which is intended to trade with the first lien modification in an trouble to get the borrower’s payments reduced to an amount he can pay. With the new scenario, when a first mortgage is being modified, those servicers participating in Twinkling Lien Program will then pulp the monthly payment on the other mortgage based on pre-set guidelines. If they don’t , they also have the opportunity to sate the promote mortgage in market for a one on occasion payment. The amount is unwavering by a formula obtained by the U. S. Moneys Hang on. The rule is hoping this will alleviate the unessential sell and charge modifications easier for all parties. As read a homeowner obtained a instant mortgage on his attribute in the amount of $50,000. 00 at an interest rating of 9%. The lenders will look at what is currently owed; let’s say $45,000. 00. With the Subordinate Lien Program, the interest calculate would be reduced to 1% for five years. This would be a propertied savings for them over the five year time. At the end of the five years, the mortgage payment would developing, but to farther down interest compute than they initially started with. If the moment mortgage payments were interest only payments, the leading balance remains the same. Under the Twinkling Lien Program, the interest chew out would be reduced to 2% for five years. Again, this would liberate the homeowner a great amount of well off of the class of the five years. At the end of the five year term, the mortgage will amortize to a course based on the longer of the unconsumed course of the first mortgage, or the source dated of the aide-de-camp mortgage. This is a bit knotty, and the homeowner will have need of to be conducive to certain he understands the terms. Always consult with a mortgage trained or your legal stratum attorney for the most artistically admonition.

© 2011 Pay Home Loan