Forum Discussion
Where can I find an amortization spreadsheet or a loan payoff calculator spreadsheet?
Ok, when I search google, I find a ton of spreadsheets. But, none seem to do exactly what I'm looking for. I have different loans. I have the start date, the APR, the monthly payment I'm making. ...
As per my understanding, you have only three variables (Loan amount, APR, and Monthly Re-payment amount) and need to calculate the monthly principal and interest amount.
You may use the attached sample file to achieve your requirements, but it would be helpful if you share some data so that a more specific solution can be suggested.
Please also note that in most cases the banks or lending companies round off the monthly re-payment amounts. In such a scenario you might need some extra adjustments to make the closing balance ‘0’.
Please let me know if it works for you.
Thanks
Tauqeer
Forget it. I looked up how to calculate APR monthly... and made my own spreadsheet. Thanks.
