Mortgage Calculator with Variable interest rate

[papal singh]

I know how to make a mortgage calculator for a fixed rate, but how would i go about making one if the rate changes every period (i already have these changing rates, the loan amount and the number of periods), what VBA codes would i write?

 

[skorpionkz]

It all depends on the conditions of your mortgage. Also how you pay off the mortgage: are you doing single payment (which repay interest first and then capital) or you doing 2 payments in period (the second usually pay of the capital only)

if you have fix rate calculator use helper column and add there variable rates, and make VBA variable not fixed (like in the fix rate case), but to change each period depends from the value of the cell which contains rate.

Also there are formulas in excel which helps to calculate credits (like RATE any many others depends on your needs )