Fins 2624 Assignment
COMPUTER ASSIGNMENT
FINS2624 Session 1, 2012
Instructions
Please read these instructions carefully before you start.
Groups
You may cooperate on this assignment in groups consisting of up to three students. If you prefer to work alone or with only one other student that is fine, too. Either way, make sure to enter the student IDs (including the letter) and names of all students in your group in the appropriate cells (B1:B6) on the Answers sheet. There will be draconian punishments for students that fail to do this.
Submission
You must submit a hard copy of the Answers sheet at your tutorial in week 8. You should also submit a copy of the assignment (the entire workbook) on Blackboard, before 9 a.m. on September 10. Name your file “Assignment First student ID”, where First student ID is the student ID (including the letter) of the first student in your group. Please only submit one hard copy and one soft copy per group.
The Excel sheet
You can download the assignment from the same folder on Blackboard where you found this document. Each non-empty cell in the sheet has a color which depends on its contents. Green cells contain given data. Blue cells contain given functions. You should not change the values of either green or blue cells. Orange cells are empty, and the assignment consists in filling these out correctly. When you download the workbook most sheets are in protected mode, so that you will only be able to change the cells you are supposed to change. If you find this annoying you may disable the protection by right-clicking the name of any sheet at the bottom of the workbook and select Unprotect Sheet. The password is FINS2624. The Questions and Solver example sheets are already unprotected, as this is necessary to use the solver. You are required to enter your names in the Answers-sheet and you have the option to play around in the Solver example-sheet, but your actual work will
1
be done in the Questions-sheet. Here you will write
FINS2624 Session 1, 2012
Instructions
Please read these instructions carefully before you start.
Groups
You may cooperate on this assignment in groups consisting of up to three students. If you prefer to work alone or with only one other student that is fine, too. Either way, make sure to enter the student IDs (including the letter) and names of all students in your group in the appropriate cells (B1:B6) on the Answers sheet. There will be draconian punishments for students that fail to do this.
Submission
You must submit a hard copy of the Answers sheet at your tutorial in week 8. You should also submit a copy of the assignment (the entire workbook) on Blackboard, before 9 a.m. on September 10. Name your file “Assignment First student ID”, where First student ID is the student ID (including the letter) of the first student in your group. Please only submit one hard copy and one soft copy per group.
The Excel sheet
You can download the assignment from the same folder on Blackboard where you found this document. Each non-empty cell in the sheet has a color which depends on its contents. Green cells contain given data. Blue cells contain given functions. You should not change the values of either green or blue cells. Orange cells are empty, and the assignment consists in filling these out correctly. When you download the workbook most sheets are in protected mode, so that you will only be able to change the cells you are supposed to change. If you find this annoying you may disable the protection by right-clicking the name of any sheet at the bottom of the workbook and select Unprotect Sheet. The password is FINS2624. The Questions and Solver example sheets are already unprotected, as this is necessary to use the solver. You are required to enter your names in the Answers-sheet and you have the option to play around in the Solver example-sheet, but your actual work will
1
be done in the Questions-sheet. Here you will write