Calculation Sheet
This query is : Resolved
23 November 2010
Hi, can any one provide calculation sheet to determine the home loan that can be avalied based on ones salary.
23 November 2010
It will differ bank to bank based on credit policy
24 November 2010
I wanted a generalised calculation sheet for computation of loan that can be availed based on the sources of income and expenditure.
18 July 2024
To create a generalized computation sheet for loan eligibility based on income and expenditure, you can follow these steps and considerations:
### Step 1: Gather Income Sources
Identify all sources of income that contribute to the borrower's financial profile. This may include:
- Salary or wages (net income after deductions)
- Rental income
- Business income (net profits)
- Other sources of income (investments, freelance work, etc.)
### Step 2: Assess Regular Expenses
List down all regular monthly expenses and financial commitments:
- Housing expenses (rent or mortgage)
- Utilities (electricity, water, internet, etc.)
- Insurance premiums (health, life, vehicle, etc.)
- Loan repayments (existing loans, credit cards)
- Daily living expenses (groceries, transportation, etc.)
- Other fixed expenses (education, childcare, subscriptions, etc.)
### Step 3: Calculate Disposable Income
Calculate the disposable income available after deducting total monthly expenses from total monthly income. This represents the amount that can potentially go towards loan repayments.
### Step 4: Debt-to-Income Ratio (DTI)
Compute the Debt-to-Income ratio, which is crucial for loan eligibility. This is calculated as:
\[ \text{DTI} = \left( \frac{\text{Total Monthly Debt Payments}}{\text{Gross Monthly Income}} \right) \times 100 \]
Lenders typically have maximum DTI thresholds (e.g., 40-50%) that borrowers should ideally stay under to qualify for loans.
### Step 5: Loan Eligibility Calculation
Based on the lender's criteria and the borrower's DTI, estimate the maximum loan amount that can be serviced comfortably. This involves:
- Determining the maximum monthly installment feasible within the DTI limit.
- Using loan eligibility calculators provided by banks or financial institutions, if available.
- Considering the loan tenure (term) and interest rate to calculate the maximum principal loan amount.
### Step 6: Prepare the Computation Sheet
Create a spreadsheet or document to summarize:
- Income sources and amounts.
- Itemized monthly expenses.
- Disposable income.
- Debt-to-Income ratio.
- Estimated loan eligibility based on DTI and lender criteria.
### Example Computation Sheet Template
Here’s a simplified template to structure your computation sheet:
| **Category** | **Amount (Monthly)** |
|------------------------------|----------------------|
| **Income** | |
| Salary | $X |
| Rental Income | $Y |
| Other Income | $Z |
| **Total Income** | **$Total Income** |
| | |
| **Expenses** | |
| Housing Expenses | $A |
| Utilities | $B |
| Loan Repayments | $C |
| Daily Living Expenses | $D |
| Other Fixed Expenses | $E |
| **Total Expenses** | **$Total Expenses** |
| | |
| **Disposable Income** | **$Disposable Income** |
| | |
| **Debt-to-Income Ratio (DTI)**| **DTI %** |
| | |
| **Estimated Loan Eligibility** | **Maximum Loan Amount** |
### Notes:
- Ensure all figures are accurate and up-to-date.
- Regularly review and adjust the computation sheet as financial circumstances change.
- Seek professional financial advice for complex loan eligibility calculations or specific lender requirements.
This structured approach will help in determining a borrower’s loan eligibility based on their income, expenses, and financial obligations.
### Step 1: Gather Income Sources
Identify all sources of income that contribute to the borrower's financial profile. This may include:
- Salary or wages (net income after deductions)
- Rental income
- Business income (net profits)
- Other sources of income (investments, freelance work, etc.)
### Step 2: Assess Regular Expenses
List down all regular monthly expenses and financial commitments:
- Housing expenses (rent or mortgage)
- Utilities (electricity, water, internet, etc.)
- Insurance premiums (health, life, vehicle, etc.)
- Loan repayments (existing loans, credit cards)
- Daily living expenses (groceries, transportation, etc.)
- Other fixed expenses (education, childcare, subscriptions, etc.)
### Step 3: Calculate Disposable Income
Calculate the disposable income available after deducting total monthly expenses from total monthly income. This represents the amount that can potentially go towards loan repayments.
### Step 4: Debt-to-Income Ratio (DTI)
Compute the Debt-to-Income ratio, which is crucial for loan eligibility. This is calculated as:
\[ \text{DTI} = \left( \frac{\text{Total Monthly Debt Payments}}{\text{Gross Monthly Income}} \right) \times 100 \]
Lenders typically have maximum DTI thresholds (e.g., 40-50%) that borrowers should ideally stay under to qualify for loans.
### Step 5: Loan Eligibility Calculation
Based on the lender's criteria and the borrower's DTI, estimate the maximum loan amount that can be serviced comfortably. This involves:
- Determining the maximum monthly installment feasible within the DTI limit.
- Using loan eligibility calculators provided by banks or financial institutions, if available.
- Considering the loan tenure (term) and interest rate to calculate the maximum principal loan amount.
### Step 6: Prepare the Computation Sheet
Create a spreadsheet or document to summarize:
- Income sources and amounts.
- Itemized monthly expenses.
- Disposable income.
- Debt-to-Income ratio.
- Estimated loan eligibility based on DTI and lender criteria.
### Example Computation Sheet Template
Here’s a simplified template to structure your computation sheet:
| **Category** | **Amount (Monthly)** |
|------------------------------|----------------------|
| **Income** | |
| Salary | $X |
| Rental Income | $Y |
| Other Income | $Z |
| **Total Income** | **$Total Income** |
| | |
| **Expenses** | |
| Housing Expenses | $A |
| Utilities | $B |
| Loan Repayments | $C |
| Daily Living Expenses | $D |
| Other Fixed Expenses | $E |
| **Total Expenses** | **$Total Expenses** |
| | |
| **Disposable Income** | **$Disposable Income** |
| | |
| **Debt-to-Income Ratio (DTI)**| **DTI %** |
| | |
| **Estimated Loan Eligibility** | **Maximum Loan Amount** |
### Notes:
- Ensure all figures are accurate and up-to-date.
- Regularly review and adjust the computation sheet as financial circumstances change.
- Seek professional financial advice for complex loan eligibility calculations or specific lender requirements.
This structured approach will help in determining a borrower’s loan eligibility based on their income, expenses, and financial obligations.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- CAPITAL GAIN REDEVELOPED FLAT
- CLOSING STOCK QUERY
- REGARDING ITR FILING QUESTION
- Requirement under FEMA &RBI
- Multiple payment of self assessment tax for A Y 2025-2026
- Gst reverse charge mechanism to be claimed in the month of payment
- Taxation on Old jewellery sold
- PF wage ceiling
- Itr processing refund
- Error in uploading Form 10BD
- Concept of Vendor and customner reconciliation
- Mistake in e-invoice identified after 24 hours
- EXPORT PAYMENT
- NRI ITR2 account in 2025-26.
- Query regarding reporting of exempt foreign remuneration in ITR (AY 2026-27)
- FEMA/RBI treatment — Amazon.ca arbitrage (US buy, Canada sell, goods never enter India)
- Goods return by customer
- INWARD REMITTANCE FOREIGN
- CPC and SAC
- Account freezed for Ineligible ITC Scrutiny for GST Annual Return
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
