Revenue & EBITDA — Monthly
Annual
Revenue
EBITDA
Margin Trends
%
Gross %
EBITDA %
PAT %
Period Summary
Top 5 Customers by Revenue
| Customer | Vertical | Revenue (Cr) | GM % | Status |
|---|---|---|---|---|
| TechCorp Global | BFSI | 52.4 | 34.2% | Healthy |
| FinServ India | BFSI | 41.8 | 28.6% | Healthy |
| RetailMax | Retail | 36.2 | 19.4% | Watch |
| ManuCo Ltd | Mfg | 28.7 | 22.8% | Healthy |
| GovProject A | Govt | 21.3 | 3.8% | Low Margin |
Budget vs Actuals — FY 25
| Head | Budget | Actual | Variance |
|---|---|---|---|
| Revenue | ₹270 Cr | ₹284.6 Cr | +5.4% |
| Employee Cost | ₹98 Cr | ₹88.4 Cr | +9.8% |
| S&M Expenses | ₹24 Cr | ₹22.1 Cr | +7.9% |
| Capex | ₹18 Cr | ₹15.6 Cr | +13.3% |
| EBITDA | ₹56 Cr | ₹35.2 Cr | -37.1% |
Operating Cash Flow
₹48.2 Cr
OCF/PAT = 1.86x
Investing Cash Flow
₹(17.5) Cr
Capex + FD investments
Financing Cash Flow
₹(18.6) Cr
Debt repayment + dividend
Statement of Cash Flows — Indirect Method IND AS 7Year ended 31 March 2025
| Particulars | FY 2024-25 (₹L) | FY 2023-24 (₹L) |
|---|---|---|
| A. Cash Flow from Operating Activities | ||
| Profit Before Tax | 3,396 | 2,316 |
| Adjustments for non-cash / non-operating items: | ||
| Add: Depreciation & Amortisation | 612 | 580 |
| Add: Finance Costs | 196 | 244 |
| Add: ESOP Charge (IND AS 102 — non-cash) | 248 | 192 |
| Add: ECL Provision movement | 32 | 24 |
| Add: Gratuity provision (IND AS 19) | 84 | 72 |
| Less: Interest income on FDs / MFs | (520) | (420) |
| Less: Profit on sale of investments | (82) | (48) |
| Operating Profit before working capital changes | 3,966 | 2,960 |
| Changes in working capital: | ||
| (Increase) in Trade Receivables | (360) | (480) |
| (Increase) in Inventories | (44) | (36) |
| (Increase) in Loans & Advances | (140) | (80) |
| Decrease in Other Current Assets | 64 | (120) |
| Increase in Trade Payables | 180 | 240 |
| Increase in Other Current Liabilities | 172 | 148 |
| Cash generated from operations | 3,838 | 2,632 |
| Income Tax paid (net of refunds) | (616) | (488) |
| Net Cash from Operating Activities (A) | 4,822 | 2,144 |
| B. Cash Flow from Investing Activities | ||
| Purchase of PPE, CWIP & Intangibles | (680) | (560) |
| Proceeds from disposal of PPE | 180 | 60 |
| Purchase / maturity of Fixed Deposits (net) | (980) | (1,200) |
| Purchase of Mutual Funds (net) | (420) | (320) |
| Investment in subsidiaries / associates | (420) | — |
| Interest received on FDs | 520 | 420 |
| Dividend received | 48 | 36 |
| Net Cash from Investing Activities (B) | (1,752) | (1,564) |
| C. Cash Flow from Financing Activities | ||
| Repayment of Long-Term Borrowings | (720) | (640) |
| Repayment of Lease Liabilities (IND AS 116) | (372) | (348) |
| Net movement in Short-Term Borrowings | (300) | 200 |
| Finance costs paid | (196) | (244) |
| Dividend paid | (280) | (200) |
| ESOP proceeds on exercise | 8 | 12 |
| Net Cash from Financing Activities (C) | (1,860) | (1,220) |
| Net Increase / (Decrease) in Cash (A+B+C) | 1,210 | (640) |
| Opening Cash & Cash Equivalents | 72 | 712 |
| Closing Cash & Cash Equivalents (Note 19) | 1,282 | 72 |
Free Cash Flow = Operating CF (₹4,822L) − Capex (₹680L) = ₹4,142L (₹41.4 Cr) · Cash conversion ratio = OCF/PAT = 1.86x (healthy > 1.0x)
Monthly MIS — P&L (₹ Lakhs)Annual
Balance Sheet Schedule III — IND ASAcme Technologies Ltd · CIN: U72000MH2010PLC123456
| Particulars | Note | 31 March 2025 (₹L) | 31 March 2024 (₹L) |
|---|---|---|---|
| I. Equity & Liabilities | |||
| (1) Shareholders' Funds | |||
| Equity Share Capital | 1 | 1,000 | 1,000 |
| Other Equity | 2 | 14,840 | 12,964 |
| Sub-total — Shareholders' Funds | 15,840 | 13,964 | |
| (2) Non-Current Liabilities | |||
| Long-Term Borrowings | 3 | 2,480 | 3,200 |
| Lease Liabilities — NC (IND AS 116) | 4 | 840 | 1,020 |
| Deferred Tax Liabilities (Net) | 5 | 312 | 284 |
| Long-Term Provisions | 5A | 248 | 196 |
| Sub-total — Non-Current Liabilities | 3,880 | 4,700 | |
| (3) Current Liabilities | |||
| Short-Term Borrowings | 6 | 500 | 800 |
| Trade Payables — MSME | 7 | 840 | 720 |
| Trade Payables — Others | 7 | 1,300 | 1,240 |
| Other Financial Liabilities | 8 | 824 | 762 |
| Other Current Liabilities | 9 | 404 | 352 |
| Short-Term Provisions | 9A | 280 | 240 |
| Current Tax Liabilities (Net) | 210 | 188 | |
| Sub-total — Current Liabilities | 4,358 | 4,302 | |
| Total Equity & Liabilities | 24,078 | 22,966 | |
| II. Assets | |||
| (1) Non-Current Assets | |||
| Property, Plant & Equipment | 10 | 3,840 | 4,120 |
| Capital Work-in-Progress | 10A | 180 | 240 |
| Right-of-Use Assets (IND AS 116) | 11 | 960 | 1,160 |
| Intangible Assets | 12 | 620 | 480 |
| Financial Assets — Investments (NC) | 13 | 1,200 | 980 |
| Financial Assets — Other (NC) | 14 | 240 | 200 |
| Non-Current Tax Assets (Net) | 140 | 120 | |
| Other Non-Current Assets | 15 | 240 | 220 |
| Sub-total — Non-Current Assets | 7,420 | 7,520 | |
| (2) Current Assets | |||
| Inventories | 16 | 424 | 380 |
| Financial Assets — Current Investments (MF) | 17 | 2,430 | 2,010 |
| Financial Assets — Trade Receivables | 18 | 3,480 | 3,120 |
| Financial Assets — Cash & Cash Equivalents | 19 | 1,282 | 1,028 |
| Financial Assets — Bank Balances other than above | 20 | 6,820 | 5,840 |
| Financial Assets — Loans | 21 | 960 | 820 |
| Current Tax Assets (Net) | 108 | 88 | |
| Other Current Assets | 23 | 1,154 | 1,160 |
| Sub-total — Current Assets | 16,658 | 14,446 | |
| Total Assets | 24,078 | 21,966 | |
Figures in brackets denote credit / negative balances. Previous year figures regrouped where necessary.
Statement of Profit & Loss Schedule III — IND ASYear ended 31 March 2025
| Particulars | Note | FY 2024-25 (₹L) | FY 2023-24 (₹L) |
|---|---|---|---|
| I. Income | |||
| Revenue from Operations | 20 | 28,460 | 24,040 |
| Other Income | 21 | 680 | 520 |
| Total Income (I) | 29,140 | 24,560 | |
| II. Expenses | |||
| Cost of Services / Materials Consumed | 22 | 13,636 | 11,820 |
| Employee Benefits Expense | 23 | 8,840 | 7,480 |
| Finance Costs | 24 | 196 | 244 |
| Depreciation & Amortisation | 25 | 612 | 580 |
| Other Expenses | 26 | 2,460 | 2,120 |
| Total Expenses (II) | 25,744 | 22,244 | |
| III. Profit | |||
| Profit Before Tax (I − II) | 3,396 | 2,316 | |
| Current Tax (25%) | 776 | 520 | |
| Deferred Tax Charge / (Credit) | 28 | 16 | |
| Profit After Tax (PAT) | 2,592 | 1,780 | |
| IV. Other Comprehensive Income (IND AS 1) | |||
| Remeasurement of Defined Benefit Obligation (IND AS 19) | (248) | (192) | |
| Income Tax on OCI | 62 | 48 | |
| Other Comprehensive Income (Net of Tax) | (186) | (144) | |
| Total Comprehensive Income | 2,406 | 1,636 | |
| V. Earnings Per Share (IND AS 33) — Face Value ₹5 | |||
| Basic EPS (₹) | 12.96 | 8.90 | |
| Diluted EPS (₹) | 12.58 | 8.64 | |
| Weighted Average Shares (Basic) | 2,00,00,000 | 2,00,00,000 | |
Note 1 — Share Capital₹ Lakhs
| Particulars | 31 Mar 2025 | 31 Mar 2024 |
|---|---|---|
| Authorised | ||
| 2,00,00,000 Equity Shares of ₹5 each | 1,000 | 1,000 |
| Issued, Subscribed & Paid-up | ||
| 2,00,00,000 Equity Shares of ₹5 each, fully paid | 1,000 | 1,000 |
| Total Share Capital | 1,000 | 1,000 |
Note 2 — Other Equity
| Particulars | 31 Mar 2025 | 31 Mar 2024 |
|---|---|---|
| Securities Premium Reserve | 4,200 | 4,200 |
| General Reserve | 2,640 | 2,640 |
| Retained Earnings | 8,000 | 6,124 |
| ESOP Reserve (IND AS 102) | 248 | 192 |
| OCI — Remeasurement of DBO (Net of Tax) | (248) | (192) |
| Total Other Equity | 14,840 | 12,964 |
Note 10 — Property, Plant & Equipment (IND AS 16)
| Asset Class | Gross Block | Accum. Depn | Net Block 2025 | Net Block 2024 |
|---|---|---|---|---|
| Plant & Machinery | 42,000 | (8,200) | 33,800 | 36,400 |
| Computers & Peripherals | 4,800 | (2,600) | 2,200 | 2,800 |
| Furniture & Fixtures | 3,200 | (1,400) | 1,800 | 2,100 |
| Vehicles | 2,400 | (960) | 1,440 | 1,680 |
| Total PPE | 52,400 | (13,160) | 3,840 | 4,120 |
Note 18 — Trade Receivables (IND AS 109 — ECL)
| Ageing | Gross (₹L) | ECL Provision | Net (₹L) |
|---|---|---|---|
| Outstanding ≤ 30 days | 1,820 | — | 1,820 |
| Outstanding 31–60 days | 940 | (12) | 928 |
| Outstanding 61–90 days | 480 | (24) | 456 |
| Outstanding 91–180 days | 240 | (60) | 180 |
| Outstanding > 180 days | 160 | (64) | 96 |
| Total Trade Receivables | 3,640 | (160) | 3,480 |
Note 23 — Employee Benefits Expense (IND AS 19 & IND AS 102)
| Particulars | FY 2024-25 | FY 2023-24 |
|---|---|---|
| Salaries, Wages & Bonus | 7,340 | 6,200 |
| Contribution to PF & ESIC | 640 | 542 |
| Gratuity Expense (IND AS 19 — Actuarial) | 420 | 356 |
| Share-based Payment Expense (IND AS 102 — ESOP) | 248 | 192 |
| Staff Welfare, Training & Development | 192 | 190 |
| Total Employee Benefits Expense | 8,840 | 7,480 |
Note 20 — Revenue from Operations (IND AS 115)
| Particulars | FY 2024-25 | FY 2023-24 |
|---|---|---|
| IT Services & Projects (Fixed Price + T&M) | 19,624 | 16,584 |
| Managed Services / SaaS / AMC | 8,836 | 7,456 |
| Total Revenue from Operations | 28,460 | 24,040 |
Cash & Bank
₹12.8 Cr
5 accounts · Note 19
Fixed Deposits
₹68.2 Cr
Avg 7.56% · Note 20
Mutual Funds
₹24.3 Cr
Liquid / MM · Note 17
Total Liquidity
₹105.3 Cr
14 months runway
Bank Accounts — Note 19 Cash & Cash Equivalents
| Bank | Account No. | Type | Balance (₹L) | Balance (₹ Cr) | Status |
|---|---|---|---|---|---|
| HDFC Bank Ltd | XXXX-4521 | Current | 482 | 4.82 | Active |
| ICICI Bank Ltd | XXXX-3310 | Current | 361 | 3.61 | Active |
| State Bank of India | XXXX-7782 | Current | 244 | 2.44 | Active |
| Kotak Mahindra Bank | XXXX-9901 | Savings/Sweep | 153 | 1.53 | Sweep |
| Cash in Hand | — | 42 | 0.42 | Cash | |
| Total Cash & Cash Equivalents | 1,282 | 12.82 | |||
Fixed Deposit Register — Note 20 Bank Balances other than Cash & CE
| Bank | FD Reference | Principal (₹L) | Rate % | Start Date | Maturity Date | Maturity Amt (₹L) | Status |
|---|---|---|---|---|---|---|---|
| HDFC Bank | FD-2024-001 | 1,500 | 7.75% | 01 Apr 2024 | 31 Mar 2025 | 1,616 | Matured |
| ICICI Bank | FD-2024-002 | 2,000 | 7.60% | 01 Jul 2024 | 30 Jun 2025 | 2,154 | 91d |
| State Bank of India | FD-2024-003 | 1,820 | 7.50% | 01 Oct 2024 | 30 Sep 2025 | 1,957 | Active |
| Axis Bank | FD-2025-001 | 1,500 | 7.40% | 01 Jan 2025 | 31 Dec 2025 | 1,611 | Active |
| Total Fixed Deposits | 6,820 | 7.56 avg | 7,338 | ||||
Mutual Fund Holdings — Note 17 Current Investments at FVTPL
| Fund Name | Category | AMC | Units | NAV (₹) | Market Value (₹L) | Cost (₹L) | Unrealised Gain |
|---|---|---|---|---|---|---|---|
| HDFC Liquid Fund — Growth | Liquid | HDFC AMC | 8,42,310 | 3,842.10 | 1,442 | 1,400 | +3.0% |
| ICICI Pru Money Market Fund | Money Market | ICICI AMC | 4,21,150 | 2,314.60 | 988 | 950 | +4.0% |
| Total Mutual Funds | 2,430 | 2,350 | +3.4% | ||||
Liquidity RatiosShort-term solvency
Profitability RatiosEarnings quality
Leverage & CoverageDebt capacity
Efficiency RatiosAsset utilisation
DuPont ROE Decomposition
Net Profit Margin
9.1%
PAT ÷ Revenue
×
Asset Turnover
1.42×
Revenue ÷ Assets
×
Equity Multiplier
1.52×
Assets ÷ Equity
=
Return on Equity
19.7%
FY24: 14.2%
Revenue & Cost Assumptions — FY 2025-26
Revenue growth rate19%
Gross margin change (pp)+1.0pp
Employee cost growth15%
Other opex growth10%
Effective tax rate (%)25%
Interest income on FDs (₹L)₹600L
FY 2025-26 Projected Output
| Metric | FY25 Actual | FY26 Projected | Δ |
|---|
PAT Sensitivity Matrix₹ Cr
Cash Conversion Cycle
45 days
DSO 45 − DPO 38 + DIO 12
Net Working Capital
₹123 Cr
Current Assets − Liabilities
Current Ratio
2.14×
vs 1.88× LY
Quick Ratio
2.04×
vs 1.77× LY
Working Capital Metrics vs Benchmarks
Debtor Ageing ECL watch
| Bucket | ₹ Lakhs | % of Total | Risk |
|---|---|---|---|
| 0–30 days | 1,820 | 50.0% | Low |
| 31–60 days | 940 | 25.8% | Low |
| 61–90 days | 480 | 13.2% | Medium |
| 91–180 days | 240 | 6.6% | Medium |
| >180 days | 160 | 4.4% | High |
| Total | 3,640 | 100% | ECL ₹160L |
Creditor Ageing & MSME Compliance
| Bucket | ₹ Lakhs | Type | Status |
|---|---|---|---|
| Within 30 days | 1,280 | MSME + Others | Compliant |
| 31–45 days | 560 | Others | Within terms |
| 46–60 days | 220 | Others | Review |
| MSME overdue >45 days | 80 | MSME | MSMED Act risk |
| Total Payables | 2,140 | DPO 38d avg |
Critical
2
Immediate action
Warnings
4
Within 30 days
Info
4
FYI items
All Clear
18
No action needed
Active Alerts2 critical
Bank Covenant MonitorAll compliant
| Covenant | Lender | Threshold | Current | Status | Headroom |
|---|---|---|---|---|---|
| DSCR | HDFC Bank | >1.50× | 4.82× | Compliant | 3.32× buffer |
| Debt / EBITDA | SBI | <3.0× | 0.84× | Compliant | 2.16× buffer |
| Current Ratio | HDFC Bank | >1.20× | 2.14× | Compliant | 0.94× buffer |
| Minimum Net Worth | SBI | ₹100 Cr | ₹158 Cr | Compliant | ₹58 Cr buffer |
Due This Month
3
Needs attention
Due Next 30 Days
5
Plan ahead
Completed YTD
28
100% on time
Annual Filings Left
4
FY25 closures
Compliance Calendar — Q1 FY 2025-26April – June 2025
Acme Technologies LtdBoard Meeting — May 2025
FY 2024-25 · Standalone · IND AS
Key Performance Indicators
Revenue
₹284.6 Cr
+18.4% YoY
Gross Profit
₹148.2 Cr
GM 52.1%
EBITDA
₹35.2 Cr
12.4% margin
PAT
₹25.9 Cr
9.1% margin
EPS Basic
₹12.96
vs ₹8.90 LY
Free Cash Flow
₹41.4 Cr
OCF/PAT 1.86×
Total Liquidity
₹105 Cr
14 months runway
ROCE
22.1%
vs 17.8% LY
Management Commentary
Revenue grew 18.4% to ₹284.6 Cr driven by IT Services (+19.6%) and Managed Services (+19.3%). 18 new customer additions.
EBITDA margin expanded to 12.4% (from 10.9%). Employee cost as % of revenue held flat at 31.1%. Gross margin improved 130 bps to 52.1%.
Free Cash Flow ₹41.4 Cr. OCF/PAT = 1.86×. Treasury ₹105 Cr. All bank covenants met. Net Cash (debt-free).
Customer concentration risk: Top 10 customers = 64.8% of revenue. GovProject A margin 3.8% — recommend repricing or exit.
HDFC FD ₹15 Cr matured 31 Mar 2025 — renewal pending. MSME payables overdue >45 days ₹80L — MSMED Act exposure.
FY26 Guidance: Revenue ₹340 Cr (+19.5%), EBITDA margin 14.5%, headcount +220, capex ₹22 Cr.
Proposed Board Meeting Agenda
| # | Agenda Item | Nature | Presenter | Time |
|---|---|---|---|---|
| 1 | Adoption of Audited Financial Statements FY 2024-25 | Approval | CFO | 20 min |
| 2 | Statutory Auditor Report & CARO 2020 | Review | Auditor | 15 min |
| 3 | Final Dividend — ₹1.40 per share | Approval | CFO | 10 min |
| 4 | FY 2025-26 Budget & Business Plan | Discussion | CEO + CFO | 30 min |
| 5 | Treasury Policy — FD renewal & MF allocation | Discussion | CFO | 15 min |
| 6 | MSME payable overdue — settlement plan | Action | CFO | 10 min |
| 7 | ROC Filings — AOC-4 & MGT-7 status | Update | CS | 10 min |
Layer 1 · Source
Trial Balance
Opening balances + 12 months × Dr/Cr per ledger. Export from Tally, SAP, Zoho Books.
28 cols · 1 sheet · monthly
Layer 2 · Map
Ledger Master
Pre-seeded 90+ IND AS mappings. Each ledger → Note No + BS/PL section + treasury type.
Pre-seeded · customisable
Layer 3 · Compute
Period Engine
BS = cumulative. P&L = selected months. All period views from same TB — no re-upload.
Monthly → Q → H → Annual
Layer 4 · Output
All Reports
MIS, Balance Sheet, P&L, Notes 1–26, Treasury — all live from same TB.
6 reports · 1 upload
Option 1 — Upload Trial Balance (Monthly)
Template has 3 sheets:
Trial_Balance — 28 columns: Ledger_Code, Ledger_Name, Opening_Dr, Opening_Cr, then Apr_Dr … Mar_Cr.
📂
Drop Trial Balance Excel here or click to browse
Supports .xlsx — Trial_Balance sheet required
Option 2 — REST API Connection
Supports: SAP · Oracle · Tally · Zoho Books · QuickBooks · Custom ERP