Advertisements
HEADLINES

Ask Geri: True Cost of Borrowing (Part 2): Diminishing Balance Amortization

Not all loan providers offer this option. But from time to time I encounter this option especially for mortgage / home loans. If Juan is presented such an option and s/he can afford the amortization using diminishing balance, s/he should go for it to save some more on interest payments.

Rate this:

Dear Geri:

Read your article on The True Cost of Borrowing We Don’t Care Much About. Saw your amortization table using straightline amortization. Can you also share your MS Excel calculator for diminishing balance amortization table?

Thanks!

-Anon 

askgeributtonwhite_smaller_zpsa277e917


Last month, we published an eye-opener-or-reminder-article for every Juan on the true cost of borrowing — how much interest we actually pay on our amortized  loans (part reason why banks are really profitable, and why I like keeping bank stocks in my portfolio, but that’s another story.)

a504f-20152bcoinbank2
We also shared Excel formulas on how to create straight-line amortization table (equal amortization per month) in Excel for those who want to have their own easy-to-use calculators. The same app mentioned in the previous article also computed using straightline amortization.

A reader asked for the formula of diminishing balance amortization.

I checked since I wrote an article on this 2 years ago: On Loans: Straightline vs Diminishing Balance, to discuss the differences but I did not include the excel formulas.

So here it goes:

Diminishing Balance_zpsscztuzbn

*For the month column (I), note that I just have a hidden +1 counter  in column A which compares the counter to the tenor. Once the counter is greater than the tenor, month column will be blank.

Not all loan providers offer this option. But from time to time I encounter this option especially for mortgage / home loans. If Juan is presented such an option and s/he can afford the amortization using diminishing balance, s/he should go for it to save some more on interest payments.

Hope this helps!

Advertisements
About Geri (355 Articles)
Founder and main author. Husband, used-to-be-breadwinner, God-made multi-millionaire, employee, financial planner and adviser, investor, stocks trader, entrepreneur, agri-preneur, book author. Firm believer that all Pinoys deserve a richer life. Not a guru, but a forever student of the investments world, a work-in-progress.

Comment here.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: