Calicut University • B.Com • Semester 3
Personal Financial Planning (COM3MN205) — Module 2: Debt Management & Credit Administration
Lecture Notes • Complete Study Material
Curricular Scope & Analytical BlueprintCOM3MN205 • Module II
Core Competency Focus: This module delivers an advanced, comprehensive examination of personal debt management, consumer credit instruments, and creditworthiness appraisal. It analyzes household income-expense budgeting and personal financial deficit financing; contrasts the legal structures, terms, and tax implications of Personal, Housing, Education, and Vehicle loans; deconstructs credit card revolving credit and the Equated Monthly Installment (EMI) mathematical mechanism; evaluates the strategic distinction between Good and Bad Debt; establishes personal Net Worth and debt service solvency metrics; and investigates credit bureau scoring models (CIBIL Score, Credit Information Reports) and score repair strategies through practical case studies.
1. Budgeting Income, Cash Flows & Managing Personal Financial Deficits
1.1 Personal Cash Flow Budgeting
Household financial stability begins with cash flow budgeting — the systematic projection and tracking of an individual's or family's monetary inflows against contractual and discretionary monetary outflows over a monthly or annual cycle. A comprehensive personal budget categorizes outlays into three distinct structural tiers:
- Fixed Contractual Outflows: Invariable obligations that must be met under legal or contractual agreements. Examples include home mortgage or vehicle loan EMIs, apartment rent, property taxes, insurance premiums, and statutory utility payments.
- Variable Living Expenses: Necessary expenditures whose absolute monetary volume fluctuates based on consumption. Examples include groceries, vehicle fuel, electricity bills, routine domestic maintenance, and medical prescriptions.
- Discretionary Lifestyle Outflows: Optional expenditures that can be postponed or eliminated without compromising basic survival. Examples include dining out, vacation travel, luxury electronics, subscriptions, and entertainment.
1.2 Understanding Personal Financial Deficits
A Personal Financial Deficit occurs when an individual's total living and debt expenditures exceed their net disposable take-home income over a given accounting interval:
Personal Financial Deficit = Total Monthly Outflows (Fixed + Variable + Discretionary) − Net Take-Home Inflow
Primary Drivers of Personal Deficit:
- Lifestyle Inflation (Creeping Consumerism): Upgrading personal expenditures, housing, and social outlays in tandem with — or faster than — salary increments.
- Uncontrolled High-Cost Borrowing: Accumulating multiple high-interest EMIs, revolving credit card balances, and personal loans whose aggregate debt-service payments absorb a disproportionate share of monthly income.
- Absence of Emergency Reserves: Encountering sudden, unbudgeted crises (such as medical emergencies, temporary job loss, or vehicle repairs) without a dedicated cash buffer, forcing reliance on high-cost debt.
1.3 Strategies for Deficit Elimination & Remediation
STAGE 1: CASH FLOW AUDIT & EXPENSE SURGERY Track every expense over 60 days; eliminate unneeded subscriptions; cap discretionary outlays. ↓ STAGE 2: DEBT RESTRUCTURING & CONSOLIDATION Consolidate multiple high-interest debts (36%-42% credit cards) into a lower-cost instrument (12%-14%). ↓ STAGE 3: ACTIVE INCOME AUGMENTATION Monetize secondary skills through freelance work, consulting, or liquidating idle household assets. ↓ STAGE 4: AUTOMATED SURPLUS RE-ENGINEERING Direct newly created monthly surpluses toward accelerated debt payoff until total debt-to-income falls below 35%.
2. Financing Alternatives: Typology of Consumer Credit
When personal borrowing is required, individuals can access various credit facilities tailored to specific financing objectives, each carrying distinct collateral structures, interest profiles, and legal covenants:
| Credit Alternative | Collateral / Security Basis | Typical Interest & Tenure | Key Statutory & Financial Features |
|---|---|---|---|
| Personal Loan | Unsecured; sanctioned purely on applicant's credit score, income stability, and repayment history. | 10.50% to 22.00% p.a. Tenure: 12 to 60 Months | No asset pledged; quick disbursement; higher interest rate; useful for emergency medical funding or high-interest debt consolidation. |
| Housing Loan (Home Mortgage) | Secured; primary mortgage created on the financed residential property. | 8.25% to 9.75% p.a. Tenure: 15 to 30 Years | Lowest borrowing rates; significant tax deductions under Section 80C (principal repayment up to Rs. 1.5 Lakhs) and Section 24(b) (interest up to Rs. 2 Lakhs). |
| Education Loan | Unsecured up to Rs. 4 Lakhs; third-party guarantee for Rs. 4L–7.5L; tangible collateral required above Rs. 7.5 Lakhs. | 8.50% to 12.00% p.a. Tenure: 5 to 15 Years | Priority sector lending; includes moratorium period (course duration + 6–12 months); unlimited tax deduction on interest under Section 80E for up to 8 consecutive years. |
| Vehicle / Auto Loan | Secured by hypothecation of the purchased automobile or two-wheeler. | 8.75% to 13.00% p.a. Tenure: 3 to 7 Years | Fixed EMI; vehicle title registered with bank hypothecation; default leads to vehicle repossession; vehicle value depreciates faster than debt amortization in early years. |
3. Credit Cards, Revolving Debt & The Mathematics of EMI
3.1 Credit Card Architecture & The Revolving Credit Mechanism
A credit card is a revolving unsecured credit line issued by commercial banks allowing cardholders to make purchases up to a sanctioned credit limit. Key operational parameters include:
- Billing Cycle & Interest-Free Grace Period: The recurring 30-day interval over which transactions are aggregated. If the previous month's statement balance was settled in full, new purchases enjoy an interest-free grace period ranging from 20 to 50 days (depending on the purchase date relative to the billing statement date).
- Finance Charges (Annual Percentage Rate - APR): If the statement balance is not paid in full by the due date, the interest-free grace period is completely forfeited. Finance charges are retroactively levied on every transaction from the exact date of purchase at rates ranging from 3.0% to 4.0% per month (36% to 48% annualized APR).
- The Minimum Amount Due (MAD) Trap: Banks allow cardholders to maintain active account status by paying a Minimum Amount Due, typically calculated as:Minimum Amount Due (MAD) = [ 5% of Total Outstanding Principal ] + [ Applicable Interest Charges + Taxes + Over-limit Fees ]Paying only the MAD creates a compounding debt trap. Because 95% of the principal continues to revolve while accruing 40%+ annual interest, a modest credit card balance can take over a decade to clear, with total interest paid often exceeding the original purchases many times over.
3.2 The Mathematics of Equated Monthly Installments (EMI)
An Equated Monthly Installment (EMI) is a fixed payment amount made by a borrower to a lender at a specified calendar date each month. Each installment covers both principal and interest, structured so that the loan balance is fully paid off by the end of the tenure.
Standard Reducing Balance EMI Formula:
EMI = [ P × r × (1 + r)n ] ÷ [ (1 + r)n − 1 ]
Where:
• P = Principal loan amount borrowed.
• r = Periodic monthly interest rate = [ Annual Nominal Rate ÷ 12 ÷ 100 ].
• n = Total loan tenure expressed in months (e.g., 5 years = 60 months).
EMI = [ P × r × (1 + r)n ] ÷ [ (1 + r)n − 1 ]
Where:
• P = Principal loan amount borrowed.
• r = Periodic monthly interest rate = [ Annual Nominal Rate ÷ 12 ÷ 100 ].
• n = Total loan tenure expressed in months (e.g., 5 years = 60 months).
3.3 The Flat Rate Deception vs. Reducing Balance Interest
Borrowers must differentiate between a Flat Interest Rate and a Reducing Balance Interest Rate:
- Flat Interest Rate: Interest is calculated on the entire original principal amount throughout the loan tenure, ignoring regular principal repayments made via monthly installments.Total Flat Interest = P × (Annual Rate ÷ 100) × Tenure in Years
Flat EMI = [ Principal + Total Flat Interest ] ÷ Total Months - Reducing Balance Method: Interest is calculated in each monthly period solely on the remaining, unamortized principal balance.
Financial Insight: A flat interest rate of 8.0% per annum is roughly equivalent to a reducing balance interest rate of 14.5% to 15.2% per annum. Uninformed borrowers often select flat-rate loans under the mistaken impression that an 8% flat rate is cheaper than an 11% reducing rate loan.
4. The Strategy of Personal Debt: Good Debt vs. Bad Debt
4.1 Conceptual Distinction
Debt is neither inherently beneficial nor harmful; its economic character depends on whether borrowed funds are deployed into productive, wealth-generating assets or consumed by lifestyle spending:
Characteristics of "Good Debt"
• Finances Appreciating Assets: Used to acquire assets that grow in market value over time (e.g., residential real estate) or increase personal human capital and future earning capacity (e.g., higher professional education).
• Low, Sustainable Cost: Carries low nominal interest rates that can be comfortably serviced from routine earnings.
• Statutory Tax Subsidies: Interest payments are eligible for income tax deductions (such as Sec 24b for home loans and Sec 80E for education loans), reducing effective borrowing costs.
• Wealth Accretive: Expected future economic returns exceed the total cost of financing.
• Low, Sustainable Cost: Carries low nominal interest rates that can be comfortably serviced from routine earnings.
• Statutory Tax Subsidies: Interest payments are eligible for income tax deductions (such as Sec 24b for home loans and Sec 80E for education loans), reducing effective borrowing costs.
• Wealth Accretive: Expected future economic returns exceed the total cost of financing.
Characteristics of "Bad Debt"
• Finances Depreciating Consumer Goods: Used to buy items that lose value immediately upon purchase (e.g., luxury clothing, mobile gadgets, vacations, dining out).
• High, Compounding Cost: Carries high interest rates (personal loans at 14%–20%; credit cards at 36%–48% APR).
• Zero Tax Benefits: Interest paid offers no statutory tax deduction under Indian income tax law.
• Wealth Destructive: Erodes disposable income, increases financial vulnerability, and diverts capital away from wealth-building investments.
• High, Compounding Cost: Carries high interest rates (personal loans at 14%–20%; credit cards at 36%–48% APR).
• Zero Tax Benefits: Interest paid offers no statutory tax deduction under Indian income tax law.
• Wealth Destructive: Erodes disposable income, increases financial vulnerability, and diverts capital away from wealth-building investments.
4.2 Systematic Debt Payoff Methodologies
When an individual holds multiple debts, two recognized payoff methodologies can be used to accelerate repayment:
1. The Debt Snowball Method (Behavioral Focus)
Approach: Rank all outstanding debts in ascending order of balance size (smallest balance to largest balance), regardless of interest rates. Maintain minimum payments across all loans, and direct all extra surplus cash to pay off the smallest balance first.
Psychological Advantage: Eliminating smaller debts quickly provides early psychological momentum, reinforcing commitment to the debt payoff plan.
Psychological Advantage: Eliminating smaller debts quickly provides early psychological momentum, reinforcing commitment to the debt payoff plan.
2. The Debt Avalanche Method (Mathematical Focus)
Approach: Rank all outstanding debts in descending order of interest rate (highest interest rate to lowest interest rate), regardless of balance size. Direct all extra cash toward eliminating the debt carrying the highest interest rate first.
Financial Advantage: Mathematically minimizes total interest paid across the debt portfolio and shortens overall debt freedom timelines.
Financial Advantage: Mathematically minimizes total interest paid across the debt portfolio and shortens overall debt freedom timelines.
5. Personal Net Worth Audit & Debt Solvency Ratios
5.1 The Personal Balance Sheet (Net Worth Statement)
An individual's personal net worth provides a snapshot of overall financial solvency. It measures the residual monetary value that would remain if all owned assets were liquidated at fair market value and all liabilities were paid off in full:
Personal Net Worth = Total Tangible Assets − Total Outstanding Liabilities
5.2 Critical Personal Debt & Solvency Ratios
| Solvency Metric | Mathematical Formulation | Benchmark Norm & Financial Interpretation |
|---|---|---|
| Debt-to-Income (DTI) Ratio | [ Total Monthly Debt EMIs ÷ Gross Monthly Income ] × 100 | Ideal: ≤ 35% – 40%. Commercial lenders use this benchmark to evaluate loan eligibility. A DTI above 50% indicates significant financial vulnerability. |
| Debt-to-Asset Ratio | [ Total Outstanding Debt ÷ Total Assets ] × 100 | Ideal: ≤ 50%. Measures the proportion of personal assets funded by external debt. A ratio above 75% indicates high financial leverage. |
| Liquidity Ratio (Months of Coverage) | Liquid Cash & Mutual Funds ÷ Monthly Living Expenses | Norm: 3.0 to 6.0 Months. Ensures sufficient liquid funds are available to service EMIs and cover living costs during income disruptions. |
6. Credit Bureaus, Credit Scoring (CIBIL) & Report Analysis
6.1 Regulatory Framework & Credit Bureaus in India
Under the Credit Information Companies (Regulation) Act, 2005 (CICRA), lending institutions are mandated to report comprehensive monthly repayment data on all retail borrowers to licensed credit bureaus. The four authorized credit bureaus operating in India are:
TransUnion CIBIL
The pioneer and most widely referenced credit bureau in India, established in 2000.
Experian India
Global credit agency providing Credit Information Reports (CIR) and consumer analytics.
Equifax & CRIF High Mark
Leading credit analytics bureaus specializing in retail, microfinance, and commercial credit scoring.
6.2 The CIBIL Score & Its Underlying Scoring Model
The CIBIL score is a three-digit numerical summary ranging from 300 to 900 that indicates an individual's creditworthiness and probability of debt default:
- 750 to 900 (Excellent / Prime): Highest creditworthiness. Qualifies for preferential interest rates, higher loan amounts, and expedited processing.
- 700 to 749 (Good): Satisfactory credit profile. Eligible for most standard consumer loans and credit card facilities.
- 650 to 699 (Fair / Moderate Risk): May encounter higher interest rates, stricter collateral requirements, or lower sanctioned credit limits.
- 300 to 649 (Poor / High Default Risk): Indicates past defaults, delayed payments, or debt settlements. Loan and credit card applications are typically rejected.
Factor Weightages in Credit Score ComputationCIBIL Scoring Model
- Repayment Track Record (35% Weight): The single most influential factor. Reflects consistency in paying loan EMIs and credit card dues on or before the due date. Single 30+ day delays or default marks significantly lower the score.
- Credit Utilization Ratio (CUR) (30% Weight): Total credit card balances divided by total sanctioned credit limits. Utilizing more than 30% of available revolving limits signals financial strain and depresses the score.
- Credit History Vintage / Length (15% Weight): The age of the borrower's oldest active credit accounts. A longer history of responsible repayment improves the score.
- Credit Portfolio Mix (10% Weight): A balanced mix of secured loans (home mortgages, auto loans) and unsecured lines (credit cards, personal loans) demonstrates varied borrowing experience.
- Recent Credit Searches / Hard Inquiries (10% Weight): Submitting multiple loan applications to different lenders in a short window triggers "hard inquiries," suggesting credit-hungry behavior.
6.3 Anatomy of a Credit Information Report (CIR) & Score Repair
A standard CIR contains: (a) Identification & Contact Information; (b) Employment & Income Records; (c) Detailed Account-by-Account History tracking 36 months of payment records using Days Past Due (DPD) codes (e.g., 000 indicates on-time payment; 030/060/090 indicates days overdue; 'SUB'/'DBT'/'LSS' indicate non-performing classifications); and (d) Inquiry History.
Concrete Strategies to Repair and Rebuild Credit:
- Pay all loan EMIs and credit card balances in full and on time each month.
- Reduce credit card utilization below 30% of sanctioned limits.
- Avoid closing old, well-maintained credit card accounts, which preserves credit history length.
- Dispute reporting inaccuracies or wrongful default flags with the credit bureau via online dispute resolution.
- If repairing a damaged score with no access to unsecured credit, obtain a Secured Credit Card backed by a fixed deposit and build a clean payment record over 12 months.
7. Exhaustive Numerical Demonstrations & Worked Practical Case Studies
PRACTICAL CASE 1: The Flat Rate vs. Reducing Balance Interest Rate Deception
Context: Rajesh requires a vehicle loan of Rs. 6,00,000 for a tenure of 5 years (60 months). He receives two competing financing proposals:
• Lender A (Non-Bank Financier): Offers an attractive "Flat Interest Rate" of 7.50% per annum.
• Lender B (Commercial Public Sector Bank): Offers a standard "Reducing Balance Interest Rate" of 12.00% per annum.
Rajesh considers Lender A because 7.5% flat appears cheaper than 12.0% reducing balance.
Required: Compute for both lenders: (a) Monthly EMI, (b) Total Interest Payable over 5 years, (c) Total Cash Outflow, and (d) Determine which loan is economically cheaper.
• Lender B (Commercial Public Sector Bank): Offers a standard "Reducing Balance Interest Rate" of 12.00% per annum.
Rajesh considers Lender A because 7.5% flat appears cheaper than 12.0% reducing balance.
Required: Compute for both lenders: (a) Monthly EMI, (b) Total Interest Payable over 5 years, (c) Total Cash Outflow, and (d) Determine which loan is economically cheaper.
Computational Solution:
1. Lender A (Flat Interest Rate @ 7.50% p.a.):
• Principal (P) = Rs. 6,00,000; Tenure (T) = 5 Years; Total Months (n) = 60
• Total Flat Interest = P × Rate × Time = Rs. 6,00,000 × 0.075 × 5 = Rs. 2,25,000
• Total Repayment Amount = Principal + Total Interest = Rs. 6,00,000 + Rs. 2,25,000 = Rs. 8,25,000
• Monthly EMI (Lender A) = Rs. 8,25,000 ÷ 60 Months = Rs. 13,750
2. Lender B (Reducing Balance Rate @ 12.00% p.a.):
• P = Rs. 6,00,000; Annual Rate = 12%; Monthly Rate (r) = 12% ÷ 12 ÷ 100 = 0.01; n = 60 Months
• (1 + r)n = (1.01)60 = 1.8167
• EMI = [ P × r × (1 + r)n ] ÷ [ (1 + r)n − 1 ]
• EMI = [ 6,00,000 × 0.01 × 1.8167 ] ÷ [ 1.8167 − 1 ]
• EMI = 10,900.2 ÷ 0.8167 = Rs. 13,347
• Total Repayment Amount = 60 × Rs. 13,347 = Rs. 8,00,820
• Total Reducing Balance Interest (Lender B) = Rs. 8,00,820 − Rs. 6,00,000 = Rs. 2,00,820
1. Lender A (Flat Interest Rate @ 7.50% p.a.):
• Principal (P) = Rs. 6,00,000; Tenure (T) = 5 Years; Total Months (n) = 60
• Total Flat Interest = P × Rate × Time = Rs. 6,00,000 × 0.075 × 5 = Rs. 2,25,000
• Total Repayment Amount = Principal + Total Interest = Rs. 6,00,000 + Rs. 2,25,000 = Rs. 8,25,000
• Monthly EMI (Lender A) = Rs. 8,25,000 ÷ 60 Months = Rs. 13,750
2. Lender B (Reducing Balance Rate @ 12.00% p.a.):
• P = Rs. 6,00,000; Annual Rate = 12%; Monthly Rate (r) = 12% ÷ 12 ÷ 100 = 0.01; n = 60 Months
• (1 + r)n = (1.01)60 = 1.8167
• EMI = [ P × r × (1 + r)n ] ÷ [ (1 + r)n − 1 ]
• EMI = [ 6,00,000 × 0.01 × 1.8167 ] ÷ [ 1.8167 − 1 ]
• EMI = 10,900.2 ÷ 0.8167 = Rs. 13,347
• Total Repayment Amount = 60 × Rs. 13,347 = Rs. 8,00,820
• Total Reducing Balance Interest (Lender B) = Rs. 8,00,820 − Rs. 6,00,000 = Rs. 2,00,820
| Comparative Dimension | Lender A (7.5% Flat Rate) | Lender B (12.0% Reducing Balance) |
|---|---|---|
| Monthly Installment (EMI) | Rs. 13,750 | Rs. 13,347 (Lower by Rs. 403/mo) |
| Total Interest Paid over 5 Years | Rs. 2,25,000 | Rs. 2,00,820 (Saves Rs. 24,180) |
| Total Cash Outflow | Rs. 8,25,000 | Rs. 8,00,820 |
| Actual Effective Annual Rate (APR) | 13.72% p.a. | 12.00% p.a. |
Borrower Decision ReviewFinancial Audit
Despite the lower headline rate (7.5% vs. 12.0%), Lender B is cheaper, saving Rajesh Rs. 24,180 in total interest and lowering monthly EMI payments by Rs. 403. Lender A charges interest on the full initial principal of Rs. 6,00,000 for all 5 years, ignoring monthly repayments. This raises the effective reducing rate to 13.72% p.a., making the flat-rate loan more expensive.
PRACTICAL CASE 2: Construction of Loan Amortization Schedule
Context: A professional borrows an unsecured personal loan of Rs. 4,00,000 at an interest rate of 12.0% per annum on a reducing balance basis for a tenure of 3 years (36 months). Construct the annual loan amortization schedule.
EMI Computation:
P = Rs. 4,00,000; Monthly rate (r) = 12% ÷ 12 ÷ 100 = 0.01; n = 36 Months.
(1 + r)n = (1.01)36 = 1.43077
Monthly EMI = [ 4,00,000 × 0.01 × 1.43077 ] ÷ [ 1.43077 − 1 ] = 5,723.08 ÷ 0.43077 = Rs. 13,286 per month
Annual Total Payment = 12 × Rs. 13,286 = Rs. 1,59,432 per year
P = Rs. 4,00,000; Monthly rate (r) = 12% ÷ 12 ÷ 100 = 0.01; n = 36 Months.
(1 + r)n = (1.01)36 = 1.43077
Monthly EMI = [ 4,00,000 × 0.01 × 1.43077 ] ÷ [ 1.43077 − 1 ] = 5,723.08 ÷ 0.43077 = Rs. 13,286 per month
Annual Total Payment = 12 × Rs. 13,286 = Rs. 1,59,432 per year
| Year | Opening Principal (Rs.) | Annual Installment (Rs.) | Interest Portion (Rs.) | Principal Repaid (Rs.) |
|---|---|---|---|---|
| 1 | 4,00,000 | 1,59,432 | 40,860 | 1,18,572 |
| 2 | 2,81,428 | 1,59,432 | 25,830 | 1,33,602 |
| 3 | 1,47,826 | 1,59,432 | 11,606 | 1,47,826 |
| TOTALS | Rs. 4,78,296 | Rs. 78,296 | Rs. 4,00,000 |
PRACTICAL CASE 3: The Credit Card Minimum Amount Due (MAD) Trap
Context: An individual accumulates a credit card balance of Rs. 1,00,000 carrying a finance charge of 3.5% per month (42% annualized APR). Compare the outcome of paying only the 5% Minimum Amount Due (MAD) each month versus paying a fixed monthly installment of Rs. 5,000.
| Repayment Strategy | Monthly Payment Profile | Time to Fully Clear Debt | Total Interest Paid |
|---|---|---|---|
| Strategy 1: Minimum Amount Due (MAD) Only | Starts at Rs. 5,000 and declines gradually as balance amortizes | 14 Years and 8 Months (176 Months) | Rs. 1,84,650 (184.6% of original debt) |
| Strategy 2: Fixed Payment (Accelerated) | Fixed commitment of Rs. 5,000 every month | 2 Years and 6 Months (30 Months) | Rs. 49,820 (Saves Rs. 1,34,830 in interest) |
Credit Card Trap Summary
Paying only the 5% minimum amount due stretches repayment to nearly 15 years and adds Rs. 1,84,650 in interest charges on a Rs. 1,00,000 balance. By maintaining a disciplined, fixed payment of Rs. 5,000 per month, the borrower clears the debt 12 years earlier and saves Rs. 1,34,830 in finance costs.
PRACTICAL CASE 4: Comprehensive Personal Net Worth & Debt-to-Income (DTI) Audit
Context: Amit Kumar (age 34) earns a gross monthly salary of Rs. 1,40,000 (net take-home salary Rs. 1,10,000). He applies for an additional personal loan of Rs. 5,00,000. The bank conducts a complete net worth and debt solvency audit based on the following financial records:
Assets: Residential Apartment (fair market value): Rs. 75,00,000; Equity Mutual Funds: Rs. 14,50,000; Public Provident Fund (PPF): Rs. 6,50,000; Cash in Bank Savings: Rs. 1,20,000; Liquid Emergency Mutual Fund: Rs. 2,80,000; Passenger Car (depreciated value): Rs. 4,50,000; Gold Jewelry: Rs. 5,50,000.
Liabilities & Monthly EMIs: Outstanding Home Mortgage: Rs. 42,00,000 (Monthly EMI: Rs. 38,000); Outstanding Auto Loan: Rs. 2,40,000 (Monthly EMI: Rs. 9,500); Credit Card Revolving Balance: Rs. 1,60,000 (Monthly Payment: Rs. 8,000).
Required: Compute (a) Personal Net Worth, (b) Debt-to-Asset Ratio, (c) Debt-to-Income (DTI) Ratio, and (d) Evaluate loan eligibility.
Liabilities & Monthly EMIs: Outstanding Home Mortgage: Rs. 42,00,000 (Monthly EMI: Rs. 38,000); Outstanding Auto Loan: Rs. 2,40,000 (Monthly EMI: Rs. 9,500); Credit Card Revolving Balance: Rs. 1,60,000 (Monthly Payment: Rs. 8,000).
Required: Compute (a) Personal Net Worth, (b) Debt-to-Asset Ratio, (c) Debt-to-Income (DTI) Ratio, and (d) Evaluate loan eligibility.
| Personal Asset Holdings | Personal Liabilities & Debt Balances |
|---|---|
| • Liquid Assets (Savings Bank + Liquid Fund): Rs. 4,00,000 • Investment Assets (Equity Funds + PPF): Rs. 21,00,000 • Real Estate & Gold (Apartment + Gold): Rs. 80,50,000 • Personal Automobile: Rs. 4,50,000 TOTAL ASSETS = Rs. 1,10,00,000 (1.10 Crores) | • Home Mortgage Principal: Rs. 42,00,000 • Auto Loan Principal: Rs. 2,40,000 • Credit Card Revolving Debt: Rs. 1,60,000 TOTAL LIABILITIES = Rs. 46,00,000 (46.0 Lakhs) |
| PERSONAL NET WORTH = Assets (Rs. 1,10,00,000) − Liabilities (Rs. 46,00,000) = Rs. 64,00,000 (64.0 Lakhs) |
Solvency & Debt Burden Calculations:
1. Debt-to-Asset Ratio:
Debt-to-Asset Ratio = [ Total Liabilities ÷ Total Assets ] × 100 = [ 46,00,000 ÷ 1,10,00,000 ] × 100 = 41.82%
Norm: ≤ 50.0%. Status: Healthy asset coverage; net assets exceed liabilities.
2. Debt-to-Income (DTI) Ratio:
• Existing Monthly Debt EMIs = Home Loan (38,000) + Auto Loan (9,500) + Credit Card (8,000) = Rs. 55,500
• Gross Monthly Income = Rs. 1,40,000; Net Take-Home Salary = Rs. 1,10,000
• DTI (on Gross Income) = [ Rs. 55,500 ÷ Rs. 1,40,000 ] × 100 = 39.64%
• DTI (on Net Take-Home Salary) = [ Rs. 55,500 ÷ Rs. 1,10,000 ] × 100 = 50.45%
1. Debt-to-Asset Ratio:
Debt-to-Asset Ratio = [ Total Liabilities ÷ Total Assets ] × 100 = [ 46,00,000 ÷ 1,10,00,000 ] × 100 = 41.82%
Norm: ≤ 50.0%. Status: Healthy asset coverage; net assets exceed liabilities.
2. Debt-to-Income (DTI) Ratio:
• Existing Monthly Debt EMIs = Home Loan (38,000) + Auto Loan (9,500) + Credit Card (8,000) = Rs. 55,500
• Gross Monthly Income = Rs. 1,40,000; Net Take-Home Salary = Rs. 1,10,000
• DTI (on Gross Income) = [ Rs. 55,500 ÷ Rs. 1,40,000 ] × 100 = 39.64%
• DTI (on Net Take-Home Salary) = [ Rs. 55,500 ÷ Rs. 1,10,000 ] × 100 = 50.45%
Credit Underwriting Evaluation: Amit KumarUnderwriting Audit
- Solvency vs. Cash Flow: Amit maintains a strong balance sheet, with a positive Net Worth of Rs. 64.0 Lakhs and a healthy Debt-to-Asset ratio of 41.82%.
- Cash Flow Strain: His monthly debt obligations of Rs. 55,500 consume 50.45% of net take-home pay, leaving limited flexibility for living costs.
- Credit Decision: Adding a Rs. 5 Lakh personal loan would add roughly Rs. 11,000 to monthly EMIs, pushing DTI to 60.5% of take-home pay. A bank would likely reject an additional unsecured loan. The recommended alternative is to liquidate Rs. 1.60 Lakhs from liquid funds to clear the high-cost revolving credit card balance, reducing monthly debt service by Rs. 8,000.
COM3MN205Personal Financial Planning
Download Module 2 Notes (PDF)
Calicut University • FYUGP 2024 Syllabus
Finished this module?
Continue reading the next module or return to the subject overview.