Can someone help me understand how to build an amortization schedule where the property tax increases by a given percentage each January over the prior December (calendar year)? I need a formula that will look at the property tax amount for the first month period and carry the same property tax amount down through month 12, but then increase by a given percentage in months 13-24, then by the same percentage in months 25-36 (period 24 plus percentage), months 37-48 and so on. Any ideas would be greatly appreciated!
GP2
Bookmarks