vba

PORTFOLIO/VBA ASSIGNMENT – PROJECT III Due Date: Friday 12 October 2018, 23:59 Weighting: 20% Type: Individual Submission: Electronic Submission via AUT Online Instructions Complete your answers in this excel workbook: AnswerFile.xlsm, once you have finished your answers, upload your solutions to Blackboard to be marked. You have to complete the two following tasks using VBA: […]

PROJECT 2 – MORTGAGE CALCULATOR Due Date: Midnight, Friday 21 September 2018 Weighting: 30% Type: Individual Submission: Electronic Submission via AUT Online Instructions for the Project Students are required to build a mortgage calculator in Excel 2016. The calculator should have the following features: It should be capable of calculating the maximum amount a home-buyer

  MS924 Spreadsheet Modelling & Demand Forecasting   Individual Assignment 2017-8   For the purpose of the assignment, you should assume the role of a consultant who has been commissioned by a small manufacturing company, called MAD Ltd, to build a spreadsheet model for demand forecasting. The Operations Manager of the client organization has prepared

City University of Hong Kong Department of Economics and Finance Course EF5213 Assignment #3 ( due March 18, 2018 ) 1. Consider the MVO problem that determines the optimal portfolio content w and w0 by minimizing the portfolio risk subject to an expected return P as minimize 1 wT w 2 subject to wT 

City University of Hong Kong Department of Economics and Finance Course EF5210 Assignment #4 Question 1 (due April 25, 2018) With an accumulator contract, investor agrees to buy a certain amount (M) of the underlying asset at a fixed price (F) over a period of time at settlement dates {1, 2, … , n}. There

Write a (1) (2) (3) (4) (5) Assignment 1 Due Date: February 14, 2018 before 11:59 pm VBA program to evaluate the performance of an investment fund over a four-year period. Using InputBox, ask the user to input the three possible returns (R1, R2 and R3 where R3 > R2 > R1, R3 > 0,

OMIS6350/3670 Winter 2018 MUST READ: General Requirements CHECKLIST for Individual Assignments   Homework assignments are to be done individually or in pairs. Please re-familiarize yourself with York’s and Schulich’s policies on plagiarism. If you base portions of your code on any source other than your own work, insert a link, or otherwise cite the source

City University of Hong Kong Department of Economics and Finance Course EF5213 Assignment #2 ( due March 4, 2018 ) 1. Use VBA as programming tool, implement the implicit finite difference method under the Crank- Nicholson scheme to price an accumulator contract written on a stock with Cox-Ingersoll-Ross volatility structure as (St, t)  

UNIVERSITY OF DELAWARE Department of Civil and Environmental Engineering _____________________________________________________________________ CIEG 430 Spring 2018 Midterm Examination Kathleen S. Boone WATER QUALITY MODELING Date Assigned Date Due 15 March 2018 5 April 2018 Open Book Examination. You may use your textbook and any notes from the course. Do not cooperate with any other student or obtain

City University of Hong Kong Department of Economics and Finance Course EF5213 Assignment #3 ( due March 18, 2018 ) 1. Consider the MVO problem that determines the optimal portfolio content w and w0 by minimizing the portfolio risk subject to an expected return P as minimize 1 wT w 2 subject to wT 