All Questions
Tagged with compound-interest loans
24 questions
1
vote
3
answers
213
views
How to calculate the very last payment when repaying a debt?
Suppose I'm repaying a fixed amount every month on a debt such as a credit card debt.
Generally, the very last payment will be less than the others, because the total owed will be less than the fixed ...
- 151
1
vote
1
answer
291
views
Confusion with payment calculation for fixed payments on fixed interest loan
I'm trying to understand how to calculate the monthly payments on a fixed interest loan with a given term. I understand this can be done with the PMT excel function.
Whenever I see this explained ...
- 13
14
votes
3
answers
8k
views
Which mortgage should I pay off first? Same interest rate and mortgage length
tl;dr:
I have two amortized mortgages; one big and one small.
The conditions (interest rate and mortgage length) are exactly the same.
Which should I pay off first?
I have always heard that you ...
- 143
-2
votes
1
answer
119
views
Are there any home-loans that compound every quarter or half-year or annually?
Are there any home-loans that compound every quarter or half-year or annually?
Asking for a friend who keeps bugging my other friend to give them money to buy a house, and the friend doesn't want to ...
user118604
1
vote
2
answers
204
views
Is this a weekly compounding loan amortization schedule?
I am currently having a disagreement with my colleagues regarding whether a loan is compounding or not.
I have linked below an image of a amortization schedule for a 52 week term for a $50,000 loan. ...
1
vote
2
answers
687
views
EU APR calculation, solving for APR
I'm looking for some help with a finance homework. We've been given the FCA calculation for APR:
Source: https://www.handbook.fca.org.uk/publication/handbook/graphic/13449.png
We've also been given a ...
- 11
10
votes
3
answers
3k
views
When computing monthly interest, why do we divide yearly interest by 12, rather than taking the 12th-root?
I've been reading about loans and interest rates, and I've run across a mathematical sticking point. The crux is that, if my loan's outstanding balance is £100,000, I make no payments, and it has an ...
- 201
3
votes
2
answers
313
views
Calculating Annuities With Different Compounding period and Interest Period
Can anyone Help me solve this?
In July 2010, Mike deposits $100 semiannually into an account compounding quarterly at 7% nominal annual interest for three years.
In July 2013, he increases the ...
- 31
1
vote
2
answers
284
views
effective rate loan installment
Why is it that the effective rate is based on compounding and it is also paid only on the remaining loan balance in compounding interest we pay interest on interest?
Can someone explain in to me? what ...
- 11
0
votes
1
answer
242
views
How to compare the APRs of different currencies?
I want to take a loan and I have two options:
Euros APR: 7.2% terms: 10 years
Yuan APR: 9.2% terms: 5 years
I have taken some financial classes so I have a vague idea about it. I know there is an ...
user79408
1
vote
1
answer
103
views
Loan with floating interest [closed]
I have taken a 7 years loan of 450 000 for a car in January 2017 with monthly payment of 7077. The interest rate was 8.25% which means that the total repayment is 593878 after 7 years. As from ...
- 113
1
vote
1
answer
189
views
What is the formula for loan payoff with daily compounded interest and annual payment?
I am trying to get the loan repayment amount for below data :
Loan Amount: $20,412.65
Payments (#): 10
Annual Interest Rate: 2.5%
Loan Date: 07/02/2018
First Payment Due: 09/02/2018 (next payment ...
- 11
1
vote
2
answers
824
views
Compound Interest & Mortgages
Mortgages are compounded 2 times a year in Canada and 12 times a year in the USA. However, I read that mortgages are simple interest and not compound interest because you pay the interest for each ...
- 27
3
votes
2
answers
288
views
How to compare loans of same principal, same interest but with different tenors
I have a scenario where there are 2 loans that can be provided (assuming I am providing the loan). The principal amount is the same, 30,000 in case of both the loans. The interest is also same at 17%. ...
- 1,185
0
votes
4
answers
510
views
Is it possible to borrow money to accrue interest, and then use that interest to pay back the borrower + fees?
Say I want to borrow $225,000.00 to accrue interest on a 1.20% APY account. I promise the lender that I'll pay them a fixed-rate of this interest with agreement that I cannot withdraw nor touch the ...
1
vote
7
answers
702
views
Why "N-year" loans (and other complications)? Why does a loan need so many parameters?
If the title sounds ridiculous, please hear me out before downvoting.
Let's start simple. You have too much money on your hands and want to start a loan business.
If you neither want to gain nor lose ...
- 3,385
2
votes
3
answers
2k
views
Looking for Excel formula to calculate the benefit of making additional payments on a loan with interest daily compounded monthly
I'm looking to make extra payments to my student loans. I currently owe $30,000 at 5.25%. I pay $250 on the 15th of every month. My loans accrue interest daily that are then compounded monthly. I want ...
- 37
1
vote
2
answers
3k
views
How to deal with February in accrued interest calculation (30/360 day count convention)
How would you deal with the month of February in a daily interest calculation on a loan that compounds monthly?
I would think that with 30/360 day count convention, each day in February results in ...
2
votes
1
answer
1k
views
Why does my interest charged (on loan) fluctuate from my own calculations?
I just want to know if I am calculating the interest correctly. Or is the interest rate is fluctuating slightly? Its not really that big of a fluctuation (we're looking at a range of 5-10 cents off). ...
- 33
1
vote
2
answers
215
views
How to get interest earned from start of repayment to a specific date on a declining balance?
I need a formula in getting the interest earned from start of payment of my loan to a specific date. I know the formula for the current due interest, which my company have given me in excel:
days = ...
3
votes
3
answers
2k
views
How to know how much interest paid per payment in a fixed tenor personal loan
I recently took up a personal loan. I do not have any financial background and I do not have any issue paying the loan but I am just curious on how they come out with some numbers.
To be precise, the ...
- 165
1
vote
1
answer
830
views
Why SUM(PMT) is not identical to FV?
I'm exploring financial functions in a spreadsheet. When I use FV, which is based on FV = PV*(1+r)^n I get a different number than when using PMT and multiplying by the number of periods.
For example:...
- 528
3
votes
2
answers
1k
views
Help with Loan Amortization Question
Hello I'm stuck on a question if anyone could walk me through on the steps that would be great. This is a loan Amortization question
The principal amount is $100,000
The Interest Rate is 3%
The ...
- 389
2
votes
3
answers
1k
views
Interest rate question
I'm having a little trouble figuring this out. Suppose I took out a loan with the following terms:
Loan Amount: 1,000
Interest Rate (APR): 10%
Compound Frequency: Monthly (12 compounding periods)
...
- 265