Developing a Financial & Project Execution Plan for a Media Project INTRODUCTION 1 TASK 1

Developing a Financial & Project
Execution Plan for a Media
Project

Table of Contents
INTRODUCTION...........................................................................................................................1
TASK...............................................................................................................................................1
2.1.1 Budget estimation..........................................................................................................1
2.1.1.2 Financial projection for next three years with help of cash flows and Profit and loss2
2.1.2.1 Staffing level and required competencies for each position.......................................6
2.1.2.2 Required equipment, tools and systems.....................................................................7
2.1.3. Project execution plan..................................................................................................8
2.1.3.1 WBS...........................................................................................................................8
2.1.3.2 Inputs and outputs.....................................................................................................10
2.1.3.3 Internal and External process...................................................................................11
2.1.3.4 Key Deliverables and KPI........................................................................................12
2.1.3.4 Gantt Chart...............................................................................................................14
CONCLUSION..............................................................................................................................16
REFERENCES..............................................................................................................................17

INTRODUCTION
A financial and project execution plan helps in creating a detailed budgeted business
proposal in respect to evaluate success of a project. The main aim of this presentation is to
develop a financial and project execution plan for This media project would be a new TV public
programme covering the people life experiences in the Arabic capital cities. In this presentation,
a project for new TV public programme is discussed which is regarding the life experience of
people in the Arabic capital cities, is selected for allocating capital investment of 3 million AED
with the objective of achieving 500 million views per month by the end of second year and these
views will be collected from the TV, Facebook video, shoot videos, twitter and YouTube
channels. This presentation covers three years’ financial projection for mass media project
related with life experience of people in Arabic capital cities. Resource acquisition and allocation
strategy is also being discussed in this presentation. Along with this a project execution plan is
also developed including all its aspects.
TASK
2.1.1 Budget estimation
Budget:
Budget is an estimation of revenues and expenses for a specific future period of time and
it is compiled and re-evaluated on a periodic basis. The estimated budget is prepared for the TV
project which covers the people life experience in the Arabic capital cities.
Estimated budget for the TV public programme (Amt in AED)
Particular Year 1 Year 2 Year 3
Initial Investment 3000000 1999000 1039000
Start Up Cost :
Incorporation
expenses
50000 - -
Other 190000 - -
Fixed cost :
Mic 150000 150000 150000
1

Video equipment 150000 150000 150000
Legal fee 40000 40000 40000
Vehicle insurance 20000 20000 20000
Computer & TV 250000 250000 250000
Variable cost :
Content writing 40000 40000 60000
Graphic expenses 20000 80000 100000
Transportation cost 35000 100000 110000
Asset cost :
Asset repairing cost 11000 40000 69000
Installation 45000 90000 90000
Balance 1999000 1039000 Nil
As from the above projection it can be seen that after incorporating all expenses of first
year it will have the balance of 1999000 which will be carry forward to next year for
incorporating further expenses and in the 2nd year total balance becomes to 1039000 and
similarly it goes for third year and balance becomes nil.
2.1.1.2 Financial projection for next three years with help of cash flows and Profit and loss
Financial projections are essential for every business plan in order to keep smooth cash
flows in business. The projection enables owners to seek attention of investors. This includes the
sales forecasting, expenses budget, cash flows and profit and loss statement. Projection is done
for entertainment media project with help of cash flow and profit and loss statement.
Projected Cash Flow For Three Years (Amt in AED)
Opening Cash Balance 3000000 4396400 5434900
CASH IN -
Cash From Sales 2500000 1800000 2500000
Cash From Out-
Licensing of
- - -
2

Intellectual Property
Loans or Other
Financial Vehicles
- - -
Tax Rebates (eg
SR&ED)
- - -
Taxes Collected from
Sales
- - -
Revenues from
Advertisement
700000 750000 790000
Interest From Bank - - -
TOTAL CASH IN 6200000 6946400 8724900
CASH OUT
Cost of Sale (COS) 500000 250000 150000
Staff Expenses /
Salaries
300000 300000 320000
Salaries 300000 300000 320000
Marketing Expenses 328000 283000 322000
Website Creation and
Maintenance
10000 4000 4000
Website and Email
Hosting
12000 12000 15000
Market Research 20000 18000 20000
Media Relations and
PR (include writing)
30000 28000 30000
Conference
Attendance
7000 8000 10000
Tradeshow Displays 68000 60000 50000
Language Versioning
of Website
45000 40000 40000
Advertising 100000 80000 120000
Subscriptions to
Publications
33000 30000 30000
Other 3000 3000 3000
Facilities 90000 95000 110000
Office: Rent 15000 15000 15000
3