Assessment A
Format: Calculation and brief working or short answer with explanation as well as the calculation solved in an Excel spreadsheet. For each calculation you must provide a manual solution and a solution using excel. Typing straight into excel without doing the calculations in excel does not qualify as solving in excel. Use the excel template provided. Do all the assignment with explanations in excel and upload one file. Type your explanation and manual answer in text boxes.
Two answers one in Excel and one in a Text box
You must provide a full answer with explanation and accompanied with the calculation done manually and one done in Excel. See the example below.
1. Manual answer as if you were answering the question in an exam (but typed). Include a time line or cash flow map/table, an explanation of the logic used to arrive at the answer, the formula used and then the calculations. The formula on its own followed by the answer is not enough.
2. You must also do the solution in Excel. Typing the answer as a number into excel is not enough.
Do all the assignment with explanations in excel and upload one file. Type your explanation and manual answer in text boxes. Use the template provided. This is the preferred method.
