Particulars Loan Amount Rate of Interest Upfront Fees (Flat plus applicable Tax) Out of Pocket TDS Calculation Interest paid to Bank @ 14% TDS i.e Tax on interest to be deducted Total Interest to be paid Out of Pocket Expenses Upfront Fees @ 1% Service Tax @ 10.3%
50,000,000.00 14.00% 1.00% 50,000.00 22.66% 7,000,000.00 7,000,000.00 50,000.00 500,000.00 51,500.00 551,500.00
Total Cost of Loan for 1st year % of cost of Loan
7,601,500.00 15.20
Loan Amount Rate of Interest Upfront Fees (Flat plus applicable Tax) Out of Pocket TDS Interest paid to Bank @ 14% TDS i.e Tax on interest to be deducted Total Interest to be paid Out of Pocket Expenses Upfront Fees @ 1% TDS i.e Tax on interest to be deducted
50,000,000 14.00% 1.00% 50,000.00 22.66% 7,000,000.00 7,000,000.00 50,000.00 500,000.00 51,500.00 551,500.00
Total Cost of Loan for 1st year Less :Taxshield on total interest out-go @34% Internal cost of loal Effective cost on loan
7,601,500.00 2,584,510.00 5,016,990.00 10.03
All amount in Lakhs Principal Amount Interest rate Upfront fees
500 14% 1%
Quarter OpeningBal Interest 1st Quarter (year 1) 500.00 2nd Quarter (year 1) 437.50 3rd Quarter (year1) 375.00 4th Quarter (year 1) 312.50 1st Quarter (year 2) 250.00 2nd Quarter (year 2) 187.50 3rd Quarter (year2) 125.00 4th Quarter (year 2) 62.50
17.50 15.31 13.13 10.94 8.75 6.56 4.38 2.19
Total Interest for 1st Year Average Loan Outstanding for 1st year Interear rate
Interest Rate Calculation Total Interest for 2year Other Charges Upfront fees @ 1% on principal Amount Add: Applicable Service Tax @ 10.3% on Upfront fees Out of Pocket Expenses Sub Total of Expenses total expenses Tax shield @ 34% Net out go at the end of 2nd year Average Loan Outstanding 281.25 Yearly Interest reat at decling Balance Interest Calculation on Flat Rate For One year
Principal Closing Loan Bal 62.50 437.50 62.50 375.00 62.50 312.50 62.50 250.00 62.50 187.50 62.50 125.00 62.50 62.50 62.50 0.00 For 1 st year For 2 st year 56.88 21.88 406.25 156.25 14 14
Without Taxshield With Taxshield 78.75 78.75 5 0.52 0.500 6.02 84.77 0 84.77 281.25 30.14 15.07
6.02 84.77 28.82 55.94 281.25 19.89 9.95
16.95 8.48
11.19 5.59