I do not need this for homework. I am trying to find what your payments would be on a mortgage at different interest rates. I need the formula and an example of how you work it out. FOR EXAMPLE
2006-10-30 11:48:28 · 5 answers · asked by bettyswestbrook 4 in Business & Finance ➔ Personal Finance
Try Yahoo Finance, they have mortgage calculators and amoritization tables.
2006-10-30 12:48:30 · answer #1 · answered by EAA Duro 3 · 0⤊ 0⤋
A spreadsheet is the easiest way I know to build the information system that you want. You start with:
Principal (loan amount)
Interest rate: (6%)
Term (months)
Using a spreadsheet you plug the numbers in to give you the monthly payment amount. Remember to divide the interest rate by 12 to give the monthly equivalent since your using monthly payments.
Then you figure the interest portion of each payment and then subtract the principal portion (remainder) of the payment from the balance and repeat.
2006-10-31 08:51:37 · answer #2 · answered by Adios 5 · 0⤊ 0⤋
Well, if you're just interested in the bottom line numbers, you can google "mortgage calculators" and plug in various numbers (principal, rate, term) and see what the payments will be.
2006-10-30 19:57:19 · answer #3 · answered by I ♥ AUG 6 · 0⤊ 0⤋
what you are looking for is an amortization table. Microsoft works has one and most spreadsheet applications have them as templates.
2006-10-30 19:57:41 · answer #4 · answered by dt_05851 3 · 0⤊ 0⤋
Go to bankrate.com
2006-10-30 23:02:42 · answer #5 · answered by Steve R 6 · 0⤊ 0⤋