All Questions
Tagged with loans calculation
62
questions
4
votes
2
answers
227
views
How to calculate monthly payment of a loan
I am trying to solve this question:
Your brother-in-law asks you to lend him $100,000 as a second mortgage on his vacation
home. He promises to make level monthly payments for 10 years, 120 payments ...
- 43
-1
votes
1
answer
138
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
5
votes
2
answers
3k
views
Why the calculated cost of a loan is less than expected? Is the bank working at a loss?
Let's say I want to borrow $1000 from a bank at an interest rate of 12% per year, for one year. The number of payments in this case is equal to 12 (one year * months per year) and the interest rate ...
- 169
1
vote
1
answer
193
views
Calculate Loan Balance and Future Balance with Extra Repayments
So, here's the current situation.
I took out a £7000 loan over 42 months at the insane interest rate of 47.4%.
I needed the loan, couldn't borrow it off family, and the interest rate is due to some ...
- 328
2
votes
2
answers
259
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
2
votes
1
answer
98
views
What's the APR for this in combination with the Balloon Payment of 6525 USD?
I am trying to solve the following:
Finance Amount: 24.951,82 USD
Interest Rate: 2.29%
Residual Value: 6.525 USD
Number of Months: 60
Fee: 374.28
Years: 5
What's the APR for this in combination with ...
- 21
1
vote
1
answer
2k
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
2k
views
Formula for calculating the monthly payment for a Personal Contract Purchase
How can I calculate the monthly payment for a PCP (Personal Contract Purchase) when given the variables below?
'Amount to be financed' - finance amount
APR (annual percentage rate - %)
Length of ...
- 13
0
votes
2
answers
107
views
Mathematical method to minimize weighted interest rate on a set of student loans for a given payment? [duplicate]
See image attached. I graduated back in May. Even though my loans are in forbearance right now due to COVID and I'm still in my grace period for payments, I wanted to get a head start on figuring out ...
0
votes
1
answer
491
views
IRR calculation with Initial Investment disbursed on two years
In my case, I think:
Numbers say more than words.
So, I've simplified the financial situation in this image:
Here is the Excel file.
How to calculate the Internal Rate of Return (IRR) with such a ...
- 101
3
votes
1
answer
467
views
Calculating interest and Principal Paid using TI-84
How do I calculate the net quantity of interest on a loan, and the net quantity of the principal on the loan, that I have paid off after a given number of payment periods in the finance app on a TI-84 ...
0
votes
1
answer
187
views
How to calculate a loan constant payment (like PMT) but extra double paying (without interest) twice a year
This is my first post in this community, already tried to find my answer, and didn't succeed :(.
I'm working a way to understand the formula behind a loan that allows the client to extra pay the same ...
- 111
1
vote
1
answer
67
views
Principle and interest calculations [closed]
I have a loan at 5%, I know the total owed and the monthly payment and need aschedule giving me the interest and principle paid each month until paid in full. Where can i find a schedule calculator ...
- 11
1
vote
0
answers
32
views
Enhancement of the open source lib for calculation of IRR (internal rate rate)
I am cs student , and has been asked to enhance the documentation for open source lib finance.js for IIR (internal rate of return) for various industry
Here I am trying to calculate IIR for the ...
1
vote
1
answer
223
views
Calculate the deposit on a loan when the monthly payment, interest rate, and balloon are known
I am looking into PCP finance for a car and I have found estimates where I enter a term and a deposit, and am given a monthly payment for the loan.
Some sites (BMW for example) will let you enter a ...
- 119