Just some Real Estate Qs

Education

Hey there guys, I am kind of new to real estate, and I was wondering if you guys could help me out here.

Let's take this scenario. A person borrows $900,000 on a 30 yr fixed rate mortgage at 4%. How would I find what the monthly payment is? If I wanted to find the total amt of payments made in the 30 yr timespan, would it be monthly payment*12 months (in a year)*30 yr?

If the mortgage was 20 yr instead of 30 yr, what changes?

Posted Dec 17, 2020, 5:46 PM UTC

110
nikidmaclay•

You are looking for an amortization calculator. You can find one here without a bunch of ads attached.

https://www.calculator.net/amortization-calculator.html

5
peacemakerguyOP•

Thanks kind person

3
makked•
1
peacemakerguyOP•

Thanks to you too

1
FridayMcNight•

Google has a mortgage calculator in the search. If you want, you can create your own amortization tables in a spreadsheet. Or my personal fave... Worlfram Alpha.

1
peacemakerguyOP•

Thanks for your suggestions

Do you know the applicable formula?

1
FridayMcNight•

I think Worlfram Alpha is gonna be the fastest, easiest, and most visually intuitive, but if you are after how to do it in a spreadsheet, let me see if I can figure out how to share mine without revealing my identity.

Not mine, but here's a public sheet you can tweak as needed, and see the formula for yourself.

1
peacemakerguyOP•

Thanks kind person 😄

2
Familysize189•

I really like Excel sheets. They can be customized to fit a lot of different situations and I think can be much easier for analyzing a lot of different scenarios. You have to learn to be able to use them but the applicable formulas are: =PMT() for payments (like mortgages without taxes and insurance), =FV() for the future value of a currwnt set amount of money, and =PV() for the present value of future money. Google "time value of money" and you can learn a lot about it.

1
peacemakerguyOP•

Thank you kind person

1