▲ 7 r/financialmodelling+2 crossposts

Financial & Valuation Modelling for Any Listed Company Using Real-Time Data (with Formula-Based Excel Export)

Hi everyone,

As a CA Finalist, I've been working on this project over the past few months. The idea was to see how much of the equity research and financial modelling workflow could be automated while still keeping the outputs fully editable.

It pulls live market data, generates forecast assumptions based on historicals (which can be edited), builds integrated financial statements and valuation models, and exports a fully formula-linked Excel model or a research report.

I've also experimented with adding DCF valuation, sensitivity analysis, forensic metrics (Beneish M-Score, Altman Z-Score, etc.), risk analysis, earnings call analysis, and industry & market research into the workflow.

I'm interested in hearing from people who build financial models regularly. Are there any modelling standards, Excel practices, or workflows you'd expect to see that I may have overlooked? Any technical feedback or suggestions would be appreciated.

u/nikhil_pratap — 7 days ago

Built a Bloomberg-lite equity research terminal as a CA student.

Been working on it for a few week along with office works + studies and somehow ended up with an actual Lite - institutional equity research platform — Meridian Terminal

Live market data, deep equity analysis — company analysis, financial statements, ratio analysis, forensic accounting flags, valuation modelling, DCF, screener, portfolio tracker, and a bunch of other tools I kept adding at 2am because why not.

About Me - 19M, I'm a Big 4 audit trainee. I just knew what I wanted it to look like.

Drop Your suggestions and reviews or whatever you want to comment.

u/nikhil_pratap — 18 days ago

CA Finalist at KPMG - Built a Live Market Research Platform

19M, CA Finalist, currently working at KPMG.

Over the last few weeks, I've been building an equity research platform alongside work and studies.

The platform uses live market data from multiple stock exchanges and indices, and the analysis updates based on current data rather than static datasets.

It covers things like company analysis, financial statement analysis, Valuation Modelling, earnings call analysis, risk assessment, Industry Market Screenr, Summarized Report.

Sharing a full video of its working.

Would genuinely appreciate feedbacks !!

u/nikhil_pratap — 22 days ago

Industrial Trainee - Raw Resume Review

About me - 19M, CA Final student currently pursuing articleship at KPMG in Statutory Audit. Near to end of 1st year of articleship in 55 Days

Based on my experience, projects, and profile, would you recommend FP&A, Valuation, Equity Research, Investment Banking, Corporate Finance, Consulting, or any other fields? Also open to suggestions on improving my profile.

Resume attached. Thanks in advance.

u/nikhil_pratap — 24 days ago

KPMG Articleship - built a gamified fintech learning platform solo — Vanilla JS, Firebase Auth, Firestore, Google APIs, zero frameworks

Not a developer. CA student at KPMG Mumbai.

Built Financial Intelligence Arena because I couldn't find any interactive platform for learning startup finance. Most resources explain concepts, but very few let you actually simulate them.

The platform includes:

• Startup fundraising journey (Seed → Series A → IPO)
• Valuation models (DCF, multiples, comparables)
• ESOP and founder dilution simulations
• DRHP and due diligence analysis
• Gamified challenges, XP, achievements, and leaderboards

Built using Vanilla JS, HTML/CSS, Chart.js, Firebase Auth, Firestore, and Google APIs.

Had no prior backend experience, so learning and integrating cloud-based authentication, user accounts, and progress syncing was a challenge in itself.

Took about 1.5 weeks excluding research phase and ~30 versions to current deployment.

Would love your feedback on it.

🔗 in the comment section/ or DM me

u/nikhil_pratap — 1 month ago

Spent months reading about Razorpay, Freshworks & BYJU'S — then built an interactive simulator so anyone can experience their financial journey

Every time I read about a funding round, startup valuation, or IPO, I found myself thinking:

"Reading about it is one thing. Could I actually model it myself?"

So over the last 1.5 weeks, I built Financial Intelligence Arena — an interactive platform that lets you simulate a startup's financial journey from Seed funding all the way to IPO.

Some things inside:

• Fundraising simulator (Seed → Series A → Unicorn → IPO)
• ESOP dilution and cap table mechanics
• Startup valuation models used by investors
• DRHP forensic analysis with real-world red flag scenarios
• Case studies based on companies like Freshworks, Razorpay and BYJU'S
• Progress syncing across devices using Firebase

The goal wasn't to build another finance course. I wanted something more hands-on and simulation-driven.

Built solo as a CA student currently working at KPMG.

It's completely free. Open for suggestions.

u/nikhil_pratap — 1 month ago

As a CA Finalist, I Spent 1.5 Weeks Building a gamified Finance Simulation Platform for Startup Valuation, ESOPs & IPO Due Diligence — Would Love Your Feedback Rant

Hi fellow Redditors,

I'm currently a CA Finalist nearing the end of my first year of articleship at KPMG - Statutory audit domain. During this period, I was fortunate to receive KPMG's Impact Award, nominated by a Senior Partner.

The reason I'm posting, however, has nothing to do with audit.

It is about a question that turned into a side project,

Over roughly 1.5 weeks of actual development time (excluding research), I built an platform - Financial Intelligence Arena - which is an interactive learning platform which can also be used as a tool primarily focused in Business & ESOP valuations, DRHP Due diligence and Fundraising scenario analysis.

The funny part is that I had almost no experience building websites before this.

So apart from designing/researching the finance side, I also had to learn authentication, APIs, frontend development, deployment, user flows, and a lot of things that broke repeatedly before finally working.

The current version is the result of nearly 30 redesigns and iterations.

I'm sure there are things that don't make sense, features that add little value, bugs I haven't discovered, and concepts that could be explained much better.

That's exactly why I'm posting it here.

If you spend a few minutes exploring it, I'd genuinely appreciate honest feedback.

Link in comment or Dm (for anyone interested in trying it)

Looking forward to hearing your thoughts - below is animated intro video.

https://reddit.com/link/1tswm9h/video/yzxgfeiieh4h1/player

reddit.com
u/nikhil_pratap — 1 month ago