Create Project report in 10 mins by following the 3 steps.
Project report for Advertising agency is as follows.
As advertising has moved on from television and newspaper columns to the web and social media, the digital wave has had its share of patrons and critics. However, for out-of-home advertising solutions, these digital trends have ushered in a new set of tools that help companies offer more personalised products to customers.Irrespective of differences between markets, clientele, or age-groups, most OOH solutions earlier featured a one-size-fits-all solution. Cut to the present, outdoor advertising calls for a more targeted, data-driven, responsive, and personalised approach. Advertising expenditure in the outdoor media market, such as billboards and transit advertising, is set to soar this year, clocking 15 per cent growth year on year. Since it cannot be skipped by consumers or blocked in outdoor environments, the out-of-home (OOH) medium has remained the core channel to reach mass urban audiences. Mobile Van advertising is carried out by fixing an illuminated billboard, displaying the advertisement on a truck which moves around the city and can be parked at targeted places. An extremely effective mode of advertising due to mobility, illumination and the ability to conveniently shift the locations as per the client's requirement.
The growth of the advertising industry is highly dependent on the penetration of various media platforms. India, with its developing economy, provides numerous opportunities to advertisers to promote their products and services through the expanding media channels in the region. The economic growth has also led to an increase in the spending power of a significant portion of the population, creating an affluent brand conscious consumer-base. Over the next few years, the Indian advertising market is projected to be the fastest-growing advertising market in Asia, after China. This growth can be attributed to a number of favourable factors. One of the primary factors is the rapid penetration of smartphones and internet in the country which facilitates the use of digital advertising. Increasing population and favourable government regulations are some of the other growth driving factors. According to the report, the market is further expected to reach a value of INR 1102 Billion by 2023.
he proposed solution is a Van based advertisement , where the moving van will have large advertisements in its two side . The Advertisement can be anything like a video, a still image a music accompanied image etc. This form of advertisement attracts the attention of the user and as it iis moving it can cover a large area of customer base which would be beneficial to the advertiers. The growth of the advertising industry is highly dependent on the penetration of various media platforms. India, with its developing economy, provides numerous opportunities to advertisers to promote their products and services through the expanding media channels in the region. The economic growth has also led to an increase in the spending power of a significant portion of the population, creating an affluent brand conscious consumer-base.
The Indian advertising industry is expected to touch Rs 776 billion, driven by smartphone penetration and subsequent spends on digital advertising, according to an industry report.The advertising industry is currently estimated to be Rs 559 billion and expected to grow at a compound annual growth rate (CAGR) of 32 per cent to reach Rs 189 billion by 2020,The growth of the advertising industry is highly dependent on the penetration of various media platforms. India, with its developing economy, provides numerous opportunities to advertisers to promote their products and services through the expanding media channels in the region. The economic growth has also led to an increase in the spending power of a significant portion of the population, creating an affluent brand conscious consumer-base. Over the next few years, the Indian advertising market is projected to be the fastest-growing advertising market in Asia, after China. This growth can be attributed to a number of favourable factors. One of the primary factors is the rapid penetration of smartphones and internet in the country which facilitates the use of digital advertising. Increasing population and favourable government regulations are some of the other growth driving factors.
Ad agency
Address
: | [email protected] | |
Phone | : | 000000 |
Constitution | : | Proprietership |
Total project cost | : | ******* |
Fixed Capital | : | ******* |
Working Capital | : | ******* |
Total Bank loan | : | ******* |
Promoter(s) contribution | : | ******* |
Term loan | : | ******* |
Working capital loan | : | ******* |
|
Debt Service Coverage Ratio (Average) | :1.87 |
Current ratio (Average) | :2.63 |
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
---|---|---|---|---|---|
Current ratio | 1.53 | 2.06 | 2.62 | 3.19 | 3.76 |
Quick ratio | 1.13 | 1.56 | 2.10 | 2.64 | 3.18 |
Interest coverage ratio | 3.87 | 5.55 | 7.00 | 9.48 | 14.71 |
Debt equity ratio | 2.863 | 2.080 | 1.528 | 1.020 | 0.542 |
TOL/TNW | 3.02 | 1.45 | 0.79 | 0.43 | 0.21 |
DSCR | 1.65 | 1.86 | 1.90 | 1.94 | 1.97 |
Gross profit Sales Percentage % | 29.23 % | 28.54 % | 28.18 % | 27.86 % | 27.50 % |
Net profit Sales Percentage % | 10.84 % | 10.56 % | 11.10 % | 11.57 % | 11.90 % |
BEP in % of installed capacity % | 49.90 % | 27.12 % | 27.12 % | 27.12 % | 27.12 % |
BEP in sales of Rs | 2,620,800.00 | 1,840,695.65 | 1,972,173.91 | 2,103,652.17 | 2,235,130.43 |
Return On Capital Employed | 0.26 | 0.34 | 0.34 | 0.33 | 0.33 |
Sl. no | Item | Amount Rs |
---|---|---|
1 | Office advance | ******* |
2 | Application design | ******* |
3 | Website designing | ******* |
4 | Software | ******* |
5 | Laptop | ******* |
6 | Priliminary exxpense | ******* |
7 | Working Capital | ******* |
Total | ******* |
Sl. no | Item | Amount Rs |
---|---|---|
1 | Consumables / stock in hand | ******* |
2 | Work in progress | ******* |
3 | Finished goods | ******* |
4 | Working expense. | ******* |
5 | Receivables/Sundry debtors | ******* |
6 | Payables | ******* |
7 | Total working capital | ******* |
8 | Own Contribution | ******* |
9 | Working capital loan | ******* |
Sl. no | Item | Rate | Quantity | Unit | Total Rs | |
---|---|---|---|---|---|---|
1 | Revenue from Ad display | ******* | X | 312 | Day | ******* |
Total | ******* |
Sl. no | Item | Amount Rs |
---|---|---|
1 | Rent | ******* |
2 | Manager | ******* |
3 | sales person | ******* |
4 | Electricity | ******* |
5 | Office expense & utilities | ******* |
6 | Stationary | ******* |
7 | Postage & Telephone | ******* |
8 | Marketing/Advertisement | ******* |
Total | ******* |
Sl. no | Item | Subsidy % | No. | Rate | Amount Rs |
---|---|---|---|---|---|
1 | Office advance | ******* | 1 | ******* | ******* |
2 | Application design | ******* | 1 | ******* | ******* |
3 | Website designing | ******* | 1 | ******* | ******* |
4 | Software | ******* | 1 | ******* | ******* |
5 | Laptop | ******* | 2 | ******* | ******* |
6 | Priliminary exxpense | ******* | 1 | ******* | ******* |
Total Investment | ******* | ||||
Total Subsidy | ******* | ||||
Net Investment | ******* |
Sl. no | Item | Amount |
---|---|---|
1 | Term Loan | ******* |
2 | Working capital Loan | ******* |
3 | Total loan | ******* |
4 | Term Loan contribution | ******* |
5 | Working capital contribution | ******* |
Year 1(!*) | Year 2 | Year 3 | Year 4 | Year 5 | |
---|---|---|---|---|---|
Revenue from operation | |||||
Sales | ***** | ***** | ***** | ***** | ***** |
Add : | |||||
Closing stock | ***** | ***** | ***** | ***** | ***** |
Total | ***** | ***** | ***** | ***** | ***** |
Less : | |||||
Opening stock | ***** | ***** | ***** | ***** | ***** |
Stock purchase | ***** | ***** | ***** | ***** | ***** |
Salary | ***** | ***** | ***** | ***** | ***** |
Repairs and maintenance charges | ***** | ***** | ***** | ***** | ***** |
gas | ***** | ***** | ***** | ***** | ***** |
ELECTRICITY bill | ***** | ***** | ***** | ***** | ***** |
Total | ***** | ***** | ***** | ***** | ***** |
Gross profit | ***** | ***** | ***** | ***** | ***** |
Less : | |||||
Rent | ***** | ***** | ***** | ***** | ***** |
Telephone/Postal &internet charge | ***** | ***** | ***** | ***** | ***** |
Total | ***** | 0***** | ***** | ***** | ***** |
Depreciation | ***** | ***** | ***** | ***** | ***** |
Interest on TL | ***** | ***** | ***** | ***** | ***** |
Interest on WC | ***** | ***** | ***** | ***** | ***** |
Total | ***** | ***** | ***** | ***** | ***** |
Profit before tax | ***** | ***** | ***** | ***** | ***** |
Income Tax | ***** | ***** | ***** | ***** | ***** |
Profit after tax | ***** | ***** | ***** | ***** | ***** |
Cash Inflow | Pre operative period | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
---|---|---|---|---|---|---|
Capital | 0.63 | ***** | ***** | ***** | ***** | ***** |
Subsidy | ***** | ***** | ***** | ***** | ***** | ***** |
Termloan | ***** | ***** | ***** | ***** | ***** | ***** |
Profit before tax with interest | ***** | ***** | ***** | ***** | ***** | ***** |
Increase in WC loan | ***** | ***** | ***** | ***** | ***** | ***** |
Depreciation | ***** | ***** | ***** | ***** | ***** | ***** |
Increase in Current liability | ***** | ***** | ***** | ***** | ***** | ***** |
Total Cash Inflow | ***** | ***** | ***** | ***** | ***** | ***** |
Cash Outflow | ||||||
Fixed Assets | ***** | ***** | ***** | ***** | ***** | ***** |
Increase in Current asset | ***** | ***** | ***** | ***** | ***** | |
Interest on TL | ***** | ***** | ***** | ***** | ***** | ***** |
Interest on WC | ***** | ***** | ***** | ***** | ***** | ***** |
Income Tax | ***** | ***** | ***** | ***** | ***** | ***** |
Decrease in Term loan | ***** | ***** | ***** | ***** | ***** | |
Drawing | ***** | ***** | ***** | ***** | ***** | ***** |
Total Cash Outflow | ***** | ***** | ***** | ***** | ***** | ***** |
Opening balance | ***** | ***** | ***** | ***** | ***** | ***** |
Net Cashflow | ***** | ***** | ***** | ***** | ***** | ***** |
Closing balance | ***** | ***** | ***** | ***** | ***** | ***** |
Liability | Pre operative period | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
---|---|---|---|---|---|---|
A. Share holders funds | ||||||
Capital | ***** | ***** | ***** | ***** | ***** | ***** |
Reserve & Surplus | ***** | ***** | ***** | ***** | ***** | ***** |
B.Non current Liabilities | ||||||
Termloan | ***** | ***** | ***** | ***** | ***** | ***** |
C.Current Liabilities | ||||||
Working capital loan | ***** | ***** | ***** | ***** | ***** | ***** |
Account payable | ***** | ***** | ***** | ***** | ***** | |
Total Liability | ***** | ***** | ***** | ***** | ***** | ***** |
Asset | ||||||
A. Non current Assets | ||||||
Fixed Assets | ***** | ***** | ***** | ***** | ***** | ***** |
B. Current Assets | ||||||
Inventory | ***** | ***** | ***** | ***** | ***** | ***** |
Trade receivables | ***** | ***** | ***** | ***** | ***** | ***** |
Cash and cash equivalence | ***** | ***** | ***** | ***** | ***** | ***** |
Total Asset | ***** | ***** | ***** | ***** | ***** | ***** |
Year | Installment | Outstanding at the beginning | Principal repayment | Interest | Amount paid | Outstanding at the end |
---|---|---|---|---|---|---|
1 | 1 | ***** | ***** | ***** | ***** | ***** |
1 | 2 | ***** | ***** | ***** | ***** | ***** |
1 | 3 | ***** | ***** | ***** | ***** | ***** |
1 | 4 | ***** | ***** | ***** | ***** | ***** |
1 | 5 | ***** | ***** | ***** | ***** | ***** |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
5 | 56 | ***** | ***** | ***** | ***** | ***** |
5 | 57 | ***** | ***** | ***** | ***** | ***** |
5 | 58 | ***** | ***** | ***** | ***** | ***** |
5 | 59 | ***** | ***** | ***** | ***** | ***** |
5 | 60 | ***** | ***** | ***** | ***** | ***** |
Particulars | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
---|---|---|---|---|---|
Receipts | |||||
a).Net Profit | ***** | ***** | ***** | ***** | ***** |
b).Depreciation | ***** | ***** | ***** | ***** | 0.30 |
c).Interest on termloan | ***** | ***** | ***** | ***** | ***** |
Total | ***** | ***** | ***** | ***** | ***** |
Repayments | |||||
a).Loan Principal | ***** | ***** | ***** | ***** | ***** |
b).Interest on termloan | ***** | ***** | ***** | ***** | ***** |
Total | ***** | ***** | ***** | ***** | ***** |
DSCR | ***** | ***** | ***** | ***** | ***** |
Particulars | Rate | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
---|---|---|---|---|---|---|
Building | ***** | ***** | ***** | ***** | ***** | ***** |
Less Depreciation | ***** | ***** | ***** | ***** | ***** | |
Written down value | ***** | ***** | ***** | ***** | ***** | |
Computers/ Printers /Photocopier/Electronic gadget | 00 | ***** | ***** | ***** | ***** | ***** |
Less Depreciation | ***** | ***** | ***** | ***** | ***** | |
Written down value | ***** | ***** | ***** | ***** | ***** | |
Furniture & fixtures | 00 | ***** | ***** | ***** | ***** | ***** |
Less Depreciation | ***** | ***** | ***** | ***** | ***** | |
Written down value | ***** | ***** | ***** | ***** | ***** | |
Racks & storage/Interior works | 00 | ***** | ***** | ***** | ***** | ***** |
Less Depreciation | ***** | ***** | ***** | ***** | ***** | |
Written down value | ***** | ***** | ***** | ***** | ***** | |
new item | 00 | ***** | ***** | ***** | ***** | ***** |
Less Depreciation | ***** | ***** | ***** | ***** | ***** | |
Written down value | ***** | ***** | ***** | ***** | ***** | |
new | 00 | ***** | ***** | ***** | ***** | ***** |
Less Depreciation | ***** | ***** | ***** | ***** | ***** | |
Written down value | ***** | ***** | ***** | ***** | ***** | |
Air-conditioning | 00 | ***** | ***** | ***** | ***** | ***** |
Less Depreciation | ***** | ***** | ***** | ***** | ***** | |
Written down value | ***** | ***** | ***** | ***** | ***** | |
Other investments | 00 | ***** | ***** | ***** | ***** | ***** |
Less Depreciation | ***** | ***** | ***** | ***** | ***** | |
Written down value | ***** | ***** | ***** | ***** | ***** | |
Total less depreciation | ***** | ***** | ***** | ***** | ***** | |
Total written down value | ***** | ***** | ***** | ***** | ***** |
The project as a whole describes the scope and viability of the Trading industry and mainly of the financial, technical and its market potential.The project guarantee sufficient fund to repay the loan and also give a good return on capital investment. When analyzing the social- economic impact, this project is able to generate an employment of 5 and above. It will cater the demand of Trading and thus helps the other business entities to increase the production and service which provide service and support to this industry. Thus more cyclic employment and livelihood generation. So in all ways, we can conclude the project is technically and socially viable and commercially sound too.
Get help from our experts. Drop us a Whatsapp message now
A good project report may contain the specific segments and in detailed format to gain confidence from the loan issuing authority
Check formatGet help from our experts. Drop us a Whatsapp message now! View video help