Total Cost Of Loan

  • Uploaded by: Tierra Hale
  • 0
  • 0
  • July 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Total Cost Of Loan as PDF for free.

More details

  • Words: 362
  • Pages: 2
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

Related Documents

Total Cost Of Loan
July 2020 15
Total Cost Of Ownership
December 2019 20
Total Cost Of Ownership
November 2019 15
Total Cost On Purchasing
December 2019 20
L31 Total Cost Management
November 2019 27
Total Annual Cost
May 2020 10

More Documents from ""

Total Cost Of Loan
July 2020 15
Csa Resource1
July 2020 15
Act-24.docx
June 2020 9
Cap_mecanismos.pdf
November 2019 10
November 2019 5