Excel Home Loan Amortization Schedule Template

Use this Excel-based template for creating an amortization schedule for your home loan. It allows you to visualize the monthly and yearly evolution of interest and principle components and the balance of the loan. It can accommodate regular (monthly, quarterly, bi-annual and annual) and irregular (random months) pre-payment schedules. It can also handle a loan…

Continue reading →

Before applying for a BIGGER home loan and buying a BIGGER house, read this

“This is a guest post from Abhinav Gulechha.  Abhinav is a Certified Financial Planner and writes at www.sohamfp.com. Views expressed are personal.” ~~~~~~~~~~~~~~~~~~ In today’s credit-driven economy in which we live, one can buy anything provided you have the income to support it. Owing to an easy availability of home loans and rising salary levels, it…

Continue reading →

Pay off home loan or invest for retirement? Calculate and find out!

Recently subra wrote an article on Payoff Mortgage or Invest…continued. Here is a calculator to fortify the argument I have modified my financial freedom calculator to accommodate immediate lump sum investment to the lender to check if that option is better than investing the money for retirement (aka financial freedom) The excel file explains the…

Continue reading →