Rojin Sapkota

About Me

I'm Rojin Sapkota, a Chartered Accountant based in Kathmandu, Nepal, with specialized expertise in financial modeling, corporate valuation, advisory in the field of finance, taxation & corporarte laws, financial reporting, and investment. With a strong foundation in both theoretical knowledge and practical application, I deliver data-driven solutions that drive informed business decisions.

Professional Background

My professional journey includes audit articleship at CSC & Co. (covering commercial banks, hydropower, and internationally funded projects), roles as Finance Controller and Research Analyst at Ideapreneurnepal, and finance and operation experience at Nabil Stock Dealer Limited. This diverse background has equipped me with deep insights into financial markets, corporate finance, and investment analysis.

Core Competencies

• Taxation: Income tax planning, corporate tax strategy, NFRS-based reporting, VAT, excise and customs compliance
• Financial Reporting & Analysis: IFRS/NFRS consolidated statements, variance analysis, budgeting, and forecasting
• Valuation & Investment Advisory: Equity valuation (DCF, comparable multiples, asset-based), M&A analysis, IPO readiness
• Financial Modeling: 3-statement models, scenario analysis, sensitivity testing, complex cash flow projections
• Data Visualization & Automation: Power BI dashboards, advanced Excel, Power Query ETL, VBA automation
• Auditing: NSA compliance, SOX 2002, internal controls, risk assessment, IS Audit

Certifications & Qualifications

Philosophy

I'm committed to delivering clear, actionable insights through rigorous financial analysis. I specialize in translating complex financial data into strategic recommendations that support business growth and risk management. Whether you need comprehensive valuation models, tax optimization strategies, or interactive analytical dashboards, I provide professional-grade deliverables backed by industry best practices.

Core Expertise

1. Financial Modeling & Forecasting

• 3-statement financial models (P&L, Balance Sheet, Cash Flow)
• Scenario analysis, sensitivity testing, and stress testing
• Revenue forecasting and working capital modeling
• DCF valuation models with varying discount rate assumptions
• Budget vs. actual variance analysis and KPI tracking

2. Valuation & Investment Advisory

• Equity valuation using DCF, comparable multiples, and precedent transaction analysis
• Private company valuations for M&A, fundraising, and strategic planning
• Accretion/dilution analysis for corporate transactions
• IPO readiness assessments and market positioning
• Real estate and asset valuation in Nepal's financial market context

3. Taxation & Compliance

• Income tax planning and optimization strategies
• Corporate tax compliance under NFRS framework
• Deferred tax accounting (IAS 12 / NAS 12)
• Tax-efficient restructuring and succession planning
• VAT/GST management and regulatory compliance

4. Financial Reporting & Analysis

• IFRS and NFRS-compliant consolidated financial statements
• Goodwill impairment testing and asset valuations
• Lease accounting under IFRS & NFRS 16
• Defined benefit pension obligations (NAS & IAS 19)
• Comprehensive variance and variance root-cause analysis

5. Advanced Excel & Data Analytics

• Dynamic PivotTables, VLOOKUP, INDEX-MATCH, and array formulas
• Power Query for data extraction, transformation, and loading (ETL)
• VBA macros for automated reporting and process efficiency
• Power BI dashboards for interactive visualization and KPI monitoring
• Python-based web scraping (requests, BeautifulSoup, Selenium)

6. Auditing & Internal Controls

• ISA 200-series audit planning and execution
• SOX 2002 compliance and control environment assessment
• Risk assessment and materiality calculations
• Fraud detection and internal audit advisory