Example

On January 1st, 2024, you borrowed $10,000 which is to be paid of in 120 monthly installments starting on February 1st. Interest is at 8 % compounded monthly.

What's your monthly payment?

Set up the following cashflow or select the Loan payment example in the Help > Examples menu.

Date	Type	Value	Occurs	#	Change	Step	Comment
1-1-2024	outflow	10,000	once				Loan
2-1-2024	unknown	1	monthly	120	no change		Payment

Enter 8 into the rate field and select monthly compounding in Compute Options.

Make sure that Auto update is checked.

You'll find the anwser in the x Value field: 121.33.

Back to Examples