Applying computer technology in financial management: an example of the amortisation schedule Online publication date: Sun, 13-Jul-2003
by Terrill R. Keasler
International Journal of Computer Applications in Technology (IJCAT), Vol. 13, No. 3/4/5, 2000
Abstract: Technology advances in software have been considerable in recent years. An example of one significant advance is the integration of a structured programming language with the capabilities of traditional spreadsheet software. This paper illustrates how a basic amortisation schedule template can be made more functional by complementing the spreadsheet template with a structured programming language. Construction of an amortisation schedule in a spreadsheet that will change the number of payments is an important issue for many spreadsheet users. The enhanced template will present a field of view that is unencumbered by extraneous cell formulas which may confuse users of a traditionally constructed template. The paper provides an algorithm for use by professionals interested in enhancing their capabilities relating to structured finance issues.
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Computer Applications in Technology (IJCAT):
Login with your Inderscience username and password:
Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.
If you still need assistance, please email subs@inderscience.com