Credit Risk Analysis - Real Estate Sector

Develop a cash flow model for lease rental discounting in Excel, analyzing rent escalations, DACA, CAM, taxes, and market due diligence to determine loan amount and tenor.

Learn to extract leased area from rent rolls, assess occupancy and renewal probability, and model real estate credit risk with debt-to-value, wacc, tax shields, and rent escalations.

Project rent per square foot under a real estate escalation model using a 4.4% annual rate, days elapsed since 2007, and a 90% lease renewal probability after 2023.

Build a rent roll matrix of monthly rentals per tenant per square foot, multiply by area to get monthly lease rentals, then total the 2016 payout at 190.7 million.

Develops lease rental discounting by estimating annual lease payouts, incorporating cam expenses escalating 6% on constructed area, property tax, and depreciation, with a 15-year loan schedule.

Analyze the lease rental discounting debt schedule from 2016 opening balances through 2030, deriving cash flow for debt service and metrics like DCR and DSR to assess debt repayment capacity.

Analyze how DSCR and DCR respond to changes in lease renewal probability, interest rates, loan amount, and loan tenor, and explore ballooning repayments to balance risk.

The develop and sell model funds construction mainly with customer advances, equity, and bank debt, exposing banks to cash flow risks and execution risk.

Assess location and market demand to decide funding levels, determine disbursement timing, and design a repayment schedule that avoids construction disruption while managing bank risk.

Use Excel to assess funding for a residential project with a 450 crore cost, saleable area of 5 lakh sq ft, land cost 250 crore, and 9,050 per sq ft.

Examine cost phasing for a 452 crore real estate project, front-loading construction over 12 quarters and aligning land, approvals, contingencies, and marketing with funding needs.

Sales phasing defines the quarterly percentage of the project sold to shape cash inflows, guided by price points and market benchmarks, with a five-year plan and launch spikes.

Explain collection phasing for a real estate project, detailing quarterly cash inflows, launches with price movement from 18,000 to 20,000 per sft, and 4% marketing costs tied to sales.

Analyze quarterly inflows and outflows in real estate credit risk using sum product to model new and old sales, incremental demand, and costs (land, construction, marketing, contingencies).

Learn to calculate cost outflows for a real estate project by balancing incremental costs, customer advances, and funding sources, using a 50% disbursement rule and floor protections.

Analyze cash flows to determine debt repayment timing and interest costs. Evaluate funding patterns by comparing disbursements, opening and closing balances, equity, bank debt, and customer advances to mitigate risk.