(in excel) project report for pmegp scheme wid claim subsidy


This query is : Resolved 

03 March 2017 Dear All,

Kindly provide me sample format for Project report of PMEGP Scheme with claim subsidy in excel format




Thanks

14 July 2024 Creating a project report for the PMEGP (Prime Minister’s Employment Generation Programme) scheme with a claim for subsidy typically involves detailing the project's financial aspects, including costs, revenue projections, and the expected subsidy amount. Here’s a basic outline and a sample format for a project report in Excel format:

### Project Report Format for PMEGP Scheme with Claim for Subsidy

#### Project Details:
- **Project Name**: [Enter project name]
- **Project Location**: [Enter project location]
- **Entrepreneur Name**: [Enter entrepreneur’s name]
- **Date**: [Enter date of project report]

#### Executive Summary:
Brief overview of the project, its objectives, and expected outcomes.

#### Project Cost Details:
- **Land and Building**: [Cost incurred or estimated]
- **Plant and Machinery**: [Cost incurred or estimated]
- **Other Fixed Assets**: [Cost incurred or estimated]
- **Working Capital**: [Cost incurred or estimated]

#### Financial Projections:
- **Investment Costs**:
- Land and Building
- Plant and Machinery
- Other Fixed Assets
- Working Capital

- **Annual Revenue Projections**:
- Year 1, Year 2, Year 3, etc.

- **Operating Expenses**:
- Salaries and Wages
- Raw Materials
- Utilities
- Marketing and Sales
- Other Expenses

- **Profit and Loss Statement**:
- Gross Profit
- Operating Profit
- Net Profit

- **Cash Flow Statement**:
- Cash Inflows (Sales, Subsidy, etc.)
- Cash Outflows (Expenses, Investments, etc.)
- Net Cash Flow

- **Break-even Analysis**:
- Break-even Point

#### Subsidy Claim Details:
- **Eligible Subsidy Percentage**: [Percentage as per PMEGP guidelines]
- **Total Project Cost**: [Sum of all investment costs]
- **Subsidy Amount Claimed**: [Calculated subsidy amount]

#### Loan Details (if applicable):
- **Loan Amount**: [If any loan is taken, specify amount]
- **Interest Rate**: [Rate of interest]
- **Loan Repayment Schedule**: [Monthly/annual repayment schedule]

#### Declaration:
- **Declaration by Entrepreneur**: [Entrepreneur’s signature and date]

### Sample Excel Format:
Here’s a simplified example of how you can structure this information in an Excel spreadsheet:

| **Category** | **Details** |
|---------------------------|----------------------------------------|
| **Project Details** | |
| Project Name | [Enter project name] |
| Project Location | [Enter project location] |
| Entrepreneur Name | [Enter entrepreneur’s name] |
| Date | [Enter date] |
| **Cost Details** | |
| Land and Building | [Cost] |
| Plant and Machinery | [Cost] |
| Other Fixed Assets | [Cost] |
| Working Capital | [Cost] |
| **Financial Projections** | |
| Investment Costs | |
| Annual Revenue Projections| Year 1, Year 2, Year 3, etc. |
| Operating Expenses | Salaries, Raw Materials, Utilities, etc.|
| Profit and Loss Statement | Gross Profit, Operating Profit, Net Profit |
| Cash Flow Statement | Cash Inflows, Cash Outflows, Net Cash Flow |
| Break-even Analysis | Break-even Point |
| **Subsidy Claim Details** | |
| Eligible Subsidy Percentage | [Percentage] |
| Total Project Cost | [Sum of all costs] |
| Subsidy Amount Claimed | [Calculated subsidy amount] |
| **Loan Details** | |
| Loan Amount | [Amount] |
| Interest Rate | [Rate] |
| Loan Repayment Schedule | [Repayment schedule] |
| **Declaration** | |
| Declaration by Entrepreneur | [Signature and date] |

This format can be customized further based on specific requirements or additional details needed for your project report under the PMEGP scheme. Adjust columns and add more specific calculations or details as per your project's characteristics and the PMEGP guidelines.


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
19 November 2026
Accounts & Taxation Executive

MCSR and Associates LLP

Hyderabad

CA Inter

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
20 November 2026
Senior Accountant

Compass Tex India Pvt Ltd

Coimbatore

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details