Pages

Monday, December 20, 2010

How to Create an Amortization Calculator

Amortization -- strange word? If so, then perhaps you haven't gone to bank yet to secure a loan, whether for a car or for a house. Amortization is what you pay the bank monthly for a fixed period. It is calculated based on the amount you borrow, the interest rate and the length of time you agree to repay the entire loan.

"Relax, Mr. Accountant" by Dennis Wong

The last thing you would want to do is to leave all the computation to the bank. A sage's advise would be for you to know your numbers first before even thinking of signing on the dotted line. With Excel you can easily do that.

Hold your breath, you need to set up all the formula first. That's a walk in the park with the step-by-step guide in the slides below.



I hope the slides have been useful to you. If so, by now you already have your own magic amortization calculator.

When we had a discussion with my real estate partners in the beginning, it kind of surprised them how I coughed out the monthly amortization as quickly as we converse. That's when I told them about my "magic amortization calculator."

Now you have it. Relish the power of knowing your numbers.

--

Your Virtual Sidekick
http://virtualsidekick.blogspot.com

1 comment:

  1. This is exciting. Using a simple Excel sheet, you can now forecast how much you pay the bank monthly for your housing loan or car loan. You quickly see the impact of variations on interest rates on your finances. That gives you power in negotiating with banks for the most favorable loan arrangements.

    ReplyDelete