Hello, I'm Anshul Rana

University of Michigan Junior, Majoring in Business Administration and Minoring in Computer Science

Download Resume

About Me

I am an ambitious junior at the Ross School of Business pursuing a BBA and minoring in Computer Science, with a passion for the intersection of Finance and Technology.

At Michigan, I have been furthering my interests in these fields through numerous extracurriculars and challenging coursework. This has helped me develop into a more educated individual during my short-time in Ann Arbor.

In my free time, I enjoy playing the guitar, going for a round of golf, watching some NFL (Go Big Blue!), and playing basketball with friends.

My Education

September 2019 - Present

University of Michigan

Bachelor of Business Administration, Minor in CS
  • Concentration in Finance and Accounting
  • Minor in Computer Science
  • GPA: 3.96/4.00
  • Academic Year Investment Banking Analyst at Demopolis Capital
  • SAT: 1580/1600 (Math: 800, Reading and Writing: 780) | National AP Scholar

My Experience

The Amazing Group

Investment Banking Summer Analyst

  • Created a DCF model for a German biotechnology recovery company, breaking down their revenues by specific genomics and lifestyle segment growth over the next 6 years, and compiled the valuation into a pitch deck to help negotiate with multiple interested buyers
  • Involved in the capital raising of one of the largest US real estate investment firms across diversified assets, and analyzed the 5-year and 10-year CAGR in order to help develop an investor pitch deck for future capital raising, driving more client investment in the short-term
  • Examined financials of another German biotechnology company, in order to understand their business model and adjust their valuation according to geographic growth, and then learned about and created an earnout model to help negotiate a fair payment price with an acquirer

Maize and Blue Endowment Fund

Analyst

  • Managed University of Michigan's $500,000 mid-cap-focused, student-run, endowment fund alongside cohort of 40 BBA/MBA students, enhancing understanding of equity and credit markets, with a return of nearly 27.9%, outperforming S&P Midcap 400 by 4% annually
  • Formulated pitch for ViaSat [NASDAQ: VSAT] based on the company’s product ingenuity, strong R&D capabilities, new satellite opportunities, and expansion into new countries

TO 415 and 515

Teaching Assistant

  • Aided students in learning VBA through office hours to help clear up different concepts and advanced objects in VBA

WaiV Technology Partners

Investment Banking Summer Analyst

  • Researched the conversational AI industry and its applications in customer service, information technology, marketing and sales, and HR in order to understand future trends
  • Created presentations on previous M&A, buyer profiles, and investor profiles in the conversational AI industry to help inform clients on current activity and to suggest possible investment activity that would benefit larger companies and VCs as the industry grows
  • Participated in calls with startups to understand their business model and where in the startup cycle they were in order to advise a possible M&A deal or help them secure funding

Michigan Investment Banking Club

Analyst

  • Educated members by leading market updates focused on market events and transactions as an analyst selected from 200 applicants to participate in club's professional and technical development seminars on accounting, finance, modeling, and valuation methodologies
  • Completed valuation slide deck for Dollar General [NYSE: DG] consisting of DCF, precedent transactions, and comparable companies analyses to conclude Dollar General is undervalued with 20% implied upside on current share price, presented findings to senior members
  • Pitched acquisition of Take-Two Interactive [NYSE:TTWO] by Amazon [NASDAQ: AMZN] for the Citi Bank M&A Case Competition, citing the growth of video game-streaming technology, the comparative advantage that exclusivity of video game IPs can bring, and potential for Prime Video growth through exclusive IP, selected as one of 3 finalist teams from 40 total teams

Global Investments Committee

President

  • Determined portfolio investments through weekly news debates, research on Real Estate equities, stock pitches, and pitch competitions, helping to manage a $25,000 student-run fund
  • As President of the fund, helped with day-to-day oversight of meetings, managing 7 pitch desks for fact-checking and vetting all pitches, assisting in a mentorship pairing initiative with club members and alumni, and aiding in the creation of a new school-wide pitch competition
  • Pitched American Tower Corporation [NYSE:AMT] long in Fall of 2019 citing growth of 5G/IoT Technology and necessity for macro cell towers as main growth catalysts; built DCF model for REIT and concluded 7% implied upside; realized an 11.5% return within 4 months
  • As desk head of Emerging Markets, pitched Millicom Celullar [NASDAQ:TIGO], citing potential market growth in Latin America with e-commerce and technological and divestiture from lower performing markets, initiated 5% position and realized 40% upside within 2 months

Boy Scouts of America

Eagle Scout, Patrol Leader

  • Created a community library box as a part of the Little Free Library Program, an organization which donates books and create accessibility for communities, for Eagle Scout Project and instructed 15 fellow scouts and friends on how to fundraise for and construct library box
  • Fundraised nearly $1500 through community events such as bake sales and car washes and contacted local businesses for sponsorships and donations in order to raise money for Eagle Project towards important materials, permits, and books necessary for its completion

Anlight Consulting Services

HR Intern

  • Aided in implementation of different resources throughout office space such as Microsoft Office and in development and management of a company website, helping to increase worker productivity by nearly 10% and streamlining any technical issues in workspace
  • Developed a presentation for client pitches about benefits of integrating cutting-edge human resource technology in order to increase efficiency in selecting desirable candidates, leading to a higher rate of success in client acquisition and extended client retention over long run

My Skills

Finance and Accounting

Experienced in financial analysis of companies, including reading through financial statements on 10-Ks, finding comparable companies, researching precedent transactions, and creating a DCF Model. Skilled in the use of FactSet and Bloomberg for research

Coding

Expertise in coding in the languages of C++, Java, Python, and VBA. Knowledgeable in HTML5, and CSS3. I have coded numerous projects such as card games that run through command line and a twitter bot that can generate headlines using machine learning data

Microsoft Excel and Office

Able to efficiently use Excel and other Microsoft Office applications like Powerpoint and Word for financial analysis and presentations. Skilled in creating DCFs using excel and have an understanding of using functions, linking between sheets, and creating useful graphics

Knowledge of Various Languages

Native English speaker, reader, and writer and talented at public speaking and debating. Bilingual certification from the State of New Jersey as a Spanish speaker, reader, and writer. Very fluent and conversational in speaking Hindi

Leadership

Served as Vice President and President of student orgs on campus. In addition, served as a volunteer tutor and volunteer firefighter, both of which taught me about leadership to others

Interests

In my free time, I love to play the guitar, I have both an acoustic and an electric. I am huge NY Giants and NY Knicks fan and eagerly await another title in New York. I love to watch old movies, favorite is Pulp Fiction

My Projects

Big Data Report

A report I made by analyzing nearly 10,000 company data points to compare valuations pre and post-tech boom

December 2021 Download Doc

NASDAQ:TIGO

Made this DCF as the desk head of Emerging Markets for an international company called Millicom Cellular who specialized in Latin American Telecommunications

October 2020 Download Spreadsheet

NASDAQ:APPN

This was for an application as a mid-cap equity pitch for the Maize and Blue Endowment Fund of a new tech company focused on Robotic Process Automation

September 2020 Download Spreadsheet

NYSE:CLX

Made this for a case competition with a fully functioning Bear, Base, and Bull case

December 2020 Download Spreadsheet

NYSE:TTWO

Made this DCF as a part of the Citi Bank M&A Case Competition with my teammates. It was made for an acquisition of Take-Two Interactive, a well-known video game developer by Amazon (NYSE:AMZN)

February 2020 Download Spreadsheet

Sample Pitch

This is a sample slide deck I worked on for a case competition in one of the clubs I am a part of on campus. It details the valutaion of Dollar General (NYSE:DG)

December 2019 Download Presentation

View the Source Code to this Website

This website is a culmination of weeks of work and leverages many different components to give the overall look and effect. View the source code on GitHub

May 2020 View Repository