Home Loan Planner - Excel based

rajanpras · #1 (**permalink**) 14-09-2008, 02:20 PM

Hi,

I have developed a Micsoft Excel based Home Loan Calculator (Amortization Schedule) and is available for download at Prasanth's Website | . The reason why I am not attaching is that this could be revised based on inputs and / or feedback from Users.
This not only calcultes the EMI applicable, but also gives the split of interest and Principal components of each EMI. In addition, this also takes care of Principal pre-payments made and also interest rate changes done for floating rates.
Do mail or reply to this thread with suggestions and / or issues if any.

Regards.
Prasanth

rajanpras · #2 (**permalink**) 14-09-2008, 11:34 PM

Hi,

On suggestion from a CA in another forum, I have added the feature of chosing the Fy such that the Principle and Interest for that FY is displayed. This version 1.1 is now available at the same URL - Prasanth's Website | .

Regards.
Prasanth

rajanpras · #3 (**permalink**) 10-10-2008, 08:04 PM

Hi all,

Please note that there is a minor correction in Principal computation when there is repayment. This is now corrected and version 1.2 and the same is now available for download at the same URL - Prasanth's Website |.

Regards.
Prasanth

kgb2006 · #4 (**permalink**) 25-11-2008, 11:45 AM

Hi
this is most useful

toneyjoseph · #5 (**permalink**) 25-11-2008, 12:12 PM

Dear,

I cant access that url, so kindly send that excel to my below id:

Quote:

Originally Posted by rajanpras

Hi,

I have developed a Micsoft Excel based Home Loan Calculator (Amortization Schedule) and is available for download at Prasanth's Website | . The reason why I am not attaching is that this could be revised based on inputs and / or feedback from Users.
This not only calcultes the EMI applicable, but also gives the split of interest and Principal components of each EMI. In addition, this also takes care of Principal pre-payments made and also interest rate changes done for floating rates.
Do mail or reply to this thread with suggestions and / or issues if any.

Regards.
Prasanth

madhuvan.pv · #6 (**permalink**) 04-12-2008, 03:51 PM

its good and iam going to use it for my home loan calculation..

rajanpras · #7 (**permalink**) 31-12-2008, 10:08 AM

Hi,

Please note that the 2.0 version is now released at the same URL - Prasanth's Website | . This now has the feature that EMI can be altered and also warns when the existing EMI will not be valid.

Regards.
Prasanth

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode