Go Back   Team-BHP > BHP India > Team-BHP Reviews > Indian Car Loans & Insurance


Reply
 
Thread Tools Search this Thread
Old 3rd December 2010, 09:15   #1
BHPian
 
Join Date: Nov 2010
Location: Hyderabad
Posts: 38
Thanked: Once
Default Car Loan Schedule Calculator

Had created an excel sheet to ease my comparison woes so just thought would share it with BHPians.

You can compare between various financing quotes by copying sheet and overwriting with the data for the other financier.

Most importantly (at least for me), I have tried to take into account loans with interest rates changing from one year to the next, and also prepayment options.

Hope this helps. Have added cell comments wherever possible.
Attached Files
File Type: xlsx Auto Loan calc.xlsx (30.2 KB, 1096 views)
Archon is offline   Reply With Quote
Old 3rd December 2010, 09:50   #2
Senior - BHPian
 
aargee's Avatar
 
Join Date: Jan 2010
Location: KATN
Posts: 4,694
Thanked: 2,115 Times
Default

Few of my observation...
- Remove the "$" symbol & can leave it blank or insert the new Re symbol
- The title says "EDITABLE" cell & gives an impression that all Yellow cells are editable; however, I'm unable to modify the processing fee, stamp duty & other charges
- Infact there should be a provision to enter the processing fee, stamp duty & other charges
- Is there any significane on leaving cols I & J blank?
- Is the prepayment period compulsory? What if the bank does not allow this feature? I tried 0 & the tool wouldn't accept
- How about a 7 year loan?
- When I input 0% interest for all 5 years for 5 year loan for a sum of 500000 the effective rate of loan is 12.17% for a mere sum of 4716 being processing fee, stamp duty & other charges. Is this right?

Car Loan Schedule Calculator-p1.jpg

Otherwise, a good calculator & appreciated effort

Last edited by aargee : 3rd December 2010 at 10:00.
aargee is offline   Reply With Quote
Old 3rd December 2010, 14:28   #3
BHPian
 
Join Date: Nov 2010
Location: Hyderabad
Posts: 38
Thanked: Once
Default

Quote:
Originally Posted by aargee View Post
Few of my observation...
- Remove the "$" symbol & can leave it blank or insert the new Re symbol (DONE)
- The title says "EDITABLE" cell & gives an impression that all Yellow cells are editable; however, I'm unable to modify the processing fee, stamp duty & other charges (Oversight on my part. Fixed in the new sheet attached with this post. Also, the sheet doesn't have a password so it can be unprotected)
- Infact there should be a provision to enter the processing fee, stamp duty & other charges (see previous point)
- Is there any significane on leaving cols I & J blank? (Nope. removed them)
- Is the prepayment period compulsory? What if the bank does not allow this feature? I tried 0 & the tool wouldn't accept (If you're not planning on prepayment, you can leave the period blank)
- How about a 7 year loan? (Didn't know people opted for that for a car)
- When I input 0% interest for all 5 years for 5 year loan for a sum of 500000 the effective rate of loan is 12.17% for a mere sum of 4716 being processing fee, stamp duty & other charges. Is this right? (Yes, you're also paying back the full amount plus Rs. 4716 after just a month. 12.17% is the annualized rate of return for the bank from your perspective. Note also that this cell might show a #NUM error sometimes, which is a limitation of how Excel calculates IRR. In that case, you can add an additional "guess" argument to the IRR function after unprotecting the sheet. Check Excel help for more details)

Attachment 463071

Otherwise, a good calculator & appreciated effort
Thanks Please find my comments inline in bold

Forgot the attachment
Attached Files
File Type: xlsx Auto Loan calc.xlsx (31.4 KB, 656 views)

Last edited by Jaggu : 3rd December 2010 at 14:36. Reason: Back to back posts, please EDIT the post once its approved. Thanks
Archon is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads
Thread Thread Starter Forum Replies Last Post
The Cheap Loan or the Smart Loan - SBI Advantage Car Loan keyur Indian Car Loans & Insurance 208 5th July 2017 15:56
Buy car using cash OR Take car loan & prepay home loan? rajshenoy Indian Car Loans & Insurance 13 2nd August 2013 18:16
Car loan checks returned without closing loan !! ashthedivx Indian Car Loans & Insurance 21 7th November 2008 12:28


All times are GMT +5.5. The time now is 14:57.

Copyright 2000 - 2017, Team-BHP.com
Proudly powered by E2E Networks