S
Stuart
Dear All,
I've been searching for a schedule for weeks and I've also tried
several excel formulas.
I need to try and work to get the following an excel spreadsheet.
These are my values.
I have a loan which was given on 24th July for $80,000. They charge
me 6% which is quarterly compounded and is based on a 360 day count.
I am suppose to pay each quarter ending September December March and
June however if I dont pay on the given dates then the interest is
added on to my principal loan figure at the end of the quarter. I am
to repay everything on 31st January 2010.
What I need to build into the above and I'm struggling to present this
in excel.....
A) I can drawn down more from the loan on any given date and interest
should start calculating on this.
B) I might not pay so it should add on the interest at the end of the
relevant quarter.
I hope someone can help me put a schedule together for all the above
variables as I'm trying to get to grips with my finances and this will
help a million.
Thanks alot,
Stuart
I've been searching for a schedule for weeks and I've also tried
several excel formulas.
I need to try and work to get the following an excel spreadsheet.
These are my values.
I have a loan which was given on 24th July for $80,000. They charge
me 6% which is quarterly compounded and is based on a 360 day count.
I am suppose to pay each quarter ending September December March and
June however if I dont pay on the given dates then the interest is
added on to my principal loan figure at the end of the quarter. I am
to repay everything on 31st January 2010.
What I need to build into the above and I'm struggling to present this
in excel.....
A) I can drawn down more from the loan on any given date and interest
should start calculating on this.
B) I might not pay so it should add on the interest at the end of the
relevant quarter.
I hope someone can help me put a schedule together for all the above
variables as I'm trying to get to grips with my finances and this will
help a million.
Thanks alot,
Stuart