Abhinay Ranjan

ABHINAY RANJAN Mobile: - E-Mail:-JOB PROFILE SUMMARY Work Experience - Approx. 7.5 years Jan 2021– Present • In the capacity of consultant, I am responsible for business development and project execution of mandates for Pan India. My experience in undertaking multi-faceted real estate assignments including valuation studies, location advisory, feasibility studies, highest & best use and market assessment across asset classes in major Tier I, II & III cities, has enabled depth to the professional capabilities • Active contributor in delivering strategic value & insightful knowledge across asset classes & markets, geographies & project lifecycle CORE COMPETENCIES: • Financial Analysis and Strategy • Financial Modelling & Scenario Analysis • Client Relationship Management & Co-ordination Meraqi Advisors Manager, Consulting and Valuation, North India Responsibilities: Jan 2021– Present • CRM and responsible for providing Valuation & Advisory services for Real estate assets for pre-investment, post investment, accounting and reporting purposes, across asset classes to clients including Developers, Corporate, Private Equity, Leading Banks and NBFCs amongst others. • Valuation of numerous residential assets like Residential Township, Commercial offices, Retail Mall and Hotels applying different methodology like DCF, Residual income, Income Capitalization, Cost • Writing and reviewing reports, valuing properties and conducting research for various types of asset classes using various methods wherever required depending on the kind of assignment. • Advisory on current and projected value of real estate, related investment and report writing on detailed analysis done of the property from Macro to Micro level • Responsible for comprehensive market analysis including market research survey & supply – demand analysis, micro market analysis, compartive and benchmarking analysis & project profiling for various national & regional developer to assist in their real estate strategy decision making, including but not limited to acquisition, product development mix, pricing strategy, project planning & phasing strategy, disposition strategy, etc. Key Assignments: • TDD and Valuation of plotted development asset located in Bangalore • Market research study of retails assets for opportunities involved in sale and lease back among institutional investors located in Raipur and Nagpur • Feasibility study and financial analysis of study of two land parcels admeasuring 6.41 and 18 acres located in south Bangalore Resurgent India Pvt. Ltd. Key Senior Manager, Consulting and Valuation, North India August 2020– Nov 2020 Responsibilities: • Business Development, CRM and responsible for providing Valuation & Advisory services for Real estate assets for pre-investment, post investment, accounting and reporting purposes, across asset classes to clients including Developers, Corporate, Private Equity, Leading Banks and NBFCs amongst others. • Valuation of numerous residential assets like Residential Township, Commercial offices, Retail Mall and Hotels applying different methodology like DCF, Residual income, Income Capitalization, Cost. • Writing and reviewing reports, valuing properties and conducting research for various types of asset classes using various methods wherever required depending on the kind of assignment. • Advisory on current and projected value of real estate, related investment and report writing on detailed analysis done of the property from Macro to Micro level Key Assignments: • Submission of various empanelment documents to private and public banks for valuation and consulting mandates Quikr Realty Limited (Erstwhile HDFC Realty) Manager, Consulting and Valuation, North India July 2019- July 2020 Key Responsibilities: • CRM and responsible for providing Valuation & Advisory services for Real estate assets for pre-investment, post investment, accounting and reporting purposes, across asset classes to clients including Developers, Corporate, Private Equity, Leading Banks and NBFCs amongst others. • Valuation of numerous residential assets like Residential Township, Commercial offices, Retail Mall and Hotels applying different methodology like DCF, Residual income, Income Capitalization, Cost Replacement Method • Writing and reviewing reports, valuing properties and conducting research for various types of asset classes using various methods wherever required depending on the kind of assignment. • Advisory on current and projected value of real estate, related investment and report writing on detailed analysis done of the property from Macro to Micro level. Key Assignments: • Half –Yearly Valuation of Portfolio of properties for multiple asset classes - residential, retail, commercial for "Ask Fund” • Pre-Investment Valuation Study of land side assets located at New Delhi, for a leading power company • Demand assessment and financial analysis of a ropeway located in Jharkhand • Highest & best use study for the TOD intense – mixed use development of 2 mn sq ft in Gurgaon including pricing & product mix derivation Ernst and Young Consultant, Corporate Finance Strategy, Pan India March 2018 - July 2019 • • • • Assist client on key business issues through rigorous financial, economic and data analytics. Review, enhance or build capital allocation processes, provide independent analysis to help optimize the portfolio, employ data analytics and predictive modelling to solve financial problems, facilitate decision making and achieve better business outcomes Analyze the impact on value and risk of alternative complex transaction structures, Analyze the impact on value and risk of alternative capital structures. Manage real estate portfolio of corporate client Key Assignments: • Managed the real estate sector and real estate portfolio of India's largest automobile client and involved in independent assessment of more than 70 land parcels and negotiation strategy for purchasing land parcels for commercial operations in Pan India • Extensively involved in the student housing white paper which includes interaction student housing promotors to understand business model and development in student housing sector • Financial Strategy for “Chinamaya Vidalya” Cushman & Wakefield India Private Limited Associate, Valuation & Advisory services, North & East India Market Research and analysis: April 2014 – February 2018 • Real estate market scenario - Supply trends, absorption and vacancy trends, rental and capital values trends, • Micro-market wide analysis of supply and demand gap benchmarking to assess successful real estate evaluations milestones • Market feasibility assessment for various land use asset classes (Residential, Commercial–Office, Retail Mall, Hospitality & Industrial) • Demand Analysis methodologies for various real estate asset classes Real estate Consulting and Valuation / Feasibility analysis • Demand - Supply gap analysis for standalone and integrated real estate projects – housing townships, mixed land use, commercial business districts, resort and leisure etc. Financial & Economic Analysis • Detailed financial analysis using various evaluation techniques – Discounted cash flow analysis and Sales comparison, Income cap methodology, depreciative replacement cost methodology • Project viability analysis in terms of Residual land value analysis (NPV, IRR) – multiple asset classes – residential, retail, commercial & hospitality Key Assignments: • Market study report of a residential property located in sector 59, off golf course extension road, Gurgaon for a Singapore based private equity firm • Market study and Appraisal Report for the property located in Dhaka, Bangladesh for client “U.S. Department of State, Bureau of Overseas Buildings Operations” in Dhaka, Bangladesh • Valuation of Portfolio for multiple asset classes – residential,retail, commercial for “National Building Construction Company” • Valuation of Portfolio for multiple asset classes – residential,retail, commercial for Samhi Hotels • Pre-investment valuation and advisory exercise of the DLF portfolio that resulted in a successful acquisition by a leading global investment firm • Pre-Investment Valuation Study of land side assets located at Indira Gandhi International Airport, New Delhi for a leading international airport developer Cushman & Wakefield (India) Pvt. Ltd. Management Trainee, Account Management services, IBM Account • • • • August 2013 – April 2014 As part of IBM Account management team, I was involved with sourcing of information, analysis & presentation of project status reports for critical decision making for Internal CW teams - AM / Transaction teams & Client Performed Data extraction (from legal documents) & validation of data from previous & existing records for the enhancement of database performance to create database design, trend analysis, and data base management Presented year-end review presentation on all current transactions of IBM and relative growth / or fall from 2013 Jan’ to 2013 June 2013 & Dec 2013 Provided information on risks involved in future and risk mitigation strategy EDUCATION- BE (biotechnology) from Sir M Visvesvarya Institute of Technology 12th from R.K.D College Patna HSC from C.B.S.E Board, St Dominic Savios High School, Patna Selected for Indian School Business, PGP Pro for working professional’ in year 2020 CERTIFICTIONS • Financial Analyst certified from Udemy • Pursuing MRICS certification ACHIEVEMENTS • Organized conference at IISc on behalf of Sir MVIT Biotech department in 2010 • Participated in Techno-utsav in 2009 • Qualified 1st round of Intel threading championship in 2009 • Active member of Sir MVIT cricket team IT SKILLS Operating Systems : Windows XP/ Vista / 7 and Linux Computer Languages : Base SAS 9.2, Advance Excel PERSONAL DETAILS Date of Birth Marital Status Permanent Address Present Address Languages Known : : : : : February 05, 1988 Married 306, RMScolony, Kankarbagh, Patna C 2839, Sushant Lok Phase 1, Gurgaon English and Hindi