Loan Schedule - Specific Requirements
 

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

Loan Schedule - Specific Requirements
 

Take a look at these samples (all are free):
http://www.vertex42.com/ExcelTemplat...readsheet.html


Regards,
Ryan---

--
RyGuy


"Stuart" wrote:

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