# 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

- Is there a reputable company in the Philippines that help me repair my credit rating?I used to have 2 credit cards from Citibank (in the Philippines) — Visa and MasterCard. Unfortunately, I was not able to pay these cards on time so I decided to cancel them while paying …
- Why are Americans (Republicans especially) so opposed to taxes?The United States citizens pay the lowest taxes per percentage of income out of every industrialized, modern country in the world and yet we also poll as the most unhappy about it while European countries …
- Reverse Mortgage, Good or Bad idea?My Parents are in their 70’s, have a house worth $ 100,000 and owe about $ 50,000. They have heard good things about Reverse Motgages. My initial reaction was “No Way! Don’t just give up …
- Is the Blockbuster collections agency real?I used to work there and nothing ever happened to accounts past due other than a hold being put on them. When they get a notice from the “collection agency” though, I would always hear …
- What is best way to purchase second home?I currently own one house have a mortgage and tomorrow I am going to purchase my second home, a house next door. What is best way to finance and is there anything I need to …

Random Topics

- How can I get all three credit scores online?I am trying to find out what my three credit scores are. Where online can I do this? Related Posts:Are credit scores with credit reports free online?Are credit scores with credit reports free online?Are credit …
- CLI from Chase BankSo i have had my chase credit card (freedom) for five years now and when i logged into my account today, surprise surprise, I found that they gave me an auto CLI of $500! Bringing …
- what types of programs there for people on section 8 to buy homes in 2010?I have a monthly income 2,000 with me. I’m still able to receive housing though and i would really like to buy my own home but i have terrible credit what should i do. i …
- Is this illegal for a debt collector to do this?I have a charged off credit card debt and its about $ 691. I do realize I have to pay the amount, trust me I know (I’m doing debt consolidation to help me deal with …
- BOA Business Mastercard ‘prescreened offers’So I log on to my BOA account and have a pre screened offer for a ‘Cash Rewards for business’ mastercard. I wonder why i got a business mastercard offer; I dont even have a …

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.