All Questions
Tagged with amortization calculation
19
questions
-1
votes
1
answer
139
views
How to solve amortization schedule where 10% of the interest is paid back on 4th payment
I am trying to find an algorithm to solve this amortization schedule:
P = 1000, term = 12 months, Interest=5%, calculation based on actual/365.
10% of the total interest of the loan is added to the ...
- 11
18
votes
1
answer
4k
views
Why does the TD Bank principal portion of a mortgage payment go up and down in sawtooth? (why is interest payment on annuity in arrears non-monotonic)
I'm trying to understand the amortization schedules of TD mortgages, as produced by the TD Calculator.
The monthly payment amounts (on this fixed rate mortgage) are predictable and constant, but the ...
- 511
2
votes
2
answers
264
views
How can I calculate amortized payment when the payments are made in advance?
I'm trying to calculate the payment amount on an amortized loan with interest where the payments are made in advance.
If the payments are made in arrears there's a simple formula, but since the first ...
- 21
1
vote
1
answer
3k
views
Formula for time taken to pay off loan with annual interest and monthly repayments
I am trying to find how to work out the period of time it will take to pay off a loan. There are plenty of online calculators out there but I cannot find the formula they use. I want to recreate the ...
- 113
1
vote
1
answer
102
views
Does the amortizing payment on a loan depend on whether interest is calculated daily or monthly?
Assume two banks offer a $100,000 mortgage at 6% annual interest for 30 years with payments due monthly. One bank assumes each month has 30 days. The other bank uses the actual number of days in ...
- 155
-1
votes
1
answer
815
views
how to find flat rate of interest per annum and month if we have given reducing rate of interest or loan amount and tenure?
For example: For loan amount 500000 for 5 years at the rate of 12% (reducing interest rate), EMI is 11,122.22 per month Here 12% reducing is equivalent to flat 6.69% per annum or flat 0.55% per month.
...
2
votes
2
answers
185
views
How can I amortize 4 rates over a 30 year term?
I've been offered a HELOC modification with the following terms:
Beginning balance $148,148.59,
Initial rate and term is 1% for 60 months at a pmt of $374.60,
The 2nd term begins Jan of yr 6, at 2% ...
- 21
4
votes
2
answers
2k
views
What is the math used to calculate the impact that overpaying a mortgage has an an amortization table?
I'm in the classic 'pay extra on the house vs invest' argument with my partner (not the subject of this question) and I'm trying to understand what exactly happens when I pay extra on a mortgage. I ...
- 1,876
0
votes
1
answer
1k
views
Calculating Interest Accrued for a late payment
I'm trying to calculate the interest accrued on my amortization schedule manually. I can calculate it fine if payments are exactly one month apart but this payment is More than 1 month apart.
This ...
- 389
0
votes
2
answers
823
views
How to calculate APR for a fixed rate loan due before amortization end date?
I need help with the following question for a homework assignment related to finding the APR for an investment class. Here's the question:
Calculate the APR for a $500000 fixed rate loan amortized ...
6
votes
4
answers
9k
views
How do I calculate the principal paid down on a mortgage?
I'm looking for an equation to find out the current principal on a mortgage. I have the following variables:
n periods
monthly payment amount
interest rate of mortgage
I'd like to know how much I'd ...
- 179
2
votes
3
answers
2k
views
Calculating interest accrued with extended Initial Payment Date
I'm wondering how do I calculate the interest accrued if the intervals aren't perfect. For example
Principal - $100,000
Interest - 8%
Compounding monthly
Disbursal Date - January 1st, 2016
Initial ...
- 389
4
votes
2
answers
5k
views
How to recalculate an amortization table after making a large payment?
I have an auto loan I wish to apply a very large amount to. I have a amortization table that shows me details for each payment I make. Here's where it gets complicated...
My lender does not allow ...
- 141
2
votes
1
answer
705
views
Checking the math on a Truth-in-Lending Disclosure
Here is a shot of an actual Truth-in-Lending statement for a real home mortgage (mine). I'm trying to check the numbers but they seem slightly off:
It's a 30-year fixed rate mortgage. The annual ...
- 21
1
vote
1
answer
1k
views
Calculating the PV and the Remaining Payments for Loans with Steps
I thought I was able to figure this out, but unfortunately my numbers did not work. If someone would please help with this scenario, then that would be greatly appreciated.
Say I'm taking out a $110,...
- 13