BUS2206 Information Systems Management
Information Systems Management
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
BUS2206 Information Systems Management
Excel Assignment (7%), Term 1
Case 7: The Very Big Bank Stress Test
• Imagine that we are still in year 2015.
• Read “Case 7: The Very Big Bank Stress Test” in pages 135-144 of “Problem-Solving Cases in
Microsoft Access and Excel”, 13th Edition, 2016.
• The book is available on reserve in the library.
• Download “Assignment2_2021T2.xlsx”.
• Complete Assignment 1 to Assignment 2A of the case; completion of Assignment 2B is not required.
• Your final Excel file should contain two sheets: (1) your Excel DSS model that deals with
Assignment 1; (2) the Scenarios Manager summary sheet for Assignment 2A.
• The result from your scenario analysis should look like this:
• Submit the completed Excel file onto Moodle.
• There is no need to print out anything for your teacher.
Marking Scheme
• Appropriate design of the spreadsheet model structure (15%)
• Simple equations are created correctly (30%)
• Advanced equations are created correctly (40%)
• Correct analysis reports are generated (15%)
Plagiarism will be penalized. Late submission will be subject to a deduction of 0.5% per day.
Scenario Summary
POOR-HIGH POOR-NORMAL OK-HIGH OK-NORMAL
Changing Cells:
MARKET VOLATILITY - ALL YEARS $C$12 H N H N
ECONOMY -- 2016 $C$13 P P O O
ECONOMY -- 2017 $D$13 P P O O
ECONOMY -- 2018 $E$13 P P O O
Result Cells:
SHORT TERM DEBT AT Y/E -- 2016 $C$18 -$ -$ -$ -$
PASS / HOLD / FAIL -- 2016 $C$19 HOLD HOLD PASS PASS
SHORT TERM DEBT AT Y/E -- 2017 $D$18 118,854$ -$ -$ -$
PASS / HOLD / FAIL -- 2017 $D$19 FAIL HOLD PASS PASS
SHORT TERM DEBT AT Y/E -- 2018 $E$18 268,569$ -$ -$ -$
PASS / HOLD / FAIL -- 2018 $E$19 FAIL HOLD PASS PASS