I need to review the calculation on a variable rate mortgage tied to the 1-year constant maturity Treasury. The mortgage is a 2/28 FHA originated in 2006, earns interest in arrears and is on a 360/30 day base. Some payments have been made past the due date and some payments different from the contractual payments were made. Based on my review several of the payment changes were not made or were made incorrectly. Do you have a product that can be used to calculate an amortization of a loan with these characteristics for comparison to the data record? If so, please tell me which product.
Karl says:
Yes. Please see this financial calculator. With this calculator, the user has complete control of all events over the entire term of the cash flow. Meaning, you can make payments (or investments) on any date for any amount. Interest rates can be changed on any date as well as the compounding method.
There are a lot of options and there are 25 tutorials to assist in learning them. Everyone should try tutorial #1 and you should specifically look at tutorial #25 – tracking loan payments.
If you want to save your work, then use C-Value!. This is a program for Windows computers that mimics the above online calculator. It has more options including saving work.
Once you’ve looked at the recommended tutorials, if you have any questions, just ask on the above linked page in the comments. Be happy to answer them.
Larry Cole says:
Thank you. Will it run on Windows 8?
Karl says:
C-Value will. The Time Value of Money calculator is an online calculator. I suggest trying that first to see if it meets your needs.
Ruth Sherwood says:
I have a couple houses that we sold owner financed. At first record keeping was fairly simple by hand but now they get behind on payments, pay odd amounts, broken into 2 or 3 payments throughout the month and I charge a late fee. I’m looking for a program that can keep an ongoing record of principal and interest paid, etc and give me the1098 information I need for the IRS at the end of each year. Do you have a program than handle my situation?
Scroll down the page to the tutorial section. Read tutorial #1 for an overview and then tutorial #2, "Calculate Loan Balance — Loan Payoff Calculation" addresses your specific needs.
If you try this calculator and you find that it does what you need (it should) and you want to save your entries, then my C-Value! program (for Windows computers) works the same way as the above free web calculator and it will allow you to save the payments to a file. Cost, $49.95.
Join the conversation. Tell me what you think.
Larry Cole says:
I need to review the calculation on a variable rate mortgage tied to the 1-year constant maturity Treasury. The mortgage is a 2/28 FHA originated in 2006, earns interest in arrears and is on a 360/30 day base. Some payments have been made past the due date and some payments different from the contractual payments were made. Based on my review several of the payment changes were not made or were made incorrectly. Do you have a product that can be used to calculate an amortization of a loan with these characteristics for comparison to the data record? If so, please tell me which product.
Karl says:
Yes. Please see this financial calculator. With this calculator, the user has complete control of all events over the entire term of the cash flow. Meaning, you can make payments (or investments) on any date for any amount. Interest rates can be changed on any date as well as the compounding method.
There are a lot of options and there are 25 tutorials to assist in learning them. Everyone should try tutorial #1 and you should specifically look at tutorial #25 – tracking loan payments.
If you want to save your work, then use C-Value!. This is a program for Windows computers that mimics the above online calculator. It has more options including saving work.
Once you’ve looked at the recommended tutorials, if you have any questions, just ask on the above linked page in the comments. Be happy to answer them.
Larry Cole says:
Thank you. Will it run on Windows 8?
Karl says:
C-Value will. The Time Value of Money calculator is an online calculator. I suggest trying that first to see if it meets your needs.
Ruth Sherwood says:
I have a couple houses that we sold owner financed. At first record keeping was fairly simple by hand but now they get behind on payments, pay odd amounts, broken into 2 or 3 payments throughout the month and I charge a late fee.
I’m looking for a program that can keep an ongoing record of principal and interest paid, etc and give me the1098 information I need for the IRS at the end of each year. Do you have a program than handle my situation?
Karl says:
Please use this calculator.
Scroll down the page to the tutorial section. Read tutorial #1 for an overview and then tutorial #2, "Calculate Loan Balance — Loan Payoff Calculation" addresses your specific needs.
If you try this calculator and you find that it does what you need (it should) and you want to save your entries, then my C-Value! program (for Windows computers) works the same way as the above free web calculator and it will allow you to save the payments to a file. Cost, $49.95.