Assignment Number One
Computer Skills Assignment
You have recently been appointed to a position of financial analyst with a large manufacturing concern. Your immediate superior has brought the CFO into your office, explaining that you are a graduate from the Accounting and Financial Management program at the University of Waterloo, and therefore, you are a computer wizard. The CFO, a gruff old lady of at least 55 years of age, looks at you with a mixture of admiration and disdain. “I’m presenting a financial analysis to the Board of Directors in a week’s time, and I need to have a good functioning financial model,” she said, stopping to look over your shoulder at the FaceBook page now quickly reduced to an icon on your desktop. “Your predecessor provided me with a spreadsheet analysis that showed the right numbers most of the time, but the board kept challenging me with other assumptions and situations. The stupid spreadsheet first gave me wrong numbers –astronomically wrong – and then simply froze up when I tried to input new variables.” “This is not going to happen again, do you understand? Never again, even if I have to replace the entire financial analysis group!” as she glanced over at your boss, who was now perspiring slightly. “Never was I so embarrassed!” “You will make it happen.” With a wave of her hand like the Queen of Hearts, she strode out of your tiny closet, back to the regal “C” suites on the 18th floor. Holding back a desire to chuckle, you know what you have to do. “Could I have a week to work on it?’ you inquire innocently of your direct boss, knowing that you could wow them with your knowledge of financial modelling on Excel. “I heard through the grapevine that she does this presentation alone, but she really doesn’t understand how the spreadsheet works .” “That’s all the time available,” was the quick response. “By the way, I’ve offered to help her in the meeting, but it’s restricted to VP’s only, so she has to...
Please join StudyMode to read the full document