1. Key inputs
15 yr
CRE?
2. Pulled from the other sheets
Change Project Cost or FOIR and this updates immediately.
Total project cost₹46,18,755
Realizable value₹41,18,450
Max loan as per LTV₹32,94,760
Total max EMI capacity (FOIR)₹86,541
3. Final quantum of finance
Applicable ROI7.95%
Max loan by FOIR₹90,83,085
Max loan by LTV₹32,94,760
Loan amount applied₹35,00,000
Three-way limiter
Eligible loan is the shortest of these three bars.
FOIR capacity₹90,83,085
LTV limit · binds₹32,94,760
Amount applied₹35,00,000
Final maximum eligible loan
₹32,94,760
EMI on eligible loan ₹31,391
Limiting factor: LTV Limit