How to optimise my algorthims

[lianp]

hello,

ok, so I had been working on a project that would generate a loan schedule.

But, It needs to factor in specified holidays and weekends.

Now, when running with a small 'term', it seems to work fine.

However,

I tried the following:

Loan amount: 300000
Interest: 7.55%
Term: 30 years
Frequency: Weekly

and let's just say that after 4 hours, it still hadn't finished.. =/

now i'm sure it can be optimised somehow to only perform it in a few seconds at max.. but, I just don't know how..

I have attached the project.

you'll need to browse to the file 'business_days' and then change the figures and click calculate.

thank you.

regards,

lianp.


EDIT: woops, i have amended the attachment now..