All Questions
Tagged with loans calculation
13
questions
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
2
votes
1
answer
3k
views
Seasonal Loan Amortization
Hi I can compute a Basic Loan Amortization Schedule, But now I'm trying to Calculate a Seasonal Loan Amortization Schedule . So for example A loan starts at January And Will go on for 3 years, with ...
- 389
10
votes
3
answers
4k
views
Overpaying on mortgage - How is term reduction calculated?
Just for some example figures:
Original Term: 25 Years
Loan Amount: £100,000
Interest rate: 2%
I'm trying to make an excel table which keeps track of my mortgage payments including overpayments. ...
- 255
4
votes
3
answers
8k
views
Loan repayment calculation and monthly compounding interest problem
I need to write a mock up application that returns a quote to potential borrowers. The specification says that "The monthly and total repayment should use monthly compounding interest".
Program ...
Fabian
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%
...
- 111
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 ...
- 91
6
votes
1
answer
660
views
How do I determine how long it will take to pay off my all my loans?
Right now I have a spreadsheet with the loans I have, the interest rates the are each at, and how much I am putting toward each in monthly payments. I then calculate how long each loan will take to ...
- 161
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 ...
- 133
3
votes
2
answers
10k
views
How to calculate the number of months until a loan is paid off (given principal, APR and payment amount)?
Does anyone know what formula they use for this When will you be debt-free? calculator? I want to put it in a Google Spreadsheet, but I can't find a payments-to-debt-free formula using my Google ...
- 133
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 ...
- 23
2
votes
3
answers
5k
views
Amortization Payments with a delay in initial payments
Typically a loan is disbursed and a month later is when payments are to be made. But there can be an agreement where it's to be delayed for a year or as short or as long as they want.
I'm wondering ...
- 389
2
votes
2
answers
129
views
Calculating long intervals of Interest
Small interval calculations is fairly straight forward. But what about long intervals. If a loan's daycount is set to Actual/Actual and the duration has run into two different DayCount intervals, how ...
- 389
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 ...
- 113