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 …show more content…
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 have a robust model that she can’t damage. Just make sure that we both have a job at the end of this.”
“By the way, they’ve changed the assumptions on the model, so don’t make the mistake of using any model from the last