WHAT TO INCLUDE IN COOL PROJECT (pick any five from the list below and implement them): Numerical Optimization (Goal Seek, Solver) Custom VBA functions Math Formulas WebQuery with parameters GoogleFinance Dropdown Menus Recorded Macros Userform Sensitivity Analysis Scenario Analysis Pivot Tables Chart and Graphs with Trendlines Anything else in Excel that students learned RULES: The project (idea and code) must be developed by the student in the current semester (not from a prior semester, not from other classes, not from the internet, etc.). The project must mainly solve a finance problem (not an IT project, not a game, etc.). If a student copied code from anywhere else, it must be referenced and attributed (not attributing amounts to plagiarism). Also, copied code can not constitute more than 20% of the total project code (measured by lines of code, without comments). The following projects can not be used: Model (code) not developed by the student, Excel models from the internet, Excel models from other classes, Excel models developed in previous semesters. RUBRIC: 24 points each are allocated for the following areas. Originality: Is this student's original idea (vs. copied from the internet or some other class)? Answer should be YES Relevance: Is the concept part of the Financial Analysis class (vs. information systems, information technology, OMG, etc.)? Answer should be YES Reusability: Can other students use it? Answer should be YES Quality: Did the model break or stop when others try to use it? Answer should be NO Effort: Since this is a semester-long project, 15 to 20 hours of model building effort should go into this project. Can other students build the same model in less than three hours? Answer should be NO