Key Takeaways
- A mudra loan project report format in excel is a linked financial model – one workbook with multiple sheets for assumptions, project cost, means of finance, sales, expenses, working capital, depreciation, loan repayment, and full financial statements connected through formulas.
- Under Pradhan Mantri Mudra Yojana, which has three categories – Shishu (up to โน50,000), Kishor (โน50,001 to โน5 lakh), and Tarun (โน5 lakh to โน10 lakh) – a project report is mandatory for Kishor and Tarun loans, and CMA data is required for these categories.
- The modelling principle “Input once โ use everywhere” means keeping all financial assumptions in one sheet and linking them via formulas, so changes in sales, interest rate, or loan amount instantly update profit, cash flow, and repayment capacity.
- A well-prepared project report clarifies business objectives and includes a 5-year financial projection with realistic, evidence-based numbers – because banks prefer conservative estimates over inflated sales figures.
- The Debt Service Coverage Ratio measures the business’s ability to cover loan repayments; a healthy DSCR average for a micro-enterprise should ideally remain above 1.5 to 2.0.
What Is a Mudra Loan Project Report Format in Excel?
A mudra loan project report excel format means the financial portion of the project report built as a Microsoft Excel workbook with live formulas – not a static pdf. It includes assumptions, calculation sheets, projected financial statements (profit and loss, balance sheet, cash flow), financial ratios and DSCR, and a loan repayment schedule.
Excel format is preferred for its clarity in financials because banks can change key assumptions – say interest from 11% to 12.25% – and instantly see updated projections. There is no single mandatory official excel sheet format prescribed for all lenders; banks may accept different layouts as long as the logic is sound.
If you need the basic concept first, read What Is a Mudra Loan Project Report? Complete Beginner Guide before continuing.
Excel Project Report vs General Project Report Format
A general mudra loan project report includes promoter details, business overview, market information, project cost, means of finance, and financial projections summary. The excel workbook is the engine that generates detailed projections, supporting schedules, and key ratios which are then referenced into the main document.
For the broader project report format explanation, see the Mudra Loan Project Report Format: Complete Guide.
Recommended Excel Workbook Structure for a Mudra Loan Project Report
A well-organized excel project report typically contains 6 to 10 separate sheets. Below is a practical structure used by many Chartered Accountants. The project report format includes financial projections and CMA data across these sheets:
| Sheet | Purpose |
|---|---|
| Basic Information | Business and promoter details |
| Assumptions | Core operating variables affecting projections |
| Project Cost | Fixed assets and working capital needs |
| Means of Finance | Promoter’s contribution and bank loan amount |
| Sales Projection | Year-wise estimated revenue |
| Expense Projection | Operating costs by category |
| Working Capital | Inventory, debtors, creditors calculation |
| Depreciation | Asset-wise annual depreciation |
| Loan Repayment | Principal, interest, and closing balance schedule |
| Projected P&L | Multi-year profitability |
| Cash Flow | Cash movement including loan inflow and repayment |
| Projected Balance Sheet | Financial position each year |
| DSCR & Ratios | Debt servicing capacity and key indicators |
| Break-Even Analysis | Minimum sales to cover total costs |
For Shishu loans, a shortened version may suffice. Kishor and Tarun loans generally justify the full structure since a project report is required for Kishor and Tarun loans.
Sheet 1: Basic Business and Project Information
This sheet gathers non-numeric details – applicant name, business name, constitution, location, nature of activity, whether new business or existing, Mudra category, and loan amount requested. It uses simple labelled rows and input cells. Supporting documents are crucial for validating the claims in the project report.
For the complete input checklist, see Information Required for a Mudra Loan Project Report.
Sheet 2: Financial Assumptions
The assumptions sheet summarizes key operating variables affecting financial projections – capacity utilisation, selling price, growth rates, raw material cost percentages, salary details, rent, interest rate, loan tenure, depreciation rates, debtor days, inventory holding days, and creditor days.
Using simple formulas in an excel workbook enhances transparency and accuracy in calculations. The principle: input once, link everywhere. Selling price feeds Sales Projection, interest rate feeds the Repayment schedule, capacity utilisation feeds both Sales and Working Capital sheets.
Sheet 3: Project Cost
The project cost section must separately specify fixed assets and working capital needs. Common items include machinery, equipment, furniture, computers, pre-operative expenses, deposits, and preliminary working capital.
Illustrative Example – Project Cost:
| Item | Amount (โน) |
|---|---|
| Furniture & Fixtures | 2,50,000 |
| Computer & Printer | 50,000 |
| Initial Stock | 2,00,000 |
| Deposit | 50,000 |
| Initial Cash/Expenses | 50,000 |
| Total Project Cost | 6,00,000 |
All major cost components should be defendable – attaching supplier quotations for machinery strengthens credibility during bank appraisal.
Sheet 4: Means of Finance
The means of finance section shows the promoter’s contribution and the bank loan amount. Total sources must match total project cost exactly.
| Source | Amount (โน) |
|---|---|
| Promoter Contribution | 2,00,000 |
| Mudra Term Loan | 4,00,000 |
| Total Means of Finance | 6,00,000 |
Collateral is not required under the Mudra loan scheme, but banks prefer seeing meaningful own contribution. This sheet links directly to the Repayment schedule and Projected Balance Sheet.
Sheet 5: Sales Projection
An effective project report requires clear sales assumptions. For manufacturing: production ร capacity utilisation ร selling price. For trading: quantity ร average selling price. For services: customers ร average billing.
Financial projections must be realistic and achievable. Sudden jumps – turnover tripling without justification – are common red flags. Mudra financing covers micro enterprises in manufacturing, trading, and services, so tailor the projection to your specific activity.
Sheet 6: Operating Expense Projection
After sales, project expenses: cost of goods sold, salary and wages, rent, power and fuel, transportation, marketing, repairs, insurance, and miscellaneous costs. Organise into variable (linked to sales) and fixed categories. Totals feed directly into the Projected Profit and Loss account.
Sheet 7: Working Capital Calculation for Mudra Loan
Working capital means funds for day-to-day operations. The sheet calculates inventory, receivables, cash (current assets) and creditors, short-term payables (current liabilities). Each item uses the formula: base figure ร holding days รท 365. Working capital assessment is essential because it determines how much operational funding the business needs beyond fixed assets.
Sheet 8: Depreciation Schedule
Depreciation affects both projected profit (as an expense) and closing asset value in the balance sheet. Structure columns for asset category, opening value, additions, applicable rate, annual depreciation, and closing written-down value. The P&L should reference this schedule via formulas rather than hard-entering depreciation directly.
Sheet 9: Mudra Loan Repayment Schedule in Excel
The repayment schedule outlines how monthly or yearly loan installments will be paid back. Include columns for period, opening balance, principal, interest (calculated on reducing balance), total instalment, and closing balance. For a โน4,00,000 Kishor loan at 11% for 5 years, Excel’s PMT function computes the EMI. Annual interest feeds the P&L; principal repayment feeds cash flow; closing balance feeds the balance sheet.
Sheet 10: Projected Profit and Loss Account
Projected profit and loss statements forecast revenues, costs, and net profits over multiple years. Structure: Sales โ less Direct Costs โ Gross Profit โ less Operating Expenses โ EBITDA โ less Depreciation โ EBIT โ less Interest โ PBT โ less Tax โ PAT. Nearly every line should link to supporting sheets.
Sheet 11: Projected Cash Flow Statement
Cash flow statements track money inflows and outflows to ensure business liquidity. A project can show profit on paper but face cash shortages due to inventory build-up and loan repayments. Structure: cash from operations, investing activities, and financing activities, leading to closing cash balance. Include a repayment plan in your project report so cash outflows for debt servicing are clearly visible.
Sheet 12: Projected Balance Sheet
Assets (fixed assets net of depreciation, current assets, deposits) must equal Liabilities plus Equity (promoter capital plus retained earnings, term loan closing balance, creditors). If the balance sheet doesn’t balance, it typically signals linking errors in the excel model.
Sheet 13: DSCR & Key Ratios
DSCR = (PAT + Depreciation + Interest) รท (Principal + Interest). According to MudraReady, roughly 45% of Mudra Loan applications face rejection due to DSCR falling below 1.25. Realistic financial projections increase loan approval chances by demonstrating strong debt servicing capacity.
Sheet 14: Break-Even Analysis
Break-even analysis calculates the sales level required to cover total costs without profit. Fixed Costs รท Contribution per Unit = Break-even Quantity. If projected sales significantly exceed break-even, it strengthens the case. This sheet should be driven by assumptions already used elsewhere in the model.
How the Excel Sheets Should Be Linked Together
The logical flow: Assumptions โ Sales & Expenses โ P&L โ Working Capital/Depreciation/Repayment โ Cash Flow โ Balance Sheet โ DSCR. If machinery cost increases, depreciation rises, interest may change, and DSCR reduces – all automatically. Use simple, transparent formulas that both entrepreneurs and branch-level bankers can follow.
Excel Formula and Modelling Practices to Follow
Maintain a dedicated assumptions sheet. Visually differentiate input cells from formula cells. Keep financial years consistent. Use SUM, PMT, and basic references. Verify that the loan balance reaches zero at tenure end and accumulated depreciation never exceeds original cost. Avoid complex macros for basic mudra loan projections.
Common Mistakes in Mudra Loan Project Report Excel Sheets
Common mistakes include: sales entered independently across multiple sheets, loan repayment not tied to the correct loan amount, interest not matching outstanding balance, depreciation inconsistent with asset values, project cost not equalling means of finance, balance sheet not balancing, unrealistic sales growth, ignoring negative cash balances, and DSCR computed using inconsistent figures. Copying another business’s excel model without adjusting assumptions is easily spotted by trained bankers.
Does the Mudra Loan Amount Affect the Level of Excel Detail?
Yes. Shishu loans may need only a simple P&L estimate. Kishor and Tarun proposals justify multi-year projections, detailed repayment schedule, working capital computation, and DSCR. The Pradhan Mantri MUDRA Yojana has four categories: Shishu, Kishor, Tarun, and Tarun Plus. For more on documentation requirements by loan amount, see the dedicated guide.
When Does a Bank Ask for These Financial Projections?
Banks commonly expect excel-based projections for a new business without financial history, expansion proposals, longer tenure loans, and cases where repayment capacity isn’t visible from existing income proof. Requirements vary between public sector banks, private banks, and individual branches. For detailed discussion, see When Does a Bank Ask for a Project Report for Mudra Loan?
Can You Prepare the Mudra Loan Excel Project Report Yourself?
An entrepreneur comfortable with basic accounting and excel can prepare project report calculations for simpler businesses. However, linking errors between sheets can cause totals not to match. Many borrowers work with a professional to set up the initial model, then update assumptions themselves. For guidance, see Can You Prepare Your Own Project Report for Mudra Loan?
Can a Mudra Loan Project Report Be Prepared Online?
Yes. Financial calculations are done in excel or similar software, but inputs can be collected online and the final report delivered digitally. Even when generated online, the model follows the same sheet structure described here. Digital preparation makes it easier to edit and re-export when the bank asks for changes.
Does a Professional Excel Project Report Guarantee Mudra Loan Approval?
No. Sanction remains subject to the lender’s credit appraisal – including CIBIL score, existing indebtedness, business experience, and eligibility norms. A well-prepared project report improves clarity and speeds up appraisal, but misrepresenting projections can backfire. See Does a Project Report Guarantee Mudra Loan Approval?
Excel Project Report vs Business Plan
An excel-based mudra loan project report is primarily a financial model for bank appraisal. A business plan is broader – covering strategy, marketing, SWOT analysis, and long-term vision. A mudra loan project report helps secure funding by detailing the business plan’s financial side. A standard project report includes business details and repayment schedule alongside the financial model.
Illustrative Example: Connecting Project Cost, Loan, Profit and DSCR
These figures are purely illustrative.
A mobile accessories shop in Jaipur: โน6,00,000 project cost, โน2,00,000 promoter contribution, โน4,00,000 Mudra Kishor loan at 11% for 5 years.
| Item | Year 1 (โน) |
|---|---|
| Sales | 12,00,000 |
| Total Expenses (incl. purchases) | 10,50,000 |
| Depreciation | 37,500 |
| Interest | 42,000 |
| Profit Before Tax | 70,500 |
| PAT (approx.) | 70,500 |
| Cash Accrual (PAT + Depreciation + Interest) | 1,50,000 |
| Total Debt Service (Principal + Interest) | 1,07,000 |
| DSCR | 1.40 |
The closing loan balance after Year 1 falls to approximately โน3,35,000, feeding directly into the balance sheet.
Practical Review Checklist Before Finalizing the Excel File
- Total project cost equals total means of finance
- Loan balance reaches zero at tenure end
- Annual interest in P&L matches the repayment schedule
- Depreciation in P&L equals the depreciation schedule total
- Balance sheet balances every year
- No year shows unexplained negative cash
- Sales growth and margins are industry-realistic
- DSCR uses consistent figures throughout
- No #REF! or #DIV/0! errors exist
- No accidental hard-coded numbers where links should exist
Expert’s View: CA Manish Gugliya on Mudra Loan Excel Models
When I prepare a mudra loan project report in excel, I start with assumptions, build cost and finance tables, integrate repayment and depreciation, and finally generate P&L, cash flow, balance sheet and DSCR as outputs.
“When I review a project report, I do not look only at projected profit. I check whether sales assumptions, expenses, working capital, loan repayment, cash flow and the balance sheet tell the same financial story. If numbers pull in different directions, bankers will notice it quickly.”
A good model is logically connected, internally consistent, and aligned with how the business will actually operate – not over-engineered with unnecessary complexity.
Frequently Asked Questions
How many years of financial projections should I prepare in Excel for a Mudra Loan?
Most practitioners prepare 3 to 5 years. A project report includes a 5-year financial projection for Kishor and Tarun loans. The projection period should at least match the loan tenure so the bank can assess repayment capacity across the full period. Align years with Indian financial years (e.g., FY 2026โ27).
Is cash flow mandatory in a Mudra Loan project report Excel sheet?
While some lenders may accept only P&L and balance sheet for very small loans, cash flow is strongly recommended. It shows whether enough cash exists to cover instalments and detects years with negative cash. Since excel makes it straightforward using data already available from P&L and repayment sheets, there is little reason to omit it.
Do I need separate Excel formats for Shishu, Kishor and Tarun Mudra loans?
The fundamental structure remains similar. Mudra loans have three categories: Shishu, Kishor, and Tarun. What changes is scale and detail. Shishu may need a simplified workbook; Kishor and Tarun justify fuller sheets including working capital and DSCR.
Does a Chartered Accountant have to certify the Mudra Loan Excel project report?
No regulation mandates CA certification for every mudra project report. Banks may accept borrower-prepared projections for smaller loans. Some lenders prefer CA-certified projections for higher amounts. Check with your specific branch. For more, see Who Can Prepare a Project Report for Mudra Loan?
Can I reuse the same Excel format for different banks?
Yes – the same core format works across lenders since Mudra loans are governed by the same PMMY framework. Before submitting to another bank, update the loan amount, interest rate, tenure, and any changed cost assumptions. Each submission should reflect the specific bank’s terms rather than being a verbatim copy.
Final Conclusion
A strong mudra loan project report format in excel works as an integrated financial model: Assumptions โ Calculations โ Financial Statements โ Repayment Analysis โ DSCR. Ensure project cost equals means of finance, the balance sheet balances every year, and DSCR is computed consistently.
Banks lending under Pradhan Mantri Mudra Yojana value realistic, internally consistent projections more than flashy formatting. Entrepreneurs who invest time understanding how their excel model is structured are better prepared to answer bank queries – and to manage their own business finances after the loan is sanctioned.