Scribd
Upload
39 views1 page

Bank Loan 2

The document provides a detailed table of various bank loans taken by individuals, including personal, car, and home loans. It lists key information such as loan type, amount, down payment, remaining amount, rate of interest (ROI), duration, equated monthly installment (EMI), total amount payable, and interest accrued. Each entry outlines the financial obligations and terms associated with the loans taken by the individuals listed.

Uploaded by

suryavanshi1788
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
39 views1 page

Bank Loan 2

The document provides a detailed table of various bank loans taken by individuals, including personal, car, and home loans. It lists key information such as loan type, amount, down payment, remaining amount, rate of interest (ROI), duration, equated monthly installment (EMI), total amount payable, and interest accrued. Each entry outlines the financial obligations and terms associated with the loans taken by the individuals listed.

Uploaded by

suryavanshi1788
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

BANK LOAN

NAME LOAN TYPE LOAN AMOUNT DOWN PAYMENT REST AMOUNT ROI DURATION(YEAR) EMI TOTAL AMOUNT INTEREST
SWATI PERSONAL LOAN ₹ 120,000 ₹ 20,000 ₹ 100,000 13% 3 ₹ 3,369.40 ₹ 121,298.23 ₹ 21,298.23
₹
SHABNAM CAR LOAN ₹ 320,000 ₹ 11,000 ₹ 309,000 12% 2 14,545.70 ₹ 349,096.87 ₹ 40,096.87
₹
ANMOL HOME LOAN ₹ 450,000 ₹ 30,000 ₹ 420,000 10% 4 10,652.29 ₹ 511,309.68 ₹ 91,309.68
₹
KARTIK HOME LOAN ₹ 190,000 ₹ 15,000 ₹ 175,000 10% 1 15,385.28 ₹ 184,623.36 ₹ 9,623.36
BRIJESH CAR LOAN ₹ 240,000 ₹ 35,000 ₹ 205,000 12% 3 ₹ 6,808.93 ₹ 245,121.61 ₹ 40,121.61
PRINCE PERSONAL LOAN ₹ 140,000 ₹ 18,000 ₹ 122,000 13% 5 ₹ 2,775.87 ₹ 166,552.49 ₹ 44,552.49
MANOJ PERSONAL LOAN ₹ 110,000 ₹ 60,000 ₹ 50,000 13% 4 ₹ 1,341.37 ₹ 64,385.99 ₹ 14,385.99
₹
SONAM PERSONAL LOAN ₹ 310,000 ₹ 75,000 ₹ 235,000 13% 2 11,172.33 ₹ 268,135.88 ₹ 33,135.88
SIMRAN CAR LOAN ₹ 180,000 ₹ 85,000 ₹ 95,000 12% 1 ₹ 8,440.63 ₹ 101,287.62 ₹ 6,287.62
PREETI HOME LOAN ₹ 250,000 ₹ 45,000 ₹ 205,000 10% 5 ₹ 4,355.64 ₹ 261,338.65 ₹ 56,338.65
₹
MEENU HOME LOAN ₹ 1,900,000 ₹ 31,000 ₹ 1,869,000 10% 3 60,307.37 ₹ 2,171,065.42 ₹ 302,065.42
JAYA CAR LOAN ₹ 240,000 ₹ 18,000 ₹ 222,000 12% 4 ₹ 5,846.11 ₹ 280,613.35 ₹ 58,613.35
₹
SRISHTI PERSONAL LOAN ₹ 800,000 ₹ 35,000 ₹ 765,000 13% 6 15,356.69 ₹ 1,105,681.71 ₹ 340,681.71
DISHA PERSONAL LOAN ₹ 750,000 ₹ 400,000 ₹ 350,000 13% 5 ₹ 7,963.58 ₹ 477,814.53 ₹ 127,814.53
₹
LIVESH PERSONAL LOAN ₹ 650,000 ₹ 100,000 ₹ 550,000 13% 4 14,755.12 ₹ 708,245.89 ₹ 158,245.89
SAHIL CAR LOAN ₹ 145,000 ₹ 40,000 ₹ 105,000 12% 1 ₹ 9,329.12 ₹ 111,949.47 ₹ 6,949.47
₹
DEEPANSHU HOME LOAN ₹ 950,000 ₹ 14,000 ₹ 936,000 10% 9 13,177.65 ₹ 1,423,186.23 ₹ 487,186.23
EMI = PMT(ROI/12,DURATION(YEAR)*12,LOAN AMOUT-DOWN PAYMENT)
TOTAL = EMI * YEAR*12
INTEREST = TOTAL AMOUNT - REST AMOUNT

You might also like