Projected Financials — P&L, Balance Sheet & Cash-Flow in Guwahati
Use Cases for Projected Financials in Guwahati
- Bank loan / OD / CC — Term loan, working capital, bill discounting, LC, BG facilities
- Investor pitch deck — Angel, seed, Series-A through Series-D fundraise, family office
- Government scheme — PMEGP, MUDRA, Stand-Up India, CGTMSE, PMFME, NABARD AIF
- Visa application — UK Innovator/Founder, Canada Start-Up Visa, USA E-2/EB-5 financial proof
- Government tender — Eligibility filings, EMD/PBG documentation, financial-strength proof
- M&A / Strategic planning — Acquirer financial due diligence, strategic 5-year roadmap
- Statutory filings — Companies Act compliance for restructuring, merger schemes (NCLT)
- Internal use — Budgeting, board pack, V-CFO outputs, runway planning
Our Scope for Guwahati-Based Engagements
- 3-year, 5-year or 10-year projection horizons (annual, quarterly or monthly granularity)
- Full-form Schedule III Profit & Loss (revenue, COGS, employee, finance, depreciation, tax)
- Full-form Schedule III Balance Sheet (Equity, Non-current liab, Current liab, Non-current asset, Current asset)
- Cash-Flow Statement under Indirect Method (Ind AS 7) — Operating, Investing, Financing
- DSCR (avg + minimum), Interest-Coverage Ratio, Current Ratio, Debt-Equity, ROCE, ROE
- Breakeven analysis — volume, value and capacity-utilisation
- Sensitivity matrix — price ±10%, volume ±10%, RM cost +10%, interest rate +200 bps
- IRR / NPV / Payback Period (where the engagement is project-finance or capex-led)
- Working-capital cycle decomposition — DSO, DPO, DIO, Cash-Conversion-Cycle
- CA-certificate signed by named partner with UDIN reference (where required)
Local Anchors — Guwahati
Statutory anchor at ROC Shillong, GSTIN state-code 18. Guwahati sector calibration covers tea (largest single-state producer in India), petroleum & natural gas (Digboi, Numaligarh), plywood & forest products — projection assumptions (price escalation, capacity ramp, working-capital cycle) are benchmarked against actual Guwahati-region peer data, not generic industry averages.
Indicative Fee Structure
| Service | Fee |
|---|---|
| 3-year Projection (P&L + BS + CF) | From ₹6,999 |
| 5-year Projection (full Schedule III) | From ₹12,499 |
| 5-year + DSCR + Sensitivity + IRR/NPV | From ₹19,999 |
| CA-Certificate with UDIN (single page) | From ₹2,499 |
| Free 30-min Consultation | No obligation |
Frequently Asked Questions
What's the difference between Projected Financials and a DPR?
Projected financials are the financial statements only (P&L, BS, CF). A DPR is the full project document that contains projected financials plus market study, technical feasibility, regulatory analysis, SWOT etc. Banks for working-capital often need only projections; for term-loan they need a full DPR.
Are your projections accepted by banks in Guwahati?
Yes. Our projections are issued in PNB-59 / SBI-CMA-2018 / Canara / HDFC / ICICI MSME formats and are routinely accepted by appraising branches in Guwahati. CA-certificate with UDIN is included where required.
How long do projections take to prepare?
3-5 working days for a 3-5 year projection from receipt of promoter inputs, historical financials (if existing business) and assumption guidance call. Bank-format conversion adds 1-2 days.
Can projections be used for investor pitch decks?
Yes. We deliver a "founder narrative" version (high-level summary slides) plus a "data-room" version (full Schedule III with assumption sheets) for investor diligence. Cap-table, runway, burn-rate, unit-economics modules included on request.
Will the projections work for visa applications?
Yes — UK Innovator/Founder, Canada SUV, USA E-2/EB-5, and Australia 188 visa applications routinely accept our CA-certified 5-year projections as financial-viability proof.
Do you serve Guwahati-based clients?
Yes. Virtual Auditor scopes projection engagements for Guwahati businesses from our offices in Chennai, Bengaluru and Mumbai. Secure data-room workflow; weekly status updates. Call +91 99622 60333.
Projected Financial Statements in Guwahati — The Full Methodology
A projection is only as useful as the assumptions it rests on. For Guwahati-based businesses, we anchor every line item in the projection to a defensible source — historical actuals (where the business has them), benchmark data from comparable Guwahati-region peers (where it doesn't), or industry studies from CRISIL/ICRA/IBEF for sector-specific items. The deliverable is a 3-5-year P&L, Balance Sheet, and Cash-Flow Statement, fully linked through assumption sheets that any banker, investor or auditor can interrogate line-by-line.
Revenue Build-Up
Revenue is built bottom-up — capacity (units or revenue-units), capacity-utilisation ramp (typical: year-1 50-60%, year-2 65-75%, year-3 onwards 75-85%), realisation per unit (with explicit price-escalation assumption tied to CPI/WPI for the Guwahati sector cluster), and net-of-discount/return adjustments. SaaS and subscription businesses build revenue off MRR/ARR with cohort retention and net-revenue-retention modelling. Project-led businesses (construction, EPC) follow the percentage-of-completion method under Ind AS 115. Our model documents which method, why, and how it reconciles to historical actuals.
Cost Structure — Variable, Semi-Variable and Fixed
Raw-material cost is benchmarked against three competing supplier quotations and tracked as a percentage of revenue. Employee cost includes gross salary, ESI/EPF (12% + 13% employer share), gratuity provision (4.81% per Payment of Gratuity Act 1972), bonus (8.33% statutory minimum where applicable), and leave-encashment provision under AS 15 / Ind AS 19. Finance cost is amortised against the proposed term-loan tenor with declining-balance interest computation. Depreciation is computed under Companies Act Schedule II (for Schedule III financials) and Income-tax Act Section 32 / Rule 5 (for tax projections) — these will differ, and reconciliation is shown.
Balance Sheet Linkage
The Balance Sheet must reconcile to the rupee with the P&L (retained earnings) and the Cash-Flow (cash & cash-equivalents). Equity capital is built from share-issuance assumptions (primary, ESOP-pool dilution, anti-dilution true-ups). Term-debt is amortised against repayment schedule. Working capital is built from holding norms — DSO (debtor-days), DPO (creditor-days), DIO (inventory-days) — calibrated to Guwahati sector cycles rather than generic industry. Fixed-asset additions and disposals link to the Cash-Flow investing section.
Cash-Flow Statement (Indirect Method, Ind AS 7)
Operating cash-flow is built from PAT + non-cash adjustments (depreciation, deferred tax, provisions) ± working-capital changes (Δ debtors, Δ creditors, Δ inventory). Investing covers fixed-asset additions, investments, sale-of-asset receipts. Financing covers term-loan drawals/repayments, equity-issue receipts, dividend payouts, interest paid. The closing cash balance must reconcile to the Balance Sheet line — a discipline that flags 80% of modelling errors before they reach the appraiser.
DSCR, IRR, NPV, Payback and Sensitivity
Average DSCR target ≥ 1.50, minimum DSCR ≥ 1.20 — these are the standard bank covenants. IRR and NPV use a discount rate that reflects the project's weighted-average cost of capital (WACC) — typical Guwahati-region SME WACC sits in the 14-18% range depending on debt-equity mix. Payback period under both undiscounted and discounted bases. Sensitivity matrix recomputes DSCR/IRR/NPV under: sales-price ±10%, sales-volume ±10%, raw-material cost +10%, interest-rate +200 bps. Tornado-chart visualisation provided for investor decks.
Breakeven and Operating Leverage
Breakeven is reported in three forms: volume (units), value (₹), and capacity utilisation (%). Operating leverage (contribution / EBIT) tells the appraiser how sensitive earnings are to revenue swings. For Guwahati-region capex-heavy businesses (tea (largest single-state producer in India), petroleum & natural gas (Digboi, Numaligarh), plywood & forest products clusters being the typical exemplars), high operating leverage means breakeven utilisation matters a lot — and we model the year-by-year breakeven trajectory rather than a static single-point.
Why Virtual Auditor for Projected Financials in Guwahati
CA V. Viswanathan (FCA, ACS, CFE, IBBI Registered Valuer — IBBI/RV/03/2019/12333) personally reviews and signs every projection deliverable. Our projection-models have been used in bank-loan appraisals across PNB, SBI, Canara, BoB, HDFC, ICICI, Axis, and Kotak; investor pitches that closed angel through Series-D rounds; visa applications under UK Innovator/Founder, Canada SUV and USA E-2/EB-5; and government-tender eligibility filings. Engagements run on fixed-fee terms with named-partner ownership and full source-document traceability.
Get Started — Free 30-Minute Consultation
To scope your Guwahati projection engagement, call +91 99622 60333 or email support@virtualauditor.in. We deliver a fee quote and turnaround timeline within 24 hours of the consultation, and provide references from comparable engagements on request, subject to client confidentiality.