Last updated for Sem. 1/2013 Page 1 AFW/AFG/AFP 2851 – Semester 1 2013 Examination Format and Sample Questions 3 hr closed book exam with 10 minutes reading time. All twelve weeks of the semester are examinable and there are ten compulsory questions on the exam with an split of approximately 45 marks on financial modelling/spreadsheet-based modelling (FM) topics and 55 marks on accounting information systems (AIS) topics. (Note on mark split in unit assessments: FM & S/S design– weeks 1-4 approx. 40%, comprising 31 marks from exam (45% of 70 marks), plus 5 marks from first class test and 4 marks from tutorial participation; AIS – weeks 5-12 approx. 60%, comprising 39 marks from exam (55% of 70 marks), plus 5 marks from second test, 10 marks from assignment, and 6 marks from tutorial participation). The financial modelling component (weeks 1 -4) will include (but is not limited to) both theory and practical questions on spreadsheet-based financial model development as well as the “practical” spreadsheet modelling exercises you were asked to complete for the related tutorials. Five hints for this semester’s exam: 1. You will be given a problem description and a spreadsheet model (complete with data and report sections) and have to write formulas for nominated cells (assuming some of these formulas could be copied.) This, along with other “practical-type” spreadsheet modelling questions will represent at least 25 marks out of 100 on the final exam. 2. You will be examined on theory material from “spreadsheet model design” from weeks 1 & 2 (Krueger & Beaman – available as Topic 13 in your textbook and also on the library electronic reading list). You don’t need to worry about details from the “protection” or “range names” sections. 3. You will be required to describe the theory behind at least one of the financial modelling techniques covered in week 3 of semester. In addition, you will typically be asked how to perform this modelling procedure in Excel: this would be…