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.

There will be a $1,000 balloon payment.

What's your monthly payment?

Set up the following cashflow or select the Balloon 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
1-1-2034	inflow	1,000	once				Balloon 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: 116.50.

Back to Examples