In Progress

Return a Date schedule

Create a piece of VBA (Access) code that takes inputs to generate a list of dates for loan repayment schedule.

Returns an array or class object that allows for easy referencing of the elements of array.

Will also in put some basic info into the date schedule such as amount and rate.

Will provide the example of how to call and reference elements of the returned date & amounts/rate schedule. See example results in document.

The function should take standard inputs;

- Start date

- MaturityDate

- RollFrequency

- RollDirection

- DateMovingConvention

- EndofMonthConvention

- Holidays as referenced in a table format

- etc

Returns the list of dates, ie quarterly date for 30-Jun-12, for 5yrs subject to USA (or other country) holidays (provided in a table).

As this request is for a market convention date schedule happy to hear suggestions for key inputs or alterations to specification.

See attached document detailing the specifications and input requirements.

Skills: Financial Markets, Microsoft Access, Visual Basic for Apps

See more: example of a requirements document, microsoft vba, microsoft usa, Return, repayment, microsoft access vba, call schedule, vba function, visual schedule, vba create schedule, requirements specification table, generate code access, access specification, vba provide, access array, create table vba access, access table vba, loan function, subject holidays, create specification table

About the Employer:
( 14 reviews ) Brisbane, Australia

Project ID: #4560427