0% found this document useful (0 votes)
10 views29 pages

Project Budget and Pipeline Overview

The document outlines financial projections and budgets for various departments, detailing total project values and expected revenues from 2024 to 2029. It includes a breakdown of operating expenses, gross revenue, and net income, highlighting significant figures such as total projects in the pipeline and budget allocations for different sectors. Overall, it presents a comprehensive financial overview aimed at guiding future investments and operational planning.

Uploaded by

Farooq Ahmad
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
10 views29 pages

Project Budget and Pipeline Overview

The document outlines financial projections and budgets for various departments, detailing total project values and expected revenues from 2024 to 2029. It includes a breakdown of operating expenses, gross revenue, and net income, highlighting significant figures such as total projects in the pipeline and budget allocations for different sectors. Overall, it presents a comprehensive financial overview aimed at guiding future investments and operational planning.

Uploaded by

Farooq Ahmad
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Sr Dept Total

1 Business D 7,473.30 Char


2 GIS/RS-Sur 23,618.32
3 Software S 393.24
Business Dev GIS/RS
4 SWTL Lab 863.39
SWTL Lab Liaison
5 Liaison/Ou 69.75 1% 3%
6 Svy Institu 103.06
Total Project in Pipeli 32,521.06

73%
Comments
All prospective leads
Chart Title
3 x Completed,
AllDev
Business activeGIS/RS-Survey
prospects Software Svs
SWTLExpected
Lab in 2025
Liaison/Outreach Svy Institute
Starting in
1% 3% 20250% 0%
Starting in 2025

23%

73%
Sr Dept Projs
1 Business D 5
2 GIS/RS-Sur 12

3 Software S 10
4 SWTL Lab 1
5 Liaison/Ou 1
6 Svy Institu 1
Total Project in Pipeline
2024 2025 2026 2027 2028 2029 Total Comments
- - 3,034.33 3,034.33 702.33 702.33 7,473.30 All prospective leads
355.56 4,121.17 1,396.81 6,180.69 6,051.45 5,868.20 23,618.32 3 x Completed,
2 x In-progress,
7 x Active prospects
50 60 71.82 78.98 86.88 95.57 393.24 All active prospects
- - 155.5 232.25 235.43 240.22 863.39 Expected in 2025
- 0.3 14.96 16.46 18.11 19.92 69.75 Starting in 2025
- 17 18 20.56 22.62 24.88 103.06 Starting in 2025
405.56 4,198.47 4,691.42 9,563.27 7,116.82 6,951.12 32,521.06
omments
All prospective leads
3 x Completed,
2 x In-progress,
7 x Active prospects
All active prospects
Expected in 2025
Starting in 2025
Starting in 2025
Sr Budget He Total
1 GIS/RS-Sur 2,326
2 Software d 18
3 Soil Lab 400
4 BD 1,031
5 Agronomy 15
6 IT 384
7 Robotics 107
8 MEL 32
9 Finance 4
10 HR 2
11 Legal 1
12 Admin 95
13 Marketing 17
14 Call Centre 55
Total 4,489
Call Centre
Marketing
Admin
Legal
HR
Finance
MEL
Robotics
IT
Agronomy
BD
Soil Lab
Software dev
GIS/RS-Survey
0 500 1,000 1,500 2,000 2,500
2,500
Cost Centre Capex : 712
2,326
18
400
1,031

15
384
107
32
4
2
1
95
17
55
Taxes

Audit Fee

Depreciation expense

Software cost

Marketing expense

Entertainment

TADA

Printing & Stationery

Utilities

Payroll
0 200 400 600 800
Budget He Total
Payroll 1,367
Utilities 264
Utilities 132
Travel Cos 286
Printing & 11
R&M 138
TADA 165
Legal, Tax 86
Entertainm 22
Professiona 22
Marketing 170
Training a 7
Software c 282
Monitoring 75
Depreciati 63
00 600 800 1,000 1,200 Insurance
1,400 1,600 7
Audit Fee 22
Gen Exps/ 3
Taxes 88
3211
Profit and Loss 5 year R
Gross revenue
GIS/RS-Survey-Survey institute
Software Services
Business Development
Soil Lab-Portable
Cost of services-Direct Project cost
GIS/RS-Survey-Survey institute
Software Services
Agronomy-Outreach
Soil Labs
BD
Robotics
IT
Gross margin
Interest income
Total revenue
Operating expenses
Payroll
Rent
Utilities
Travel Cost POL
Printing & Stationery
Repair and maintenance/Renovation
TADA
Legal, Tax Compliance
Entertainment
Professional Fee/Certifications
Marketing expense
Training and dev
Software cost
Monitoring and evaluation
Depreciation expense
Insurance
Audit Fee
General Admin Expense/ Overheads
Taxes
Operating income

Interest expense on long-term debt

Operating income before other items

Loss (gain) on sale of assets


Other unusual expenses (income)

Earnings before taxes


Taxes on income (29%) 29%
Net income (loss) Rs. M
Net income (loss) Rs. Bln

Aspect

Net income (loss) Rs. M

Net income (loss) Rs. Bln


Total Capex Project and dept Rs. Bln (A)
Total Opex Expenses Rs. Bln (B)

Contingency and Reserve (10% OPEX CAPEX Food security an


Total Budget Ball Park Figure Rs. Bln (A+B

National Projects-Food security CAPEX (Rs. Bln) Carbon Credit


Edible Oil
Carbon Credit

National Projects-Food security Opex (Rs. Bln)


Edible Oil
Carbon Credit

International Donor/PPP Funding required (Rs. Bln)


Govt Funding National Projects required (Rs. Bln)

Total Budget in 5 years


Sr Budget Head 2024 2025 2026
1 GIS/RS-Survey 4 792 205
2 Software dev 3 3
3 Soil Lab 1.18 283 117
4 BD - 3 265
5 Agronomy - 15 -
6 IT 33 99 72
7 Robotics 1 14 20
8 MEL - 17 -
9 Finance - 4 -
10 HR - 2 -
11 Legal - 1 -
12 Admin 10 43 11
13 Marketing - 17 -
14 Call Centre 9 10
Total 49 1,303 703

2024 2025 2026 2027 2028 2029


- (13.75) (13.75) (13.75) (67.00) -
- - - - - -
- - - - - -
- (13.75) (13.75) (13.75) (55.00) -
- - (12.00) 4m per lab
- (4.00) - - (708.00) -
- - - - (700.00) -
- - - - - -
- - - - - -
- - - - -
- (4.00) - - (8.00) -
- - - - - -
(9.00) (9.00) (9.00) (9.00) - #VALUE!
0.00 -17.75 -13.75 -13.75 -775.00 0.00
- - - - -
0.00 -13.75 -13.75 -13.75 -67.00 0.00
0.00 -21.44 -21.44 -21.44 -171.52 0.00
0 - - - - -
0 - - - - -
0 - - - - -
0 (20.00) (20.00) (20.00) (80.00) -
0 (1.44) (1.44) (1.44) (5.76) -
0 - - - (85.76) -
0 - - - - -
0 - - - - -
0 - - - - -
0 - - - - -
0 - - - - -
0 - - - - -
0 - - - - -
0 - - - - -
0 - - - - -
0 - - - - -
0 - - - - -
0 - - - - -
0 - - - - -
0.00 -39.19 -35.19 -35.19 -946.52 0.00

0.00 -39.19 -35.19 -35.19 -946.52 0.00

0.00 0.00 0.00 1,000.00 0.00 0.00


0.00 0.00 0.00 0.00 0.00 0.00

0.00 -39.19 -35.19 964.81 -946.52 0.00


0.00 0.00 0.00 0.00 0.00 0.00
- (39.19) (35.19) 964.81 (946.52) -
- (0.04) (0.04) 0.96 (0.95) -

2024 2025 2026 2027 2028 2029

(61.58) 2,139.35 (396.90) 2,975.76 742.66 653.39

(0.06) 2.14 (0.40) 2.98 0.74 0.65


0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.02 0.02 0.02 0.17 0.00

APEX Food security and 7.20


re Rs. Bln (A+B 7.22

Carbon Credit 0.00 0.00 0.00 0.00

0.00 7.20 2.80 10.00 9,050.00

ed (Rs. Bln)
(Rs. Bln)
2027 2028 2029 Total
241 842 246 2,286
4 4 4 18
- - - 400
263 253 253 1,036
- - - 15
71 70 68 50
22 24 27 107
- - 15 32
- - - 4
- - - 2
- - - 1
12 13 15 95
- - - 17
11 12 13 55
624 1,218 `641 4,489

Total (Rs. M)
-
-
-
-
-
-
-
-
-
-
-
-
-
0.00
-
0.00
0.00
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
0.00

0.00

0.00
0.00

0.00
0.00
-
-

Total

5,519.37

5.52
0.00
0.00

0.00

9,070.00

4,535.00
4,535.00

4,535.00
Sr Budget He Total
1 Gross Reve 36,949.20
2 Cost of ser -21,536.74
3 Gross Marg 15,412.46
4 Total Reve 4,285.57
5 Operating 41,235
6 Earnings be -3,211.00
7 Tax on inc 16,487.46
8 Net Income -4,781.36
9 Net Income 11,706.10 Cost of servi

-30,000.00 -20,000.00
Net Income (Bn)

Net Income

Tax on income

Earnings before taxes

Operating expenses

Total Revenue

Gross Margins

Cost of services-Direct Project cost

Gross Revenue

-30,000.00 -20,000.00 -10,000.00 0.00 10,000.00 20,000.00 30,000.00 40,000.00 50,000.00


0,000.00 50,000.00
Sr Budget He Total
1 Gross Reve 36,949.20
2 Cost of ser -21,536.74
3 Gross Marg 15,412.46
4 Other incom 4236.4
5 Total Reve 41,185.60
6 Operating -3,211
7 Earnings be 16,438.29
8 Tax on inc -4,767.10
9 Net Income 11,671.10
10 Net Income 11.71
Net Income 11,671.10

-4,767.10
Tax on income

Earnings before taxes 16,438.29

Operating
-3,211
expenses

Total Revenue

Other income (Interest) 4236.4

Gross Margins 15,412.46

-21,536.74 Cost of services-Direct Project cost

Gross Revenue from Operations

-30,000.00 -20,000.00 -10,000.00 0.00 10,000.00 20,000.00 30,0


11,671.10

16,438.29

41,185.60

15,412.46

36,949.20

00 20,000.00 30,000.00 40,000.00 50,000.00


1 Gross Reve 36,949.20
2 Cost of ser -24,128.80
3 Gross Marg 12,820.40 Net Income
6 Operating -3,211
7 Earnings be 9,609.83 Tax
-2,786.85
on income
8 Tax on inc -2,786.85
Net IncomeNet Income 6,822.98 Earnings before taxes

Operating-3,211
expenses

Gross Margins

-24,128.80
Cost of services-Direct Project cost

Gross Revenue from Operations

-30,000.00 -20,000.00 -10,000.00 0.00


Net Income 6,822.98

Tax
-2,786.85
on income

Earnings before taxes 9,609.83

Operating-3,211
expenses

Gross Margins 12,820.40

ervices-Direct Project cost

s Revenue from Operations 36,949.20

000.00 -10,000.00 0.00 10,000.00 20,000.00 30,000.00 40,000.00 50,000.00

You might also like