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
- Holidays as referenced in a table format
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.