Amortisation schedule

%3CLINGO-SUB%20id%3D%22lingo-sub-2209456%22%20slang%3D%22en-US%22%3EAmortisation%20schedule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2209456%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20I%20am%20wondering%20if%20there%20is%20a%20formula%20that%20will%20show%20a%20loan%20amortisation%20schedule%20where%20the%20total%20monthly%20payment%20remains%20the%20same%20with%20the%20interest%20payments%20gradually%20reducing%20and%20the%20principle%20repayments%20gradually%20increasing%20over%20the%20period%20of%20the%20loan%20term%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2209456%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi all, I am wondering if there is a formula that will show a loan amortisation schedule where the total monthly payment remains the same with the interest payments gradually reducing and the principle repayments gradually increasing over the period of the loan term?

1 Reply

@Duncan_Dids 

You can use the PPMT and IPMT functions for this purpose.

S0211.png