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

This query is : Resolved

Mukesh Rathore (Querist)
Follow

03 March 2017 Dear All,

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

Thanks

Asha Kanta Sharma

Asha Kanta Sharma

(Expert)
Follow

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.