Model - Financial

Batman007
InnovareModel-WIP.docx

Innovare Model - WIP Model

Innovare runs on a fiscal year. July 2021 to June 2022 is what aI need the model built out for.

Model should be based on their projected sales and marketing goals.

· P&L Historicals are accurate in the excel Workbook

· Need you to set up the income Statement, Balance Sheet and Cash Flow Statement (my setup is not entirely correct)

Inputs – Key information in this tab (Goals) Please make an inputs tab. I am attaching their sales and marketing goals.

1. Close -Win Goal

2. Opportunity Goal

3. SQL Goal

4. MQL Goal

5. Prospect Goal

6. Simple Lead Goal

7. Anonymous Visitor Tracking

Lead Generation / Sales Funnel – Need the sales funnel to be built into the model to make it work - Key information

1. $208 is the cost per lead

2. Incorporate the average deal size $12,500

Key information

1. They have 3 types of clients

a. Charter Schools

b. Non-Profits

c. School Districts

2. 4 different regions

a. IL

b. NY/NJ/CT

c. DC/VA/MD

d. MO

Model must incorporate all these elements and be able to track everything.

There is also an FTE tab. This may be good for know but I will keep you posted on any changes that I may need.