Calculation Sheet

This query is : Resolved

Abhishek (Querist)
Follow

23 November 2010 Hi, can any one provide calculation sheet to determine the home loan that can be avalied based on ones salary.

CMA Ramesh Krishnan

CMA Ramesh Krishnan (Expert)
Follow

23 November 2010 It will differ bank to bank based on credit policy

Abhishek

Abhishek (Querist)
Follow

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.

Aashok Kumar Sharma

Aashok Kumar Sharma (Expert)
Follow

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.

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Summarize this with AI

ChatGPT Perplexity Claude Google AI Grok