All Questions
7 questions
17
votes
10
answers
10k
views
How can I buy things with monthly payments in the US?
I am a new international student in the US. In our country we didn't have credit cards like in the US and this is a new system to me.
If I get a new credit card in the US with a $2000 credit line/...
user109157
1
vote
1
answer
3k
views
Daily interest calculation on a 30/360 basis, considering payment occurs before schedule — how-to in Excel?
I'm setting up a payment spreadsheet for a loan just granted, and want to be able to make daily calculations of accrued interest.
The debtor has been given a payment schedule with an interest only ...
- 11
1
vote
3
answers
188
views
How are mortgage payments decided? [duplicate]
I always used to think that monthly mortgage payments had fixed proportion of interest payments and house payments (determined by rate and term). But, I recently heard that you start off with making ...
- 121
3
votes
2
answers
3k
views
Calculating amortisation payment amount, where first payment date differs from loan start date
I'm trying to reproduce the schedule, but I cant seem to get the same Payment and Interest for each month. The tricky part here is that the Loan start date is 9 Feb 2017 but the first payment is only ...
- 133
1
vote
1
answer
1k
views
Calculating the number of years before an investment with increasing savings reach a certain value
I want to calculate the number of years required before an investment reach a certain value assuming increased payments.
Ignoring the increase of payments, I can calculate using NPER (Google Sheets, ...
0
votes
1
answer
13k
views
What is the formula for loan payoff with daily compounded interest and monthly payment?
My goal is to make a graph using this formula for all possible monthly payments.
Let's say...
Loans: 21750
Monthly Payment: 220
Daily Interest: 4.0% / 365
What formula would I use to get the total ...
- 125
3
votes
2
answers
8k
views
Monthly/Annual Payments Calculation with percentage increase to equal exact dollar amount over exact specified period
I'm not sure if this is the right place to ask this kind of a question, but here it goes.
I have the following information:
A = Total amount needed
B = Number of periods (monthly, 12 payments of ...
- 133