All Questions
Tagged with loans calculation
62
questions
4
votes
2
answers
236
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 ...
-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 ...
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 ...
1
vote
1
answer
196
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 ...
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 ...
2
votes
1
answer
100
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 ...
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 ...
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 ...
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
495
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 ...
3
votes
1
answer
472
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
189
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 ...
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 ...
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 ...
4
votes
3
answers
914
views
Please help me calculate interest on a loan
My Ex owes me $66000 and I need to give him a payment plan with 8% interest over 5 years.
The monthly repayments need to tier roughly as follows (he's going to earn more in the 2nd and 3rd years and ...
1
vote
3
answers
225
views
What would the formula for loan payoff with daily compounded interest and paid 5 days per wk?
I'm interested in calculating the impact of making payments on my student loans daily (5 payments per wk).
For example my current loan is 50,000$ @ 5.05% interest compounded daily. The term of the ...
-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.
...
3
votes
2
answers
2k
views
What is the formula for loan payoff date?
My goal is to calculate loan payoff date. Actually I'm making a wordpress plugin to calculate that. I made a form from I can have following inputs from user.
Current Loan Information
Original ...
4
votes
2
answers
545
views
Pay off student loans vs pay myself and try to get PSLF? (is my math right?)
I am trying to decide between paying off my student loans in 5 years vs attempting to quality for Public Service Loan Forgiveness (PSLF), which I could conceivably do in 5 years. My options are to 1) ...
2
votes
1
answer
445
views
How does Sallie Mae calculate its payment?
Short Version
Can anyone figure out how Sallie Mae comes up with its personal loan payment amount?
Long Version
I have a friend who took out a personal loan with Sallie Mae, and their payment ...
1
vote
1
answer
136
views
Loan calculation with percentage [closed]
I want to know monthly payment with percentage. Let's say I took loan of $200 and I have to pay monthly for 5 months and amount pay back is $260. Over here $60 is interest. I could make out that I ...
0
votes
1
answer
1k
views
Algorithm to calculate the Interest on Loan with a Balloon Payment
I am trying to understand the algorithm used by My Calculators.com - Balloon Payment Calculator
If I enter the following details:
Loan amount: 4556.75
Number of months: 5
Interest rate: 5.75%
...
0
votes
1
answer
172
views
How do interest calculations differ between loans and savings? [closed]
At the bank or financial institute how are the interest calculation is different from loans and savings? Are they calculated the same way?
3
votes
2
answers
272
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%. ...
2
votes
1
answer
931
views
Excel calculating interest rate on loan
Not sure if this is the right place to ask this type of question, apologies if it isn't.
I am following this explanation on office support to answer my own question.
Using the values they use, what ...
9
votes
2
answers
3k
views
What is the formula for calculating the total cost of a loan with extra payments towards the principal?
If I have a 30 year mortgage of $200,000 with an APR of 4.446% I can calculate how much my monthly payment will be and how much the total cost of the loan will be.
But what if I have an extra $200 to ...
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 ...
2
votes
2
answers
1k
views
Calculate the Loan Amount for a given Monthly Payment where the Balloon Payment is a Percentage of the Loan Amount
I'm trying to calculate how much you can borrow for a given monthly payment, including a balloon payment, where the balloon payment is given as a percentage of the final loan amount.
The calculation ...
0
votes
2
answers
140
views
Calculate money owed on shared loan
I am in an interesting situation that I am looking for help with.
I went to college a number of years ago, as did my brother. My mother had two student loans (one for each of us) and a few years ago,...