Mortgage Amortization Spreadsheet

I finally got the first home I wanted. Yay! Now onto paying off the mortgage over the next 30 years. I can’t wait till the day comes when I write my last check to the bank. Though I really don’t want to imagine myself, 30 years older, but that is reality. This is better than paying rent till the day I die, hopefully longer than 30 years…

I made it my next goal to shorten the term, by making additional payments every month. Sure, I could have just sign up for a shorter term loan but I would not have been able to make the higher payments. How much additional payment do I have to make to trim 1 year, 2 year, or 5 years off my loan? How soon can I pay off my mortgage if I reduce my coffee/bubble tea fund and use it to pay toward my mortgage? I found a mortgage amortization table online and customized it to calculate just that. I also discovered after playing around with the table a bit, that a 4% annual interest rate is equivalent to 72% interest over a 30 year period. In the end, the banks are the real winners in this real estate business.

The Spreadsheet

Download Mortgage Amortization spreadsheet here. Start by entering a few numbers: home purchase price, down payment, first payment date, loan period and interest rate. Next, enter an amount in the “Extra Payment” column ($50 from my coffee fund) and the number will be automatically repeated for the length of the loan. The “Key Figures” section will show you how many years you saved by making the extra payments, and when exactly is your last payment date, etc. In this snapshot, on a $80,000 loan, $50 additional monthly payment shaved off 5.9 years off the 30-year loan.



Can bankruptcy help to save your home from being foreclosed?

This is a guest post by Sophia Kinsella. Sophia is a financial writer and offers her advice to many people suffering with business related problem. She contributes articles to many sites and guides people through different forums.

Foreclosure is undoubtedly a nightmare for every homeowner. However, it’s possible to avoid foreclosure by filing bankruptcy. This will help to stall foreclosure proceedings and other notorious debt collection practices. In fact, through bankruptcy many homeowners have been able to save their properties permanently.

Peter Orville, an experienced attorney from Binghamton, N.Y., believes “It’s the best tool there is for people behind in payments but who have ongoing income”. The homeowners struggling to pay off the mortgage loan may get some time to continue their payments after filing bankruptcy. This helps a lot in averting foreclosure by paying off the mortgage.

Continue reading