Financing the Mozal Project

FINS 5535 Computer Assignment For this assignment, you may work in groups of up to four. The due date for the assignment is Friday, 1 June, 2012 by 6:00pm. You may hand in the assignment at the Banking and Finance assignment boxes on the ground floor of the Australian School of Business building. To find the assignment boxes, go to the west elevator (further from the bookstore, closer to the Roundhouse), and go straight out the back through the glass doors (left of the elevator). On the left-hand side you’ll see the Banking and Finance assignment boxes. Let’s use Assignment box 2. I’ll put up a sign closer to the due date. Or, you can hand them directly to me, or bring them to my office during my consultation hours. Please do not disturb our administrative staff. Introduction The purpose of this assignment is to have you solve a number of problems using a variety of spreadsheets that will be provided to you. For the most part, the spreadsheets are designed so that you need merely enter the input variables, which are indicated by the red font. You should only have to change the variables with the red font. Some other colours are used as well, for example, in some cases the solution is given in blue font. NOTE: any input variables that happen to be in the spreadsheet when you receive them should be considered to be irrelevant. You will provide all the relevant input variables. For each spreadsheet, answer the questions provided. The questions will be indicated by letters, (a), (b), etc. Generally, each question is worth 1 mark. Please do not hand in a spreadsheet unless explicitly asked to do so. Introduction to the Spreadsheets Puts&Dvd.xls and Call&Dvd.xls NOTE: before opening the spreadsheets Call&Dvd.xls and Puts&Dvd.xls, you need to go to Tools, Add-Ins, and make sure there’s a check mark beside Analysis ToolPak-VBA. Also, make sure that there’s a check mark beside Solver. (To do this with Office 2007, click on the Microsoft Office button on the upper left