This repository contains the complete analytical model used for my cross-market corporate research comparing India and the United States across 11 major sectors. The financial model integrates ROCE-PE analysis, fundamental scorecards, sector heatmaps, risk-return maps, Risk-Adjusted Performance Index, Composite Attractiveness Score models for both economies. This repo serves as a transparent, structured view of the analytical backbone used in my research paper "Decoding India and US Corporate Landscape: Cross-Sector Fundamentals and Outlook to 2030".
Cross-market-financial-models-2020-2030 │ ├── Financial Model/ │ ├── Cross-Market-Financial-Model.xlsx ← Main Model (India + US) │ └── README.md │ ├── India/ │ ├── RAPI.png │ ├── Heatmap.png │ ├── CAS.png │ └── README.md │ └── US/ ├── RAPI.png ├── Heatmap.png ├── CAS.png └── README.md
-
Cross-Market ROCE-PE Framework Analyzes valuation efficiency across markets and identifies mispricing gaps.
-
Fundamental Pillar Scorecards Evaluates 5 pillars:
Profitability Efficiency Leverage Growth Valuation
-
RAPI (Risk-Adjusted Performance Index) Ranks sectors on a risk-adjusted basis using stability, return quality, and leverage impact.
-
CAS (Composite Attractiveness Score) Combine fundamentals + macro + risk to generate a strategic allocation matrix.
This repo is designed to demonstrate:
Financial Modelling competence Multi-sector analytical capability Data harmonization across markets Transparency behind research outputs Portfolio construction logic
This repository will continue to grow as additional models and dashboards are published.
Akshat Gupta Email: akshatgupta13427@gmail.com LinkedIn: www.linkedin.com/in/akshat-gupta-2100ag