Financial & Project Execution Plan for a Media Project Analysis

This document presents a comprehensive financial and project execution plan for a media project, designed to secure investment and achieve 500 million views within two years. It begins with a detailed budget estimation, including initial, fixed, and variable costs, followed by financial projections spanning three years, encompassing cash flow and profit and loss statements. The plan outlines staffing levels, required competencies for each role, and necessary equipment and systems. A project execution plan is included, detailing a work breakdown structure, inputs and outputs, internal and external processes, key deliverables, and key performance indicators (KPIs), visualized with a Gantt chart. The project aims to develop a TV program showcasing life experiences in Arabic capital cities, with marketing strategies involving television, social media, and print. The plan emphasizes resource allocation, strategy, and efficient fund utilization to achieve the project's objectives. The document concludes with a reference list supporting the proposed strategies.

Developing a Financial &
Project Execution Plan for
a Media Project

Table of Content
• Introduction
• Budget estimation
• Financial projection for next three years
• Staffing level and required competencies
• Required equipment, tools and systems
• Project execution plan
• WBS
• Inputs and outputs
• Internal and External process
• Key Deliverables and KPI
• Gantt Chart
• Conclusion
• References

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 a media
project. 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.

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. The Estimated budget for the TV public programme is
determined as:

Continue
Particular Year 1 (Amt in AED) Year 2 (Amt in AED) Year 3 (Amt in AED)
Initial Investment 3000000 1999000 1039000
Start Up Cost :
Incorporation expenses 50000 - -
Other 190000 - -
Fixed cost :
Mic 150000 150000 150000
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

Financial projection for next
three years
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.

Cash flow
Opening Cash Balance 3000000 4396400 5434900
CASH IN -
Cash From Sales 2500000 1800000 2500000
Cash From Out-Licensing of
Intellectual Property - - -
Loans or Other Financial Vehicles - - -
Tax Rebates (e.g. SR&ED) - - -
Taxes Collected from Sales - - -
Revenues from Advertisement 700000 750000 790000
Interest From Bank - - -
TOTAL CASH IN 6200000 6946400 8724900
(Amt in AED)

Continue
Facilities 90000 95000 110000
Office: Rent 15000 15000 15000
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

Continue
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

Profit and loss account
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

Staffing level and required
competencies
Staffing is a function for employee recruitment, screening and selection of
candidate in order to fill the vacant job position. The competencies refer to
the skill set which required for an individual to perform their jobs according
to designation. The different staffing level 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

Continue
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 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.