Hello guys..

I made a programs using vb6 to generate the amortization schedule, for weekly,daily,and monthly..

The programs run very efficient.. but i want to add more features to it..  what if the customers want to pay twice a month.. and they are going to customize it.. for example they want to pay at  10th and 20th day of month because they  receive their salary to that day..  I've been 3 days planning and thinking about this but unfortunately, until now i did not..

Is there any idea to solve this..?
Could somebody post their vb6 code here?

for example:

customers want to pay  every 10th and 25th day of the month..

date                principal              interest             total
-----------------------------------------------------------------
june 10                10                      2                    12  
june 25                10                      2                    12
july 10                 10                      2                    12
july 25                 10                      2                    12


my only problem is how to generate that day...

thank you very much to all of you and i hope for your immediate response..

thanks...

Hi,

U cud use the vb builtin calender. Search ur msdn or google for exact usage...

If u cud be more specific about ur problem, maybe u'd get a quicker and better response...
Best of luck  


BR

____________________________
lOsT...

it means it will going to generate the amortization schedule twice a month..

[Edited by VYX on 08-07-2007 at 10:14 AM GMT]

Hi misterxed,

its just like

enter amount: 40
monthduration: 2 months
enter interest rate: 4% per month
modepayment: twice a month
datereleased: june 1 200x

daypayment1:10   ''every 10th day of the respective date
daypayment2:25   ''every 25th day of the respective date


customers want to pay  every 10th and 25th day of the month until it finished all his loan..IF the datereleased was june 1 his first payment is june10 and the second is june 25
---------------------------------------------------------------------
                            amortization schedule
---------------------------------------------------------------------

date                       principal              interest             total
--------------------------------------------------------------------
june 10 200x               10                      2                    12  
june 25 200x               10                      2                    12
july 10  200x               10                      2                    12
july 25  200x               10                      2                    12


the code module will generate like this

my only problem is how to generate that day...


thanks in advance..

Hi

If the dates r fixed, like every tenth day, or whatever, u can use the DATEADD function

Conversely, if u know the date b4 hand, u can generate it in string format, then use the CDATE funciton to convert it to days...

If ur interest amount is accrued per DAY, u can use the DATEDIFF function to find out the number of days between 2 given dates... Like in ur example, there'd  be 16 days b/w 25 july and 10 aug, and 15 days between 10 aug and 25 aug...

Hope that solves ur problem...  

BR

____________________________
lOsT...

thank you very much.. i did like this..

since the encoder just put or select the date which is the first payment and second payment and also the term in month
for example
date payment 10/10/2007 and 10/25/2007
term 2 months

output will become like this

11/10/2007
12/10/2007

11/25/2007
12/25/2007



solution:
to generate a the first two line amortization
it just like
for i=1 to term 'which is the 2 months'
          x=dateadd("m",i,firstdate")'which is the 10/10/2007
          list.additems x
next

for j=1 to term 'which is the 2 months'
     z=dateadd("m",j,seconddate") which is the 10/25/2007
     list.additems z
next


when the amortization was being generated i made a function to sort it by datepayment

11/10/2007
11/25/2007
12/10/2007
12/25/2007

but it was so tedious and became complex if you have a suggested code to do like that.. please post here..

I wish this idea could help those programmer doing also a program like this.

thanks..

--------------------------
"Don't be discouraged if your dream doesn't come true immediately.. Victory goes to those who want to fight for another round"
--------------------------
I Want to know more about Programming Strategy!!!