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 in a professional finance role such as investment analyst, portfolio manager or fund manager and that 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. Question 1 i. Create and document a model to produce an asset depreciation table for a fixed asset using both the SLN (Straight line depreciation method) and DDB (Double declining balance depreciation method) functions within VBA. 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 a predesigned worksheet with labels, table headings, formatting and so on. (30 Marks) ii. Explain and demonstrate an alternative method which you could have used to solve the problem in 1.i. instead of using the SLN and DDB functions in VBA. (5 marks) iii. Use the above VBA exercise in 1.i. and 1.ii. to compare VBA modelling and Excel modelling. Marks allocated to professional presentation of your report. (5 marks) (5 marks) (Question: Total 45 marks) Question 2 Develop and document a VBA driven multicurrency convertor for various currencies. A multicurrency convertor allows the user to query exchange rates across different currencies. Prepare a spreadsheet that stores a table of exchange rates across at least four currencies. It is assumed that the user can complete this table before the subroutine runs. 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. You may use either the most up to date exchange rates for the currencies that you can find, or the rates detailed below: 1 GBP 41.68 THB or 1 THB = 0.024 GBP 1 GBP = 1.63 SGD or 1 SGD = 0.61 GBP == 1 GBP = 22.55 MXP or 1 MXP = 0.044 GBP 1 GBP = 159.80 JPY or 1 JPY = 0.0063 GBP (30 marks) Explain and demonstrate 2 methods that can be used to 'call' a VBA subroutine. (5 marks) (Question: Total 35 marks) Question 3 i. Create a workbook containing VBA User Defined Functions. One function should calculate the unlevered beta and one function should calculate the levered beta. (5 marks) Explain and demonstrate 2 methods that can be used to 'call' a VBA function. (5 marks) Suggest and demonstrate an alternative method that could be used in Excel to achieve the same operations. (5 marks) Marks allocated to professional presentation of your report. (5 marks) (Question: Total 20 marks) (Assignment: Total 100 marks) Submission You are required to submit the following: One report answering the questions within this assignment. Do not exceed 10 pages. One Excel workbook containing all your code, data inputs and outputs.