There are 3 problems and one excel file for each one of them.
Any question requiring written explanations, please use empty cells at bottom of sheets and label question answers clearly!!(for example, Answer1.d for problem 1.d, etc …)
PROBLEM 1: (58%)
Use the excel file named ‘assignment1_problem1.xls’ that you can download from the student portal and follow the instructions below:
a. Use naming and labelling of cells according to the needs of this problem. (10 pts)
b. Use all the appropriate formulas in cells E8:M25 (filled with blue colours)
(Leave M17 as it is until after question d) (26 pts)
c. Add your full name and student id number to the Header. (2 pts)
d. Find the source of the ‘#VALUE’ error in the P&L sheet using the auditing tool. Explain what this error is due to. (2 pts)
e. The net profit in year 2003 appears large. Is there a problem? (2 pts)
f. Create base case, best case, and worst case scenarios for the P&L sheet using the data shown at bottom of sheet. (12 pts)
g. Create a scenario summary. What’s your favourite scenario and why? (use the bottom of sheet to answer questions) (4 pts)
PROBLEM 2: (30%)
Use the workbook “Assignment1_problem2.xls ” for this problem.
a. Rename sheet 1 as ‘Holidays_your_full_name”. (1 pt)
b. Use naming and labelling of cells according to the needs of this problem. (5 pts)
c. Insert the appropriate formulas or functions in the cells shaded in yellow colour except for cell B19. (hint: start from E4 and use autofilling) (14 pts)
d. Format cells in range D4:E10 as currency (Euro) and with 2 decimals. F4:F10 should be formatted as £ Sterling and 2 decimals. E17:F17 to numbers with 2 decimals.
...