# what formula do I need to use in Excel to calculate a Mortgage payment for a 30 year fixed loan?

Deal Score0

Login / Register Submit a deal

Home » Mortgage Loan » what formula do I need to use in Excel to calculate a Mortgage payment for a 30 year fixed loan?

Deal Score0

Related Articles

No widgets added. You can disable footer widget area in theme options - footer options

Random Posts

- If your spouse cheats on you and you ask them to move, do you still expect them to pay his half of everything?If your spouse cheats on you and you tell them to get out, would you still expect them to pay their half of the bills (mortgage and utilities specifically) even if they didn’t have anywhere …
- Which PC would be better for World of Warcraft?What’s Included •Compaq Presario Desktop / AMD Athlon™ II Processor / 2GB Memory / 500GB Hard Drive •USB keyboard, optical mouse •Software: Cyberlink DVD Suite Deluxe and more •Owner’s manual Product Features •AMD Athlon™ II …
- Why do my feeder fish keep blowing bubbles in the top of the bowl?I have two feeder fish and I have them in a goldfish bowl and they keep blowing bubbles. why? Now before you get on me let me plead my case, first I went to the …
- Can a second person be added to an FHA morgage?my friend and I want to buy this townhouse. The problem is he is currently unemployed so he doesn’t quilify for a morgage. He is a union electrician and so its only temporary unemployment. I …
- How life insurance if you smoke cigarettes when you quit a week before the test?Can I quit smoking one week before my exam insurance and the test results are negative, if this is the case, what happens if I die of lung cancer 20 years later? If the insurance …

Random Topics

- Is there a way for me to buy another home in this situation?I want to buy a home in Florida while prices are low. But I’m in Michigan where nothing is selling. I’m retired. I want to use my invested savings tax deffered account to withdraw and …
- Is it a hassle to sell your house without an agent?I live in Texas and planning to put my house on the market. I’m trying to save as much money possible. Related Posts:Is it a hassle to sell your house without an agent?Should I rent …
- debt settlement program?How much is the fee usually associated with a debt settlement programs? Note I am talking about “debt settlement” program not “debt consolidation” prorgram. I called two places and both the fee is 15% of …
- 6 year Old account shows up as collection on my credit reportHi, Any advice will be greatly appreciated. * We are 10 days away from closing on our First Home. We were preparing for our First home from past 3 years, worked on my credit score, …
- Why did NFCU issue me a pre-approval, then two days later pull my credit report AGAINHello, I just received an alert that my credit report was pulled today by NFCU regarding the mortgage application. I called NFCU since my score did decrease since they did a pull on June 4 …

Register New Account

Already have an account? Login

Login

Don't have an account? Sign Up

Reset Password

Already have an account? Login

http://realestate.yahoo.com/calculators/payment.html

Not sure, I would look here

http://tcalc.com/tvwww.dll?user?tmplt=usertool.htm

Use the PMT cell formula function. The syntax is:

=PMT(monthly rate as decimal, #months, principal).

Suppose you have a $ 10000 loan 15 years at 6%. The formula is:

= PMT(0.005, 180, 10000).

Open Excel, and click insert, then function. Once the dialog box opens, click financial from the dropdown menu under “choose a catagory.” Scroll down and click “PMT” under “choose a function.” A new dialog box will open. For “rate”, make sure you devide by the number of payments within the year assuming the rate in annual. For example, if your interest rate is 7% per year, the calculation will be .07/12 = .005833 This will be your interest rate per month. For “Nper”, multiply the length of the loan by the number of payments within the year. For example 30 Years x 12 months = 360 This will be the total number of monthly payments made for the loan. For “PV” (Present Value), enter the total amount you are borrowing. For example 300000. For “FV” (Future Value) enter 0 assuming your loan will be paid off at the end of 30 years. For “Type” enter a 1 if your scheduled payment is at the beginning of the month, or enter 0 if your payment is at the end of the month. Assuming your scheduled payment is at the beginning of the month, your payment should be 1,984.33 against a $ 300,000 loan at a 30 year 7% fixed. Note that this amount will only include Principle and interest. If you looking for a house, you’ll need to come up with an estimate for taxes and insurance in addition to the payment above, however, for a car, this works like a charm.

Cheers

This is your answer. This is the formula that the real estate websites do not want you to know. You must start with pasting the values after the description (i.e. Price) in cell C2.

=C2Price $ 395,000.00

=C2*C10Down Payment $ 98,750.00

=C2-C3Principal $ 296,250.00

=C5Interest Rate5.375

=C6Length30

=C5/(12*100) Monthly interest in decimal0.004479167

=C6*12Number of months that loan360

=C4*(C7/(1-(1+C7)^-C8))Monthly Payment $ 1,658.91

= C10Down Payment %25.000%

I am a real estate investor and I can plug numbers into my excel file on the fly and it will tell me if I will make money or not given certain assumptions.

Let me know if you have any follow up questions.

Good Luck!!!

To calculate a mortgage payment for a 30 year fixed loan in excel here is the formula – PMT(interest rate/12,# of years*12,amount borrowed)*-1

for example

For example, if you want to purchase a property with a sales price of $ 179,000 and are putting 10% down (17,900). The 161,100 (is 90% financed), If you have an interest rate of 7.75%, at 30 years fixed, with a loan amount of 161,100. The calculation looks like this:

PMT(7.75/12,30*12,161,100)*-1

The payment (principal and interest) will come out to $ 1,154.14 a month.