# 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

- Need answers to practice test to prepare for real estate exam?A seller’s broker rebating a portion of her commission to a seller is: a. In violation of RESPA b. In violation of licensing law c. In breach of her fiduciary duty d. Not in violation …
- I have 4 credit cards that equal $25,000 in debt, should I get a consolidation loan to clear debt?Related Posts:I have 4 credit cards that equal $25,000 in debt,…Do debt consolidation companies really help that much?Do debt consolidation companies really help that much?debt consolidation or personal loan help ?debt consolidation or personal loan …
- what all will I need to rent an apartment?I am only 18 years old and I have to get an apartment within the next 2 months…I have never rented an apartment before so I have no clue what I am doing…(I live in …
- if you are not able to get a credit card. what is the best way to increase your credit score?Related Posts:Need adviceQuestion about score increase potential with new cardWIll personal loan help credit score?Personal loan from wells fargoWhat is the best way to increase a credit score in…
- Mortgage Tax Credit for someone with a co-signer?If my mother is a non-occupying co-borrower is on my credit, I can still tax credit if they own a home? Related Posts:Mortgage Tax Credit For someone with a cosigner?What is the difference between Borrower …

Random Topics

- Projector's?Hi, can you tell me by this page in the inputs section if an Xbox 360 would be compatible with this projector. Thanks. Also, If it doesnt please guide me to a good buy for …
- Are credit cards with no balance good for credit report?I am trying to build a better credit score. I have two credit cards, one is at 20% limit, the other at about 5%. Is it good to maintain them like this? or is it …
- How to go about this..I have a medical collection that hasn’t been updated on my CR since early 2011.* I didn’t pull my reports until Jan/Feb and paid it off at that time.* It still didn’t update after a …
- my apartment was flooded by the water heater.am i entitled to recoup lost money?while on vacation in texas, my water heater gave out and flooded my apartment. was put up in a motel twice. lost money due to missed work and airfair lost to return home early. can …
- fastest way to improve credit ?credit upper 500’s which is bad..so i need to get up to buy a new car with rates in single digitis…ideally 7 or below % ; Any tips Related Posts:What’s the fastest way to improve …

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.