I am setting up a budget on Excel. I want to show the balance after I make my
payment minus the interest rate and escrow. (Sometimes I also pay more than
the minimum due.) What kind of formula do you use for this ?
I am setting up a budget on Excel. I want to show the balance after I make my
payment minus the interest rate and escrow. (Sometimes I also pay more than
the minimum due.) What kind of formula do you use for this ?
On each row, you'd indicate the total amount paid, then split this up into:
1) escrow (a fixed amount, probably chaning once per year), 2) interest,
calculated as prior month's ending balance * interest rate / 12, 3)
principle, calculated as the total paid minus escrow and interest, 4) new
balance, calculated as prior balance minus principle.
"Kim2000" wrote:
> I am setting up a budget on Excel. I want to show the balance after I make my
> payment minus the interest rate and escrow. (Sometimes I also pay more than
> the minimum due.) What kind of formula do you use for this ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks