All Questions
Tagged with loans calculation
62
questions
3
votes
1
answer
186
views
Effective Interest Rate from bifurcated interest rate
Here goes, this is the scope of my question: Say I want to take out a credit card, that has 0% interest for 12 months, when at the 13th month, whatever debt is taken out on the card will be subjected ...
1
vote
1
answer
174
views
How is minimum payment calculated for this daily amortized loan?
I'm trying to figure out how the bank calculated the minimum payment for a personal loan.
Starting Principle: $6,800
Interest Rate: 13.750%
Loan Term: 36 months
Payment Frequency: Monthly
Start Date: ...
2
votes
1
answer
4k
views
Calculating total number of monthly payments in Excel using NPER and PMT?
How to calculate the total number of monthly payments given the amount of loan ($275,000), the annual interest rate (4.35%) and the number of years (30)? I'm confused because I'm trying to use the ...
1
vote
0
answers
182
views
How to calculate interest charged on my loan given a series of dates & payments?
I want to calculate the interest rate payed for this loan using Mathematica.
The initial amount was of 12000€, then they asked to pay 240€ for opening the loan and another 870€ for the insurance for ...
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 ...
0
votes
2
answers
2k
views
Loan Amortization with Daily Calculation
I'm trying to solve this Loan Amortization Question.
Principal = $125000
Interest = 8.5%
Compounded semi annually
Duration is 10 years (120 months)
Monthly Payments
Loan given on 7/31/2009
First ...
0
votes
2
answers
2k
views
Formula for how to distribute a loan payment between multiple loans such that the remaining principal accrues the least interest?
Assume 4 loans (Balance @ p.a. interest):
$10,000 @ 5.5%
$5,500 @ 7.25%
$2,000 @ 5.5%
$1,000 @ 4.5%
If I am looking to pay $7,250 towards principal only, how would I calculate the ...
0
votes
1
answer
111
views
How can I calculate minimum payment on quick loan? [closed]
I am working on calculator for quick loans. Client can select how much he will pay monthly. Base on it payment schedule will be calculated. Payment interest depends on 1 payment period. Number of ...
0
votes
3
answers
147
views
Personal Loan issuer online service
I have chunk of money that I would like to loan to my brother. I would like to charge him interest same as banks do.
Is there a website or online service where I can enter the "loan" amount, ...
0
votes
2
answers
79
views
Day of payment affecting Payment amount
I'm currently testing this Loan Amortization Software. I can enter in a Principal amount, Interest, Payment durations and future value in the end of the duration, When payments are to be made, ...
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,...
1
vote
2
answers
212
views
Loan Amortization with Insurance
I'm wondering how does you calculate payment amount of the loan amortization schedule if insurance is involved. "Desjardins" insurance on loan is such that for every $1000 outstanding balance, you get ...
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 ...
2
votes
2
answers
172
views
How to calculate whether it's better to pay my education loan, or my home investment loan?
I have an education loan @ 11.5 % for 1,000,000. I can pay it in 3 years.
I am planning to make an investment by buying a home @ 10.5% for 2,200,000. Term = 20 yrs.
I am thinking if I sell the house ...
2
votes
1
answer
243
views
How to calculate outstanding Graduate Plus Loan balance currently in deferment?
Can someone tell me what I'm doing wrong here?
If I have a $56,500 loan and the interest rate is 7.9% how much will I
owe after 8 months?
I thought this would be fairly simple. I would compound ...