Design an excel spreadsheet and write a report based on the Guidelines for Marking.pdf for the criteria for individual project for the excel spreadsheet and the report.
The project is to demonstrate the use of financial analysis model test depending on the grid you have chosen (examples: Sensitivity Analysis, Scenario Analysis, Monte Carlo Simulation, etc), to demonstrate the use of various function in excel and the use of VBA and to show in your model the model diagram identifying what are your inputs with sufficient use of form controls. You need to split your one page model into inputs, logic and output block into several worksheets showing your inputs.
Samples are attached for your reference. Sample of Individual Project.xlsm and Sample of Individual.pdf are examples that one student is able to demonstrate to meet the requirement of the project.