Developing Financial & Project Execution Plan for Media Project

This project presents a comprehensive financial and project execution plan for a new TV public program focusing on the life experiences of people in Arabic capital cities. The plan includes a detailed budget estimation spanning three years, outlining initial investments, fixed and variable costs, and asset expenses. Financial projections, incorporating cash flow statements and profit and loss analyses, are provided to illustrate revenue generation through advertising and satellite rights. Furthermore, the project addresses resource acquisition and allocation, detailing staffing levels and required competencies for each position within the media project. A project execution plan, complete with a work breakdown structure (WBS), inputs and outputs, internal and external processes, key deliverables, and KPIs, is also included. The project aims to achieve 500 million views per month by the end of the second year, with a Gantt chart to visualize project timelines.

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

Office: Utilities 30000 35000 40000
Office: Furniture and
Fittings (cap)
40000 40000 50000
Cleaning and Waste
Management
5000 5000 5000
IT/IS 84500 93500 98500
Telephones 20000 20000 25000
Integrated
Communications
System (voice/data)
30000 35000 35000
Workstations, Printers
and Peripherals
10000 12000 12000
Software 15000 15000 15000
Network supplies
(LAN)
4500 4500 4500
Mobile phones and
PDAs
5000 7000 7000
Internal Project
Resources
32000 40000 35000
Materials 12000 15000 15000
Equipment 20000 25000 20000
Project Contract
Resources
57000 60000 58000
Subcontractor 2: 12000 12000 10000
Subcontractor 1 11000 11000 10000
Materials 1000 4000 5000
Facilities and
Equipment
33000 33000 33000
Technical Support 120000 120000 120000
Materials 70000 70000 70000
Equipment 50000 50000 50000
Financial 40000 45000 55000
Aged Accounts
Payable
40000 45000 55000
R&D Expenses 6000 6000 6000
4

In-Licensing of
Intellectual Property
5000 5000 5000
Subscriptions and
Technical Research
1000 1000 1000
Travel 80000 100000 150000
Selling Expenses (eg:
Commissions)
7500 8000 15000
Office Support 40000 42000 45000
Office Supplies 20000 15000 15000
Office Equipment 20000 27000 30000
Professional Fees 62800 68000 68000
Legal -- General 40000 40000 40000
Legal -- Patents 5000 5000 5000
Accounting 7800 8000 8000
Book-keeping 10000 10000 10000
Advisor Fees - 5000 5000
Banking Charges 4000 4000 4000
Bank Fees 4000 4000 4000
Taxes 125000 90000 250000
Sales Tax 125000 90000 250000
Miscellaneous 6800 7000 7000
Insurance 5000 5000 5000
Membership Fees 800 800 800
Couriers, Mail and
Postage
1000 1200 1200
TOTAL CASH
DISBURSEMENT
1803600 1511500 1538500
Net Cash 4396400 5434900 7186400
Revenue for this media project is only not procured through satellite rights of television
but income generated by this media programme is also contributed by the advertisements which
are shown between the lap of each episode of this programme. This media project is broadcast on
5

Television, Facebook and YouTube. The advertisements of all these mediums will have their
contribution against the revenue generation of this media project.
6

Profit and Loss Statement for three years (Amt in AED)
Year 1 Year 2 Year 3
Sales 2500000 1800000 2500000
Income from
Investment
700000 750000 790000
Less: Cost of Goods -500000 -250000 -150000
Gross Profit 2700000 2300000 3140000
Less : Expenses
Salaries 300000 300000 320000
Rent 15000 15000 15000
Project expenses 89000 100000 93000
Office expenses 130000 137000 155000
R&D 6000 6000 6000
IT 204500 213500 218500
Marketing 328000 283000 322000
Legal/Accounting 62800 68000 68000
Miscellaneous 6800 7000 7000
Sales tax 125000 90000 125000
Bank charges 4000 4000 4000
Travel expenses 80000 100000 150000
Aged accounts payable 40000 45000 55000
Total Operating
Expenses
1391100 1368500 1538500
Net Profit 1308900 931500 1601500
The profit and loss statement shows that the project will have the good amount of profit
by the 3rd year which is around 1601500 AED after deducting all expenses.
7

2.1.2.1 Staffing level and required competencies for each position
Staffing is a function for employee recruitment, screening and selection of candidate in
order to fill the vacant job position. The different staffing level in entertainment media and
competencies for each position is discussed below:
Top Level Management
Director
Chief Executive Officer
Chief Financial Officer
Middle Level Management
Content Analyst
News Anchor
Lower Level Management
Cameraman
Cinematographer
Post Competencies
Director: Directors have many responsibilities which are
linked to keeping business running smoothly. It
is observed that director require specific skills
like multitasking, logical and critical thinking
and handle networking within media company.
Entertainment media task director have
formulated an aim to achieve 500 million
views for their T.V show at the end of second
year. Their main duty involve everything such
as crafting components of a campaign,
launching the campaign and measure the
outcome of campaign's.
Chief Executive Officer: The CEO necessarily must be conflict solver so
that any type of internal and external fight can
8

be handled effectively. The also help director
in making effective plan and strategies so that
T.V program are managed well. They also
make sure that business objective i.e to achieve
500 million view can be accomplish in time.
Chief Financial Officer: Important decision related to finance and
utilisation of funds are taken by CFO of
company. Chief financial officer of
entertainment media project needs to allocate
the available fund in adequate manner so that
maximum return can be gain from investment.
They must have professional skills such as
strategic vision, corporate financial
competencies and strong work ethic. That will
support in attaining the overall objective of
company.
Content Analyst: They plays an important part in media industry
as proper and strong analyst help to make
decision either to launch T.V Show or not. This
help in achieving predetermined goals and set
target for company. Basic knowledge and skills
required by Content analyst are proper
knowledge of content and decision making
skill. They make sure that content of program
are accurate or not that help to achieve number
of viewers.
News Anchor: News anchor should be able to develop story
ideas and report stories on TV so that goals of
high views can be achieved. The main skills
required by competencies required by new
9

anchor are energetic reporter, effective
communication skills and interviewing so that
they may connect to viewer. This help in
increasing number of people so that goal of
500 million view can be achieved.
Cameraman: Cameraman plays an important role in media
as they can focus to find the best angle to cover
the report and news and present in best ways.
This will attract number of viewer as people
are always attracted towards new and
innovative thing.
Cinematographer: Cinematographer is a very important job role
in entertainment media as they add some
special effects so that an effective content can
be presented. It requires digital camera,
computer skills and artistic skills to perform
their job.
2.1.2.2 Required equipment, tools and systems
There are various tools and equipment which are required in an entertainment media
project and these are discussed below:
Notebook:
The notebook should have with every media person in order to note down the things so
later on they can present in digital format.
Digital recorder (Audio / Video):
This is the most important tool for media person as to cover the latest news whether in
audio form or video form. The recorder would be used to record the footage of people who
would be sharing their life experience in the Arabic capital cities on show.
Digital Camera:
10