LATEST SPREADSHEET CORNER ARTICLE:

CI Mortgage Refinance Calculator

April 18, 2015

Nowadays, while interest rates are low, many individuals contemplate refinancing their mortgage. But with refinancing comes costs. Some homeowners are considered “refinance junkies” and continually jump from one low interest rate to the next, but these individuals may not factor refinancing costs into the total benefit associated with a lower interest rate.

There are several different goals when refinancing a mortgage. A majority of homeowners seek to reduce their interest expense, but there are others who appreciate the ability to extend the term of the mortgage, effectively reducing their periodic payment. On the other hand, individuals may seek to lower their loan repayment period if they are in a position to afford a higher periodic payment. Another goal might be to consolidate debt. If you have an initial mortgage as well as a home equity loan, combining the two mortgages into one may level out the payments and simplify the repayment process.

Much of the analysis presented on mortgage refinancing stresses the fact that an individual should only refinance if they plan on being in their home for a while. This is because homeowners are urged to consider how many months of lower payments it will take to recoup the closing costs of the new mortgage. Individuals should also evaluate how long they intend to stay in a particular home in order to estimate the principal balance when it comes time to sell the property and compare that with what the balance will be if the mortgage is refinanced.

The CI Mortgage Refinance Calculator is meant to be a simple illustration of how refinancing your mortgage could affect your cash flow, whether positive or negative. This is a topic that has many intricate and elaborate caveats, and we advise that you consult a mortgage professional before making any decisions.

Read More »

Contact CI       Computerized Investing

CI Market Dashboard

We have put together a collection of market indicators and track them to help you gauge the direction of the market.


CI Analysis Worksheets

Interactive analysis templates covering DuPont analysis (return on equity), valuing stocks the Warren Buffett way, and more to come.


CI Blog Feed

Robotic surgery Isn’t as Safe You Thought
posted 5 hours ago by Hareesh Jayanthi

Interactive Brokers to Acquire Covestor
posted 1 day ago by Jaclyn McClellan

You Can Buy It But It’s Not Yours
posted 3 days ago by Hareesh Jayanthi

Oscar is potentially disruptive
posted 4 days ago by Hareesh Jayanthi

WSJ: Ransomeware a Growing Threat
posted 7 days ago by Wayne Thorp


Recent Articles

January 17, 2015

Retirement Withdrawal Calculator

A simple spreadsheet that allows you to input a few estimates and see whether you will have enough savings to last through your retirement years.

October 18, 2014

Using Google Sheets to Create a Portfolio Tracker

An overview of Google Sheets spreadsheet app as well as a portfolio tracker created with Google Sheets that automatically retrieves financial information for portfolio tracking and watchlist construction.

July 19, 2014

CI’s Financial Ratio Analysis Spreadsheet

Excel spreadsheet automatically derives financial ratios for company analysis after a simple import of financial statement data from Morningstar.com.

First Quarter 2014

Calculating Mohanram’s G-Score Using SI Pro and Microsoft Excel

Quantifying a strategy focused on separating the winners from the losers in high price-to-book-value stocks.

Click here for entire collection of Spreadsheet Corner articles ➜