Amortization table Academic Essay
Section A Individual Assignment (maximum 10 pages, around 2500 words report)
1 (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).
PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT
The mark that you score on this coursework constitutes 100% of the final assessment for this module. There will be no other assignment. The assessment will be based on the level of basic comprehension or understanding that you will demonstrate. We will also be looking for ability to apply the relevant VBA concepts, critical thinking and originality skills.
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.
Upload your report of not more than 10 pages to the IF1201 Moodle website. Also upload the file containing your results and macro on Moodle. Remember to save as macro enabled workbooks. In case your macros get disabled during the submission process, please make sure all members of your group save the same final version of the results in your U-drive or other forms of back up. Where we do not find macros on your Moodle file, we will request any one of the group members to resubmit the coursework.
Online Submission Deadline Friday: 20 April 2018 Time: 1500hrs