Adwani Blogs

Author: CA Manish Mata

  • FP&A and Excel Automation: The CFO’s Secret Weapon for Smarter Decisions in 2026

    FP&A and Excel Automation: The CFO’s Secret Weapon for Smarter Decisions in 2026

    CA Manish Mata April 2026 10 min read

    It’s quarter-end. Your CFO needs a three-scenario revenue forecast by tomorrow morning. Your finance team is buried in spreadsheets, copying data from one tab to another, double-checking formulas at midnight. Sound familiar? This is the reality for thousands of Indian businesses in 2026 — and it is entirely avoidable.

    The game-changer is FP&A (Financial Planning & Analysis) and Excel automation. For modern CFOs and finance leaders in India, this combination has stopped being a “nice to have” and become an absolute competitive necessity. Whether you run a growing startup, a mid-sized manufacturing firm, or a large enterprise, your ability to plan, forecast, and analyze financial data intelligently will determine whether you lead or lag.

    At Adwani and Company, we work with businesses across India to implement framework of FP&A and Excel automation workflows that save time, reduce errors, and give CFOs the clarity they need to make bold decisions. “The CFO who automates today will strategize tomorrow. The CFO who doesn’t will still be building pivot tables.”

    What Is FP&A and Why Does It Matter for CFOs in India?

    FP&A — Financial Planning and Analysis is the discipline that sits at the heart of every well-run finance function. It brings together budgeting, forecasting, variance analysis, and financial modeling to give leadership a forward-looking picture of the business. Unlike traditional accounting (which looks backward), FP&A looks ahead.

    For Indian CFOs navigating a dynamic environment with updated income tax regulations under the Income Tax Act 2025, shifting GST compliance requirements, and MCA reporting obligations FP&A provides the analytical backbone to stay ahead of both opportunities and risks.

    The three pillars of effective FP&A are:

    • Budgeting: Coordinating annual and rolling budgets across departments aligned with business strategy.
    • Forecasting: Updating financial projections based on real business performance, not just static assumptions.
    • Analysis: Identifying variances, trends, and actionable insights to guide CFO decision making.

    Excel Automation: Transforming FP&A from Manual to Intelligent

    Despite the rise of dedicated FP&A software, Microsoft Excel remains the dominant tool in Indian finance teams and for good reason. It is flexible, widely understood, and deeply integrated into how finance professionals work. The problem isn’t Excel itself; it’s how most teams use it: manually.

    Excel automation through macros, VBA scripts, Power Query, Power Pivot, and dynamic array formulas turns Excel from a static spreadsheet into a live financial intelligence engine. Here is what automation actually looks like in practice:

    1. Automated Data Consolidation

    Instead of manually copying data from ERP systems, bank statements, and CRM reports into a master spreadsheet, Power Query pulls and refreshes data from multiple sources at the click of a button. A business that previously spent 3 days consolidating monthly MIS data now completes it in under 2 hours.

    2. Dynamic Financial Models

    FP&A models built with structured Excel formulas (INDEX/MATCH, XLOOKUP, dynamic arrays) update automatically when assumptions change. A CFO can run a best-case, base-case, and worst-case scenario simultaneously without creating three separate files.

    3. Automated Reporting Dashboards

    Using Power Pivot and pivot charts, finance teams can build self-updating dashboards that surface KPIs like gross margin, working capital, EBITDA, and cash runway

    Real-World Example: FP&A and Excel automation in Action

    A mid-sized manufacturing company in Pune was spending approximately 80 hours per month on manual financial reporting across 12 departments. After implementing an automated FP&A model in Excel with Power Query pulling data from their ERP, VBA scripts formatting reports, and a live dashboard for the CFO their monthly reporting cycle dropped to just 14 hours. That is a saving of 66 hours per month, freeing up the finance team for strategic analysis rather than data entry. The CFO was now able to present scenario forecasts in board meetings instead of static backward-looking reports.

    How FP&A and Excel Automation Sharpen CFO Decision-Making

    The role of the CFO in Indian organisations has evolved dramatically. According to guidance from the Ministry of Corporate Affairs (MCA), CFOs of listed companies carry statutory responsibilities that go beyond financial reporting — including compliance with the Companies Act, 2013, and oversight of internal controls. This regulatory weight means CFOs cannot afford to waste time on manual processes.

    Here is how FP&A and Excel automation directly improves CFO decision quality:

    • Faster Scenario Analysis: Model the financial impact of a new product line, a pricing change, or a hiring plan within minutes, not days.
    • Improved Cash Flow Visibility: Rolling 13-week cash flow forecasts updated automatically help CFOs avoid liquidity crunches before they happen.
    • Accurate Tax Planning: With the new Income Tax Act 2025 changes and updated TDS rates for FY 2026-27, tax modelling within FP&A ensures no surprises at year-end.
    • GST Compliance Integration: Automating GSTR-3B and GSTR-1 reconciliation within financial models reduces errors and ensures timely filing.
    • Board-Ready Reporting: Automated variance analysis and commentary generation mean the CFO walks into board meetings with insights, not just numbers.

    FP&A Must Include Tax Planning: Income Tax Act 2025 Implications

    One of the most significant recent developments affecting Indian CFOs is the Income Tax Act 2025, which introduces a consolidated framework replacing several provisions of the Income Tax Act, 1961. According to the Income Tax Department of India, the revised Act focuses on simplification of tax computation, updated definitions of taxable income, and streamlined return filing. CFOs need to ensure their FP&A models incorporate these changes from April 2026.

    Key FP&A and Excel automation considerations under the updated tax framework include:

    • New Tax Regime Slabs for FY 2026-27: Ensuring salary cost models reflect revised TDS rates under Section 192 for all employees.
    • Capital Gains Tax Integration: Post-2026 changes to LTCG and STCG rates on equities and mutual funds must be reflected in investment planning models.
    • TDS on Rent and Professional Fees: FP&A models must auto-calculate TDS obligations under Sections 194I and 194J to avoid deduction defaults.

    Also Read https://www.adwaniandco.com/blog/old-vs-new-tax-regime

    This is exactly where working with a qualified CA firm like Adwani and Company becomes invaluable. They bridge the technical FP&A and Excel automation world with the regulatory compliance framework that Indian CFOs must navigate. Learn more about our Tax Planning Services. https://www.adwaniandco.com/services/taxation-compliance

    GST Compliance Automation: Making FP&A GST-Ready

    Under the GST framework administered by the GSTN (GST Network) portal, businesses must file multiple returns monthly and annually — GSTR-1, GSTR-3B, GSTR-9, and more. For CFOs managing large vendor bases and complex ITC (Input Tax Credit) positions, manual reconciliation is not just time-consuming — it is risky.

    Embedding GST automation within an FP&A model means:

    • Real-time ITC Reconciliation: Matching purchase invoices against GSTR-2B automatically, flagging mismatches before filing.
    • GST Liability Projections: Forecasting monthly GST outflows as part of cash flow planning rather than treating them as a surprise.
    • Late Fee Monitoring: Automating due date tracking for GSTR-3B and other returns to avoid penalties.

    For businesses unsure about GST registration requirements or ITC eligibility in 2026, read our detailed guide on GST Compliance for Indian Businesses crafted by our expert team at Adwani and Company.

    Building an FP&A Model in Excel: A Practical Framework

    If you want to build a robust FP&A and Excel automation model in Excel that would satisfy even the most demanding CFO, follow this proven structure developed and tested by the advisory team at Adwani and Company:

    1. Assumptions: All key drivers live here revenue growth rates, headcount, tax rates, inflation. This single tab controls the entire model.
    2. Income Statement: Driven entirely by formulas linked to assumptions. No hardcoded values.
    3. Balance Sheet: Auto-calculated from the income statement, with working capital schedules plugged in.
    4. Cash Flow: Indirect method cash flow statement that ties to the balance sheet. Includes a 13-week rolling cash forecast.
    5. Scenarios: Three scenarios (bear, base, bull) driven by a dropdown that switches assumption sets instantly.
    6. Dashboard: KPI cards, waterfall charts, and trend graphs that update automatically. Board ready at any moment.

    Power Query handles data ingestion. VBA handles report formatting. The CFO gets a single source of financial truth that is always current.

    Why CFOs Should Work With a CA Firm for FP&A Design

    While Excel skills are learnable, financial model design is not just a technical exercise it is a regulatory and strategic one. A model that ignores TDS implications, misstates deferred tax, or misclassifies capital vs. revenue expenditure will produce misleading outputs regardless of how elegant its formulas are.

    This is where Adwani and Company adds irreplaceable value. Under the leadership of Dr. Haresh Adwani a PhD holder in Commerce with a strong foundation in Indian commercial law —our firm combines FP&A consulting with tax compliance expertise. We don’t just build models; we build models that are legally sound, audit-ready, and aligned with current Indian regulations including the Income Tax Act 2025, GST law, and MCA requirements.

    Our FP&A advisory services for CFOs include:

    • Custom Excel automation model design and implementation
    • Integration of tax planning (income tax, TDS, capital gains) into financial models
    • GST liability forecasting and ITC reconciliation automation
    • Board and investor reporting dashboards
    • Financial model audit and error-proofing

    Learn more about our CFO Advisory and FP&A Services and discover how Adwani and Company can transform your finance function.

    Conclusion

    In 2026, the finance function is no longer defined by who can produce the most accurate historical report. It is defined by who can produce the most insightful forward-looking analysis fast, accurately, and in alignment with India’s evolving regulatory environment.

    FP&A and Excel automation are not just efficiency tools. They are strategic levers. They give CFOs the bandwidth to move from number-crunching to value creation advising the board on acquisitions, guiding pricing strategy, and modelling tax-efficient capital structures.

    But getting the most from FP&A requires more than Excel skills. It requires understanding the Income Tax Act 2025, GST compliance, MCA reporting, and how all of these intersect with business performance. That intersection is exactly where the team at Adwani and Company operate every day helping Indian businesses build finance functions that are intelligent, compliant, and future-ready.

    1. What is FP&A and why do Indian CFOs need it in 2026?

    FP&A Financial Planning and Analysis is the function responsible for budgeting, forecasting, and strategic financial analysis. In 2026, with updated tax regimes, new ITR forms, and increased regulatory scrutiny, Indian CFOs need FP&A to make proactive, data-driven decisions rather than reactive ones.

    2. How does Excel automation improve FP&A processes?

    Excel automation (using Power Query, VBA, dynamic arrays, and Power Pivot) eliminates manual data entry, speeds up report generation, reduces formula errors, and enables real-time scenario analysis dramatically increasing the productivity and accuracy of finance teams.

    3. Can FP&A models include GST and income tax calculations?

    Yes, and they should. A well-built FP&A model integrates TDS calculations under the new tax regime, GST liability projections, ITC reconciliation, and capital gains tax implications giving the CFO a true after-tax view of business performance.

    4. What is the difference between FP&A and traditional accounting?

    Traditional accounting (managed under statutory audit requirements and the Companies Act) looks backward recording what happened. FP&A and Excel automation looks forward projecting what will happen and why, enabling better strategic decisions.

    5. How does Adwani and Company help with FP&A and Excel automation?

    Adwani and Company offers end-to-end FP&A advisory from designing Excel automation models to integrating income tax and GST compliance into financial planning frameworks. Led by Dr. Haresh Adwani, our team brings both financial modelling expertise and deep regulatory knowledge to every engagement. Connect with us today.

    6. Is Excel still relevant for FP&A or should businesses use dedicated software?

    For most Indian SMEs and mid-market businesses, well-automated Excel remains the most practical FP&A tool. Dedicated FP&A software becomes relevant at larger scale. The key is automation removing manual work and adding intelligence to how Excel is used.

    7. How do I start building an FP&A model for my business?

    Start with a clean assumptions tab, then build your income statement, balance sheet, and cash flow using formulas linked to those assumptions. Add scenario functionality and a dashboard. If you need expert guidance, Adwani and Company can design and implement a custom FP&A and Excel automation model for your business from scratch.

    Author
    CA. Manish R. Mata Practising In India (Ex – PwC),  At Adwani & Co LLP leads the International Accounting & Tax Support vertical, delivering structured execution assistance to US CPA firms and overseas businesses.

  • Smart Business Growth Strategy(2026): Find the Bypass

    Smart Business Growth Strategy(2026): Find the Bypass

    Smart Business Growth Strategy: Stop Pushing Harder and Find the Bypass

    Here is a truth that most business owners learn too late: the biggest obstacle to growth is almost never what you think it is. You blame the sales team. You blame the market. You blame the economy. But the real problem the one quietly draining your revenue, your margins, and your energy is usually hiding in plain sight, disguised as something you have always accepted as normal.

    The most effective business growth strategy is not about pushing harder through obstacles. It is about finding the bypass the smarter, faster, less crowded path that everyone else overlooked.

    At Adwani and Company, we see this pattern repeatedly. Businesses generating ₹50 crore, ₹100 crore, or more in revenue come to us frustrated. Growth has stalled. Costs are rising. Customers are complaining. And the owner is convinced the solution is more effort, more investment, more pressure.

    It rarely is.

    In this blog, we will explore why the most powerful business growth strategy often involves subtraction, not addition removing the hidden friction points that silently sabotage your business. We will share a real-world example, actionable frameworks, and the thinking that separates businesses that scale from businesses that struggle.

    Also Read:

    https://www.adwaniandco.com/blog/capital-gains-exemption

    Why Pushing Harder Is Not a Business Growth Strategy

    There is a deeply ingrained belief in Indian business culture that success comes from relentless effort. Work longer hours. Hire more salespeople. Spend more on marketing. Push, push, push.

    And effort absolutely matters. Nobody builds a successful business without hard work.

    But here is the problem: effort without direction is just friction. And friction, compounded over months and years, destroys businesses.

    Consider this scenario. You are walking briskly one morning clear mind, strong focus, productive energy. Then you encounter a group blocking your path. Moving slowly. Chatting casually. Unaware of anyone behind them.

    You have three options:

    1. Wait behind them patient, but slow.
    2. Force your way through aggressive, but creates conflict.
    3. Find a side lane a simple bypass that gets you ahead without friction.

    Option three is almost always the best choice. And it is almost always the one people overlook.

    Business works the same way. The most effective business growth strategy is not about exerting more force against the same obstacle. It is about recognising the obstacle for what it is and finding a smarter route around it.

    The Hidden Bottleneck: A Real-World Business Growth Strategy Example

    Let us look at a situation that Dr. Haresh Adwani and the advisory team at Adwani and Company encountered with a client a mid-sized manufacturing business with annual revenue exceeding ₹50 crore.

    The Symptoms

    The business was showing classic signs of stagnation:

    • Revenue growth had slowed to near zero.
    • Customer complaints were increasing quarter over quarter.
    • Gross margins were shrinking despite stable pricing.
    • The operations team was working harder but achieving less.

    The owner was convinced the problem was sales. “We need more customers. We need a better sales team. We need to spend more on marketing.”

    The Diagnosis

    When we looked deeper beyond the P&L statement and into the operational mechanics a different picture emerged.

    The root cause was not sales. It was one supplier.

    This supplier was well-known in the market. Popular. In demand. Every manufacturer wanted to work with them. And because of that dominant position:

    • Prices kept rising 8–12% annually, far above market averages.
    • Deliveries kept slipping lead times had grown from 2 weeks to 6 weeks.
    • Quality became inconsistent rejection rates had doubled in 18 months.

    The business was haemorrhaging money, not because of a sales problem, but because of a supplier dependency problem. More than ₹50 crore in annual revenue was being exposed to decisions made by someone else’s business.

    The Bypass

    Instead of renegotiating harder (pushing through the crowd), we helped the client find the bypass.

    We conducted a comprehensive supplier review evaluating alternatives across quality, pricing, delivery reliability, and scalability. The result was a newer, less crowded supplier that offered:

    • 15% lower pricing on key raw materials.
    • 60% faster delivery times from 6 weeks back to under 2 weeks.
    • Significantly better quality consistency rejection rates dropped by 70%.

    The shift looked small on paper. One supplier changed.

    The impact was anything but small:

    MetricBefore BypassAfter Bypass
    Raw material cost₹18.5 crore/year₹15.7 crore/year
    Average delivery time6 weeks1.5 weeks
    Quality rejection rate8.2%2.4%
    Customer complaints45/month12/month
    Revenue growth (next 12 months)~0%18%

    That is the power of a well-executed business growth strategy not more effort, but better decisions.

    Pattern Recognition: The Core of Every Great Business Growth Strategy

    Warren Buffett does not succeed because he works harder than other investors. He succeeds because he sees patterns others miss. Steve Jobs did not build Apple by outspending competitors. He built it by recognising what customers wanted before they knew they wanted it.

    The best business growth strategy is rooted in pattern recognition the ability to look at a complex business and identify the one lever that, when pulled, unlocks disproportionate results.

    As Dr. Haresh Adwani often explains: “Numbers tell you what is happening. Patterns tell you why. And understanding why is where real advisory value begins.”

    Most business owners are drowning in data. Revenue reports, expense dashboards, sales funnels, customer analytics. But data without interpretation is noise. The role of a strategic advisor is to cut through that noise and find the signal the one insight that changes the trajectory.

    Five Signs Your Business Needs a Bypass, Not More Effort

    How do you know when pushing harder is the wrong approach? Here are five patterns we frequently identify at Adwani and Company:

    1. Revenue Is Growing but Margins Are Shrinking

    If your top line is increasing but your bottom line is flat or declining, you have a structural problem not a sales problem. The bypass might be in your cost structure, your pricing model, or your customer mix.

    2. Your Best People Are Burning Out

    When high performers start leaving or disengaging, it is rarely about compensation. It is usually about friction inefficient processes, unclear priorities, or systemic bottlenecks that make their work unnecessarily difficult. The bypass is operational, not motivational.

    3. Customer Complaints Are Increasing Despite Good Products

    This almost always points to a supply chain or delivery issue. Your product may be excellent, but if it arrives late, arrives damaged, or arrives inconsistently, customers will leave. The bypass is upstream, not downstream.

    4. You Are Over-Dependent on One Supplier, One Client, or One Channel

    Concentration risk is the silent killer of mid-sized businesses. If more than 30% of your revenue or supply chain depends on a single entity, you are one decision away from crisis. The bypass is diversification systematic, strategic, and planned.

    5. You Keep Solving the Same Problems

    If the same issues resurface every quarter cash flow crunches, inventory mismatches, compliance delays you are treating symptoms, not causes. The bypass requires going deeper and restructuring the root process.

    How to Build a Business Growth Strategy Around Finding Bypasses

    Here is a practical framework that any business owner can implement:

    Step 1: Map Your Friction Points

    List every area where your business experiences recurring delays, cost overruns, or quality issues. Be brutally honest. Common areas include procurement, logistics, compliance, hiring, and collections.

    Step 2: Quantify the Cost of Friction

    For each friction point, estimate the annual cost in money, time, and opportunity. You will be surprised how much “accepted” inefficiency is actually costing you. A ₹50 crore business can easily be losing ₹3–5 crore annually to friction it has never measured.

    Step 3: Identify the Biggest Lever

    Not all friction points are equal. Find the one that, if resolved, would have the largest cascading impact on revenue, margins, and customer satisfaction. This is your primary bypass.

    Step 4: Explore Alternatives Relentlessly

    Do not accept the first alternative you find. Evaluate multiple options. Test small before committing large. The best business growth strategy decisions are informed, not impulsive.

    Step 5: Execute and Measure

    Implement the change, track the metrics, and iterate. A bypass is not a one-time fix it is a new path that needs to be maintained and optimised over time.

    The Role of Advisory in Modern Business Growth Strategy

    Here is something most business owners do not want to hear: you cannot see your own blind spots.

    You are too close to the business. You have too many emotional attachments to existing relationships, processes, and decisions. The supplier who is costing you ₹3 crore a year might also be someone you have known for 15 years. The process that is bleeding efficiency might be one you designed yourself.

    This is where external advisory becomes invaluable not to replace your judgment, but to complement it with objectivity.

    At Adwani and Company, our advisory approach goes beyond spreadsheets and compliance. Led by Dr. Haresh Adwani, our team works with business owners to identify hidden friction, quantify its impact, and design practical solutions that drive measurable growth.

    Whether it is a supplier review, a cost restructuring, a compliance overhaul, or a full strategic reassessment, the goal is always the same: find the bypass that unlocks your next phase of growth.

    The Ministry of Corporate Affairs (MCA) and regulatory frameworks like the Companies Act increasingly demand that businesses maintain robust governance and operational structures. A strong business growth strategy must account for compliance as a growth enabler, not just a cost centre.

    Conclusion: The Smartest Business Growth Strategy Is Seeing What Others Miss

    Every business owner faces crowded paths saturated markets, rising costs, difficult suppliers, demanding customers. The instinct is to push harder, move faster, and outwork the competition.

    But the most successful businesses the ones that scale sustainably and profitably do something different. They pause. They observe. They find the bypass.

    The side lane nobody noticed. The supplier nobody evaluated. The process nobody questioned. The insight nobody connected.

    That is not laziness. That is strategic intelligence. And it is the foundation of every truly effective business growth strategy.

    Where in your business are you pushing harder when you should be looking for the bypass?

    If you want expert guidance to identify hidden growth opportunities, streamline operations, and build a business growth strategy that actually works, connect with Adwani and Company today. Dr. Haresh Adwani and our advisory team are ready to help you find the path that transforms your business.

    1. What is a business growth strategy?

    A business growth strategy is a structured plan to increase revenue, improve margins, and scale operations sustainably. It involves identifying opportunities, removing bottlenecks, and making strategic decisions about markets, products, pricing, and operations.

    2. Why does pushing harder sometimes fail as a business growth strategy?

    Because effort without direction creates friction. If the underlying problem is structural a bad supplier, an inefficient process, a flawed pricing model more effort will not solve it. You need to identify and address the root cause.

    3. How do I identify hidden bottlenecks in my business?

    Start by mapping every area where recurring problems occur delays, cost overruns, complaints, rework. Quantify the cost of each. The largest hidden cost is usually your biggest bottleneck and your most valuable bypass.

    4. How often should a business review its growth strategy?

    At minimum, annually. However, high-growth businesses benefit from quarterly strategic reviews. Market conditions, supplier dynamics, and customer needs change constantly your business growth strategy must evolve accordingly.

    5. Can a single supplier really impact business growth?

    Absolutely. As our real-world example demonstrated, one over-relied-upon supplier can silently erode margins, delay deliveries, and damage customer relationships putting crores of revenue at risk.

    6. What role does a CA firm play in business growth strategy?

    A modern CA firm like Adwani and Company goes beyond compliance. We analyse financial data, identify operational inefficiencies, advise on tax-efficient structuring, and help business owners make strategic decisions backed by numbers and expertise.

    Author
    CA. Manish R. Mata Practising In India (Ex – PwC),  At Adwani & Co LLP leads the International Accounting & Tax Support vertical, delivering structured execution assistance to US CPA firms and overseas businesses.

  • NRI Tax Rules: 10 Critical Questions Before Returning to India

    NRI Tax Rules: 10 Critical Questions Before Returning to India

    NRI Tax Rules: 10 Critical Questions Before Returning to India
    NRI Tax Rules: 10 Critical Questions Before Returning to India

    Why NRI Tax Planning Before Returning to India Matters

    Every year, thousands of Non-Resident Indians working in the United States, Canada, United Kingdom, UAE, Australia, and other countries make the decision to return home. For many, it is driven by family, career opportunities, or simply the desire to reconnect with their roots. But what often comes as a surprise sometimes a very expensive one is how dramatically their tax situation changes the moment they step back on Indian soil for good.

    According to guidelines issued by the Income Tax Department of India, your residential status determines the scope of your tax liability. As an NRI, you are taxed only on income earned or received in India. The moment your status changes to Resident, however, India gains the right to tax your global income including income from foreign bank accounts, rental earnings from property abroad, dividends from US or UK stocks, and money you earn from global investments.

    This is why NRI tax planning before the return journey is not just advisable it is essential. Dr. Haresh Adwani of Adwani & Company has guided hundreds of returning NRIs through this transition, and consistently observes that those who plan ahead save significantly more, comply cleanly, and avoid stressful tax notices later.

    Important Alert

    Many NRIs believe their foreign income is permanently outside India’s tax net. This is incorrect once you become a tax resident. The planning window particularly your RNOR period is limited and time-sensitive.

    NRI Tax Rules: When Do You Become Resident, RNOR, or ROR?

    Understanding your residential status is the very first step in NRI tax planning in India. The Income Tax Act, 1961 defines three categories of residential status for individuals:

    StatusWhat It MeansIndian Tax on Foreign Income?
    NRI (Non-Resident Indian)Stays less than 182 days in India in a year (general rule)Not Taxable
    RNOR (Resident but Not Ordinarily Resident)Transitional status for returning NRIs; limited foreign tax exposurePartially Exempt
    ROR (Resident and Ordinarily Resident)Full tax resident; all global income taxable in IndiaFully Taxable

    The RNOR status is arguably the most valuable tool available to a returning NRI — but it is available only for a limited period, typically two to three financial years after returning, depending on your prior NRI history. During this window, your foreign income remains outside India’s tax net, giving you critical time to restructure investments and repatriate funds in a tax-efficient manner.

    Dr. Haresh Adwani strongly advises every returning professional to calculate their RNOR window as the very first step, ideally six to twelve months before the planned return date.

    Also Read:

    https://www.adwaniandco.com/blog/the-120-day-rule-that-is-silently-taxing-thousands-of-nris-in-india

    The 120-Day Rule That Silently Traps NRIs

    Here is a less-known but critically important provision in India’s NRI tax rules that catches many people completely off guard. Most NRIs believe that as long as they live outside India, their NRI status is protected. But there is a specific rule, introduced via the Finance Act 2020, that can strip your NRI status even if you live abroad.

    If the following three conditions are all true, you may be classified as a tax resident of India even though you live abroad:

    The Three-Condition Rule

    1. Your income from India exceeds ₹15 lakh in the financial year
    2. You stayed in India for 120 days or more in that financial year
    3. You stayed in India for 365 days or more cumulatively over the previous four financial years

    120 days sounds like a lot. But consider this you come for a wedding in December, stay through January. You visit again in April for a family function. You attend a relative’s medical emergency in August. Without consciously tracking, you may have crossed the 120-day threshold without even realising it. And if your Indian income salary from an Indian employer, rent from property, or dividend from Indian shares exceeds ₹15 lakh, India’s tax jurisdiction now extends to your global income.

    This is not a hypothetical risk. At Adwani & Company, we have advised clients who received income tax notices specifically because of this provision. The solution is straightforward track your travel days carefully and consult a qualified NRI tax advisor well before the end of each financial year (March 31).

    10 NRI Tax Questions You Cannot Afford to Ignore

    Based on years of advising professionals returning from the US, UK, UAE, Canada, Singapore, and Australia, Dr. Haresh Adwani has compiled the ten most important NRI tax questions that arise during the return transition. Each of these has significant financial implications if not addressed in advance.

    1. When exactly will I become Resident, RNOR, or ROR in India? 

    Your status depends on your physical presence over multiple financial years. Calculating this accurately determines your tax liability strategy.

    2. If I sell my US or UK stocks after returning, where will the capital gains be taxed?

     Gains on foreign stocks can be taxed in both India and the country where the assets are held, unless DTAA provisions apply. Selling while still RNOR can make a significant difference.

    3. How can I avoid double taxation between India and my country of work? 

    India has Double Taxation Avoidance Agreements (DTAA) with over 90 countries. Understanding which provisions apply to your income type is crucial.

    4. Can I claim Foreign Tax Credit (FTC) in India for taxes already paid abroad? 

    Yes, under Rule 128 of the Income Tax Rules, you can claim credit for foreign taxes paid. However, the process requires Form 67 and specific documentation.

    5. What happens to my foreign bank accounts and investments once I become a resident?

     Your NRE and FCNR accounts must be re-designated to RFC (Resident Foreign Currency) accounts. Failure to do so is a FEMA violation with serious penalties.

    6. Do I need to report foreign assets in my Indian income tax return? 

    Absolutely. Once you become a full Resident (ROR), you must disclose all foreign assets, accounts, and income in Schedule FA of your ITR. Non-disclosure attracts severe penalties under the Black Money Act.

    7. Should I sell some investments while I am still RNOR rather than waiting until ROR? 

    In many cases, yes. Since foreign income is not taxable during the RNOR period, strategic divestment of foreign assets during this window can produce significant tax savings.

    8. How are RSUs, ESOPs, and stock compensation from foreign employers taxed in India? 

    This is complex. RSUs may be taxed both when they vest (as salary income) and when sold (as capital gains). DTAA provisions and the nature of your resident status at both events determine the outcome.

    9. What are the tax implications if I sell property in India after returning? 

    The tax treatment depends on the holding period, whether you are RNOR or ROR at time of sale, and available exemptions under Section 54 or 54EC of the Income Tax Act.

    10. How can I bring my foreign savings to India in a legal and efficient way? 

    FEMA governs the repatriation of foreign funds. The RFC account and LRS (Liberalised Remittance Scheme) framework provides structured pathways to bring money in compliantly.

    Real-World Example: IT Professional Returning from the US

    Rajesh S., Software Engineer San Francisco to Pune

    Rajesh worked in the US for 14 years on an H-1B visa and decided to return to India in July 2025. He had accumulated USD 280,000 in a US brokerage account (mostly tech stocks with significant unrealised gains), USD 95,000 in a 401(k) retirement account, and owned a property in Pune generating ₹18 lakh annual rent.

    Without Planning: Had Rajesh returned and immediately converted his NRE account, sold his US stocks after becoming ROR, he would have faced Indian capital gains tax on the full appreciation potentially ₹40–50 lakh in additional tax liability, plus mandatory disclosure of all foreign assets.

    With Planning via Adwani & Company: By calculating his RNOR window (approximately 2 financial years), Rajesh sold his US stocks strategically during that period when foreign income was not taxable in India. His NRE and FCNR accounts were re-designated to RFC accounts in time. Form 67 was filed correctly to claim US tax credit. Penalty exposure was eliminated entirely.

    FEMA Compliance for Returning NRIs: What You Must Do

    The Foreign Exchange Management Act (FEMA) governs how Indian residents including returning NRIs manage their foreign currency assets, bank accounts, and international transactions. Violations under FEMA are taken seriously by the Enforcement Directorate and can attract penalties many times the value of the transaction involved.

    As per Reserve Bank of India (RBI) guidelines, the following changes must be made immediately upon returning to India as a resident:

    Account/Asset TypeAction RequiredDeadline
    NRE (Non-Resident External) AccountRe-designate to RFC or Resident Savings AccountImmediately upon change of status
    FCNR (Foreign Currency NR) AccountRe-designate to RFC accountAt maturity or immediately
    NRO (Non-Resident Ordinary) AccountRe-designate to ordinary resident savings accountImmediately upon change of status
    Foreign Bank AccountsDeclare in ITR Schedule FA; permitted to retain under FEMAAnnual ITR filing deadline
    Foreign InvestmentsDeclare and report under FEMA OI regulationsAnnual reporting cycle

    Dr. Haresh Adwani advises every returning NRI to consult an authorised FEMA practitioner as a first step not after they have returned, but three to six months before the anticipated return date. This provides time to restructure accounts, repatriate funds, and file necessary declarations without rushing.

    Learn more about our NRI FEMA Compliance Services at Adwani & Company.

    Pre-Return NRI Tax Planning Checklist

    If you are planning to return to India within the next six to eighteen months, use this checklist to ensure you enter the transition fully prepared:

    • Calculate your RNOR eligibility window based on your exact NRI years — this is your most valuable planning asset
    • Identify all foreign assets: stocks, mutual funds, retirement accounts (401k, IRA, pension), bank accounts, and property
    • Evaluate which assets to sell before returning versus during the RNOR window versus after becoming ROR
    • Check whether DTAA provisions between India and your country of residence apply to your income types
    • Arrange re-designation of NRE, FCNR, and NRO accounts to RFC before or immediately upon return
    • Obtain Form 67 documentation for claiming Foreign Tax Credit on income taxed abroad
    • Ensure your ITR includes Schedule FA for all foreign assets once you attain ROR status
    • Consult a qualified NRI tax advisor ideally one registered with ICAI and experienced in international tax

    Read our detailed guide on NRI Taxation and FEMA Compliance — A Complete Handbook for deeper coverage of each checklist item.

    DTAA Benefits: How Returning NRIs Can Avoid Double Taxation

    One of the most powerful tools available to a returning NRI is the Double Taxation Avoidance Agreement (DTAA). India has signed DTAAs with over 90 countries including the United States, United Kingdom, UAE, Canada, Australia, Singapore, and Germany. These agreements ensure that the same income is not taxed twice once in the country where it is earned and again in India.

    However, DTAA benefits are not automatic. You must actively claim them, file the correct forms, and provide the necessary documentation including Tax Residency Certificates (TRC) and Form 10F. The specific provisions vary significantly by country and income type. For instance, the India-US DTAA has specific provisions for employment income, dividends, and capital gains each with different conditions and rates.

    DTAA Quick Tip

    For NRIs returning from the UAE, note that the India-UAE DTAA was renegotiated and updated. The provisions affecting salary income and capital gains have changed. Ensure you are referencing the most current treaty text, or consult Adwani & Company for up-to-date guidance specific to your income profile.

    Conclusion: Your Return to India Deserves a Well-Crafted Tax Strategy

    Returning to India after years abroad is an emotionally significant and practically complex decision. The financial implications spanning NRI tax rules, RNOR status planning, FEMA compliance, DTAA benefits, and foreign asset disclosure require careful attention and expert guidance well before the moving date.

    The good news is that with proper NRI tax planning, the transition can be managed smoothly. The RNOR window is a legitimate and powerful tool. DTAA provisions can significantly reduce your tax burden. FEMA compliance, when handled proactively, is straightforward. The 120-day rule, once you are aware of it, is entirely manageable.

    The critical factor is timing. Tax planning done before the return preserves options. Tax planning attempted after the return or worse, after a notice from the Income Tax Department is reactive, expensive, and stressful. As Dr. Haresh Adwani consistently advises clients: the best time to plan your return tax strategy is at least six to twelve months before you board that flight home.

    Frequently Asked Questions:

    1. What is RNOR statusand how does it benifit a returning NRI?

    RNOR stands for Resident but Not Ordinarily Resident. It is a transitional tax status available to returning NRIs for a limited period typically two to three financial years after returning, depending on the number of years they were NRI. During the RNOR period, India does not tax income that is earned outside India and not received in India. This makes the RNOR window a critical opportunity to restructure foreign investments and repatriate funds tax-efficiently. Calculating your exact RNOR window is the most important first step in any returning NRI tax planning exercise.

    2. Do i need to report my foreign bank accounts after returning to india?

    Yes. Once you attain ROR (Resident and Ordinarily Resident) status, you are required to disclose all foreign bank accounts, financial assets, and income from foreign sources in Schedule FA (Foreign Assets) of your Income Tax Return. Non-disclosure is treated as a violation under the Black Money (Undisclosed Foreign Income and Assets) and Imposition of Tax Act, 2015, which prescribes severe penalties including a flat 30% tax plus a 90% penalty on undisclosed amounts. Proactive disclosure and professional guidance from a qualified NRI tax advisor is strongly recommended.

    3. How are RSUs and ESOPs from a US employer taxed when i return to india?

    RSUs (Restricted Stock Units) and ESOPs (Employee Stock Option Plans) granted by foreign employers are taxed at two points first at vesting (treated as perquisite or salary income) and again at sale (capital gains). If you are RNOR when the shares vest, there may be no Indian tax at vesting for foreign-source income. However, gains on sale after becoming ROR are fully taxable in India. The India-US DTAA may provide relief on employment income. Given the complexity, consulting a specialist NRI tax advisor who handles cross-border equity compensation is highly advisable.

    4. can keep my NRE account after returning to india?

    No. Under FEMA regulations, once your residential status changes to Resident Indian, your NRE (Non-Resident External) account must be re-designated to a Resident Foreign Currency (RFC) account or a regular resident savings account. Continuing to operate an NRE account after becoming a resident is a FEMA violation and can attract penalties under the Enforcement Directorate. The re-designation must happen promptly upon change in status. Similarly, FCNR accounts must be re-designated to RFC accounts at maturity.

    5.Is the 120-day rule applicable to all NRIs only thoes with high indian income?

    The 120-day rule applies specifically to NRIs whose Indian income exceeds ₹15 lakh in the relevant financial year. If your Indian income is below this threshold, the standard 182-day rule applies for determining NRI status. However, if your Indian income from sources such as rent, salary from Indian companies, or interest from NRO accounts exceeds ₹15 lakh, then staying 120 days or more in India in a financial year, combined with a cumulative stay of 365 days in the previous four years, can make you a resident for tax purposes. Tracking your India travel days carefully is essential if you have significant Indian income.

    6.what is best time to sell foreign stock-before returning or after returning

    The timing of foreign asset liquidation is one of the highest-impact NRI tax planning decisions. Selling before returning (when you are still an NRI) means the gains are taxed only in the country where the asset is held not India. Selling during the RNOR window means the gains from foreign sources are not taxable in India under current provisions. Selling after becoming ROR means full Indian capital gains tax applies. The optimal strategy depends on the specific country, the type of asset, applicable DTAA provisions, and your income profile. Dr. Haresh Adwani and the team at Adwani & Company specialise in creating personalised divestment plans for returning NRIs.

    7. How do i claim Foreign Tax Credit(FTC) in india?

    Foreign Tax Credit in India is governed by Rule 128 of the Income Tax Rules, 1962. To claim FTC, you must file Form 67 on the income tax e-filing portal before the due date of your return. You will need documentation including a tax payment certificate or withholding statement from the foreign country confirming the taxes paid. The credit is available against the Indian tax payable on the same income, up to the Indian tax liability on that income. FTC cannot create a refund it can only reduce your Indian tax to zero on the relevant income. Missing the Form 67 deadline means losing the credit entirely.

    Author

    CA. Manish R. Mata Practising In India (Ex – PwC),  At Adwani & Co LLP leads the International Accounting & Tax Support vertical, delivering structured execution assistance to US CPA firms and overseas businesses.

  • Ultimate Financial Modeling to Normalize Business Valuation in India

    Ultimate Financial Modeling to Normalize Business Valuation in India

    CA Manish Mata May 2026 10 min read

    An experienced founder sat across prospective investors for his business fundraising exercise. On paper, his company’s earnings per share (EPS) was ₹63 impressive, but not spectacular. Yet the founder believed the true earning capacity was closer to ₹82. The investors were skeptical. Financial modeling for business valuation plays a critical role in how investors assess a company’s true earning potential.

    That changed the moment he presented a financial model. Through scenario-based analysis and transparent normalisation of non-recurring costs, the team arrived at a normalised EPS of ₹79. Nobody challenged the number not because it was high, but because the logic behind it was airtight.

    This is the central insight of modern business valuation: investors care far more about the story and rigour behind the numbers than the numbers themselves. It is a principle that CA Dr. Haresh Adwani and the team at Adwani and Company have applied across hundreds of fundraising in India.

    Key takeaway A well-structured financial model can lift your business valuation by 30 to 40% not by inflating numbers, but by making the true earning power visible and defensible to investors.

    Benefits of Financial Modeling for Business Valuation


    • Improves investor confidence
    • Makes valuation assumptions transparent
    • Highlights true earning potential
    • Increases chances of higher valuation

    What Is Financial Modeling for Business Valuation in India?

    Financial modeling is the process of creating a structured representation of a business’s financial performance, usually in Excel or specialized software. It helps founders, investors, and analysts understand a company’s earning potential, cash flows, and valuation under different scenarios. By clearly modeling assumptions, revenues, and costs, investors can make informed decisions rather than relying solely on past financial statements.

    Financial modeling for business valuation in India can significantly improve valuation through normalized EPS adjustments and scenario analysis

    How to Calculate Normalized EPS (Step-by-Step)

    1. Start with reported net income: Take the net profit from your financial statements.
    2. Identify non-recurring items: Include one-time costs, extraordinary gains, or temporary losses.
    3. Adjust for these items: Add back non-recurring expenses or subtract non-recurring income.
    4. Divide by total shares outstanding: This gives the normalized earnings per share.

    Formula for Normalized EPS

    Normalized EPS = Adjusted Net Income 
                    Total Shares Outstanding

    Example: If adjusted net income is ₹5.52 crore and shares outstanding are 6,70,000, Normalized EPS = ₹82.39.

    Example of a Financial Model for Business Valuation (India)

    Imagine a mid sized Indian manufacturing company projecting its revenue for the next 3 years:

    • Historical revenue: 10–12 crore
    • Adjustments for non recurring expenses: 1.5 crore
    • Normalized EBITDA: 3.8 crore
    • Scenario analysis: Base, Upside, Downside
      The model shows investors exactly how the company arrives at a normalized EPS of Rs.79, making valuation credible and defensible.

    1. How Business Valuation Has Changed: From Multiples to Models

    The old approach vs. the modern standard

    Until roughly a decade ago, Indian business valuations were largely mechanical: take the last three years’ profits, apply an industry multiple, arrive at a figure. A company with 10 crore profit valued at 10× equals 100 crore. Simple.

    The 2008 global financial crisis changed this permanently. Companies with impressive reported earnings collapsed because those earnings were not sustainable. Sophisticated investors especially institutional funds and PE firms learnt to demand transparency in the assumptions that drive valuations, not just headline figures.

    Why founders who model well get better valuations

    Consider two founders approaching the same investor with the same underlying business. Founder A presents raw historical financials. Founder B presents a normalised model with documented adjustments, three growth scenarios, and sensitivity tables.

    Founder B almost always gets a higher valuation and closes faster. The model does not change the business; it makes the business understandable to the person writing the cheque.

    2. What Is a Financial Model? Core Components Explained

    A financial model is a structured hypothesis about how your business creates value. It is not a prediction predictions are always wrong. It is a framework that makes the assumptions visible, so investors can agree or disagree with specific inputs rather than rejecting the entire valuation.

    The four layers of a credible valuation model

    • Historical analysis (3–5 years): Revenue trends, cost structure, margin evolution, and cash conversion efficiency. This anchors the model in reality.
    • Normalisation layer: Adjustments that remove one time, non recurring, or distorting items from reported earnings. This reveals the true earning power of the business.
    • Forward projections: Revenue and cost forecasts tied explicitly to operational drivers not just a straight line trend.
    • Scenario and sensitivity analysis: At minimum, a base case, a downside case, and an upside case, with clear articulation of the key variables in each.

    Also Read:

    Common Business Valuation Methods in India

    There are several approaches to valuing businesses in India, each suitable for different types of companies:

    1. Market Multiples Method : Valuation based on industry P/E or EBITDA multiples.
    2. Discounted Cash Flow (DCF) Method :Projected cash flows discounted to present value.
    3. Asset-Based Valuation : Total assets minus liabilities.
    4. Comparable Transactions : Benchmarking against similar business deals in India.

    Using financial modeling with normalized EPS complements these methods by making projections transparent and credible.

    3. Case Study: From Reported Rs.63 EPS to Normalised Rs.79 EPS

    The situation

    A mid-sized manufacturing business approached investors for growth capital. The reported financials showed:

    • Reported net income: 4.21 crore
    • Shares outstanding: 6,70,000
    • Reported EPS: 63
    • Founder’s assessment of true earning capacity: 82 per share
    • Investor challenge: Unwilling to value on the higher figure without proof

    The normalised EPS calculation

    The financial model identified four documented, non recurring cost items that had depressed reported earnings in that year:

    Earnings Adjustment ItemAmount (₹ lakh)
    Reported net income₹4.21 crore (base)
    + Pandemic margin impact (documented, non-recurring)+ ₹42 lakh
    + Operational efficiency gains (one-time restructuring)+ ₹28 lakh
    + Restructuring costs (non-recurring, with board approval)+ ₹42 lakh
    + Supply chain losses (temporary, COVID-linked)+ ₹19 lakh
    = Normalised net income₹5.52 crore
    ÷ Shares outstanding6,70,000
    = Normalised EPS₹82.39 (rounded to ₹79 for conservatism)
    Why ₹79 and not ₹82? The model deliberately rounded down to ₹79 slightly below the founder’s own estimate to signal conservatism and credibility. In investor negotiations, a number that is lower than what the management claims is always more trusted than a number that conveniently matches it.

    4. The Valuation Impact: A 36.4% Uplift Explained

    Using the standard 12× EBITDA multiple common in Indian SME and mid market business valuations, here is the direct financial impact of having a credible model:

     Without model (reported)With credible model (normalized)
    EBITDA used₹2.83 crore₹3.86 crore

    ( Normalized Net Income ₹ 5.52 crore * EBITDA Margin = 70% (typical for this business))
    Multiple applied12×12×
    Business valuation₹33.96 crore₹46.32 crore
    Valuation Increase from Financial Modeling—+₹12.36 crore (+36.40%)

    This 12.36 crore difference did not come from cooking the books. It came entirely from making visible what was already there non-recurring costs that had temporarily suppressed earnings, documented in detail so investors could verify them independently.

    3. Common Mistakes Founders Make in Financial Modeling

    Based on deal experience, these are the most frequent errors that undermine credibility with investors:

    Normalising without documentation

    Adjusting reported earnings upward without a paper trail board resolutions, auditor notes, or third party invoices confirming the non-recurring nature of costs is the fastest way to lose investor trust. Every adjustment needs a corresponding document.

    Presenting only the upside scenario

    A model with no downside case signals that the founder has not stress-tested their own assumptions. Sophisticated investors will immediately ask: what does this look like if revenue grows at 8% instead of 20% Have that answer ready.

    Hockey stick projections without operational justification

    Revenue projections that suddenly accelerate in Year 3 without a documented operational reason a new plant coming online, a signed distribution contract, a regulatory approval are dismissed immediately. Growth assumptions must be grounded in real operational milestones.

    In these contexts, a professionally built model does more than present numbers it demonstrates that the business is being run with institutional grade financial discipline.

    Conclusion: Credibility Is Built Before the Meeting

    The most important thing a founder can bring to an investor meeting is not the highest number it is the most defensible number. A normalised EPS of Rs.79 backed by documented evidence and transparent methodology will outperform an unsupported claim of Rs.100 every time.

    Financial modeling for business valuation is not an accounting exercise. It is a credibility building process that tells the story of your business’s true earning power in a language investors are trained to trust.

    Whether you are raising your first round, preparing for acquisition, or simply want to understand what your business is genuinely worth, the investment in a rigorous financial model pays for itself many times over.

    Benefits of Financial Modeling for Business Valuation

    1. What is the difference between reported EPS and normalised EPS?

    Reported EPS reflects actual earnings for a specific period, including one-time events, disruptions, and non-recurring costs. Normalised EPS adjusts for those items to show what the business would consistently earn under typical operating conditions. In the case study above, reported EPS was Rs.63 while normalised EPS was ₹79 a 25% difference that directly affects what multiple an investor is willing to apply.

    2. Should I always present a normalised EPS to investors?

    Only if every adjustment is supported by documented evidence that the cost or revenue impact is genuinely non-recurring. Investors will verify each item in due diligence. An unsupported upward adjustment damages credibility more than presenting the lower reported number.

    3. What is financial modeling in simple terms?

    Financial modeling is creating a structured representation of a company’s financial performance to help decision-making, plan scenarios, and communicate valuation transparently to investors.

    4. Why do investors prefer normalized EPS?

    Investors prefer normalized EPS because it removes one-time or non-recurring items, showing the company’s true earning potential, making valuations more reliable and defensible

    Author

    CA. Manish R. Mata Practising In India was associated with PwC,  At Adwani & Co LLP leads the International Accounting & Tax Support vertical, delivering structured execution assistance to US CPA firms and overseas businesses.