Thursday, April 2, 2009

House mortgage calculator – Excel template (Flemish)

Since we recently bought a new house, I spent some time to be able to calculate the best construction for our house credit / loan / mortgage. I tried to list all costs in an Excel sheet, combined with our earnings, to get a clear global picture on what we will have to pay. Based on these calculations, I extracted an Excel template that could be used by anyone. The costs taken into account are quite specific for Belgium (Flanders) and for our case but I suppose the sheet could be used as a start for others (let me know if this is the case)…

When using this template, some data will have to be filled in, before the calculated results will be meaningful. The fields that can be filled in/changed/selected manually, are marked in the following style: 

fieldtofill

The most important fields to fill in at start are: price, cadastral income, savings, average pay, average outlay, interest rate of the banks, etc within the ‘kosten’ sheet. Within the ‘interesten’ sheet only at the top some fields should be filled up to denote how you would like to calculate a split loan (to benefit most of the fiscal revenue). Again the same format style is used to denote these fields should be filled in. The other fields are locked on the sheet (although they can easily be unlocked without a password).

Once the basic numbers are filled in, one can start to play with the list boxes to easily compare different constructions (split loan, fixed capital payment, years, banks, etc). One can now change the control to show how much will have to be paid and gained in the selected year. This way, you can easily check if you will be able to pay all costs and still save some money.yearselectorThe template can be downloaded here.



The site rentevoet.be has also made a nice excel to calculate different loan payments, besides some other calculators.




Some interesting links I used to make all calculations:


Update 08/10/09: extra info link

Update 05/01/10: new template download link

Update 03/12/10: link to renteopdevoet.be

7 comments:

  1. Is the file still online? I get this message when navigating to the download url:

    Error
    The file could not be found. Please check the download link.

    (http://rapidshare.com/files/217446076/Lening_-_template.xltm.html)

    If it's not online anymore, could you please upload it again?

    ReplyDelete
  2. hmm, stupid rapidshare...I'll try to find it back at home an reupload it...

    ReplyDelete
  3. Reverse mortgage loan can indeed supplement the meager retirement funds in case the senior person has substantial equity in his/her home. Here, the retired person would not have to make any monthly payments, instead the payments would be made to him/her by the lender.


    What is a reverse mortgage

    ReplyDelete
  4. I am sure you have a zealous fan stalking out there.
    ppi

    ReplyDelete
  5. t's becoming increasingly popular for home owners—even those on tight budgets—to refinance their 30-year fixed-rate mortgages to 20- or even 15-year ones. Today's low rates allow you to do this while keeping your monthly payment fairly close to the current amount, says Erin Lantz, the director of Zillow's Mortgage Marketplace, a real estate–valuation website. Say you've been making payments on a 30-year, 6 percent fixed-rate mortgage of $200,000 for five years. If you refinance to a 15-year, 2.87 percent fixed-rate loan (typical at press time), for example, your payments will increase by less than $80 a month. Yet you would pay off the loan 10 years earlier, build equity faster, and save an astonishing $130,477 in interest.
    Easy Mortgage Calculator

    ReplyDelete
  6. This comment has been removed by a blog administrator.

    ReplyDelete