Topic: Visual Basic for Applications (VBA)
Paper details:
All your code, data inputs and outputs should be in the same worksheet. Each question will marked
out of 100 marks and 10 marks are reserved for good presentation ie. efficiency, elegance and
clarity of the code. Therefore please remember to choose your data variable names carefully, indent
your code, comment extensively to explain your code. When there are multiple ways of doing the
same thing, use more efficient commands and richer data structures to achieve the same result.
There are three questions: (i) Create and document a model to produce an amortization table for a fixed rate loan using the PMT
function. The loan is to be repaid in equal annual instalments over its life and the first payment is to be
made at the end of the first year. Use dialog boxes to get the user inputs. The program should validate the
user input for reasonableness and ask the user to modify any input that is not appropriate. For output, use
the worksheet predesigned with labels, table headings, formatting and so on. (40 Marks)
(ii) Explain and demonstrate another alternative VBA method which you could have used to solve the
problem in No (i) instead of using the PMT function in VBA. (40 marks)
(iii) Use the above VBA exercise in (a) and (b) to compare and contrast VBA modelling and Excel
modelling (20 marks)
(Total 100 marks).
The post Topic: Visual Basic for Applications (VBA) Paper appeared first on EssayBishop.