Senior Analyst / Lead Analyst

While the initial function will be to take direction from the Origination team members, the aspirational goal is to expand the Wipro scope to include the following :

• Extracting market and asset specific statistics from various data sources (for eg : CoStar or similar platforms) for the pipeline deals which are shortlisted for screening or underwriting.
• Comparing the key deal metrics which includes Occupancy, Cap Rates, Debt Yield, Cash Flow, NOI etc. of the pipeline deals with existing portfolio.
• Analyzing property pictures & map for location-based insights, preparing the capital stack (i. e. , Equity vs. Debt) and presenting them in an excel and ppt format.
• Collecting and preparing sales and rent comparable of the target originations with the market data sourced through broker reports or web-based applications.
• Studying the demographics to understand the unit mixes, interpreting all sources of incomes & expenses through review of cash flows, ascertaining vacancy rates & rental income using rent rolls and using NOI to calculate key liquidity ratios i. e. , DSCR, DY etc.
• Creating investment memorandums with the deal team ahead of investment committee.
• Conducting due diligence prior to closing of deal as per closing checklist.
• Data input in pipeline tool (i. e. , DealPath, Loan Tapes) as and when required.

Essential Skills & Experience :

Skills Required

Analytical, Due Diligence, Senior Analyst, Loans, Cre, Data Validation, Ms Office, Cash Flow