# 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

- How do you count the cost of good sold having the information below?Sales 71,000 Opening stock 32,000 Purchases 35,000 Closing stock 32,000 my book says the cost of goods sold should be 35,000 and the profit 36,000. How did they come up with that sum? Related Posts:How …
- if my credit score is 588, and i have debts like 1500 dollars , is there a way without paying?to get my credit score up in like 6 months or less??? and are there and agencies i can get to help me , or is its best to do it my self??? Related Posts:If …
- Should I refinance from 30 years to 15yr?I bought my house in 2008, $ 155k. I have $ 35k, down. I have $ 118 left to pay. My original game was 5.5%. The new prices are 15yr looks good. 3-4%. I understand …
- what are the pros/cons of buying a foreclosed home?I plan on buying my first home very soon here and i know that buying foreclosed homes can be a cheaper alternative to buying a regular home. Since i’m buying for the first time i …
- 2 months mortgage payments late to the backend are taken from my credit.?I am two months behind on my mortgage because of job loss and I will not be able to get over my past payments for several months. Is there a good opportunity to negotiate to …

Random Topics

- How can I start buying houses and fliping them for profit?i need help on where to start ive never bought a house before and want to buy a pos and fix it and make money flipping it. Related Posts:How can I start buying houses and …
- is there a website where i can check my credit score free with using my atm?i found one that is good but its only a trail i want one that is completely free so i can check my credit score because ima get a credit car so i can fix …
- How to resolve my credit card debt issue? I am in a collection status, how can I deal with that?An unexpected payment of $ 2,499.06 was posted to my Citi account on May 27th, 2005. The payment posted in error was corrected on the statement of 12/10/2005. . I was unaware of this matter …
- Is it better to rent an apartment or buy a home if you are going to relocate after one year?home cost is $ 280,00, monthly expenses- utilities-$ 220., maint-$ 100., property tax-$ 380., home insurance-$ 50. 30-year mort-8% interest rate, 20% downpayment and closing costs equal to $ 1,000. plus 3 points. Rent would …
- How long would it take for a community of 100 houses to free themselves?How long would it take for a community of 100 houses to free themselves from their home debt assuming each house is worth 100,000 dollars if they all help one another pay those houses? Related …

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.