How to Make a Fixed Rate Loan/Mortgage Calculator in Excel

www.TeachExcel.com This video tutorial will show you how to make a fixed rate loan or mortgage calculator in excel. It is in fact quite simple to do and after surveillance this step-by-step example and walk-through, you will be able to make your own also. This tutorial uses the PMT() function to calculate the required payments and it is also clarified in the tutorial. To stay on along with the spreadsheet seen in the tutorial or to get some free excel macros or tips & tricks, go to the website www.TeachExcel.com

I Am Refinancing My 3 Yr. Arm Mortgage & Getting a Fixed Rate Mortgage?

refinancing

I am refinancing to a fixed rate mortgage from a 3 yr. ARM. I have $16,825.37 in unpaid deferred interest. A mortgage broker told me this amount can be used either as an income tax deduction or to add to the principle of my new mortgage. I don’t know the concept of this at all. I would like someone to clarify this better.