F1201 Introduction to Visual Basic Assignment

Assignment Help Visual Basic Programming

Reference no: EM132506737

F1201 Introduction to Visual Basic Assignment, Cass Business School - City University London, UK

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 analysing 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 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.

(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 a 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 analyse 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.

Reference no: EM132506737

Questions Cloud

Create a narrative summary of the documentation : Analyze the data requirements, create a data collection form (template) to assess the criteria, and create a narrative summary of the documentation(compliance).

Why relevance are the only two fundamental qualities : Discuss why faithful representation and relevance are the only two fundamental qualities which ensure that accounting information is useful.

Should product b be processed further : $2 of joint costs from the initial production operation. Should Product B be processed further, or should it be sold at the end of the initial operations?

Create plan to address social distancing for him frontline : Create a plan to address social distancing for the HIM frontline of ROI. Provide an update of recent changes in HIPAA regulations in response to Covid-19.

F1201 Introduction to Visual Basic Assignment : F1201 Introduction to Visual Basic Assignment Help and Solution, Cass Business School - City University London, UK - Assessment Writing Service

Find what amount will be in investment fund on december : Determine If Wagner will earn 12% on the investment, what amount will be in the investment fund on December 31, 2023? (Rounded your answer to nearest €)

Create a plan for a hipaa interdepartmental workshop : The Chief Executive Officer of Battleground University Medical Center is concerned about the overall competency level regarding healthcare privacy and security.

What is the correct cash balance on may : What is the correct cash balance on May 31? A May 31 deposit of $300 does not appear on the bank statement; but a $3 service charge does

Explain what interests me in the program : The task I was given is to explain in 500-600 words what interests me in the program. I am interested in this program mostly for it's diverse career.

User Account

All Pages