Internship Overview

• Interns: 1
• Time Commitment for Each Intern: at least 13 hours/week
• Total Project Length: 4-6 weeks

Project Overview

We are building a brand-new approach to worldwide consumer marketing. Our service is currently in development and therefore in "stealth mode". We need a financial model that will help us understand our market, our business model and our value proposition for participants.

Objective

We need to design & build a financial model in Excel that will integrate macro-level (aka industry-wide) information regarding marketing expenditures and micro-level information regarding spending decisions by individual marketers, allow us to fine-tune assumptions over time, and output a complete financial forecast. Understanding our business model will be critical to helping fine-tune assumptions, creating meaningful KPIs and teasing actionable business intelligence from the model.

Project Details

This project will include:

• Spending time with our team to understand at a high level the service we are working to build and the marketplace in which it operates;
• Reviewing our existing analysis of macro- and micro-level marketing expenditures;
• Developing the high-level methodology that will drive the forecast and working with our team to refine that methodology;
• Building a detailed and flexible financial model that implements the final methodology;
• Working with our team to review & revise that model; and
• Doing a live presentation to explain that model to our team upon project completion.

This will be a monthly 5-year model that rolls up into quarterly, annual, and trailing-12-month reports. It will include tabs for assumptions, revenue build-up, income statement, balance sheet, cash flows, schedules/supporting details and KPIs. We will give you access to organizational assets to support this project such as personnel, brand collateral and more.

In addition, there will be opportunities to augment the modeling work with smaller projects around business strategy, competitive intelligence and technology selection.

This project requires strong skills in financial modeling, financial analysis, accounting, communication and teamwork. In addition, the model will be built in Microsoft Excel, so a high level of experience and proficiency in Excel is required.

Please see project description