Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need a loan payment schedule | New Users to Excel | |||
Loan Schedule - Specific Requirements | Excel Discussion (Misc queries) | |||
loan amortization schedule | Excel Discussion (Misc queries) | |||
I am looking for a loan schedule which allows for a residual | Excel Worksheet Functions | |||
loan amortization schedule | Excel Discussion (Misc queries) |