Tag Archives: Excel

Programs or excel software for newlywed budget planning?

I’m getting married soon and the final budget cruncher. I keep track of the time cost me my boyfriend is great, but I know I’m better at pulling the “string-purse” from it (even if it’s a bitch spend all). I’m using Excel and make my own tracker like to go, but not really functional for … Continue reading

Excel Magic Trick 355: VLOOKUP for Mortgage Calculator

See how to use VLOOKUP to create a Mortgage Calculator that can handle 4 different types of loans: Begin Annuity, End Annuity, Interest Only and Other loan.

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 actually quite easy to do and after watching 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 … Continue reading