At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
depends on how often you pay off principle and how much dollars.
and how often you are charged interest.
fv=pv*(1+interest rate)^n n being the term of interest
so lets assume you pay zero off it and interest is calculated daily
fv=6300*(1+0.015/365)^365
interest = fv - pv
= 95.21 for one year without repayment
if you were to pay approx 25.15 a week you would pay this loan in 5 years time and pay approx $240 in total interest over five years
EXCLUDING future interest rate increases over the five years and excluding bank fees like account fees or account manage fee or setup a loan fee.
You could create a spreadsheet each day and calculate the interest as annual interest / 365 for the daily calculation
Then add the account fee onto the balance calc + any set up fee onto the start balance. by using =a$5 for the repayment on all rows as an example you can copy it down and the cell number will always be a$5
this way you can alter a5 and the repayment alters all the way down each week row.
or just download a template for excel
https://templates.office.com/en-us/Loan-amortization-schedule-TM10073881
×