Tutorial #Q6-7: Refinancing a Loan | AccountingWEB

Tutorial #Q6-7: Refinancing a Loan

Intro: If you have considered refinancing a loan and wonder exactly how much you will save and how long it will take you to recoup the costs of refinancing, Quicken has just the tool to help you with your calculations. The Refinance Calculator is designed for mortgages, but you can adapt it to help you consider refinancing any type of loan.

Step 1: View Quicken's Calculators
Open the Planning menu and choose Financial Calculators. An assortment of financial calculating options will appear.

Step 2: Open the Refinance Calculator
Choose Refinance from the list of available calculators.
***Production: Re Figure Q6-7_02.GIF. Please crop out the text that appears under the "Financial Calculators" portion of the menu. Thanks/gap"

Step 3: Enter Current Information
In the Existing Mortgage section of the Refinance Calculator, enter the current monthly payment that you make, then enter the amount of that payment that represents something other than principal and interest. Quicken will calculate the amount of your payment that represents only principal and interest.

Step 4: Enter Proposed Option
In the Proposed Mortgage section of the Refinance Calculator, enter the amount you expect to borrow when you refinance, the number of years over which you will pay off the new loan, and the interest rate.

Quicken will calculate the amount of principal and interest you will pay each month, and the monthly savings when compared to your current loan.

Step 5: Enter Closing Costs
In the Break Even Analysis section of the Refinance Calculator, enter the amount of any costs associated with refinancing your loan, including appraisal, title fee, legal fees, and so on. On the second line of this section enter the amount of points you will pay, if any, on refinancing.

Quicken will calculate the total amount of closing costs you will pay, and will determine how many months it will take you to pay off those closing costs, based on the monthly savings you acquire through refinancing.

Step 6: Print Your Calculations
Click on the Print button in the Refinance Calculator window to print a copy of these calculations. Click OK in the Print window to print this information. Click Done to close the Refinance Calculator.

This refinance information is not saved in Quicken. If you choose to refinance your loan, you will need to set up the new, refinanced loan in Quicken (see Create a Liability Account earlier in this set of tutorials). You will also want to remove the old loan from your Quicken records (see Deleting a Loan).

Wait, there's more!
There's always more at AccountingWEB. We're an active community of financial professionals and journalists who strive to bring you valuable content every day. If you'd like, let us know your interests and we'll send you a few articles every week either in taxation, practice excellence, or just our most popular stories from that week. It's free to sign up and to be a part of our community.
Premium content is currently locked

Editor's Choice

As part of our continued effort to provide valuable resources and insight to our subscribers, we're conducting this brief survey to learn more about your personal experiences in the accounting profession. We will be giving away five $50 Amazon gift cards, and a $250 Amazon gift card to one lucky participant.
This is strictly for internal use and data will not be sold
or shared with any third parties.