Assignment is to develop a fully functioning Excel model for the project

Imagine you are working with a company’s head office in Calgary when a new opportunity comes up. The Director of Business Development comes to you with a new project that they are considering pursuing. However, they don’t know any of the impacts this project may make for the company (good or bad).

The Director has come to you because of your expert Excel skills, your strategic mindset, and your ability to model the financial output for this project. Your assignment is to develop a fully functioning Excel model for the project and a 1-page business memo addressed to the Director of Business Development that summarizes your findings and your recommendation of whether to pursue the project and why.