Mangusta Capital Externship via Extern

Junior finance student building automated valuation tools

I create DCF models, automate company valuations, and analyze startup deals while learning SQL, Excel, and AI-driven data tools.

View my work Message Me

Work samples

My portfolio includes a 10-year Tesla DCF and Valynt.app, a deployed platform that automates multi-year DCFs, financial statement normalization, and valuation visualizations.

Tesla DCF | Source Code | Jupyter Notebook
Tesla DCF | Source Code | Jupyter Notebook
Created a 10-year DCF model for Tesla using the last 5 years of financial revenue data and projected revenue from $91.99B in 2026 to $133.02B in 2035 based on evaluated assumptions. Modeling operating margin expansion from 3.7% to 9.5% projected FCF growth from $0.37B to $15.98B, and Discounted Cash Flows at a 14.86% WACC. Evaluated Tesla at $58.44B enterprise value, and a base implied value of roughly $16.56 per share, created a 3x3 variable WACC/Terminal Growth sensitivity table with a $12.48-$26.26 per share range.
Jupyter Notebook
Automated DCF Valuation Platform | Valynt.app
Automated DCF Valuation Platform | Valynt.app
Built and deployed a private company valuation tool automating 5-10 year FCFF based DCF models, generating projected FCF, terminal value, equity value, enterprise value, resulting in implied share price on demand. Developed an AI native financial statement analyzer and normalization process, cleans up 30+ line items across income statement, balance sheet, and cash flow statements to support automated valuation modeling. Presented platform to financial advisory firms as a valuation visualization tool, reached 200+ organic visitors, showcased real-world application.

About me

I create DCF models, automate company valuations, and analyze startup deals while learning SQL, Excel, and AI-driven data tools.

I am Abhi Rastogi, a junior at the University of Tennessee Knoxville studying Finance with a Business Analytics concentration and an AI minor. I build financial models, automate valuation workflows, and analyze startups through an active Mangusta Capital externship while sharpening technical skills like SQL, Excel, and Jupyter Notebook.

Externships

Mangusta Capital Deal Sourcing & Startup Analysis Externship

Mangusta Capital

Education

University of Tennessee Knoxville, Haslam School of Business

Bachelor's of Finance in Concentration of Business Analytics with Artificial Intelligence Minor · Class of 2028

Skills

Financial ModelingDCF ValuationFinancial Statement AnalysisMicrosoft ExcelPowerpointSQLJupyter NotebookBloomberg TerminalEnglishHindi

Back to work

Tesla DCF | Source Code | Jupyter Notebook

Created a 10-year DCF model for Tesla using the last 5 years of financial revenue data and projected revenue from $91.99B in 2026 to $133.02B in 2035 based on evaluated assumptions. Modeling operating margin expansion from 3.7% to 9.5% projected FCF growth from $0.37B to $15.98B, and Discounted Cash Flows at a 14.86% WACC. Evaluated Tesla at $58.44B enterprise value, and a base implied value of roughly $16.56 per share, created a 3x3 variable WACC/Terminal Growth sensitivity table with a $12.48-$26.26 per share range.

Jupyter Notebook

View all work

Back to work

Automated DCF Valuation Platform | Valynt.app

Built and deployed a private company valuation tool automating 5-10 year FCFF based DCF models, generating projected FCF, terminal value, equity value, enterprise value, resulting in implied share price on demand. Developed an AI native financial statement analyzer and normalization process, cleans up 30+ line items across income statement, balance sheet, and cash flow statements to support automated valuation modeling. Presented platform to financial advisory firms as a valuation visualization tool, reached 200+ organic visitors, showcased real-world application.

View all work