Answer all questions: Make the necessary assumptions to complete your VBA models in a clear and easy to follow structure. When documenting your models, assume that you are an investment analyst, portfolio manager, bank fund manager etc where you are introducing a new approach to analyzing your client's reports by using VBA programming. You want to persuade them to appreciate the advantages of VBA modelling.
Section A: Individual Assignment
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 installments 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.
(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.
(iii) Use the above VBA exercise in (a) and (b) to compare and contrast VBA modelling and Excel modeling.
Section B: Group Assignment
2. Develop and document a model that allows the user to query exchange rates across three or more currencies. Prepare a spread sheet that stores a table of exchange rates across three or more currencies that the user can fill in before the program runs.
For example to illustrate you could use the following rates:
1 GBP = 1.12952 EUR 1 EUR = 0.885329 GBP
1 GBP = 1.64004 USD 1 USD = 0.609740 GBP
1 USD = 0.688735 EUR 1 EUR = 1.45194 USD
At run time the user simply states the source and destination currencies and your model should output to the screen the relevant exchange rate(s) picked out from the table. (In other words create an efficient multicurrency convertor).
3. (i) Create a workbook with a macro that creates three or more additional excel windows from the same workbook to analyze financial data. Explain how your VBA macro works.
(ii) Create a workbook containing a macro with VBA code that finds the average of a range of numbers. The macro should also calculate other statistical parameters e.g descriptive statistics. Discuss how your macro functions.
Are you in the quest for the most skilled and talented tutor to precisely complete your academic tasks and for securing higher academic grades? Then consider Introduction to Visual Basic Assignment Help service as your ultimate destination!
Tags: Introduction to Visual Basic Assignment Help, Introduction to Visual Basic Homework Help, Introduction to Visual Basic Coursework, Introduction to Visual Basic Solved Assignments